How to fix the ids?
 

Hello, I've made a lot of groups. And then I deleted them most of them.

I have like 9 groups left.

the counter is messed now, when I make a group it starts on 41. It should start on 10.
Anyone know how to make it start from 10? I have basic understanding in MYSQL.
But I don't know how to setup the AI.

Anyone knows how?

Thanks

Try to run this query at the phpmyadmin in the cp of your host:



If your db tables have a prefix, don''t forget to include it in your query as well. And replace Banned Users with the name of your custom group that you want to have the uid 10.

I am just following up on this Muazam. Did the above solution worked for you?

I am curious as I think this is what I need from profile fields adds and deletes I have done. Yes I know a different query run is needed.

I'll try it soon, Thanks Borbole.

Try this query instead. It will reset the auto_increment value to the current highest + 1

[sql]ALTER TABLE usergroup AUTO_INCREMENT = 1[/sql]

No problem, let us know how it will go. You can run either query as long as you get done what you need, which is the most important thing.