[GH-ISSUE #245] issues to migrate from 3.0.8 to 3.0.15 #196

Closed
opened 2026-02-26 09:36:39 +03:00 by kerem · 0 comments
Owner

Originally created by @ituxmx on GitHub (Jun 19, 2018).
Original GitHub issue: https://github.com/opensolutions/ViMbAdmin/issues/245

I'm migrating from vimbadmin 3.0.8 to 3.0.15 in a new server using the task listed above:

  1. export from old server
  2. import to new mysql server
  3. ./doctrine2-cli.php orm:validate-schema
  4. ./doctrine2-cli.php orm:schema-tool:update --force

And I receive this error:
[Doctrine\DBAL\Exception\UniqueConstraintViolationException]
An exception occurred while executing 'ALTER TABLE alias DROP INDEX address, ADD UNIQUE INDEX UNIQ_E16C6B94D4E6F81 (address)':
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'info@domain.com' for key 'UNIQ_E16C6B94D4E6F81'
[Doctrine\DBAL\Driver\PDOException]
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'info@domain.com' for key 'UNIQ_E16C6B94D4E6F81'
[PDOException]
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'info@domain.com' for key 'UNIQ_E16C6B94D4E6F81'

Originally created by @ituxmx on GitHub (Jun 19, 2018). Original GitHub issue: https://github.com/opensolutions/ViMbAdmin/issues/245 I'm migrating from vimbadmin 3.0.8 to 3.0.15 in a new server using the task listed above: 1) export from old server 2) import to new mysql server 3) ./doctrine2-cli.php orm:validate-schema 4) ./doctrine2-cli.php orm:schema-tool:update --force And I receive this error: [Doctrine\DBAL\Exception\UniqueConstraintViolationException] An exception occurred while executing 'ALTER TABLE alias DROP INDEX address, ADD UNIQUE INDEX UNIQ_E16C6B94D4E6F81 (address)': SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'info@domain.com' for key 'UNIQ_E16C6B94D4E6F81' [Doctrine\DBAL\Driver\PDOException] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'info@domain.com' for key 'UNIQ_E16C6B94D4E6F81' [PDOException] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'info@domain.com' for key 'UNIQ_E16C6B94D4E6F81'
kerem closed this issue 2026-02-26 09:36:39 +03:00
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/ViMbAdmin-opensolutions#196
No description provided.