URL to your eFiction: http://jarlylove.com/fanfic/
Version of eFiction: 3.0
Version of PHP: 4.4.2
Version of MySQL: 5.0.16 I think. I looked at phpmyadmin and it said
MySQL client version: 5.0.16
Have you searched for your problem: Yes
If so, what terms did you try: Fatal MySQL Error, and I looked in every board (archived and non) with 3.0
Have you looked at the FAQs: I didn't see a 3.0 FAQ
State the nature of your problem: I get this error when trying to click on a letter when viewing all members here:
http://jarlylove.com/fanfic/authors.php?action=list
A fatal MySQL error was encountered.
Query: SELECT count( stories.sid ) as stories, author.penname as penname, author.uid as uid FROM jarlylov_fanficfanfiction_authors as author LEFT JOIN jarlylov_fanficfanfiction_authorprefs AS ap ON author.uid = ap.uid LEFT JOIN jarlylov_fanficfanfiction_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 'D%' GROUP BY author.uid ORDER BY author.penname LIMIT 0,40
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 'D%' GROUP BY author.uid ORDER BY author.penname LIMIT' at line 1
Url: http://fanfic.jarlylove.com/
Efic Version: 3.3.1
Latest Patches: Yes
Bridges: none
Mods: Challenges, Beta-Reader, Recommendations, Story end
PHP: 5.2.2
MySQL: 5
I don't think that this is an upgrade problem... seems like you upgraded fine, your problem is a member list. O.o
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 a bug. Watch for an update in the next couple of days to fix it.
Manual fix in the meantime. Open authors.php and change WHERE to AND on lines 66 and 67.
I do not get this bug with the latest update. Moving to solved.
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