# V 6.0.0 EA 2 nach V 6.1.0 (RC2)

**URL:** <https://forum.shopware.com/t/v-6-0-0-ea-2-nach-v-6-1-0-rc2/63506>\
**Category:** Installation / Einstieg\
**Created:** [12. Dezember 2019 um 12:20 UTC](https://forum.shopware.com/t/v-6-0-0-ea-2-nach-v-6-1-0-rc2/63506 "2019-12-12T12:20:59Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![vanlohuizen](https://avatars.discourse-cdn.com/v4/letter/v/71c47a/32.png) [@vanlohuizen](https://forum.shopware.com/u/vanlohuizen)\
**Post date:** [12. Dezember 2019 um 12:20 UTC](https://forum.shopware.com/t/v-6-0-0-ea-2-nach-v-6-1-0-rc2/63506/1 "2019-12-12T12:20:59Z")

</div>

```
 Ich habe jetzt mehrmals versucht, auf die neue Version zu aktualisieren. Ich bekomme immer wieder Fehler beim Update (Datenbankmigration). Es ist auch möglich, alle Website-Dateien vom FTP zu löschen. Neue Version hochladen. Und dann installieren. Kann ich das machen Und werde ich meine aktuelle Website / Produkte / Texte usw. behalten? ( Sie würden erwarten, dass die alten Daten aus der 6.0.0-Datenbank abgerufen werden)
```

---

<div class="post-metadata">

**Author:** ![vanlohuizen](https://avatars.discourse-cdn.com/v4/letter/v/71c47a/32.png) [@vanlohuizen](https://forum.shopware.com/u/vanlohuizen)\
**Post date:** [12. Dezember 2019 um 15:03 UTC](https://forum.shopware.com/t/v-6-0-0-ea-2-nach-v-6-1-0-rc2/63506/2 "2019-12-12T15:03:07Z")

</div>

```
Error
Received the following error message:
Undefined class constant 'SALES_CHANNEL_TYPE_PRODUCT_COMPARISON'

Please try to fix this error and restart the update.
Response
{"valid":false,"errorMsg":"Undefined class constant 'SALES_CHANNEL_TYPE_PRODUCT_COMPARISON'"}

```

&nbsp;

---

<div class="post-metadata">

**Author:** ![Oliver\_Skroblin](https://avatars.discourse-cdn.com/v4/letter/o/6bbea6/32.png) [@Oliver\_Skroblin](https://forum.shopware.com/u/Oliver_Skroblin)\
**Post date:** [13. Dezember 2019 um 08:59 UTC](https://forum.shopware.com/t/v-6-0-0-ea-2-nach-v-6-1-0-rc2/63506/3 "2019-12-13T08:59:57Z")

</div>

Hi&nbsp;vanlohuizen,

wir&nbsp;vermuten, dass der Fehler aufgrund des op\_cache entsteht. Wir haben die Referenz auf&nbsp;SALES\_CHANNEL\_TYPE\_PRODUCT\_COMPARISON entfernt.&nbsp;

Wenn du das ganze lokal bei dir fixen möchtest kannst du folgende Änderungen bei dir einfügen:

[https://github.com/shopware/platform/commit/6c418fdd7b4569f07c8133da470207ba05647377](https://github.com/shopware/platform/commit/6c418fdd7b4569f07c8133da470207ba05647377)

Ansonsten wirst du die Änderungen mit dem nächsten RC automatisch bekommen.

Gruß Oliver

---

<div class="post-metadata">

**Author:** ![vanlohuizen](https://avatars.discourse-cdn.com/v4/letter/v/71c47a/32.png) [@vanlohuizen](https://forum.shopware.com/u/vanlohuizen)\
**Post date:** [14. Dezember 2019 um 18:55 UTC](https://forum.shopware.com/t/v-6-0-0-ea-2-nach-v-6-1-0-rc2/63506/4 "2019-12-14T18:55:13Z")

</div>

```
 danke für die lösung. Leider habe ich jetzt folgende Fehlermeldung beim Update.

Error
Received the following error message:
An exception occurred while executing 'INSERT INTO mail_template (id, mail_template_type_id, system_default, created_at) VALUES (?, ?, ?, ?)' with params ["\xe4\xf5\xd6\xa3\xf3\x39\x43\x28\xbd\x91\x55\xbb\x86\x6b\x58\x40", false, true, "2019-12-14 19:51:45.000"]: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`vanlohuizen_6`.`mail_template`, CONSTRAINT `fk.mail_template.mail_template_type_id` FOREIGN KEY (`mail_template_type_id`) REFERENCES `mail_template_type` (`id`) ON DELETE SET NULL ON UPDATE C)

Please try to fix this error and restart the update.
Response
{"valid":false,"errorMsg":"An exception occurred while executing 'INSERT INTO mail_template (id, mail_template_type_id, system_default, created_at) VALUES (?, ?, ?, ?)' with params [\"\\xe4\\xf5\\xd6\\xa3\\xf3\\x39\\x43\\x28\\xbd\\x91\\x55\\xbb\\x86\\x6b\\x58\\x40\", false, true, \"2019-12-14 19:51:45.000\"]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`vanlohuizen_6`.`mail_template`, CONSTRAINT `fk.mail_template.mail_template_type_id` FOREIGN KEY (`mail_template_type_id`) REFERENCES `mail_template_type` (`id`) ON DELETE SET NULL ON UPDATE C)"}
2 / 3 Database migration in progress...

```

&nbsp;

---

<div class="post-metadata">

**Author:** ![vanlohuizen](https://avatars.discourse-cdn.com/v4/letter/v/71c47a/32.png) [@vanlohuizen](https://forum.shopware.com/u/vanlohuizen)\
**Post date:** [18. Dezember 2019 um 07:11 UTC](https://forum.shopware.com/t/v-6-0-0-ea-2-nach-v-6-1-0-rc2/63506/5 "2019-12-18T07:11:53Z")

</div>

Gibt es auch einen Lösung für die Folgende Fehler? Ich muss Morgen die 6.1 an meinen Kollega Presentieren.

```
Error
Received the following error message:
An exception occurred while executing 'INSERT INTO mail_template (id, mail_template_type_id, system_default, created_at) VALUES (?, ?, ?, ?)' with params ["\xe4\xf5\xd6\xa3\xf3\x39\x43\x28\xbd\x91\x55\xbb\x86\x6b\x58\x40", false, true, "2019-12-14 19:51:45.000"]: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`vanlohuizen_6`.`mail_template`, CONSTRAINT `fk.mail_template.mail_template_type_id` FOREIGN KEY (`mail_template_type_id`) REFERENCES `mail_template_type` (`id`) ON DELETE SET NULL ON UPDATE C)

Please try to fix this error and restart the update.
Response
{"valid":false,"errorMsg":"An exception occurred while executing 'INSERT INTO mail_template (id, mail_template_type_id, system_default, created_at) VALUES (?, ?, ?, ?)' with params [\"\\xe4\\xf5\\xd6\\xa3\\xf3\\x39\\x43\\x28\\xbd\\x91\\x55\\xbb\\x86\\x6b\\x58\\x40\", false, true, \"2019-12-14 19:51:45.000\"]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`vanlohuizen_6`.`mail_template`, CONSTRAINT `fk.mail_template.mail_template_type_id` FOREIGN KEY (`mail_template_type_id`) REFERENCES `mail_template_type` (`id`) ON DELETE SET NULL ON UPDATE C)"}
2 / 3 Database migration in progress...

```

&nbsp;

---

<div class="post-metadata">

**Author:** ![Moritz\_Naczenski](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/moritz_naczenski/32/7792_2.png) [@Moritz\_Naczenski](https://forum.shopware.com/u/Moritz_Naczenski)\
**Post date:** [18. Dezember 2019 um 07:14 UTC](https://forum.shopware.com/t/v-6-0-0-ea-2-nach-v-6-1-0-rc2/63506/6 "2019-12-18T07:14:01Z")

</div>

Klingt so, als ob eine&nbsp;mail\_template\_type\_id&nbsp;doppelt im System ist. Also am besten mal die Tabelle mail\_template prüfen. Den Eintrag löschen und danach das Update nochmal starten.

&nbsp;

---

<div class="post-metadata">

**Author:** ![vanlohuizen](https://avatars.discourse-cdn.com/v4/letter/v/71c47a/32.png) [@vanlohuizen](https://forum.shopware.com/u/vanlohuizen)\
**Post date:** [18. Dezember 2019 um 17:49 UTC](https://forum.shopware.com/t/v-6-0-0-ea-2-nach-v-6-1-0-rc2/63506/7 "2019-12-18T17:49:13Z")

</div>

Ich habe leider kein Glück. Ich habe einige zusätzliche Informationen hinzugefügt. Gibt es eine Möglichkeit, dieses Problem zu lösen? Ich finde es schade, dass bei einem Update so viele Fehlermeldungen auftauchen.

```
Error
Received the following error message:
An exception occurred while executing 'INSERT INTO mail_template (id, mail_template_type_id, system_default, created_at) VALUES (?, ?, ?, ?)' with params ["\xda\xaf\x66\x9c\xc1\xdd\x46\x70\xa8\x40\xe3\x69\x1f\x40\x4e\x39", "\xe2\xff\x06\x8d\xb2\xb2\x43\x85\xae\xf4\x72\xef\x88\xe6\x71\xc7", true, "2019-12-18 18:26:26.000"]: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`vanlohuizen_6`.`mail_template`, CONSTRAINT `fk.mail_template.mail_template_type_id` FOREIGN KEY (`mail_template_type_id`) REFERENCES `mail_template_type` (`id`) ON DELETE SET NULL ON UPDATE C)

Please try to fix this error and restart the update.
Response
{"valid":false,"errorMsg":"An exception occurred while executing 'INSERT INTO mail_template (id, mail_template_type_id, system_default, created_at) VALUES (?, ?, ?, ?)' with params [\"\\xda\\xaf\\x66\\x9c\\xc1\\xdd\\x46\\x70\\xa8\\x40\\xe3\\x69\\x1f\\x40\\x4e\\x39\", \"\\xe2\\xff\\x06\\x8d\\xb2\\xb2\\x43\\x85\\xae\\xf4\\x72\\xef\\x88\\xe6\\x71\\xc7\", true, \"2019-12-18 18:26:26.000\"]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`vanlohuizen_6`.`mail_template`, CONSTRAINT `fk.mail_template.mail_template_type_id` FOREIGN KEY (`mail_template_type_id`) REFERENCES `mail_template_type` (`id`) ON DELETE SET NULL ON UPDATE C)"}

```

&nbsp;

 ![](https://europe1.discourse-cdn.com/flex013/uploads/shopware/original/2X/d/dea6b9102133e7927e61d4742b693ef1cff63545.png) ![](https://europe1.discourse-cdn.com/flex013/uploads/shopware/original/2X/b/b0a465c07c4f13eac33e3410f963816cf0b291e7.png)
