URL to your eFiction: http://www.svufiction.com ... but upgrade has failed several times so I'm testing upgrading here: http://racharoni.com/svufiction
Version of eFiction: 2.0.3
Have you bridged eFiction, if so with what?: no
Version of PHP: 4.4.1
Version of MySQL: 4.1.22-standard-log
Have you searched for your problem: yes
If so, what terms did you try: Table 'fanfiction_authorfields' already exists, lots of other searches
State the nature of your problem:
I get this error in step four when upgrading from v2 to v3.3:
A fatal MySQL error was encountered.
Query: CREATE TABLE `fanfiction_authorfields` ( `field_id` int(11) NOT NULL AUTO_INCREMENT, `field_type` tinyint(4) NOT NULL default '0', `field_name` varchar(30) NOT NULL default ' ', `field_title` varchar(255) NOT NULL default ' ', `field_options` text, `field_code_in` text, `field_code_out` text, `field_on` tinyint(1) NOT NULL default '0', PRIMARY KEY (`field_id`) ) TYPE=MyISAM;
Error: (1050) Table 'fanfiction_authorfields' already exists
When I look in my database, I find that it does exist and has 36 entries in it. No idea where it came from, but it's all lj, website, AIM, ICQ, MSN, etc. I tried deleting it so the script could insert it's own authorfields and then it gave me this error:
A fatal MySQL error was encountered.
Query: CREATE TABLE `fanfiction_authorinfo` ( `uid` int(11) NOT NULL default '0', `field` int(11) NOT NULL default '0', `info` varchar(255) NOT NULL default ' ', PRIMARY KEY (`uid`,`field`), KEY `uid` (`uid`)) TYPE=MyISAM;
Error: (1050) Table 'fanfiction_authorinfo' already exists
And it turned out that it does exist, too, with 9,182 entries. I have no idea why... as far as I was ever concerned, my archive has always been version 2 and I don't know why it's using all these tables that are meant for version 3. Unless authorinfo is a table utilized in version 2 as well and there's something wrong with the upgrade script.
I have no clue what's going on or how to proceed and anyone that could help would be a lifesaver. I've tried skipping ahead to different steps or messing with the databases, everything that I could think of (not that I know what I'm doing), but it always comes out as a mess.
Do you have a test account for us? No
My server was down for a while but it's back up now, so the test site can now be seen.
Is there anyone out there that has any idea how to help? At this point I'd seriously consider paying someone if it's that difficult.
