Member ID Help

[NaisA-]

I went into our database and messed with our Forum Bot and changed the member ID to 10000. Since then I deleted the Forum Bot, but now the ID of whoever registers falls after 10000. I only have 8 people right now on our forums. Anyone know how to fix this?

[Nathan Explosion]

https://stackoverflow.com/questions/8923114/how-to-reset-auto-increment-in-mysql

[Adriano Faria]

I would change it to 9:

ALTER TABLE core_members AUTO_INCREMENT=9;

Not sure what happens if you already have records higher than ID = 9.

[NaisA-]

Thanks @Nathan Explosion @Adriano Faria that worked.

@Adriano Faria can you look at my request here -