[wp-trac] [WordPress Trac] #27972: wp_update_network_user_counts searches non-existent 'deleted', 'spam' columns

[WordPress Trac]

#27972: wp_update_network_user_counts searches non-existent 'deleted', 'spam'
columns
--------------------------------+-----------------------------
 Reporter:  mkuplens            |      Owner:
     Type:  defect (bug)        |     Status:  new
 Priority:  normal              |  Milestone:  Awaiting Review
Component:  Networks and Sites  |    Version:  trunk
 Severity:  normal              |   Keywords:
  Focuses:  multisite           |
--------------------------------+-----------------------------
 wp_update_network_user_counts executes the following query:

 {{{
 SELECT COUNT(ID) as c FROM $wpdb->users WHERE spam = '0' AND deleted = '0'
 }}}

 The columns in the WHERE statement are not in this table, however, causing
 the query to fail. The WHERE statement appears to have been copied from
 {{{wp_update_network_site_counts}}}, where the columns are used to count
 active, non-spam network sites.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/27972>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform