MyBB Community Forums
Reset all forum counters - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: General Support (https://community.mybb.com/forum-176.html)
+--- Thread: Reset all forum counters (/thread-215833.html)



Reset all forum counters - WallBB - 2018-02-08

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


RE: Reset all forum counters - dragonexpert - 2018-02-08

There is no reason a forum id has to be 1. The column is auto increment for a reason; to prevent duplicate entries.


RE: Reset all forum counters - .m. - 2018-02-08

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;



RE: Reset all forum counters - WallBB - 2018-02-08

(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