Upgrade 1.1 to 3.3.1 - upgrade failed at first step

URL to your eFiction: http://efiction.souzou.org
Version of eFiction: 3.3.1
Have you bridged eFiction, if so with what?: No
Version of PHP: 4.0.26-standard
Version of MySQL: 5.0.24a
Have you searched for your problem: Yes, endlessly. Somehow I can't find what fits mine.
If so, what terms did you try: 1050, 1064, as well looking through the entire sub-forum for upgrade problems with an older version
State the nature of your problem: See below.
Do you have a test account for us? No

Amazingly, I can't get past the first step. The upgrade detected the 1.1 version and proceeded to setting up the tables automatically. I tried it numerous times, with and without table prefixes and I still get the same error message. If I refresh the page, I get the 1050 error:

A fatal MySQL error was encountered.
Query: RENAME TABLE fanfiction_settings TO fanfiction_settings_old
Error: (1050) Table 'fanfiction_settings_old' already exists

Seems like it bypassed the first error. But I looked through the database and the new settings table is not created. I also tried setting it up manually to no avail.

Originally, this is what I received:

A fatal MySQL error was encountered.
Query: CREATE TABLE IF NOT EXISTS`fanfiction_settings` ( `sitekey` varchar(50) NOT NULL default '1', `sitename` varchar(200) NOT NULL default 'Your Site', `slogan` varchar(200) NOT NULL default 'It''s a cool site!', `url` varchar(200) NOT NULL default ' http://www.yoursite.com', `siteemail` varchar(200) NOT NULL default 'you@yoursite.com', `tableprefix` varchar(50) NOT NULL default '', `skin` varchar(50) NOT NULL default 'default', `hiddenskins` varchar(255) default '', `language` varchar(10) NOT NULL default 'en', `submissionsoff` tinyint(1) NOT NULL default '0', `storiespath` varchar(20) NOT NULL default 'stories', `store` varchar(5) NOT NULL default 'files', `autovalidate` tinyint(1) NOT NULL default '0', `coauthallowed` int(1) NOT NULL default '0', `maxwords` int(11) NOT NULL default '0', `minwords` int(11) NOT NULL default '0', `imageupload` tinyint(1) NOT NULL default '0', `imageheight` int(11) NOT NULL default '200', `imagewidth` int(11) NOT NULL default '200', `roundrobins` tinyint(1) NOT NULL default '0', `allowseries` tinyint(4) NOT NULL default '2', `tinyMCE` tinyint(1) NOT NULL default '0', `allowed_tags` varchar(200) NOT NULL default '

', `favorites` tinyint(1) NOT NULL default '0', `multiplecats` tinyint(1) NOT NULL default '0', `newscomments` tinyint(1) NOT NULL default '0', `logging` tinyint(1) NOT NULL default '0', `maintenance` tinyint(1) NOT NULL default '0', `debug` tinyint(1) NOT NULL default '0', `captcha` tinyint(1) NOT NULL default '0', `dateformat` varchar(20) NOT NULL default 'd/m/y', `timeformat` varchar(20) NOT NULL default '- h:i a', `recentdays` tinyint(2) NOT NULL default '7', `displaycolumns` tinyint(1) NOT NULL default '1', `itemsperpage` tinyint(2) NOT NULL default '25', `extendcats` tinyint(1) NOT NULL default '0', `displayindex` tinyint(1) NOT NULL default '0', `defaultsort` tinyint(1) NOT NULL default '0', `displayprofile` tinyint(1) NOT NULL default '0', `linkstyle` tinyint(1) NOT NULL default '0', `linkrange` tinyint(2) NOT NULL default '5', `reviewsallowed` tinyint(1) NOT NULL default '0', `ratings` tinyint(1) NOT NULL default '0', `anonreviews` tinyint(1) NOT NULL default '0', `revdelete` tinyint(1) NOT NULL default '0', `rateonly` tinyint(1) NOT NULL default '0', `pwdsetting` tinyint(1) NOT NULL default '0', `alertson` tinyint(1) NOT NULL default '0', `disablepopups` tinyint(1) NOT NULL default '0', `agestatement` tinyint(1) NOT NULL default '0', `words` text collate utf8_unicode_ci, `version` varchar(10) NOT NULL default '3.3.1', `smtp_host` varchar(200) default NULL, `smtp_username` varchar(50) default NULL, `smtp_password` varchar(50) default NULL, PRIMARY KEY (`sitekey`) ) TYPE=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 utf8_unicode_ci, `version` varchar(10) NOT NULL defau

No idea why it's stuck at step 1. Any help would be appreciated. Thanks! 🙂