View Single Post
Old July 28th, 2009, 10:23 AM   #1 (permalink)
cdub
Junior Member
Verified Customer
 
Join Date: Jul 2009
Posts: 8
SQL errors after upgrade

I just upgraded my PP from 5.6 to 6.23. I'm now getting email like the following:

Quote:
An error was encountered during execution of the query:

SELECT id,user,userid,cat,storecat,title,ismature,bigimage,height,width FROM pp_photos WHERE approved=1 AND storecat=0 AND cat IN (2,c) ORDER BY date DESC LIMIT 34

The query returned with an errorcode of:

Unknown column 'c' in 'where clause'

If you need assistence or feel this is a 'bug'; please report it to our support forums at: Photopost Pro Bug Reports - PhotoPost Community

To turn off these emails, set $debug=0 in your config-inc.php file.
I get a few different email for different queries, but each has the same
Quote:
Unknown column 'c' in 'where clause'
error in each of them. I haven't run into any errors on the site, but the amount of email is a bit alarming. Any help?
cdub is offline   Reply With Quote