[SOLVED] Enabling "Use email as username" on a populated Tiki23
HI Bernard
Well done - there may be other places where user logins are used, tiki_history, tiki_actionlog
etc which on some sites also need changing, which is why it's best to get this decision right at the start!
Bernard Sfez / Tiki Specialist wrote:
- Reinstate the admin account (last but not least), go back to users_users and normally your very first user is the admin, replace the login (email) with "admin.
You could always exclude the admin user from the updates with
Copy to clipboard
UPDATE users_users SET login=email; WHERE login != 'admin'
But well done, maybe this should be a recipe somewhere?