Problems with 'limit 1' again

[Daniel Rt]

Dear friends:

I installed Photopost some weeks ago but nobody has still registered. I know some people has been trying to register but they couldn't. I receive following error messages in my mailbox:

An error was encountered during execution of the query:

SELECT bigimage,approved,cat,storecat,title,userid,width,height,date,filesize,rating,views,user FROM pp_photos WHERE id=’’ 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

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.


The message is ussually received twice, one wit WHERE id=’’ LIMIT 1 and one with WHERE id= LIMIT 1

May this be the cause of people to be unable to register?. How can I fix this?.

I had a similar problem you can find at Limit 1

Thanks in advance,


Daniel

[Chuck S]

That error would have nothing to do with registrations sorry but if your getting no registrations maybe someone does not want to register. The easiest way to find out if register works is simply to register a test account. The error noted is probally from a spider doing something it should not but the fix is easy we just encapulate the id variable

In comshow.php replace the query noted in your error with this one

Content visible to verified customers only.

[Daniel Rt]

I'm still having this error, even after fixing as explained.

Any other idea?.

Thanks,


Daniel