Error when using the same email for both Google and GitHub sign-ins

[DhanushNehru]

When a user tries to sign in with both Google and GitHub using the same primary email address, it causes a database conflict and raises an error. This is likely because the email is already stored in the database when they first use Google sign-in, and attempting to log in via GitHub with the same email results in a duplicate entry.

Checkout this PR for reference #139

Steps to Reproduce:

Sign up with Google using an email.
Try signing in with GitHub using the same primary email.

Expected Behavior:

The user should be able to sign in with either Google or GitHub using the same email without raising an error.

Actual Behavior:

An error occurs due to a conflict in the database for the same email being linked to different sign-in providers.

[swarupn17]

Hey @DhanushNehru I can do this task. Please can you assign it to me.
Thanks!

[tusharshah21]

@DhanushNehru this looks interesting, can you assign this to me also?

[DhanushNehru]

Hi @tusharshah21

Seems @swarupn17 is working on it. @swarupn17 any updates ?

[tusharshah21]

@DhanushNehru now can you check and assign it to me?

[tusharshah21]

@DhanushNehru you expecting a Single User Identity or multi-user Identity?

[DhanushNehru]

SSO if possible @tusharshah21

[tusharshah21]

@DhanushNehru tried to resolved it, but couldn't resolve the conflict to be precise, could only add an alert that there exist an account already. Let me know if it is good to go

open.mp4

[tusharshah21]

@DhanushNehru any update?

[DhanushNehru]

FIne for now , raise a new issue and new pr for alert alone, let this issue still be open @tusharshah21

[tusharshah21]

alright