WordPress MU

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?

Maybe they;re not getting the activation email?

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.

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. :)