user IDs > 2147483647 in table "users" get mapped to user IDs <= 2147483647 in table "usermeta"

[bugreporter]

e.g. user ID 2147483648 gets mapped to 2147483647, user ID 4294967295 gets mapped to 1 (killed my admin!), etc.

[scribu]

Both wp_users.ID and wp_usermeta.user_id columns have the same definition: bigint(20) unsigned. Therefore, this is unlikely to be caused by SQL.

My bet is incorrect plugin/theme code. Please disable all plugins and switch to default theme and then try to create a new user with some other capability other than admin.

[dd32]

2147483647 is the largest number a 32bit installation of PHP can store in it's INT datatype.

a 32bit system may be able to store a larger integer in a float data type however.

Ultimately, I'd suggest upgrading to 64bit, to give an MAX_INT of 9223372036854775807

[azaozz]

Do you really have more than 2,147,483,647 users? :-)

Seriously, if randomizing user_id perhaps limit them to 2,000,000,000.