Mysql error: SELECT lastphoto FROM pp_users WHERE userid= LIMIT 1

[Alfa1]

An error was encountered during execution of the query:

SELECT lastphoto FROM pp_users WHERE userid= 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 'LIMIT 1' at line 1

PP 8.01
vb3.8
PHP 5.3.8
LSWS 5.5
MySQL5.5.11

IIC I have had this error in previous versions as well.
Please advise how to resolve this.

[Chuck S]

What are you doing to get that error?

I would suspect some bot playing with the urls and variables because one would never get an error through normal program operation.

Here is the query in editphoto.php or adm-misc.php

Content visible to verified customers only.

$puserid is definately defined but you can stop any error if this is indeed a bot by encapsulating $puserid in that query with single quotes

Content visible to verified customers only.

[Alfa1]

Im not sure whats causing it. It could be caused by editing / deleting photos.

[Chuck S]

I do not see any issues deleting photos through editphoto but as I said encapsulating that variable indeed will resolve the query error your posting. The reason I say is a bot playing with urls is $puserid would NEVER be empty through normal script operation.