How to fix the ids?

[Muazam]

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

[borbole]

Originally Posted by Muazam

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:

UPDATE `usergroup` SET usergroupid = 10 WHERE title = 'Banned Users';

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.

[borbole]

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

[Charlie98902]

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.

[Muazam]

I'll try it soon, Thanks Borbole.

[DavidsMods]

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

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

[borbole]

Originally Posted by Muazam

I'll try it soon, Thanks Borbole.

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.