I deleted a classification that I screwed up and though it deleted it, I got the below error:
A fatal MySQL error was encountered.
Query: UPDATE hp.fanfiction_stories SET classes = '155,52,101,3,10,7,2,5' WHERE sid = '781' LIMIT 1
Error: (1146) Table 'hp.fanfiction_stories' doesn't exist
Dreamy
Current Version: 3.4.2
PHP 4
Mods: Challenges, Recommendations, Storyend, Display Word, Beta Reader, Bad Reviewer
There's an extra period in the file. Some of your stories will probably have a phantom classification now, but I don't think you'll see any error messages pop up.
I found it, posting so others can fix theirs till the update.
Open admin/classifications.php
Find:
dbquery("UPDATE ".$tableprefix.".fanfiction_stories SET classes = '".implode(",", array_diff(explode(",", $s['classes']), array($class)))."' WHERE sid = '$s[sid]' LIMIT 1");
Replace with:
dbquery("UPDATE ".$tableprefix."fanfiction_stories SET classes = '".implode(",", array_diff(explode(",", $s['classes']), array($class)))."' WHERE sid = '$s[sid]' LIMIT 1");
Dreamy
Current Version: 3.4.2
PHP 4
Mods: Challenges, Recommendations, Storyend, Display Word, Beta Reader, Bad Reviewer
Tammy, you forgot to fix this in your update. It's line 49 I believe.
Just thought you would like to know. 🙂
Current Version: 3.4.2
PHP 4
Mods: Challenges, Recommendations, Storyend, Display Word, Beta Reader, Bad Reviewer
Thanks for the info.
This should be fixed with 3.3.
I created some classifications and deleted them and didn't have any problems. 🙂 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
