SQL errors after upgrade from 6.2

[DaveS]

Hi I'm getting the following errors after an upgrade from 6.2 to 7.02.

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.

[Chuck S]

SQL error

That would help

[DaveS]

ok thanks, but.... why am I hacking core Photopost files? This isn't a great thing to do as every time I upgrade it's going to break if that file has been updated.

I have made the change anyway so we'll see if it sorts it.

[Chuck S]

That was a reported bug after the release of 7.02 it will be included in the next release.

[DaveS]

Originally Posted by Chuck S

That was a reported bug after the release of 7.02 it will be included in the next release.

Ok understood. Thanks for the update.

[Chuck S]

enjoy let us know if you need anything else