Delete a large amount of unapproved threads & posts in MyBB

Delete a large amount of unapproved threads & posts in MyBB - Printable Version

+- howtothings.co.uk (https://www.howtothings.co.uk)
+-- Forum: Computing (https://www.howtothings.co.uk/forumdisplay.php?fid=4)
+--- Forum: Website Development, Implementation and General Webmaster Support (https://www.howtothings.co.uk/forumdisplay.php?fid=9)
+--- Thread: Delete a large amount of unapproved threads & posts in MyBB (/showthread.php?tid=52053)

Delete a large amount of unapproved threads & posts in MyBB - Mark - 09-08-2022

If you have a large amount of threads requiring approval on your MyBB forum then rather than deleting them through the Admin CP you can bulk delete them all from a SQL query.

Normal method:
MyBB Admin CP > Forums & Posts > Moderation Queue

Delete using SQL query:
Log in to your database using something like phpmyadmin
Select the database
Select "Query"

Execute these queries one at a time and note down the returned result.

Code:
SELECT * FROM mybb_threads WHERE visible = 0;

Code:
SELECT * FROM mybb_posts WHERE visible = 0 AND replyto = 0;

To delete all threads requiring approval, execute this query:

Code:
DELETE FROM mybb_threads WHERE visible = 0;

The number of rows it deletes should match that of the first query which then should also match the number of unapproved threads.

To delete all posts requiring approval, execute this query:

Code:
DELETE FROM mybb_posts WHERE visible = 0 AND replyto = 0;

Rebuild the forum counters:
ACP > Tools & maintenance > Recount & Rebuild > Rebuild Forum Counters > Go.