|
Thanks.
Without knowing what the fix is, I can't tell if you'll be fixing similar errors I am seeing, so here are a few more:
=============
An error was encountered during execution of the query:
SELECT id,user,userid,cat,title,manu,bigimage,views, id*0+RAND() as rand_col FROM rp_products WHERE bigimage !='' AND approved='1' AND cat in (all,1,23,35) ORDER BY rand_col DESC
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 'all,1,23,35) ORDER BY rand_col DESC' at line 1
==========
An error was encountered during execution of the query:
SELECT id,user,userid,cat,title,manu,bigimage,views, id*0+RAND() as rand_col FROM rp_products WHERE bigimage !='' AND approved='1' AND cat in (last14,1,23,35) ORDER BY rand_col DESC
The query returned with an errorcode of:
Unknown column 'last14' in 'where clause'
===============
An error was encountered during execution of the query:
SELECT id,user,userid,cat,title,manu,bigimage,views, id*0+RAND() as rand_col FROM rp_products WHERE bigimage !='' AND approved='1' AND cat in (fav,1,23,35) ORDER BY rand_col DESC
The query returned with an errorcode of:
Unknown column 'fav' in 'where clause'
|