December 18th, 2009, 08:31 AM
|
#1 (permalink)
|
| Junior Member Verified Customer
Join Date: Jul 2009
Posts: 8
| SQL error after 7.0 upgrade
I just upgraded from 5.3 to 7.0. PP is sending me emails with the following: Quote:
An error was encountered during execution of the query:
SELECT id,user,userid,cat,storecat,date,title,description,ismature,keywords,bigimage,width,height,filesize,views,medwidth,medheight,medsize,approved,rating,votes,allowprint,numcom,lastposter FROM pp_photos WHERE userid= AND storecat=0 ORDER BY disporder,date 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 'AND storecat=0 ORDER BY disporder,date DESC' at line 1
| It looks like the userid is missing causing the SQL error, but I can't figure out what page this is on as from my quick look over my gallery frontend I don't see anything obviously missing or erroring.
|
| |