id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc
17860,Multisite: Incorrect User Counts on Sites,cgrymala,nacin,"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).",defect (bug),closed,normal,3.5,Multisite,3.1.3,normal,fixed,,petemall