View Single Post
Old December 18th, 2009, 08:31 AM   #1 (permalink)
cdub
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.
cdub is offline   Reply With Quote