when he is at the login screen, instead of entering his username where it asks for a username, have him login with his email address in that box.
you can login with either your username or email address, even though the prompt is only asking for username.
ignore this comment, as it is incorrect for the version you currently have installed.
I will be posting a sql solution in my reply below...
Last edited by id242; 10/23/2015 1:39 PM.
