When I tried to upgrade to 3.4.2, I got this message
A fatal MySQL error was encountered.
Query: INSERT INTO shficfanfiction_coathors(`uid`, `sid`) VALUES('13', '12')
Error: (1146) Table 'splurd_shfanfic.shficfanfiction_coathors' doesn't exist
you'll note it says coathors, how do I fix this?
EDIT: I tried going into php and inserting values 13 and 12 manually into the coauthor's table and now I have this problem
A fatal MySQL error was encountered.
Query: CREATE TABLE `shficfanfiction_coauthors` ( `sid` int(11) NOT NULL default '0', `uid` int(11) NOT NULL default '0', PRIMARY KEY (`sid`,`uid`) ) TYPE=MyISAM;
Error: (1050) Table 'shficfanfiction_coauthors' already exists
eFiction:3.5.1
Latest Patche(s):Yes
bridged?:No
modified?:Yes.
PHP:2.11.9.4
MySQL:5.0.32
Manually change your version to 3.4.2 through phpmyadmin. You probably lost some co-author information. If you've got a database backup and want to revert and do it over the typo is on line 235 of update.php. I'll fix it in the .zip in a bit.
How do I do that? I'm afraid of breaking something.
Or should I just wait for the updated zip?
eFiction:3.5.1
Latest Patche(s):Yes
bridged?:No
modified?:Yes.
PHP:2.11.9.4
MySQL:5.0.32
To manually change your version to 3.4.2, go to phpmyadmin and fanfiction_settings and "Browse". Edit the row with your site key. Scroll all the way down until you see the word "version". It should have 3.4.1 at the moment. Change it to 3.4.2. Then hit "Go".
I do not know if you got to update yet or not, but I just encountered this same bug from a fresh download.
I do not know if you got to update yet or not, but I just encountered this same bug from a fresh download.
Well, I lost all the co-author information, and in fact, the list for selecting co-author's is empty when submitting a new story. *Shrug*
eFiction:3.5.1
Latest Patche(s):Yes
bridged?:No
modified?:Yes.
PHP:2.11.9.4
MySQL:5.0.32
Do you mean when you add a story and you type in the first few letters for the co-author nothing shows up?
******************************************
Mucking around in eFiction since circa 2001 (ver. 1.0)
Now running v.3
Do you mean when you add a story and you type in the first few letters for the co-author nothing shows up?
*Blinks* Is that a new feature? Before the list was just filled with every members name and you would just click on them to select your co-author.
Ok, no problem then, I suppose.
eFiction:3.5.1
Latest Patche(s):Yes
bridged?:No
modified?:Yes.
PHP:2.11.9.4
MySQL:5.0.32
Yeah, that's a new feature to 3.4. It took me by surprise when I first saw it as well.
******************************************
Mucking around in eFiction since circa 2001 (ver. 1.0)
Now running v.3
Please note that this is stil NOT fixed in the zip.
Can you please check and see if this is still an issue with 3.5? Thank you!
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
Moving to solved. This was only an issue in the update script for version 3.4.2 which has now been superseded by 3.4.3 and 3.5. The issue wasn't in the 3.4.3 update script.
