When user assign an email to it's profile, it is lower cased

[alexgarel]

Description

• On subscription when a user enter an email with upper cases inside, it is automatically registered in lower case format
• On profile, if a user changes hes email for an email with upper cases inside, it is automatically saved in lower case format

Acceptance criteria

• Old users that have entered an email with upper cases in the past, now have a lowercase email
• if a there is different users for same emails with different cases, the user with upper cases in email is disabled, we only keep the one with the lower cased email
• if a user try a registration with an email with upper case but there is already an existing with same email in lowercase, registrations fails
• if a user tries to login with an email with upper cases, it is logged in with lower cased email (already implemented in Try lowercase email on password reset, fixes #5807 #5812)
• if a user asks for password reset with an email with upper cases, it is logged in with lower cased email (already implemented in Try lowercase email on password reset, fixes #5807 #5812)

What would a demo look like

• I fill the subscription putting [email protected] as email
• I can login with [email protected]
• if I go in my profile email in [email protected] or [email protected]
• I try to change email in my profile to [email protected]
• I confirm the change and logout
• I can login with [email protected] or [email protected]
• if I go in my profile the email is lower case.

Notes

• For old users we need to do a migration script

Tasks

• Modify registration to lower case email
• Modify user profile change to lower case email
• Make a script to change old users emails that needs to be lowercased

Part of

• 👥 User management (tracker) #5809
• 👤 Open Food Facts account (tracker) #6436

[alexgarel]

@stephanegigandet and @teolemon it relates to #5807 but I imagine it's not urgent, right ?

[stephanegigandet]

It's been like that for 10 years so no special urgency. It would be nice to fix though.

[github-actions]

This issue is stale because it has been open 90 days with no activity.