I was viewing the members list in the admin panel and I clicked on a letter:
A fatal MySQL error was encountered.
Query: SELECT COUNT(DISTINCT author.uid) FROM fanfiction_authors as author LEFT JOIN fanfiction_stories as stories ON stories.validated > 0 AND (FIND_IN_SET(author.uid, stories.coauthors) > 0 OR stories.uid = author.uid) LEFT JOIN fanfiction_authorprefs as ap ON author.uid = ap.uid AND _PENNNAMEFIELD LIKE 'N%'
Error: (1054) Unknown column '_PENNNAMEFIELD' in 'on clause'
http://www.potionsandsnitches.net/fanfiction/admin.php?action=members
http://www.potionsandsnitches.net/fanfiction/admin.php?action=members&do=list&list=members&let=N
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
Easy fix. It's got NNN instead of NN.
The letters don't take you to the actual letter page now. You click on the L, it highlights the L so you know you're on the page, but the list of the authors is still on the A's.
Similar thing to the challenge bug here: https://efiction.org/forums/index.php?topic=4085.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
Okay. We'll give this another shot tonight.
The pagelinks at the bottom work, but the ABC links at the top give me this 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 author.penname LIKE 'L%' 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 author.penname LIKE 'L%' GROUP BY author.uid ORDER BY author.penname LIMIT' 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
This is now solved. 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
