How to decrease the forums ID number [Archive]

View Full Version : How to decrease the forums ID number

Mupetz

12-12-2010, 07:03 AM

For one week now, I've tested some features; so I have created forums, deleted, creating again and so on.
Finnaly I'm getting myself with 700+ IDs in URLs
Example :
domain.com/forumdisplay.php?733-CategoryName

Somehow, with the database or else, I would like to decrease the forums ID.
forum ids 1 , 2 , 3 , etc are not used.
1 makes more clean than 735 in the urls..

Thank you

Mupetz

12-15-2010, 10:24 AM

anyone ?

Lynne

12-15-2010, 01:59 PM

Have you actually removed all the forums from the site now? If so, you may go into the database and the forum table and set the auto_increment for forumid back down to xxx - xxx being larger than the last forumid in the forum table. You cannot set it to be lower than the last forumid and you cannot just manually change the forumids of existing forums in that table unless you want to really mess things up.