2022-08-10, 11:24 AM
(This post was last modified: 2022-08-10, 11:27 AM by MarkW7. Edited 2 times in total.)
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.
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.
