Open q2apro opened 4 months ago
This is not only a plugin issue. If two users register the same time with question2answer, having the same email or/and the same username, two user accounts would be created.
I have set handle
and email
to unique:
In general, it is irresponsible to allow two userhandles because they can be used for a login - and user A could access the data of user B.
I think this makes sense. Thank you for raising this issue.
I used a plugin that generates userhandles and inserts them. It happened, that users simultaneously signed up and the plugin checked if the userhandle does not exist, which was true for both, then used
function qa_db_user_create()
to create the new user. Hence, the user handle was assigned twice and even the email was there twice!Starting questions:
qa_users
the columnhandle
is not unique?qa_users
the columnemail
is not unique?Code question:
qa_db_user_create()
so it does something like:handle
andemail
unique and then catch somehow the error that is casted by MySQL withINSERT INTO
.