SQL error

[VW Derf]

Last weekend I upgraded from 5.2x to 7.01 and it pretty much went fine. When upgrading to 5.5 I received the error ""Error: Duplicate entry '223' for key 1" errors and "Error: Duplicate column name 'lastphoto'" but otherwise all was ok and worked fine.

I did however start to receive some emails with query problems as shown below:
--------------------------
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
------------

A quick look at the code indicates that userID was not filled in, but I don't know what query/feature is being run when this happens.

Any ideas?

thanks,

[Chuck S]

Try changing this in showgallery.php

Content visible to verified customers only.

to this

Content visible to verified customers only.

[VW Derf]

Just did that update and now I get this error:

Content visible to verified customers only.

[Chuck S]

reapply the edit above.

[VW Derf]

Thanks,

So far so good. I cant' get the error to re-appear, but I'll give my users a couple of days to verify.

[Chuck S]

Nope that should solve your issue.

[VW Derf]

Yup, it seems to have. No error messages since this was applied.

Thanks for the quick response!

[Chuck S]

glad to assist