Hey there,
We've been getting reports of the following error. Any ideas of what might be causing this?
> An error was encountered during execution of the query:
>
> SELECT id,cat FROM pp_photos WHERE approved=1 AND storecat=0 AND ((title
> LIKE "% "carnival%" OR description LIKE "% "carnival%" OR keywords LIKE "%
> "carnival%" OR bigimage LIKE "% "carnival%"
> OR extra1 LIKE "% "carnival%" OR extra2 LIKE "%
> "carnival%" OR extra3 LIKE "% "carnival%" OR extra4 LIKE "% "carnival%" OR
> extra5 LIKE "% "carnival%" OR extra6 LIKE "% "carnival%") OR (title LIKE
> ""carnival%" OR description LIKE ""carnival%" OR keywords LIKE
> ""carnival%" OR bigimage LIKE ""carnival%"
> OR extra1 LIKE "%"carnival%" OR extra2 LIKE
> "%"carnival%" OR extra3 LIKE "%"carnival%" OR extra4 LIKE "%"carnival%" OR
> extra5 LIKE "%"carnival%" OR extra6 LIKE "%"carnival%"))AND ((title LIKE
> "% holiday"%" OR description LIKE "% holiday"%" OR keywords LIKE "%
> holiday"%" OR bigimage LIKE "% holiday"%"
> OR extra1 LIKE "% holiday"%" OR extra2 LIKE "%
> holiday"%" OR extra3 LIKE "% holiday"%" OR extra4 LIKE "% holiday"%" OR
> extra5 LIKE "% holiday"%" OR extra6 LIKE "% holiday"%") OR (title LIKE
> "holiday"%" OR description LIKE "holiday"%" OR keywords LIKE "holiday"%"
> OR bigimage LIKE "holiday"%"
> OR extra1 LIKE "%holiday"%" OR extra2 LIKE
> "%holiday"%" OR extra3 LIKE "%holiday"%" OR extra4 LIKE "%holiday"%" OR
> extra5 LIKE "%holiday"%" OR extra6 LIKE "%holiday"%")) ORDER BY date DESC
> LIMIT 50
>
> The query returned with an errorcode of:
>
> 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 'carnival%" OR
> description LIKE "% "carnival%" OR keywords LIKE "
>
> If you need assistence or feel this is a 'bug'; please report it to our
> support forums at:
http://www.photopost.com/members/forum/f66/index.html
>
> To turn off these emails, set $debug=0 in your config-inc.php file.
>