A fatal MySQL error was encountered.
Query: SELECT count(sid) FROM fanfiction_stories as stories WHERE validated > 0 AND stories.completed = '1' AND FIND_IN_SET(,22, stories.classes) > 0 AND FIND_IN_SET(27, stories.classes) > 0 AND featured > 0
Error: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '22, stories.classes) > 0 AND FIND_IN_SET(27, stories.classes) > 0 AND featured >' at line 1
I was browsing in the Featured Stories list. I sorted for only one warnings, and then I sorted again for a different warning.
Page I got the error:
http://www.potionsandsnitches.net/fanfiction/browse.php?type=featured&catid=&complete=1&classin=,22&wordlow=-500&wordhigh=1000000
Page I was on before I got the error:
http://www.potionsandsnitches.net/fanfiction/browse.php?type=featured&catid=&complete=1&wordlow=-500&wordhigh=1000000
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
Okay, I'll look into it. FYI for others that follow, that'll happen on any of the browse pages until I get it fixed.
A fatal MySQL error was encountered.
Query: SELECT count(sid) FROM fanfiction_stories as stories WHERE validated > 0 AND stories.completed = '1' AND FIND_IN_SET(12,22, stories.classes) > 0 AND FIND_IN_SET(22, stories.classes) > 0 AND featured > 0
Error: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' stories.classes) > 0 AND FIND_IN_SET(22, stories.classes) > 0 AND featured > 0' at line 1
http://www.potionsandsnitches.net/fanfiction/browse.php?type=featured&complete=1&classin=12,22
I sorted for a warning. it worked well. I sorted for another warning, no results, but that's okay. I sorted for the same warning and got this. Apparently the third time breaks it.
I also got this when I tried to reset the sorts to show everything:
A fatal MySQL error was encountered.
Query: SELECT count(sid) fanfiction_stories as stories WHERE validated > 0 AND stories.completed = '1' AND FIND_IN_SET(12,22, stories.classes) > 0 AND featured > 0
Error: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' stories.classes) > 0 AND featured > 0' at line 1
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
I think that this is fixed now. Thank you Tammy. 🙂
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
