PhotoPost Community

PhotoPost Community (http://www.photopost.com/forum/)
-   Photopost Pro Bug Reports (http://www.photopost.com/forum/photopost-pro-bug-reports/)
-   -   Gallery MySQL Error Report (http://www.photopost.com/forum/photopost-pro-bug-reports/147343-gallery-mysql-error-report.html)

firstrebel January 21st, 2012 03:01 AM

Gallery MySQL Error Report
 
Chuck

I am starting a thread here that links to the http://www.photopost.com/forum/class...or-report.html in the Classifieds Bug reports forum so that Photopost Pro Gallery users may see it and may get a response.

Quote:

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 January 21st, 2012 07:46 AM

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.


All times are GMT -5. The time now is 03:52 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97