Some user register with their email as their user name (its valid).
Once you edit this account (for approval etc.) you can not submit is and get this error message
This name has already been taken by another user.
The problem is with the validation function at line 370
if (db_num_rows(db_query("SELECT uid FROM {users} WHERE LOWER(mail) = LOWER('%s') ", $form_values['name'])) > 0) {
Replace it with this one and it works fine
if (db_num_rows(db_query("SELECT uid FROM {users} WHERE LOWER(mail) = LOWER('%s') && uid != %d", $form_values['name'],$form_values['uid'])) > 0) {
Comments
Comment #1
hunmonk commentedif you'd like a patch reviewed, please follow drupal conventions and submit it in the proper format.
http://drupal.org/patch/create
Comment #2
hunmonk commentedthe line you pointed to is the incorrect location for this fix. it was however fixed by this commit:
http://drupal.org/cvs?commit=104980
Comment #3
Anonymous (not verified) commentedAutomatically closed -- issue fixed for two weeks with no activity.