# Shopware Update 5.5.10 zu 5.6.8 Error - Could not apply migration (Migrations\_Migration1611).

**URL:** <https://forum.shopware.com/t/shopware-update-5-5-10-zu-5-6-8-error-could-not-apply-migration-migrations-migration1611/70224>\
**Category:** Installation/Einstieg\
**Created:** [15. Oktober 2020 um 10:18 UTC](https://forum.shopware.com/t/shopware-update-5-5-10-zu-5-6-8-error-could-not-apply-migration-migrations-migration1611/70224 "2020-10-15T10:18:23Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![WOLLkenSchaf](https://avatars.discourse-cdn.com/v4/letter/w/8491ac/32.png) [@WOLLkenSchaf](https://forum.shopware.com/u/WOLLkenSchaf)\
**Post date:** [15. Oktober 2020 um 10:18 UTC](https://forum.shopware.com/t/shopware-update-5-5-10-zu-5-6-8-error-could-not-apply-migration-migrations-migration1611/70224/1 "2020-10-15T10:18:23Z")

</div>

Hey shopware community, ich bekomme bei dem Versuch mein Shopware auf 5.6.8 zu updaten folgende Fehlermeldung:

```
Error
Received the following error message:
Could not apply migration (Migrations_Migration1611). Error: SQLSTATE[HY000]: General error: 1553 Cannot drop index 'PRIMARY': needed in a foreign key constraint

Please try to fix this error and restart the update.
Response
{"valid":false,"errorMsg":"Could not apply migration (Migrations_Migration1611). Error: SQLSTATE[HY000]: General error: 1553 Cannot drop index 'PRIMARY': needed in a foreign key constraint "}

```

In einem anderen Post hab ich gelesen, dass “DELETE from s\_order\_details &nbsp;WHERE orderID Not IN (Select id from s\_order)” helfen kann.&nbsp;

Wurde von mir ausgeführt und einige Datensätze wurden auch entfernt, nur leider nicht die Fehlermeldung.&nbsp;

Hat jemand evtl. einen Tipp für mich was ich machen kann, um diesen Fehler zu beheben?

Vielen Dank&nbsp; ![Smile](https://europe1.discourse-cdn.com/flex013/uploads/shopware/original/1X/bac5f5766b6a20565a8fb995345b4e41d24daac0.png "Smile")

&nbsp;

---

<div class="post-metadata">

**Author:** ![erfansh](https://avatars.discourse-cdn.com/v4/letter/e/51bf81/32.png) [@erfansh](https://forum.shopware.com/u/erfansh)\
**Post date:** [16. Oktober 2020 um 15:04 UTC](https://forum.shopware.com/t/shopware-update-5-5-10-zu-5-6-8-error-could-not-apply-migration-migrations-migration1611/70224/2 "2020-10-16T15:04:34Z")

</div>

The problem is related to Migrations\_Migration1611. It is placed in&nbsp;update-assets/migrations/1611-change-order-details-id-column.php

Here you can read about the purpose of this migration&nbsp;[Add Mysql 8 workaround by soebbing · Pull Request #900 · shopware/devdocs · GitHub](https://github.com/shopware/devdocs/pull/900/files) .

This migration renames the id column of “s\_order\_documents”&nbsp;from “ID” to “id”.

I had the same problem and the easiest way i found to solve it is to manually rename the field from “ID” to “id” (for example via phpMyAdmin). After that the migration should continue.

---

<div class="post-metadata">

**Author:** ![WOLLkenSchaf](https://avatars.discourse-cdn.com/v4/letter/w/8491ac/32.png) [@WOLLkenSchaf](https://forum.shopware.com/u/WOLLkenSchaf)\
**Post date:** [16. Oktober 2020 um 18:37 UTC](https://forum.shopware.com/t/shopware-update-5-5-10-zu-5-6-8-error-could-not-apply-migration-migrations-migration1611/70224/3 "2020-10-16T18:37:47Z")

</div>

You are my hero.&nbsp; ![Smile](https://forum.shopware.com/plugins/CKEditor/plugins/smiley/images/smile.png "Smile")

Many many&nbsp;thanks.