MyBB Community Forums

Full Version: Delete Members without changing member ID consistency
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hey, my friend and I have been working on our forums for awhile. We had some test accounts and deleted them. There is just us two now. If someone signs up, their profile ID(on the URL) would be like 9 or 10 instead of three. How can I fix this? Is there an alternative? Thanks.
Go to your users database phpMyAdmin and run the following query:


ALTER TABLE `mybb_users` AUTO_INCREMENT = 3; 

Where it is assumed that your table prefix is mybb_, change it if necessary/
That worked perfectly, thank you so much. Big Grin