Make WordPress Core

Opened 13 years ago

Closed 13 years ago

#14320 closed defect (bug) (invalid)

ms-function: get_user_count incorrect query

Reported by: agentile's profile agentile Owned by:
Milestone: Priority: normal
Severity: normal Version: 3.0
Component: Multisite Keywords: has-patch
Focuses: Cc:

Description

line 166:
$count = $wpdb->get_var( $wpdb->prepare("SELECT COUNT(ID) as c FROM $wpdb->users WHERE spam = '0' AND deleted = '0'") );

spam and deleted columns don't exist in the users table...im guessing a copy paste error from the get_blog_count() below it....unless I am completely missing something.

Attachments (1)

get_user_count.diff (625 bytes) - added by scribu 13 years ago.

Download all attachments as: .zip

Change History (3)

#1 @scribu
13 years ago

  • Keywords has-patch added
  • Milestone changed from Awaiting Review to 3.0.1

#2 @nacin
13 years ago

  • Milestone 3.0.1 deleted
  • Resolution set to invalid
  • Status changed from new to closed

Yes, you're missing something :-)

The spam and deleted columns are multisite only. See install_network().

Note: See TracTickets for help on using tickets.