MyBB Community Forums

Double posted from Discord.

Why aren't MyBB's uids ascending by reg time?
https://community.mybb.com/memberlist.ph...=ascending

Like, why the user in the 1st position (and some other users) in that list has a bigger uid but an earlier registration time than those who have smaller uids? Eg, uid=1 is registered on June but the first user April.

Great question!

In my opinion this could be caused by different reasons...
- Different behaviour in auto-incrrement depending on the database or the DB engine used. So new users (uid) may end up in filling these id gaps of deleted users.
- Merged user accounts
- Export/import of database with manual manipulation/reorganisation of IDs. (The most uncommon reason)

[ExiTuS]

Would imagine either a combination of data migrations from DevBB (MyBB's predecessor) or manual changes.