URL to your eFiction: http://www.the-gateroom.com/fic
Version of eFiction:2.0.7 - 3.5
Have you bridged eFiction, if so with what?:n/a
Version of PHP: 5.2.6
Version of MySQL: 5.0.51a-community
Have you searched for your problem: Yes
If so, what terms did you try: 1050
State the nature of your problem: Error on Step 4 of upgrade from 2.0.7 to 3.5
Screen goes black, and the following appears at top of screen.
A fatal MySQL error was encountered.
Query: CREATE TABLE `fffanfiction_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 'fffanfiction_authorfields' already exists
I have gone through a variety of errors, all of which I have managed to fix, aside from this one. I have no idea where to go from here in order to complete the upgrade. And yes, I have ensured it is the upgrade I am going through, and not a complete install.
Do you have a test account for us? No, sorry
Have you already started the upgrade process before? If so, you might have already done this step, since it's saying the table already exists. You'll need to move on to the next step. I had this issue with my initial upgrade and what I did was change the URL to the next step in order to to get to it. If you're sure that you've already done this one than you can skip to the next step by changing the 4 to a 5. You'll want to verify that your authorfields table has all the right fields in it, though.
I had to create a couple tables manually when I upgraded. You may find you have have to do so. Some of the tables are found as .sql files in the docs folder, and the rest of the info you can find in the actual upgrade files by looking at them in a text editor.
I'd started it before, but had only gotten to step 3. Would that have created the new tables? Would it be easier to go in and just drop the new tables, then re-run the automatic creation? Sorry, don't really trust myself to be messing about creating tables manually... 😳
-------------------------------------------------------------------------
Edit: went in and dropped the new tables that were causing the errors, which worked, and I am now up to step 13. However, it would appear that although the table fanfiction_favseries also threw up the same error, after dropping and then automatically creating the tables, that one wasn't recreated. Does anyone have the structure for that one, please, as it's not in the docs file. Here's my current error...
A fatal MySQL error was encountered.
Query: INSERT INTO fffanfiction_favorites(uid, item, type) SELECT uid, seriesid, 'SE' FROM fffanfiction_favseries
Error: (1146) Table 'gateroom_ff.fffanfiction_favseries' doesn't exist
3.0 doesn't have a favseries table. I don't remember 100%, but that's probably a 2.0 table that it's trying to pull that info from and put in into fanfiction_favorites, where it needs to be. Somehow the fanfiction_favseries table was deleted beforehand.
Thanks Lyndsie, for your help. All issues have now been resolved through manual installation and deletion of tables, and manual editing of some SQL.
