MySQL Error Report

[softsingapore]

An error was encountered during execution of the query:

SELECT bigimage,approved,cat,title,userid,date,rating,views,user FROM cp_products 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: Photopost Pro Bug Reports - PhotoPost Community

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

I have been getting quite a few of these, is there something I should do?

[Chuck S]

I will see if I can find anything.

[klaush]

The same here since today!

Originally Posted by Chuck S

I will see if I can find anything.

[Chuck S]

well how do you get this error anything in the report? how about if you set the debug option to display errors?

[klaush]

Chuck, i will see, if we could get any information. The last three days the error did not happen.

Greetings

Klaus

[Chuck S]

yeah no problem I am testing as well but do not get any errors then again I am using 4.1 which I think was released after this thread.

[RobVA]

In the last week, I started getting the same exact errors and I am running 4.1 with MySQL version 5.0.9-community.

[Chuck S]

That query is only used in comshow.php

I would suspect this is a BOT issue.

That error would only happen if you have no comments and in our software we do not show a link to users unless there is a comment so bots have to be scanning different scripting.

I can alter the query to surpress any error by simply putting '' around the id variable however my suggestion would be to put this in the robots.txt file in your classifieds folder

Content visible to verified customers only.

[klaush]

O.k., update from me/us. The error is gone, heaven knows why, for we did not change anything at all.

Greetings

Klaus

[Chuck S]

Okay no problem

[firstrebel]

I have just started getting these from our Photopost Pro gallery (version 7.1)

Bob

[Chuck S]

You can try what is posted in post 8

[firstrebel]

That does not work.

Bob

[Chuck S]

well then maybe your issue is not what is posted here not much for me to go on with the info given.

[firstrebel]

Same error message

An error was encountered during execution of the query:

SELECT bigimage,approved,cat,storecat,title,userid,width,height,date,filesize,rating,views,user FROM 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: Photopost Pro Bug Reports - PhotoPost Community

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

Bob

[Chuck S]

well your problem would have to be a bot viewing the file directly. See if you have no comments on your system we do not show a link to that script.

I suppose you could edit comshow.php and add the following code where noted in bold to kill the script before it does anything if there are no comments like this.

Content visible to verified customers only.

[firstrebel]

Thank you for the code but it stopped before I used it. Really odd.

Bob

[Chuck S]

yeah as I suspected a bot issue but the code above should as well add a second level of defense

[firstrebel]

This has come back with avengance, over a 100 messages overnight, and one in the past few minutes. I have narrowed this down to either Google on IP 66.249. or msnbot on 157.55. I wonder what has changed to do this on an intermittent basis. I will put your code in and see if it goes away permanently.

Bob

[Chuck S]

Yep try post 16 also but post 8 should stop a bot anyway do both.