double email

Please report bugs and any annoyances here. Kindly include all possible details: steps to reproduce, expected result, actual result, screenshots, ... etc.
Post Reply
riko01
Posts: 8
Joined: 2020-06-22 19:24

double email

Post by riko01 » 2021-01-24 08:27

I tried signing up with a different username and the same email.

example:

user A.
username: testa
email: [email protected]

User B
username: testa1
email: [email protected]

and registration is successful.
how to handle it? whether there is no default setting from appgini. should we hook code?

Thanks

User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts: 1156
Joined: 2019-05-21 22:42
Location: Germany
Contact:

Re: double email

Post by onoehring » 2021-01-24 08:58

Hi,

well, is this a bug or a feature? I am not so sure. Allowing different usernames with one email address might be uncommon, but (at least for me) it's great for testing.
You can use this quickfix: Use phpmyadmin (or adminer or similar) and alter the membership_users table: Set an index UNIQUE on the field email. Done. From now one, there can be only one username using an email address.

Olaf

riko01
Posts: 8
Joined: 2020-06-22 19:24

Re: double email

Post by riko01 » 2021-01-24 09:19

Thanks onoehring for your response.
I'm not sure if these are bugs. previously I have done as you suggest.
in the released future, double email prevention setting may be the default

User avatar
jsetzer
AppGini Super Hero
AppGini Super Hero
Posts: 1807
Joined: 2018-07-06 06:03
Location: Kiel, Germany
Contact:

Re: double email

Post by jsetzer » 2021-01-24 10:16

I totally agree with Olaf concerning testing with different users but identical email address.

Additionally, consider creating a unique index on membership_users.email column by code in case you are not on localhost using a SQL command. Doing it by code will save you time on every deployment/installation.
Kind regards,
<js />

My AppGini Blog:
https://appgini.bizzworxx.de/blog

You can help us helping you:
Please always put code fragments inside [code]...[/code] blocks for better readability

AppGini 24.10 Revision 1579 + all AppGini Helper tools

pfrumkin
Veteran Member
Posts: 157
Joined: 2020-02-18 17:58
Location: Albuquerque, New Mexico USA

Re: double email

Post by pfrumkin » 2021-01-29 14:58

I agree with Olaf and Jan, there can be business reasons to use the same email address with multiple login IDs. It is presumptuous to disallow that. Perhaps make it an option, sure, but not sure it's worth it for AG. Olaf has a great workaround (defined here as simple and straightforward).

~Paul

User avatar
baudwalker
Veteran Member
Posts: 188
Joined: 2015-02-03 08:08
Location: Bellingen NSW Australia

Re: double email

Post by baudwalker » 2021-01-29 22:45

One can see a problem with having 2 or more users using the same email. How would the program handle retrieving a password if the email address is used. Which users password would be reset?

In these days of hotmail, gmail and the like there is no reason for many people using the same email in this instance.

User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts: 1156
Joined: 2019-05-21 22:42
Location: Germany
Contact:

Re: double email

Post by onoehring » 2021-01-30 09:00

Hi

interesting train of thought the email recovery. Either only 1 email is sent - of multiple emails for each account .. which will target the same email address. So there should be no problem. We can just try what happens :-)

Olaf

User avatar
baudwalker
Veteran Member
Posts: 188
Joined: 2015-02-03 08:08
Location: Bellingen NSW Australia

Re: double email

Post by baudwalker » 2021-01-30 10:22

The answer is that you get no emails.

User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts: 1156
Joined: 2019-05-21 22:42
Location: Germany
Contact:

Re: double email

Post by onoehring » 2021-01-30 11:51

Hi,

oops, that's unexpected ... I tried and can confirm ...and imho should not be the case.

Olaf

User avatar
baudwalker
Veteran Member
Posts: 188
Joined: 2015-02-03 08:08
Location: Bellingen NSW Australia

Re: double email

Post by baudwalker » 2021-02-01 07:58

One of my projects has about 1000 users. Some time husband and wife try to use the same email. Like myself the users are mostly seniors and often forget their passwords and cannot retrieve it due to the emails not being unique. I advise them to get a hotmail or gmail account and forward the emails to their common account, this works well.

User avatar
a.gneady
Site Admin
Posts: 1281
Joined: 2012-09-27 14:46
Contact:

Re: double email

Post by a.gneady » 2021-02-06 10:48

Hi everyone ... I'm proposing a fix to this issue here: viewtopic.php?f=11&t=4170&p=16402#p16402
Kindly check this thread and let me know your thoughts.
:idea: AppGini plugins to add more power to your apps:
  • DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
  • Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
  • Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.

Post Reply