View Single Post
Old July 26th, 2010, 01:00 AM   #1 (permalink)
DaveS
Junior Member
Verified Customer
 
Join Date: Feb 2007
Posts: 21
SQL errors after upgrade from 6.2

Hi I'm getting the following errors after an upgrade from 6.2 to 7.02.
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

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.

Last edited by DaveS; July 26th, 2010 at 03:23 PM.
DaveS is offline   Reply With Quote