[wp-trac] [WordPress Trac] #17860: Multisite: Incorrect User Counts on Sites

[WordPress Trac]

#17860: Multisite: Incorrect User Counts on Sites
--------------------------+-----------------------------
 Reporter:  cgrymala      |      Owner:
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  Multisite     |    Version:
 Severity:  normal        |   Keywords:  ux-feedback
--------------------------+-----------------------------
 On a Multisite installation, the count of users does not always match the
 number of users displayed in the table on wp-admin/users.php or wp-
 admin/network/site-users.php.

 The issue appears to be related to some users being stored in the database
 with specific capabilities, but without one of those capabilities being a
 "role".

 For instance, let's say you're working on a site with an ID of 12 and a
 table prefix of `wp_`. If you query the `wp_usermeta` table you will
 retrieve a result similar to the following:

 {{{
 umeta_id: 72
 user_id: 3
 meta_key: wp_12_capabilities
 meta_value: a:1:{s:17:"gform_full_access";s:1:"1";}
 }}}

 That particular capability is added by Gravity Forms, but there are other
 plugins that perform similar actions.

 When you view the table of Users under Network Admin -> Sites -> Edit ->
 Users or under Site Admin -> Users, the user count does not match what's
 shown in the table.

 This bug is present in the current stable version (3.1.3) and in the
 current nightly version as of June 21, 2011.

 I have attached 2 screen shots showing the Network Admin -> Sites -> Edit
 -> Users screen and the Site Admin -> Users screen. As you can see, the
 number next to "All" says there are 2 users, and the number of "items" at
 the top and bottom of the table is 2; but there is only 1 user displayed
 in the table.

 This bug makes it very difficult to manage the users on each site and, in
 some cases, will trigger a "user already exists" error when you try to use
 "Add New" to add a user that's not shown in the table (though I haven't
 been able to reproduce that particular problem since I started testing to
 create this ticket).

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/17860>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software