Mysql error

aberg · January 5th, 2010, 12:17 PM

I'am received about two times a day this error:

An error was encountered during execution of the query:

SELECT id,user,userid,cat,storecat,date,title,description,ismature,keywords,bigimage,width,height,filesize,views,medwidth,medheight,medsize,approved,rating,votes,allowprint,numcom,lastposter FROM pp_photos WHERE userid= AND storecat=0 ORDER BY disporder,date DESC

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 'AND storecat=0 ORDER BY disporder,date DESC' 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.

Any idea?

aberg · January 10th, 2010, 03:06 PM

I still get regulair this error.
Please support

Chuck S · January 10th, 2010, 03:14 PM

well that query only exists only place in the application. Maybe a bot playing with urls. because in our application that is only ran if $ppuser exists which is a users userid but I dont see how it could be empty.

You can find this line

Code:

Content visible to verified customers only.

try changing to this

Code:

Content visible to verified customers only.

aberg · January 16th, 2010, 05:41 PM

Sorry for mu late reaction Chuck , but I have also problems with my forum.
I can't uploading on this moment so I have send a support question to Vbulletin.

Back to this problem, still I have it but I don't can find the row $query .= "WHERE userid=$ppuser AND storecat=0";
Can you please tell me where I can find this?

Chuck S · January 16th, 2010, 08:21 PM

Sorry thought I posted the script name above. It would be showgallery.php

aberg · January 17th, 2010, 03:06 PM

Thanks Chuck for the replay.
I have today upgrade to 7.01 so I wait to see of the emails are over.
If not I tried what you wrote.

Chuck S · January 17th, 2010, 04:54 PM

No problem enjoy the holiday weekend.

aberg · January 21st, 2010, 09:59 AM

Chuck, Update was not the solution for the problem.
But after change the code you give the error seems to be over.
Again thanks

Chuck S · January 21st, 2010, 10:11 AM

Not a problem

Jim O · January 26th, 2010, 05:48 PM

I am having the same issue. For some reason I am showing up as "unverified" though I have a valid license. I can't read the code. How do I fix my status?

Chuck S · January 26th, 2010, 06:27 PM

If your license has current members access simply make sure the forum email matches that of your valid license that has support access and you will become verified and see the code.

Jim O · January 29th, 2010, 10:07 AM

Thank you.

Chuck S · January 29th, 2010, 10:10 AM

Your welcome