MySQL Error Report
 

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

I will see if I can find anything.

The same here since today!

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

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

Greetings

Klaus

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.

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

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

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

Greetings

Klaus

Okay no problem

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

Bob

You can try what is posted in post 8

That does not work.

Bob

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

Same error message
Bob

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.

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

Bob

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

It's back
 

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

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