[PHP]co w tym zapytaniu jest nie tak? (DoctrineMigrationBundle wygenerował zapytanie które zwraca błedy INTEGRITY CONSTRAINT) Opcje

[porzeczki]

Proszę poradzić co jest nie tak. DoctrineMigrationBundle wygenerował zapytanie które zwraca błędy INTEGRITY CONSTRAINT. Poniżej wklejam wyniki komendy i eksport istniejącej (kłopotliwej) tabeli

doctrine:migration:diff (fragment)

[PHP] pobierz, plaintext 
    public function up(Schema $schema)
    {
        $this->addSql('CREATE UNIQUE INDEX UNIQ_DFCCB96DEDE56D28 ON shop_division_position_link (division_position_link_did)');
 
    }
[PHP] pobierz, plaintext 

doctrine:migration:migrate

[PHP] pobierz, plaintext 
Migrating [32mup[39m to [33m20180310185535[39m from [33m0[39m
 
  [32m++[39m migrating [33m20180310184729[39m
 
     [33m->[39m CREATE UNIQUE INDEX UNIQ_DFCCB96DEDE56D28 ON shop_division_position_link (division_position_link_did)
[37;41mMigration 20180310184729 failed during Execution. Error An exception occurred while executing 'CREATE UNIQUE INDEX UNIQ_DFCCB96DEDE56D28 ON shop_division_position_link (division_position_link_did)':
 
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '17' for key 'UNIQ_DFCCB96DEDE56D28'[39;49m
 
[37;41m                                                                                                                                                   [39;49m
[37;41m  [Doctrine\DBAL\Exception\UniqueConstraintViolationException]                                                                                     [39;49m
[37;41m  An exception occurred while executing 'CREATE UNIQUE INDEX UNIQ_DFCCB96DEDE56D28 ON shop_division_position_link (division_position_link_did)':  [39;49m
[37;41m                                                                                                                                                   [39;49m
[37;41m  SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '17' for key 'UNIQ_DFCCB96DEDE56D28'                                       [39;49m
[37;41m                                                                                                                                                   [39;49m
 
[37;41m                                                                                                              [39;49m
[37;41m  [Doctrine\DBAL\Driver\PDOException]                                                                         [39;49m
[37;41m  SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '17' for key 'UNIQ_DFCCB96DEDE56D28'  [39;49m
[37;41m                                                                                                              [39;49m
 
[37;41m                                                                                                              [39;49m
[37;41m  [PDOException]                                                                                              [39;49m
[37;41m  SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '17' for key 'UNIQ_DFCCB96DEDE56D28'  [39;49m
[37;41m                                                                                                              [39;49m
[PHP] pobierz, plaintext 

export sql istniejącej bazy (tylko tabela kłopotliwa)

[SQL] pobierz, plaintext 
CREATE TABLE `shop_division_position_link` (
  `division_position_link_pid` int(10) UNSIGNED NOT NULL,
  `division_position_link_did` int(10) UNSIGNED NOT NULL,
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
ALTER TABLE `shop_division_position_link`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_DFCCB96DF6CA6684` (`division_position_link_pid`);
 
ALTER TABLE `shop_division_position_link`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
[SQL] pobierz, plaintext 

Ten post edytował porzeczki 10.03.2018, 20:19:38

[Pyton_000]

Przecież masz wyjaśniony błąd.

Masz zduplikowany wiersz z ID = 17 w tabeli a próbujesz nakładać UNIQUE.

Więc masz problem z danymi a nie z wygenerowanym zapytaniem.