[FD929]

Originally Posted by rossco_2005

@tmod,

This is a vbulletin bug I encountered ONCE on my own forums.
It left behind the entry in the 'moderation' table even though the post was set to visible (approved).

Here is how I fixed it. You need phpmyadmin access for this method, or if you're familiar with mysql you can come up with a query of your own but I won't spend time on that.

1. Make sure there are no posts, threads, etc. in the moderation queue first!
2. Go into phpmyadmin and browse to the table 'moderation'
3. Click on browse and there should be only ONE entry here. Delete this entry. Backup/export first if you want for safety but there shouldn't be any problem.

Here's a quicker way, in admincp execute query (credit to Brian vbAdvanced.com):
DELETE FROM moderation

BTW, working fantastic on 3.8.1 ... would love to see this updated to include visitor messages, group messages, etc.!