[wp-trac] [WordPress Trac] #16633: reauth loop if database contains duplicate values

[WordPress Trac]

#16633: reauth loop if database contains duplicate values
-------------------------------+------------------------------
 Reporter:  danielpataki       |       Owner:
     Type:  enhancement        |      Status:  new
 Priority:  normal             |   Milestone:  Awaiting Review
Component:  Database           |     Version:
 Severity:  minor              |  Resolution:
 Keywords:  reporter-feedback  |
-------------------------------+------------------------------
Changes (by kurtpayne):

 * cc: kurtpayne (added)
 * keywords:   => reporter-feedback


Comment:

 How are you creating these duplicate logins?  What is the use case?

 I tried to recreate this on WP 3.2 and found the following results:

  * The function get_user_by() uses this query "SELECT * FROM $wpdb->users
 WHERE $field = %s" without an SQL limit
  * Without an SQL limit, the query will match all users who share a
 duplicate login name or friendly name
  * The first result from the query is taken because the query is passed
 through $wpdb->get_row() which retrieves exactly one row
  * I duplicated an admin user record in my database, and a subscriber user
 record, but I was not able to replicate the problem described in the
 original post.

 Can you please try with the latest version and post your results?

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/16633#comment:2>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software