After the k!reVerify command is used on a particular role, users will be stripped of that role until they reverify the email that was paired with it. However, when verifying adresses with the gmail.com domain, an integrity error message occurs, looking like this:
IntegrityError
(raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely)
(pysqlcipher3.dbapi2.IntegrityError) UNIQUE constraint failed: verified_emails.u_id, verified_emails.email
[SQL: INSERT INTO verified_emails (u_id, email) VALUES (?, ?)]
[parameters: (305629460919615490, 'rudeboiyt@gmail.com')]
(Background on this error at: https://sqlalche.me/e/14/gkpj)
Additionally, the user is not given the role in the server.
To Reproduce
Verify your email to give your account a role.
Type k!reVerify [role] where [role] is the role your account was given.
Slide into KoalaBot's DMs and type k!verify [email] where [email] is your email.
In your email inbox, copy the k!confirm command KoalaBot sent you and clap it back to KoalaBot in DMs.
Observe error message.
Expected behaviour
The bot should return Your email has been verified, thank you and the user should be reassigned the role.
Screenshots
Additional context
Other domains tested which didn't return this error:
Describe the bug
After the
k!reVerifycommand is used on a particular role, users will be stripped of that role until they reverify the email that was paired with it. However, when verifying adresses with thegmail.comdomain, an integrity error message occurs, looking like this:Additionally, the user is not given the role in the server.
To Reproduce
k!reVerify [role]where [role] is the role your account was given.k!verify [email]where [email] is your email.k!confirmcommand KoalaBot sent you and clap it back to KoalaBot in DMs.Expected behaviour
The bot should return
Your email has been verified, thank youand the user should be reassigned the role.Screenshots
Additional context
Other domains tested which didn't return this error: