NaisA- Posted March 6, 2018 Share Posted March 6, 2018 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? Link to comment Share on other sites More sharing options...
Nathan Explosion Posted March 6, 2018 Share Posted March 6, 2018 https://stackoverflow.com/questions/8923114/how-to-reset-auto-increment-in-mysql Link to comment Share on other sites More sharing options...
Adriano Faria Posted March 6, 2018 Share Posted March 6, 2018 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. Link to comment Share on other sites More sharing options...
NaisA- Posted March 6, 2018 Author Share Posted March 6, 2018 Thanks @Nathan Explosion @Adriano Faria that worked. @Adriano Faria can you look at my request here - Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.