An error was encountered

klaush · February 13th, 2011, 06:22 PM

Hello Chuck,

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!

Greetings

Klaus

Chuck S · February 13th, 2011, 06:50 PM

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.

klaush · February 13th, 2011, 09:06 PM

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.

Greetings

Klaus

Chuck S · February 13th, 2011, 10:22 PM

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.

klaush · February 13th, 2011, 10:31 PM

Thanks, Chuck; i just did an update to 4.2. So let´s see, what will happen in the next few days!

Greetings

Klaus

Chuck S · February 14th, 2011, 07:55 AM

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.

klaush · March 3rd, 2011, 09:18 AM

We still have that issue, Chuck.

What do you think, what we can do?

Chuck S · March 3rd, 2011, 09:47 AM

You can try making the query in comshow.php this

Code:

Content visible to verified customers only.

Personally I would simply add something like this to the robots.txt

Code:

Content visible to verified customers only.

Really the only way to get this issue since we do not present a link in the program for it is you have to have 0 comments and have a bot just playing with urls and filenames. Your seeing an error you never would see in the program because we do not give you a link with no comments.

klaush · March 3rd, 2011, 09:59 AM

Thanks Chuck, we´ll try that and i will give feedback here!

Chuck S · March 3rd, 2011, 11:48 AM

No problem either should assist in that regard.

klaush · March 21st, 2011, 11:19 AM

Hello Chuck, promised to give feedback, this did the trick!

Thanks!

[quote=Chuck S;1285247]You can try making the query in comshow.php this

Code:

Content visible to verified customers only.

Chuck S · March 21st, 2011, 01:00 PM

enjoy your week glad to help