Repeated Gallery Issues

gholsie · March 24th, 2012, 09:35 PM

Gents, I am seeing quite a number of errors emailed to me daily. These errors are coming from the newest installation of Photopost on my vbulletin 4.1.11 site. Can you help me with a suggestion about how I can fix this problem? Thank you.

Mike

Quote:

An error was encountered during execution of the query:

SELECT numcom,rating,cat,id,title FROM photos WHERE cat IN (3d551) ORDER BY rating DESC LIMIT 10

The query returned with an errorcode of:

Unknown column '3d551' in 'where clause'

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.

Chuck S · March 25th, 2012, 09:06 AM

well literally can not replicate the issue and that query can only be found one place the ratings cache function.

I would suspect a bot maybe playing with urls values.

Maybe as a test try making line 5220 of pp-inc.php.

Code:

Content visible to verified customers only.

what I added is in bold.

gholsie · April 5th, 2012, 12:48 AM

Thanks Chuck. Line 5220 does not have that code, it has..

Code:

Content visible to verified customers only.

I found it on line 5188. Would that be a problem? Do I have the wrong code?

m

Chuck S · April 5th, 2012, 07:42 AM

line 5220 of our pp-inc.php is by default this

Code:

Content visible to verified customers only.

You can only be counting the lines wrong or your file is older. I can not say which. The line is in the get_ratingscache function. You would make sure the line above is what I posted in my previous post.