Quick Moderation Issue

[joeychgo]

the quick moderation block said I have 4 posts to moderate - I clicked on it and moderated the 2 posts that came up -- and it still says 2 posts are to be moderated, but whern I click it now, no posts come up for moderation.....

[Brian]

Do you have the "Quick Stats" option turned on which shows the number of posts awaiting moderation in your admin cp? If so, does that show any posts awaiting moderation?

[joeychgo]

yes - it shows 2 also, but again, when I click 'view' i get nothing to moderate

[Brian]

Sounds more like a vBulletin problem then. You could try running this query to see what the threads are:

SELECT * FROM moderation WHERE type = 'reply';

That should at least return the two posts that are awaiting moderation and let you know what they are. If you just want to remove them you could run this query:

DELETE FROM moderation WHERE type = 'reply';

Other than that though, you would need to ask why it's happening at vbulletin.com

[eclectica]

I had this same problem where it showed in the quick stats of the admincp that I had 1 post to moderate, along with on the front page in the "quick moderation" box. I'm not comfortable running queries on the database, so what I did was go into phpMyAdmin and found the table called moderation. I then browsed it and found the one post with both a threadid and postid indicated. I then went to see if I could view the post in the forum but it showed it to be an invalid link. So I then selected to empty the table, and that fixed the problem.