Sweet, tasty details:
- Application Version - Upgrading 18.104.22.168 to 22.214.171.124
- Description of issue
I’m getting a ‘Duplicate entry’ error when no duplicate exists.
- Steps you took leading up to the issue
When upgrading (with php tools/upgrade.php upgrade), I get the following error:
<snip, upgrade progressing normally>
ERROR: Upgrade failed: DB: SQLSTATE: Integrity constraint violation: 1062 Duplicate entry ‘firstname.lastname@example.org’ for key ‘users_email’ (SQL: ALTER TABLE users ADD UNIQUE INDEX users_email (email))
- What you tried to resolve the issue
Read in many places, looked for any duplicates in the table… none exist (before or after)
- Error log messages if applicable
… posted above.