MyBB Community Forums

Full Version: Update the unapproved threads number.
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
On my forum I had 49,172 unapproved threads, rather than deleting them via the Admin CP one page at a time I ran this query which deleted 49,172 entries.

DELETE FROM mybb_threads WHERE visible = 0;



I have waited 24 hours however it still shows in the banner:

Awaiting Moderation: 49,172 unapproved threads


But in Mod & Admin CP it says:

There are no threads, posts or attachments currently awaiting moderation.


How do I force it to update?

I've rebuilt the cache & run the recount and rebuild. I've also created a new thread that required approval and the count rose up 1 and when I deleted it via ACP I decreased 1.