Gallery MySQL Error Report

[firstrebel]

Chuck

I am starting a thread here that links to the MySQL Error Report in the Classifieds Bug reports forum so that Photopost Pro Gallery users may see it and may get a response.

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.

I have just got another 155 messages since I did both the mods last night you suggested in the original thread. I could block all bots to see what happens, but as found by myself and the original reporter, this stops and starts for a reason not clear at the moment. I will trawl the logs and try to see what IPs may be hitting the gallery at the times on the error messages.

Of course the big question is, what has started this ???

Bob

[Chuck S]

You can apply the same to your gallery as I said for the classifieds but most likely it is a bot just like I have already said. we do not show a comshow.php link in our application if there are no comments.

PhotoPost 8 already has any recommended fixes which should be gold anyday so this matter is a mute point.