Ok, so I imported 30,000 users. Most users use an email address or some alpha-numeric combination. Some users used all numbers in their username.
Here's two examples:
1334
105881
... and so while we were testing all this, we randomly picked those two users and got the results I mentioned above.
Well, after curling up in the fetal position for an hour, I started to look through the MySQL export of the database. I started doing a search to see what the SQL looked like for those users. It was then I discovered that there were rows that had UserID and MetaUserID values matching those usernames (because, again, they are numbers).
So, I'm guessing WordPress (?) does some wacky lookups for login that somehow involve these fields, but gets confused when the username is a number matching userid's or metauserid's in the database. I don't know.
So, the moral of the story is that if you conduct an import of a large number of users be wary and know that any weirdness may be due to the data and the denormalized/pivoted nature of WordPress' user meta data.
I hope this was helpful for someone in the future.Statistics: Posted by BobTabor — July 5th, 2011, 12:29 pm
]]>