change login from username to email

change login from username to email

According to my forum research I just have to deselect the username from registration fields.
If I change it with existing customers in database I would have to overwrite the old usernames with their emails, right?
If so, is there a simple query for it or has it to be done manually?

I recognized that after unchecking the username Login site field changes 'username' to 'email' but login module doesn't.

Aw: change login from username to email

Will be added in the new version of the mod_jshopping_login.

SQL query:
UPDATE `#__users` SET `username` = `email`

However, make sure to back up the users table before running the query.

Aw: change login from username to email

Thank you. seems to work.

meanwhile changed username to Email with language override

---

Aw: change login from username to email

new version:
Module login 5.1.1 (JoomShopping 5.0.0+)