MyBB Community Forums

I was making some adjustments to one of my tables on myBB and now I'm getting a weird adding error when a member registers on my site it keeps adding an extra 0 in the uid that shouldn't be there and AUTO_INCREMENT is enabled. 

An example of what I mean: 



I've tried deleting the table and creating the table again and importing it and it doesn't fix it. I've also made sure there is no UID any higher then the rest below the test uid. In the usersfields table I've also deleted some of the extra 0's it added and it adds them there too.

Does anyone have a solution? Many thanks!

Try resetting the auto_increment value to 1 above your highest uid. The easiest way to find the highest uid is by running this query:

SELECT uid FROM mybb_users ORDER BY uid DESC LIMIT 1;