Notifications
Clear all
Topic starter
When I attempt to search by Penname in simple search I get the following 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 '%babaca%' GROUP BY author.uid
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 '%babaca%' GROUP BY author.uid' at line 1
******************************************
Mucking around in eFiction since circa 2001 (ver. 1.0)
Now running v.3
Posted : 30/11/2006 9:57 pm
Weird. Okay it'll be fixed in the morning.
Posted : 01/12/2006 12:34 am
Topic starter
It's fixed by the way.
******************************************
Mucking around in eFiction since circa 2001 (ver. 1.0)
Now running v.3
Posted : 06/12/2006 3:54 pm
