server icon indicating copy to clipboard operation
server copied to clipboard

Enforce valid email address for User email

Open harminius opened this issue 1 year ago • 1 comments

resolves #2537

Add additional format validity check for the user's email.

  • when the validation registration form
  • on the database level

Registration form check Screenshot from 2024-10-25 09-25-56

Before running the migration, we need to sanitize our database.

To see which emails break the new rule, try select email from public."user" where email !~ '^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+.[A-Za-z]{2,}$';

harminius avatar Oct 25 '24 13:10 harminius