[Harlequin]

There's something important to mention here (if it hasn't been mentioned already somewhere in this thread).


I was receiving the 'Query Failed' message for a day or two until I finally started searching around on threads and found someone's solution that worked like a charm, and while I forget who it is, they're a great, great person to get this going and noticing something that I had completely skipped.


In an untouched thumbinclude.php around line 177 they'll be a bunch of these similiar-looking $query statements. >

$query = "SELECT id,user,userid,cat,title,bigimage,views FROM photos WHERE bigimage!='' AND approved='1' $exclude_cat ORDER BY views DESC LIMIT $limit";


Note the 'photos'.



It's a simple oversight, but if you've added a prefix on to Photopost's queries during it's install, say 'photopost_photos' (as I have it on my forum), then you would most certainly get the Query Failed message as I did.


So to remedy this, I added the prefix:

$query = "SELECT id,user,userid,cat,title,bigimage,views FROM photopost_photos WHERE bigimage!='' AND approved='1' $exclude_cat ORDER BY views DESC LIMIT $limit";


And boom, it came up and worked beautifully.


Each of the $query statements in the thumbinclude.php need to be edited the same way if they're making a call to 'photos' rather than, like in my example, 'photopost_photos'.

<edit>

Btw, ty Pixel and Mickie.

And heck, this may have actually been mentioned in this thread. My brain ain't with it.