The MU forums have moved to WordPress.org

Mysterious "No matching users found" error condition (4 posts)

  1. rcwatson
    Member
    Posted 5 years ago #

    users of my wpmu install have begun to complain that the usernames they create are not active. i have been getting their registration emails, so I decided to double-check the database. when i do this query for a user named martdl:

    SELECT * FROM wordpressmu.wp_users where user_login = 'martdl'

    I get 0 rows, even though I got the e-mail for that username creation.

    So, thinking it was a misfire, i try to create a new record by filling out the Add New User form in wp-admin. When I click "Add User", I get the message "ERROR: This username is already registered. Please choose another one."

    WTF?

  2. andrea_r
    Moderator
    Posted 5 years ago #

    Maybe they;re not getting the activation email?

  3. rcwatson
    Member
    Posted 5 years ago #

    I don't know whether they already clicked the activation link, so I've asked the user to look for the activation email.

    What I don't get is why I got 0 rows from my query.

  4. andrea_r
    Moderator
    Posted 5 years ago #

    Because if they haven't activated yet, their info is in wp_signups table, but NOT in wp_users. Technically they are not a user (yet) but they have signed up.

    Check the wp_signups table. :)

About this Topic

  • Started 5 years ago by rcwatson
  • Latest reply from andrea_r