An error was encountered
i announced this already but got no answer:
An error was encountered during execution of the query:
SELECT bigimage,approved,cat,title,userid,date,rating,views,user FROM pp_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.
We have this error since weeks a few times a day.
What causes this and how can we solve it?
Thanks for help!
Not sure where you asked this as it does not appear to be here in our forums as I viewed your posts for the past 2 months or more and nothing about this.
At any rate it would help to know what script we are talking about here. The error is the product id is empty.
I have searched most of the main scripts so far and do not find that query. I will continue to search but tell me more about what action your doing to produce the error.
I told about the error in this thread.
But anyway, i canīt reproduce this on with my account or any action i do in and with classified. Today we had this error nearly 10 times, yesterday only twice, may tommorrow it will not behappen.
long time ago
well the problem I am having is not being able to find that query in our actual program
but I finally found it however no idea how you would get any errors its in comshow script
It has to be some bot or something. we only have one link to the comshow script in our application and thats on the comments block on index page. That only shows when there are comments to display so in short your problem is a bot.
Thanks, Chuck; i just did an update to 4.2. So letīs see, what will happen in the next few days!
Yeah like I said we only display the comshow link when you have comments so apparently a bot is playing with a url. If you continue to have an issue I can try an alteration to the code.
We still have that issue, Chuck.
What do you think, what we can do?
You can try making the query in comshow.php this
Thanks Chuck, weīll try that and i will give feedback here!
No problem either should assist in that regard.
Hello Chuck, promised to give feedback, this did the trick!
[quote=Chuck S;1285247]You can try making the query in comshow.php this
enjoy your week glad to help
|All times are GMT -5. The time now is 12:21 PM.|
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0