[wp-trac] [WordPress Trac] #17945: user IDs > 2147483647 in table "users" get mapped to user IDs <= 2147483647 in table "usermeta"

WordPress Trac wp-trac at lists.automattic.com
Thu Jun 30 13:44:01 UTC 2011


#17945: user IDs > 2147483647 in table "users" get mapped to user IDs <= 2147483647
in table "usermeta"
-------------------------------------+------------------------------
 Reporter:  bugreporter              |       Owner:
     Type:  defect (bug)             |      Status:  new
 Priority:  normal                   |   Milestone:  Awaiting Review
Component:  Users                    |     Version:  3.1.4
 Severity:  blocker                  |  Resolution:
 Keywords:  close reporter-feedback  |
-------------------------------------+------------------------------

Comment (by 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

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/17945#comment:2>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software


More information about the wp-trac mailing list