Frequently SQL Error

[vigape]

An error was encountered during execution of the query:

SELECT p.id,p.title,p.userid,p.cat,p.approved,p.storecat,p.bigimage FROM pp_photos p LEFT JOIN pp_categories c ON p.cat=c.id WHERE p.userid= AND c.password='' ORDER BY p.date DESC LIMIT 5

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 c.password='' ORDER BY p.date DESC LIMIT 5' at line 1

If you need assistence or feel this is a 'bug'; please report it to our support forums at: http://www.photopost.com/members/forum/f66/index.html

To turn off these emails, set $debug=0 in your config-inc.php file.

[Chuck S]

I would suspect maybe a bot playing with a url so member.php this line 553 make it this all I am doing is encapsulating a variable in the query

Content visible to verified customers only.

[oly51]

I was getting the same error message. I made your change to member.php.

[oly51]

Scott - Made that change earlier and I just got 10 new error notifications:

An error was encountered during execution of the query:

SELECT id,user,userid,date FROM photos WHERE cat IN (501,535,3197,3231,3300,3303,
3301,3302,3047,3294,3253,508,3275,3221,3172,3098,3042,534,509,515,521,522,3037,
502,3235,3115,3057,541,510,511,517,3038,3070,546,516,537,538,512,3237,3102,3049,
536,513,514,518,519,520,3067,545,3252,3297,3061,3298,3226,542,3233,3107,) ORDER BY date DESC LIMIT 1

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 ') ORDER BY date DESC LIMIT 1' at line 1

If you need assistence or feel this is a 'bug'; please report it to our support forums at:
http://www.photopost.com/members/forum/f66/index.html

To turn off these emails, set $debug=0 in your config-inc.php file.

[Chuck S]

That is some other query and as noted in the query your issue is your last child is empty thats the error.

Is there a little more info here on what your where doing viewing etc?