Wedge

Public area => Bug reports => The Pub => Archived fixes => Topic started by: txcas on March 1st, 2014, 03:37 AM

Title: Database Error: You have an error in your SQL syntax...
Post by: txcas on March 1st, 2014, 03:37 AM

I found this in the error log.

Code: [Select]

URL http://www.domain.com/do/search2/
Database Error: 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 '' at line 3
Only show the errors from this file File: /home/creedmoo/public_html/gz/app/Search2.php
 Line: 232

Title: Re: Database Error: You have an error in your SQL syntax...
Post by: Nao on March 1st, 2014, 02:13 PM

I can't reproduce this. The error doesn't show the complete query.
Please go to Admin > Server > Error log > Settings, and enable the logging of DB queries. Then, if and when this happens again, please post the complete query.
Oh, scratch that... It's good if you enable this, but I was able to reproduce.
Search for anything, and instead of '*' in the username box, enter ',' (just a comma), or a space (or several). Boom, error shows up.
Will fix in a minute.

Title: Re: Database Error: You have an error in your SQL syntax...
Post by: Nao on March 1st, 2014, 02:18 PM

Fixed!
Thanks :)

Title: Re: Database Error: You have an error in your SQL syntax...
Post by: Farjo on March 1st, 2014, 02:52 PM

Note for txcas: I recreated this then applied the fix. It worked once I had purged the cache.