Not Solved Reset all forum counters
#4
Not Solved
(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
Reply


Messages In This Thread
Reset all forum counters - by WallBB - 2018-02-08, 02:25 PM
RE: Reset all forum counters - by dragonexpert - 2018-02-08, 03:51 PM
RE: Reset all forum counters - by .m. - 2018-02-08, 04:09 PM
RE: Reset all forum counters - by WallBB - 2018-02-08, 07:01 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)