MyBB Community Forums

Full Version: Deleting All Threads
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Alright, I wanted to delete all the threads on the complete forum without losing anything else and went to the threads table and emptied it. Now I have in the index showing as if there were posts. How can I update this?

Thanks & Regards.
You have to empty the posts table, too.
Still, forums show "threads" and "posts" on the index.
Please update your caches and the statistics in the maintenance section in your admin-cp.
Hey

you will have also to delete mybb_threads Smile

however that last poster will still appearing but i guess the moment u post a new thread it will be gone Smile

regards
Copy the following php code and save it in a text editor as <somename>.php and upload it onto your MyBB main folder and run it with your browser.

<?php
// FIX FORUM COUNTS

require "./global.php";

$query = $db->query("SELECT fid FROM ".TABLE_PREFIX."forums");
while($row = $db->fetch_array($query))
{
	updateforumcount($row['fid']);
}
?>

That should update the last posts and post numbers on each of your forums.