Somehow I've got 2 users in my
users table with the same email address (mine!). I need to delete one of them. One is user ID #1, the other is user ID #144.
When I use the
advuser module to search for my email address, only one user (#144) shows up. I select it and try to delete, but it's not successful - the confirmation screen says
"No selections have been applied." I'm guessing it's trying carefully to not delete user #1.
Additionally, I can't seem to change any account details in my own (user #1) account, it complains that
"The e-mail address firstname.lastname@example.org is already taken."
Not sure what to do next - am I safe to just do
DELETE FROM users WHERE uid=144;? Or will that create dangling references elsewhere?
I'm using D7, but I had this extra user before I upgraded from D6 too.