Red check in front of Admin

[catnipmercer]

When I go to our photoboard at http://purebredcatbreedrescue.org/ph.../adm-index.php and login as administrator, there is a red check in front of "Admin" which would usually mean there are photos or comments that need to be moderated... but there are none when I check the admin and there are no waiting messages in vbulletin either. The statistics page of the admin says "Awaiting approval" = 4...four what are awaiting approval? How do I fix this?

Your people installed photopost and all updates for us, we are using Photopost vB3 enhanced with vbulletin.

[Chuck S]

Yes that means something is not approved. Your seeing nothing in admin for photos or comments?

You can run these queries in phpmyadmin or if your gallery tables are in the same database as the forums you can use their sql box

UPDATE pp_photos SET approved=1 WHERE approved=0;

UPDATE pp_comments SET approved=1 WHERE approved=0;

[catnipmercer]

Sorry it took so long for me to reply but rescue has been VERY hectic. No, it's checked and there are no photos or comments to be moderated shown.

I ran the SQL Queries you suggested and got this:


SQL query:

UPDATE pp_photos SET approved =1 WHERE approved =0;

MySQL said: Documentation
#1146 - Table 'bboards.pp_photos' doesn't exist

Same thing for pp_comments

There is a comments section and a photo section, however.. and those appear to be photopost's since the comments are those showing in photopost when I check.

Can you tell me how much it will cost to get your to upgrade our photopost and also check the whole layout and that everything works? Since the last upgrade the comments posted have become almost nonexistant while before the upgrade we have a very active photo gallery. We did require registration, so I'd have expected some drop.. but not to near zero... and the vbulletin board has been going strong despite requiring membership.

Linda

Originally Posted by Chuck S

Yes that means something is not approved. Your seeing nothing in admin for photos or comments?

You can run these queries in phpmyadmin or if your gallery tables are in the same database as the forums you can use their sql box

UPDATE pp_photos SET approved=1 WHERE approved=0;

UPDATE pp_comments SET approved=1 WHERE approved=0;

[catnipmercer]

I ran the SQL again removing the pp_ in front of photos and comments, and the red check is gone!!!

However, I'd still like to get the board updated and checked for functionality.. I still think there's something wrong as the red check was recent and the comment posting has been near 0 much longer than that.

[Chuck S]

You can purchase an upgrade from our online store if your trying to update the software to the latest version.