Solved: 3 Months, 3 Weeks, 2 Days ago Update the unapproved threads number.
#1
Solved: 3 Months, 3 Weeks, 2 Days ago
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.
Reply
#2
Solved: 3 Months, 3 Weeks, 2 Days ago
Never mind, fixed myself Big Grin

https://www.howtothings.co.uk/showthread.php?tid=52053
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)