Hello. Long time reader, first time poster here.
First off, I just want to say a huge thank you to Tammy for the wonderful work she has done on efiction and to all the volunteers who help out with answering questions here. Whether it was directly or not, your knowledge and advice have been really helpful to me and I appreciate all the work that's being done here.
So onto, the my current issue:
URL to your eFiction: Still under construction. Not yet public
Version of eFiction: 3.3.1 trying for 3.4.2
Have you bridged eFiction, if so with what?: No
Version of PHP: 4.4.7
Version of MySQL: 4.1.22
Have you searched for your problem: Yes
If so, what terms did you try: MySQL error, database error, upgrade problem
State the nature of your problem: A fatal MySQL error was encountered during the upgrade from 3.3.1 to 3.4.2
Do you have a test account for us? Not until I can get things running again
So, I've been playing around with efiction 3.3.1 for a few months now, trying to convert a rather large website archive (already hosted by me) into an efiction site. The accounts have all been created by me and the stories have all been uploaded by me. I've been waiting until I have the project (skins, stories, modules, everything) complete to invite the authors. I also run a phpBB forum from the same hosting package, but the two will not be connected in any way.
All was well until I tried to upgrade to 3.4.2. I followed the insturctions in the README.txt file and when I clicked "yes" I want to update, I got one of these:
A fatal MySQL error was encountered.
Query: CREATE TABLE `ef_fanfiction_coauthors` ( `sid` int(11) NOT NULL default '0', `uid` int(11) NOT NULL default '0', PRIMARY KEY (`sid`,`uid`) ) TYPE=MyISAM;
Error: (1050) Table 'ef_fanfiction_coauthors' already exists
I can't claim to be a php expert, but I've helped with the design and modding of a few forums to have a fairly good idea of what I'm doing. However, the MySQL end of it, I know very little about. I tried skipping that step by doing the database queries manually, but I just don't know how the query is supposed to be written up to make it work. Then I restored my backup and tried again, but still the same error popped up. I've even tried asking for help from others I know who also use efiction, but nothing seems to work. So, if anyone has any idea where I've gone wrong and might be able to help me get back on the right track to finish the upgrade, I will be forever in your debt.
Thanks in advance.
Jaded
Looks like you may have double clicked in the update and it ran or half-way ran twice. You should be able to just edit your version number in phpmyadmin and be good to go.
Thank you for such a quick reply, Tammy! I was hoping it would be something simple like that. You're going to have to forgive my sounding like an idiot here, but where in phpmyadmin do I make that edit? I tend to get a little lost in there if it's anything more complicated than making a database backup.
It's in _settings. Click Browse & you'll see it (toward the bottom, I think).
URL to your eFiction: http://www.mickiclark.com/efiction33
Version of eFiction: 3.3.1
Have you bridged eFiction, if so with what?: SMF
Version of PHP:
Version of MySQL: MySQL 4.1.14
Found it!!! And...
You are currently running eFiction version 3.4.2. 😀
It's working now! Thank you both so much for your help!
