SQL Query required to Prune forum

[alirex]

Dear Helpers

I need a SQL query to remove my empty forums which have no thread . Due to some changes i need to delete many forums on my board and it will take hours to delete one by one. I am not able to find Prune empty forum in my adminCP.

Thank you in advance

[vBNinja]

This should work

PHP Code:

DELETE FROM forum 
WHERE threadcount = 0 AND parentid != -1; 


Run it through phpmyadmin then go to admincp->maintenance->rebuild forum information

[alirex]

Thank You very much " vBNinja "

One problem i am facing

#1093 - You can't specify target table 'forum' for update in FROM clause

[vBNinja]

You probably have a table prefix, look for "forum" in the tables with phpmyadmin
If it has something in front of it, use that name in the query instead of "forum"

[alirex]

Originally Posted by vBNinja

You probably have a table prefix, look for "forum" in the tables with phpmyadmin
If it has something in front of it, use that name in the query instead of "forum"

It is forum only there is no prefix , but dont know why your command is not working.

[ForceHSS]

DELETE FROM `forum` WHERE `threadcount`='0' AND `parentid`='-1'
Please do a backup before running this