Hello!
URL to your eFiction: http://anime-fanfiction.animehq.hu/fanfic
Version of eFiction: 3.3.1
Have you bridged eFiction, if so with what?: i haven’t
Have you searched for your problem: yes
State the nature of your problem:
I have a little problem with the new patch. If i try to update my site, it will write out an error:
A fatal MySQL error was encountered.
Query: INSERT INTO 3fanfiction_coathors(`uid`, `sid`) VALUES('20', '117')
Error: (1146) Table 'animefanfic.3fanfiction_coathors' doesn't exist
Okay, then, i refresh the page, and the site writes out a new error:
A fatal MySQL error was encountered.
Query: CREATE TABLE `3fanfiction_coauthors` ( `sid` int(11) NOT NULL default '0', `uid` int(11) NOT NULL default '0', PRIMARY KEY (`sid`,`uid`) ) TYPE=MyISAM;
Error: (1050) Table '3fanfiction_coauthors' already exists
After it i tried to delete the coauthors table manually, and started the update from the first step. The result was that the site wrote out the first error again.
Can anybody help me?
https://efiction.org/forums/index.php?topic=6179.0
Whoever said nothing is impossible never tried slamming a revolving door.
url: https://www.potionsandsnitches.org/fanfiction
php: 7.4.33 msql: 5.6.51-community GPL
efic version: 3.5.5 latest patches: yes
bridges: none mods: challenges, tracker, story end, beta, word
Thanks, Jan_AQ for your reply, but... um, I know, I am lame, but unfortunately it still doesn't work. I have modified the efic version in the database manually, but the error messages are the same. So I don't think my problem and AnarchicQ's problem are the same. Marauder by Midnight wrote that "It should have 3.4.1 at the moment.", but my efic version is still 3.3.1, because I couldn't run the update, the errors came out after the confirm which have asked me if I want to run the update.
Tammy wrote that "Manually change your version to 3.4.2 through phpmyadmin." -- I don't understand it. If I change the version number manually, how could it help me? "You probably lost some co-author information." -- Does it mean that it causes my problem with the update?
Maybe I have misunderstood something.
If you open the update.php file in efiction in notepad do a Find all instances of "coathor" and replace it with "coauthor", save and run the update it will give rid of the first sql error about the table not existing with the typo.
I'm not sure about the rest though. I just know that typo causes a lot of problems for folks.
******************************************
Mucking around in eFiction since circa 2001 (ver. 1.0)
Now running v.3
"The action was succesful." - Thanks a lot 🙂 🙂 🙂
