Viewing all admin members has an error:
A fatal MySQL error was encountered.
Query: SELECT count( stories.sid ) as stories, author.penname as penname, author.uid as uid FROM fanfiction_authors as author LEFT JOIN fanfiction_authorprefs AS ap ON author.uid = ap.uid LEFT JOIN fanfiction_stories AS stories ON stories.validated > 0 WHERE (FIND_IN_SET(author.uid, stories.coauthors) > 0 OR stories.uid = author.uid) WHERE ap.level > 0 AND ap.level < 4 GROUP BY author.uid ORDER BY author.penname LIMIT 0,24
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 'WHERE ap.level > 0 AND ap.level < 4 GROUP BY author.uid ORDER BY author.penname ' at line 1
http://www.potionsandsnitches.net/fanfiction/authors.php?list=admins
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
Yeah it's the same problem as reported in another thread.
This is now fixed. Thanks 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
