Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved Reset all forum counters
#1
Not Solved
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
Reply
#2
Not Solved
There is no reason a forum id has to be 1. The column is auto increment for a reason; to prevent duplicate entries.
Reply
#3
Not Solved
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;
Reply
#4
Not Solved
(02-08-2018, 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.

(02-08-2018, 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
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)