When you delete a topic, post, user, it deletes an id which is lost.
Here is what i thought on fixing that a bit..
When you delete a user (1081), phpbb should check if there are any users registered after it (1082).
If there hasnt been any registered user, it should go in the autoincreament and lower the number which was just deleted.
So to be more explicit, if you are trying to delete the latest user, it should decrease the autoincreament number, as it was the last user and other users can register on that id.
After i delete the latest topics,posts,users i have to manually go in the database and run something like this:
- Code: Select all
ALTER TABLE phpbb_topics AUTO_INCREMENT =2021;
ALTER TABLE phpbb_posts AUTO_INCREMENT =4165;
ALTER TABLE phpbb_users AUTO_INCREMENT =1082;
Yes, i know someone, probably nox might rant at me again..