Delete duplicate user 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 me@foo.com 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.
Instead of deleting the user and risking something going bad, why don't you try just to change his e-mail address in the SQL table? If you change #144's mail won't you then be able to edit, delete his account through the usual UI way?