[buddypress-trac] [BuddyPress Trac] #7677: Group with no admin or mod causes heavy user query

[buddypress-trac]

#7677: Group with no admin or mod causes heavy user query
--------------------------+------------------------------
 Reporter:  cyclic        |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Core          |     Version:
 Severity:  normal        |  Resolution:
 Keywords:                |
--------------------------+------------------------------

Comment (by cyclic):

 It's likely that the only admin was deleted in a nonstandard way. We run
 Commons In A Box with a ton of custom code and integrate with a
 Shibboleth-based identity management stack to deal with authentication and
 user management, and there are scenarios where a WordPress user could be
 removed and might not run all relevant hooks, so the broken state of the
 data is probably related.

 Here's what the database says for one affected group:

 {{{#!sql
 > select count(*) from wp_bp_groups_members where group_id = 288\G
 *************************** 1. row ***************************
 count(*): 20
 1 row in set (0.00 sec)

 > select * from wp_bp_groups_members where group_id = 288 and ( is_admin =
 1 or is_mod = 1 )\G
 Empty set (0.00 sec)
 }}}

--
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/7677#comment:2>
BuddyPress Trac <http://buddypress.org/>
BuddyPress Trac