forum ids

[IDN]

it would be nice if when you delete a thread and that thread id was 5, that the next forum you make is also 5... instead of being six...


why does it do that? gets annoying and sometimes misleads the actual forums in the BBS

[tubedogg]

It's the way MySQL works with auto-incrementing numbers. It will not be changed.

[IDN]

:(


guess next time i will have to instead of deleting it change it to a new forum, or hide it

[Chen]

If it really bothers you, you can run this query:
ALTER TABLE forum AUTO_INCREMENT = 0;
Every time you remove a forum. Then the auto_increment will start from 0 (so you won't have any "gaps").

[Boofo]

Chen,

Is there any way to get this to work with the Quote table and the user table to fill in the gaps? I tried it with the user table, but it didn't take care of it. :)

Originally posted by FireFly
If it really bothers you, you can run this query:
ALTER TABLE forum AUTO_INCREMENT = 0;
Every time you remove a forum. Then the auto_increment will start from 0 (so you won't have any "gaps").

[Chen]

It won't fill in existing gaps, but only stop new ones from appearing.