MyBB Community Forums

In one of my forums on the index page, it says there is one unapproved post in there somewhere. However the mod queue is empty and the DB has 0 in the unapprovedposts column for the forum.

I'd really like to get rid of the (1) on the forum listing, mainly because there could be a db mismatch somewhere?

Any help/suggestions welcome!

Thanks

So these:

SELECT `fid` FROM `mybb_forums` WHERE `unapprovedthreads` != 0;

SELECT `fid` FROM `mybb_forums` WHERE `unapprovedposts` != 0;

returns 0 for both?? What about these??

SELECT `tid` FROM `mybb_threads` WHERE `visible` != '1' OR `unapprovedposts` != '0';

SELECT `pid` FROM `mybb_posts` WHERE `visible` != '1';

Fixed, it was a sub-forum which had the unapproved post. But it still didn't show up in the mod queue which still bothers me.