Sweet, tasty details:
- Application Version - Upgrading 3.2.1.1 to 3.3.0.3
- 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>
[schema: lib/pkp/xml/schema/common.xml]
ERROR: Upgrade failed: DB: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘email-redacted@email-host.redacted’ 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) - Screenshots
None… - Error log messages if applicable
… posted above.