Multiple accounts for members

[benjaminrancourt]

Issue Summary

When the user use the same email address to login but with different case sensitivity, multiple accounts are created.

Steps to Reproduce

1. Sign in using your email ([email protected])
2. Click on the sign up link you received
3. Logout
4. Sign in using your email ([email protected])
5. Click on the sign up link you received
6. Check your members in Ghost admin and you should see multiple accounts for the same email address

Ghost Version

4.47.1

Node.js Version

v14.19.1

How did you install Ghost?

Docker

Database type

SQLite3

Browser & OS version

No response

Relevant log / error output

No response

Code of Conduct

• [X] I agree to be friendly and polite to people in this repository

[ErisDS]

Hey there @benjaminrancourt, this is due to sqlite3 not doing case sensitive unique constraints by default, and knex not handling the difference. It is therefore only an issue in development as we don't recommend running SQLite3 in production.

If anyone is really keen to get this fixed, it would be great to see knex get more love for things like this, so that operations like creating unique constraints are consistent across databases.

[github-actions[bot]]

Our bot has automatically marked this issue as stale because there has not been any activity here in some time.

The issue will be closed soon if there are no further updates, however we ask that you do not post comments to keep the issue open if you are not actively working on a PR.

We keep the issue list minimal so we can keep focus on the most pressing issues. Closed issues can always be reopened if a new contributor is found. Thank you for understanding 🙂