Log in with username/password: lyceum/lyceum

Ticket #874 (closed defect: fixed)

Opened 1 year ago

Last modified 1 year ago

We can not search user in wp-admin/users.php

Reported by: lyceum Assigned to:
Priority: normal Milestone: 1.0.1
Keywords: user search Cc: xfliu.math@gmail.com

Description

As title, there never comes search result, which is because there is sth wrong with table names in query string. Please refer to the patch below:

Index: users.php
===================================================================
--- users.php   (revision 1251)
+++ users.php   (working copy)
@@ -148,11 +148,11 @@
        if ($filter != '') {
                $filter = "%$filter%";
 
-               $users_without_privileges = $wpdb->get_col(
+               $users_without_privileges = $wpdb->get_col( //PEAK
                        "SELECT DISTINCT ID
-                       FROM users
-                               INNER JOIN usermeta um_filter  ON (ID  = um_filter.user_id  )
-                               INNER JOIN usermeta um_exclude ON (ID != um_exclude.user_id )
+                       FROM $wpdb->users
+                               INNER JOIN $wpdb->usermeta um_filter  ON (ID  = um_filter.user_id  )
+                               INNER JOIN $wpdb->usermeta um_exclude ON (ID != um_exclude.user_id )
                        WHERE
                                ( um_exclude.blog = '$blog' ) AND 
                                ( user_login LIKE '$filter' OR 

Change History

10/29/07 23:57:09 changed by jjb

  • status changed from new to closed.
  • resolution set to fixed.

[1255] fixed. Thanks!

Log in with username/password: lyceum/lyceum