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

WordPress Trac noreply at wordpress.org
Tue Apr 22 14:56:00 UTC 2014

#27972: wp_update_network_user_counts searches non-existent 'deleted', 'spam'
 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

More information about the wp-trac mailing list