How to hide private album photos from Featured Photo list

Silver_2000 · January 4th, 2013, 08:20 PM

Fresh install of VB4 with Photopost 8.22 and private albums are showing on the featured photos plugin

also the statistics link in PP takes forever - its clearly doing some kind of "phone home" because the server simply isnt that slow

nloc.net

the selling album is a private album http://www.nloc.net/photopost/showgallery.php?cat=2172

Chuck S · January 4th, 2013, 09:31 PM

Not sure what your talking about statistics link?

As far as any vb plugin you can check the queries in the featured photos plugin this line and add the text in bold

Code:

Content visible to verified customers only.

Silver_2000 · January 4th, 2013, 09:40 PM

Statistics link is the top link on the left of the admin cp of the product

It shows the log and the current version

Chuck S · January 4th, 2013, 10:10 PM

Okay that link thats easy its trying to stat your data directory and yours is too large comment out this line in adm-misc.php

Code:

Content visible to verified customers only.

Silver_2000 · January 4th, 2013, 10:49 PM

Quote:

Originally Posted by Chuck S

Not sure what your talking about statistics link?

As far as any vb plugin you can check the queries in the featured photos plugin this line and add the text in bold

Code:

Content visible to verified customers only.

that code occurs 3 times

adding the bold to the lines results in
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 c.password = ''* ORDER BY date DESC LIMIT 25' at line 4

Silver_2000 · January 4th, 2013, 10:53 PM

Quote:

Originally Posted by Chuck S

Okay that link thats easy its trying to stat your data directory and yours is too large comment out this line in adm-misc.php

Code:

Content visible to verified customers only.

Too large is right

thats why I want to reduce the size of the images folders as well

Ive limited the size of the uploads now but some legacy files are too big

some are over 2 mb each full size image

the edit seems to have worked

Chuck S · January 5th, 2013, 06:44 AM

Quote:

Originally Posted by Silver_2000

that code occurs 3 times

adding the bold to the lines results in
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 c.password = ''* ORDER BY date DESC LIMIT 25' at line 4

You have to be editing something incorrect that is all I can say there. Your essentially adding

AND c.password = ''

Silver_2000 · January 5th, 2013, 09:54 AM

well it seems that making the same edits this morning went better

THANKS

Chuck S · January 5th, 2013, 10:13 AM

Not a problem looking at your error above it shows you added * when doing your edit which would of course cause an issue as the query would indeed not be valid.