Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
  • Register
Welcome to the Q&A for Question2Answer.

If you have questions about the platform, click here to ask and please use English.

If you just want to try Q2A, please use the demo, which also grants admin access.

Apr 29: Q2A 1.5.2

Duplicate Emails in user table

0 votes
I'm using 1.5 beta version.

I just check my user table in database and i can see same email has been used 2 time.

same email entry more then once. it should only be one uniqe email addresss.
Q2A version: 1.5 beta
asked Jan 6 in Q2A Core by anonymous

1 Answer

0 votes
I think this can happen if one user signed up directly, and the other signed up via Facebook or another external identity provider. Does that make sense in your case?
answered Jan 7 by gidgreen
I was actually going to ask a similar question. So someone can now sign up with the same email thru Facebook that also signed up via the regular registration process? Shouldn't that be prevented, so that there are no duplicate registrations with the same email?
Note, you won't be able to get more than two users per email because Facebook doesn't allow you multiple accounts with the same email AFAIK. Unless you have multiple login providers (OpenID etc).
Yes, but the problem is that if a user registers with QA first and then registers via FB, then the database will save the user from FB even if the email address is the same. This creates duplicate email addresses in the database, which should not be allowed. There should be some check in the FB plugin, to ensure the person doesn't already have an account with the same email on QA before allowing registration with FB.