[BUG] Unable to add any new user

[tlvu]

[BUG] Unable to add any new user

[tlvu]

The WebUI should also display the email, in addition to the username, on the page where all users are listed, since email is enforced to be unique so we can find out which email has been already in use.

My collegues also found out that email comparison was case-sensitive so they got around to create a new user with [email protected] when [email protected] already exist in the DB. This should probably be case-insensitive.

[tlvu]

Email validation should also trim beginning and ending white spaces. I found some email with white spaces in our production DB. Probably fat finger typo when entering data in the add user form.

[tlvu]

@fmigneault this is urgent for us, we are not able to add new users anymore !

[tlogan2000]

I believe I have figured this out. The provided email was already in the system so even with new usernames the account was not being created. What is strange is that I cannot find the preexisting account in the UI user list.

[tlvu]

I believe I have figured this out. The provided email was already in the system so even with new usernames the account was not being created. What is strange is that I cannot find the preexisting account in the UI user list.

In this case I think the error message should specify exactly which string was causing the duplicate error. This way we do not have to guess if it is the username or the email that is duplicated.

Back to the original cause: unclear error message

[fmigneault]

I will look into it assuming it is related to email.
When testing with a duplicate name, I get this answer instead of the error:

[fmigneault]

Email validation should also trim beginning and ending white spaces

This is done automatically by the field type validation that requires a valid email in the UI. It is also validated with a regex in the API.
Maybe they have been inserted manually in the DB? Otherwise, provide an example.

[tlvu]

This is done automatically by the field type validation that requires a valid email in the UI. It is also validated with a regex in the API.
Maybe they have been inserted manually in the DB? Otherwise, provide an example.

Our production DB started with a very old version of Magpie. Could it have happened since that time? In the very early days, those validation might possibly not exist?

The user with space in their is email is actually you :D I am guessing you must be one of the first users and your account most probably was created with the very first version of Magpie.

Anyways, it's good news that those validations are there now.