Resetting UserIDs?

[Glenn379]

Hey everyone! This forum has helped me in the past so I figured I'd see if anyone knows.

I had opened a new forum awhile back. After neglecting it for 2 months (It was still more of a test) I got 300+ spam users. I'm hoping to be able to reset the userID count so that it doesn't go 1-10 and then jump to 301, etc. I've now deleted those users so I'm hoping there's a way to reset it. Any ideas?

[Lynne]

You could really screw things up if you play with the auto increment number for the tables and don't know exactly what you are doing. It's best to leave that number alone.

[Glenn379]

Originally Posted by Lynne

You could really screw things up if you play with the auto increment number for the tables and don't know exactly what you are doing. It's best to leave that number alone.

I'm just anal about the gap. There isn't any roundabout way to do it or anything? Its just me and another admin, if everyone is deleted but us, registered users 1 and 2, there isn't any way to continue new registrations from 3?

[Lynne]

Yes, there probably is by changing the auto-increment number in your database if you really know exactly what you are about. Otherwise, you will screw up your site.

[Adrian Schneider]

If you deleted the users properly, and no lingering data remains (userfield, usertextfield, etc.) then all you need to do is run this query:

alter table user auto_increment = 3;

It should be harmless.