Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Database error occurs when inviting user whose email already exists but with a different case #499

Open
zpchavez opened this issue May 13, 2021 · 0 comments
Labels
blocking Automatically assigned to indicate this issue is a blocker for another issue. bug Something isn't working minor Severity: Affects minor functionality or non-critical data. It has an easy workaround.

Comments

@zpchavez
Copy link
Contributor

When inviting a user, we check if the email already exists and if it does we do a reinvite. If it does not exist, we create a new user. The problem is we do the check against the email column instead of the email_lower_case column. So if we invite [email protected] and they exist in OIDC as [email protected], it will try to create a new user and then fail because the email_lower_case field will not be unique.

@zpchavez zpchavez added the bug Something isn't working label May 13, 2021
@synbot synbot added the blocking Automatically assigned to indicate this issue is a blocker for another issue. label May 13, 2021
@bobeagan bobeagan added the minor Severity: Affects minor functionality or non-critical data. It has an easy workaround. label May 13, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
blocking Automatically assigned to indicate this issue is a blocker for another issue. bug Something isn't working minor Severity: Affects minor functionality or non-critical data. It has an easy workaround.
Projects
None yet
Development

No branches or pull requests

3 participants