URL to your eFiction: http://www.athenewolfe.com/justrewards/
Version of eFiction: 2.06 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: error 1050, step 4. `fangfanfiction_authorfields
State the nature of your problem: Copy and paste any errors you are receiving.
A fatal MySQL error was encountered.
Query: CREATE TABLE `fangfanfiction_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 'fangfanfiction_authorfields' already exists
I deleted everything - reinstalled all my 2.0 files, it worked then I tried to upgrading 3.2 again and now I keep getting stopped at step 4. I am so frustrated at this now being my fifth attempt that I just keep crying. I don't know what I am doing wrong. I don't know how to fix it, I am on the verge of deleting everything and telling all my users I quit. If you can help please let me know what the heck I am doing wrong...
Not well versed in the update script, but what I can do is decipher that error for you. What that statement is trying to do is create the database table fangfanfiction_authorfields and set it up. You're getting that error because fangfanfiction_authorfields already exists and the upgrade isn't' being told to skip the step if the table already exists. Because of that, I'm guessing that this table is new to Efic version 3.0+ otherwise there'd be some kind of UPDATE statement instead. Tammy Carissa, Jan, and others can verify that or state that I'm mistaken.
If the case that this table is new to efic version 3.0+, then perhaps the easiest solution for you is to delete that table in the database, then start at step 4. To delete the table, access your database using myPHPAdmin, find that table and delete it.
I hope that sheds some light on your problem. 🙂
Chelle's probably right. But I think before you delete it you should try to figure out why it's already there. Do you have any other scripts installed that might have an _authorfields table?
Here is more info:
I only have one database e_fiction that I have used for 2.0 etc. I have attempted to upgrade -- um five times now -- but when I started this attempt this morning I had uploaded a backup of my MySQL database and had reloaded my entire 2.0 website and it was working. I do have a backup of the website that my husband saved in another folder for me (he just renamed the old folder because he is out of town - but he said that shouldn't matter because the folder is named something differently.
I have been continuously trying to troubleshoot and figure this out .
1) The prefix for the upgrade is the same as the prefix for v 2 - would this affect anything - I didn't think it would because I actually got to step 19 last time I tried to upgrade. Is this going to cause any problems.
2) Is it going to cause a problem to have a folder called bad version and the good version? All the links etc would be different?
3) I checked and yes I do have fanfiction author fields in the database. My browser crashed so I no longer have the install page up either. Should I a) reload everything and start over making sure that I delete authorfiields if it is till in mySQL databse? When i do this should I (tech idiot) try to manual install or just hope the automatic works) or b) something else
4) Since my browser crashed I can't get /install to pull anything up... does this mean i need to start over
5) My husband thinks that the backup I am installing (through the server) of the MySQL database is not deleting things that were added and instead only putting things back to the way they were - I am not sure if it is or not - but it says create a backup which I did and upload backup (which I did)
Sprry for this to be so long --- trying to get as many issues resolved as possible so I don't have to keep posting thread after thread
Thank you in advance!
OK, so you just have efiction using that database, correct? No other script has information stored in that database? I'm assuming this as fact for the rest of my reply.
1) Shouldn't affect anything. I did the same thing for my upgrades.
2) Not sure what you're asking..are you talking about your backup of the site? Shouldn't because it's just a file destination on your computer..not your website and all you would be doing is uploading the contents.
3) If, as Tammy cautioned in her reply, that table isn't being used for anything else other than efic, then you should be fine. As i said in my reply, sounds like it's a table not in version 2.0, otherwise the upgrade script would have had an UPDATE statement or tell the upgrade to skip it if there was no change to be done. I think the upgrade script moves data into it after it's created from an existing table in 2.0..I think. Been a long time since I've upgraded.
4) I don't know what the URL is to start at a certain step...perhaps someone else does and can post it. But yes, that is one way to go
5) The backup..was this of the 2.0 database? Any backups of databases done backs up the information in the database at the time you initiate the back up. It doesn't execute any commands to delete anything or add anything or modify anything whatsoever. If you did a backup of your database after you tried to upgrade and are uploading that, that could explain why you got this error on step 4 instead of getting to step 19 with no issue.
Hope that helps a lil bit more
Thank you so much Chelle and Tammy for all your help!
I know have a semi- successful running 3.21 website.
How I did this... um... I kinda found step 5 in my history and kept going through the process - skipping that same error in a few places. Now I have a few errors but hopefully I can get this fixed with the help of the search function. thank you again for the help. I will now go and search the help for the problems I am encountering now (some duplicate links, etc)
No problem, glad I could help out a bit 🙂
