[SOLVED] Changing Category ID Numbers

[willdebeest]

I have added a few categories but later deleted those categories. When I now add a category I have Id Numbers:
1
2
3
10

is there a way I can edit 10 to become category ID no. 4 as this effects some scripting to display my page, which simply adds 1 to the category number each time to display the page?

[willdebeest]

Solved. I just needed to change the autoincrement value in the database.

[Radu]

great! that was the only solution. can you please add before the post title the [sOLVED] word? Thank you!

[uddhava]

Hacking the database is of course an option, but a fairly complex and sometimes dangerous one.
I would suggest to create a CSV file with your categories and ID in it. Then reimport this file with the import tool..
All your previous cat can be deleted and the imported cats have the correct ID's again

[Roman_vinnitskij]

Solved. I just needed to change the autoincrement value in the database.

I have same problem!!! Could you describe more in detail how to fix it.
Where I can found "autoincrement value" in phpmyadmin ?

[Radu]

change autoincrement using this sql:
ALTER TABLE my_table_name AUTO_INCREMENT = 1000;