[RESOLVED] upgrading from 2.0.x to 3.2.x not working

URL to your eFiction: http://www.destinysgateway.com
Version of eFiction: 2.0.7 upgrade to 3.2
Have you bridged eFiction, if so with what?: no
Version of PHP: 4.4.4
Version of MySQL: 4.0.27-standard
Have you searched for your problem: (yes/no) yes
If so, what terms did you try: settings upgrade 2.0 install error mysql 1064 optimize
State the nature of your problem: Copy and paste any errors you are receiving.

On install I get this error at step 19:

A fatal MySQL error was encountered.
Query: UPDATE fanfiction_news SET comments = '1 WHERE nid = 17
Error: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''1 WHERE nid = 17' at line 1

I'm not sure but I think something is missing? Everytime I run this script I have to backtrack to set up and start again (dropping tables too) or it gets errors gallore!

thanks.

EDIT: I found the problem--good thing I remembered my php coding after posting this.

dbquery("UPDATE ".$tableprefix."fanfiction_news SET comments = '".$n['count']." WHERE nid = ".$n['nid']);

IS COMPLETELY WRONG IN THE ZIP UPGRADE20.PHP

It's meant to be:

dbquery("UPDATE ".$tableprefix."fanfiction_news SET comments = '".$n['count']."' WHERE nid = ".$n['nid']."");

You can find this under alter tables at the top of the page.

I just spent a good two hours manually optimizing my tables because of this--I didnt want lose my 2000+ members if I had to drop the tables and start again. (Even though I have it on back up...just some things half way through were dropped added etc.)