MySQL error email

I received some emails that shows :


------------------------------------------------

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.

-----------------------------------


An error was encountered during execution of the query:

SELECT photo,comment FROM pp_comments WHERE userid= AND comment != '' 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 'AND comment != '' 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.





any idea how to fix this error?

thanks

[Chuck S]

Line 364 of member.php should be this. Simple encapsulate(place single quotes around) the $uid variable in the query.

Content visible to verified customers only.

also line 540 of that same file the same issue.

Content visible to verified customers only.

Chuck, i replaced the code. but now i get another error message.

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: SELECT photo,comment FROM pp_comments WHERE userid= AND comment != '' ORDER BY date DESC LIMIT 1

Result: 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 comment != '' ORDER BY date DESC LIMIT 1' at line 1

Database handle: Resource id #24

[Chuck S]

that error tells me you have no applied the first query alteration. If you had added that query you would not get the same error you initially posted and you are.