[Solved] Upgrading from 2.0.7 to 3.2, mySQL error 1064

URL to your eFiction: http://www.wolves-online.com/eFiction
Version of eFiction: Upgrading to 3.2
Have you bridged eFiction, if so with what?: N/A yet 🙁
Version of PHP: 4.3.11
Version of MySQL: 4.0
Have you searched for your problem: Yes
If so, what terms did you try: 1064
State the nature of your problem: Basically, I had this problem when trying a fresh install with version 3.2. I searched the forums for the problem, and found out that it was solved by installing 3.0 and then upgrading to 3.2. However, I could not find a release with just 3.0. So I decided to go along with the bright idea of installing 2.0.7 and then upgrade, but to no avail. I'm pretty sure this was NOT the way to go about this.

Here's the exact error that I am getting:

A fatal MySQL error was encountered.
Query: CREATE TABLE `WOfanfiction_stats` ( `sitekey` varchar(50) collate latin1_general_ci NOT NULL default '0'
 `stories` int(11) NOT NULL default '0', `chapters` int(11) NOT NULL default '0', `series` int(11) NOT
 NULL default '0', `reviews`
 int(11) NOT NULL default '0',`wordcount` int(11) NOT NULL default '0', 
`authors` int(11) NOT NULL default '0', `members` int(11) NOT NULL default '0', `reviewers`
int(11) NOT NULL default '0', `newestmember` int(11) 
NOT NULL default '0' ) ENGINE=MyISAM

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 'collate latin1_general_ci NOT NULL default '0', `stories` in

So I'd like to try the 3.0 and then upgrade that, but I can't seem to find it (perhaps I'm just blind? :(), so if someone could point me in the right direction, I'd really appreciate it. Thanks!

Do you have a test account for us? No.