PhotoPost Community - Repeated Gallery Issues

PhotoPost Community (http://www.photopost.com/forum/)

- Photopost Pro Bug Reports (http://www.photopost.com/forum/photopost-pro-bug-reports/)

- - Repeated Gallery Issues (http://www.photopost.com/forum/photopost-pro-bug-reports/147845-repeated-gallery-issues.html)

gholsie

March 24th, 2012 09:35 PM

Repeated Gallery Issues

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.

All times are GMT -5. The time now is 08:04 PM.

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