inc_features...pulling from one cat (not specified in inc_features)...Ideas?

[cobradude]

For some reason I can't get random photos on my home page to work quite right. Actually, on one site (same server) it works perfectly, while in this case, it shows random pictures from one specific category (id 3022), but I can't get the thing to pull from cat 500 for the life of me. I even copied the inc_features from the other site in case it was dorked up. Still, I get random pics from the one cat.

Please help! It just so happens that the one cat I don't want showing IS showing. I have tried specifying specific cats with no luck too.

thoughts?

current inc_features settings (all photos are showing from cat 3022):


FROM {$pp_db_prefix}photos p
LEFT JOIN {$pp_db_prefix}categories c ON c.id = p.cat
WHERE c.cattype = 'c' AND p.storecat = 0
ORDER BY RAND()";

[Chuck S]

Well in a default inc_features.php it does not pull from the members gallery at all. That would be because of the query including this

AND p.cat != 500

The query above will pull random photos from any category that is not an album so it would pull member gallery photos but just a thought here check your member's gallery permissions in admin edit categories because the mod will only show photos you have permission to view.

[cobradude]

I checked all of the permissions. The one category that shows is the one that requires membership. Did some testing with permissions and here's what I found.

Only category that wasn't wide open to viewing, etc was 3022 which is the only one that showed up. Hmmmm....

Changed category 3022 to be wide open to viewing, etc, (all boxes checked), and it stopped showing on the home page (nothing shows)

changed another category to not show for people waiting on email notification and now it shows on the home page.

Changed a bunch of other categories in the same way and they all show.

Log out and view the home page and guess what, the one category 3022 which shouldn't show images if the person is unregistered show just fine. That's bad.

On the site where everything works the ability to view the photos for every category has every box checked and the only difference between the sites is that the one that seems to work has vb3.5 and the one that doesn't is vb2x. There's some sort of permissions bug here, but I can't figure it out. The only way I can make the category 3022 not show on the home page seems to be to open it up (don't want to do) OR add AND p.cat != 3022 to inc_features.

Thoughts?

[Chuck S]

Not without seeing your setup Nope. The inc_features.php script as supported in our software is written to show photos that are in regular categories and not in the members gallery or albums.

[cobradude]

What do you need from me to check settings, etc?

[Chuck S]

Well url's and maybe an admin login would be needed. You could send ftp if you want.

[cobradude]

Just sent you a pm with username/password.

[Chuck S]

I clicked the link you sent me and I see random photos from over 5 categories when I view that page it appears to work just fine.

[cobradude]

It only works because like I said above, I unchecked one (any one or more) of the boxes for viewing those categories. If I didn't exclude 3022 from inc_features it would show too even though I had the permissions set to not viewable by unregistered users. Likewise, if I have a category that has the images viewable by all groups, it will not show on the front page. I am ok with the results at this point as I have worked around a problem, but it's not absolutely correct behavior.

[Chuck S]

The inc file itself checks your permissions and shows categories that a user has view permission for.

Have you done anything like switch integrations lately any major changes?

[cobradude]

I upgraded only from 4.5.