Error Query

[maomao]

After upgrade to latest version i have this error sometimes
-------------

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.

[maomao]

I read now here

Mysql error code

i tried to change showgallery.php

from

$query .= "WHERE userid=$ppuser AND storecat=0";

to
$query .= "WHERE userid='$ppuser' AND storecat=0";

[Chuck S]

yes that should be fine.