Notifications
Clear all

All Member Search Fatal MySQL Error

4 Posts
3 Users
0 Reactions
2,340 Views
(@clove)
Posts: 26
Eminent Member
Topic starter
 

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

Corinne-Designs.net

 
Posted : 03/12/2006 10:03 pm
Jan_AQ
(@jan_aq)
Posts: 1300
Noble Member
 

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

 
Posted : 04/12/2006 1:54 am
(@tammy)
Posts: 2577
Member Moderator
 

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.


 
Posted : 04/12/2006 3:04 am
Jan_AQ
(@jan_aq)
Posts: 1300
Noble Member
 

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

 
Posted : 13/12/2006 7:33 pm
Share: