[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:40:50 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  |
-------------------------------------+------------------------------
Changes (by scribu):

 * keywords:   => close reporter-feedback


Comment:

 Both wp_users.ID and wp_usermeta.user_id 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.

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


More information about the wp-trac mailing list