MyBB Community Forums

Full Version: Reset all forum counters
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi all,
Is there a way present in MyBB so that I can reset forum id to 0 making any new forum that is created inside Admin CP will get the id starting from 0 ?
I tried removing all forum and running Recount tools but it doesn't seem to work.

What would be the correct place to modify this
There is no reason a forum id has to be 1. The column is auto increment for a reason; to prevent duplicate entries.
if all forums are removed & if you want to have forum IDs start from one (1) again then
below SQL query might help
ALTER TABLE `mybb_forums`
MODIFY `fid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;
(2018-02-08, 03:51 PM)dragonexpert Wrote: [ -> ]There is no reason a forum id has to be 1. The column is auto increment for a reason; to prevent duplicate entries.

(2018-02-08, 04:09 PM).m. Wrote: [ -> ]if all forums are removed & if you want to have forum IDs start from one (1) again then
below SQL query might help
ALTER TABLE `mybb_forums`
MODIFY `fid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;

Ah, thr reason why editing database was not working is evident now. Smile
I didn't check it was auto increment, thank you very much Smile