Admin Checkmark & Closing Photopost

aaronp · October 31st, 2006, 03:35 PM

I have two questions, hopefully quick ones.

1) After a recent upgrade to 5.5 with vb3 integration everything has been going very smoothly. Users have been uploading lots of photos without incident. However, I just approved a photo and afterwards the red check mark that appears next to "Admin" does not go away. There are no photos left to approve (No comments either, though they arent moderated). Why did this happen and how do I fix it?

2) I want to rebuild all thumbnails cause some of the initial ones were pretty small, now they are bigger. But it tells me to backup first, and before I back up it tells me to close the photopost via the config-inc.php file. I opened the config file and didnt see how/where to close photopost. I searched the forums and couldnt find it either. How do I close it?

Chuck S · October 31st, 2006, 04:36 PM

You close the forums via global options in admin now

try running this query and tell me the results

SELECT FROM pp_photos WHERE approved=0

aaronp · October 31st, 2006, 05:40 PM

I would love to. I presume you mean query the database? How do I do that?

(I tried to figure out how to do it on my own... still am....)

Chuck S · October 31st, 2006, 06:16 PM

In your webhosting site control panel there is usually a phpmyadmin link and you can do queries there.

Do you have this in your control panel?

aaronp · October 31st, 2006, 06:41 PM

Yes I do. I found the query tab which asks for the following parameters:

Field (drop down)
Sort (ascending/descending)
Show Criteria (text box)
And/Or (text box for additional criteria?)
Modify
Add Delete Criteria Row (drop down with positive and negative numbers)
Add/Delete Field Colums (drop down with positive and negative numbers)

Is this the right place? What do I do?

aaronp · November 2nd, 2006, 04:54 PM

You still there chuck?

Chuck S · November 2nd, 2006, 06:59 PM

you do an sql box and do the query noted

aaronp · November 2nd, 2006, 11:54 PM

I enter what you told me to in the box and then it says I have a syntax error.

#1064 - 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 'FROM pp_photos WHERE approved = 0
LIMIT 0, 30' at line 1

Chuck S · November 3rd, 2006, 08:39 AM

SELECT * FROM pp_photos WHERE approved=0

Is your prefix pp_

aaronp · November 3rd, 2006, 03:02 PM

yes, pp_ is the prefix.

Now when I enter the query I get a table containing three images, and the information about them.

However, all photos have been approved in the photopost admin panel.

Chuck S · November 3rd, 2006, 09:23 PM

Those images are not approved

Run this

UPDATE pp_photos SET approved=1

aaronp · November 4th, 2006, 07:24 PM

fixed! Thanks Chuck.