Guten Morgen, ich richte gerade einen neuen Shop mit Shopware 6 ein. Habe nun die Migration von Shopware 5 eingespielt. Nun möchte ich gerne den Abgleich mit der Wawi durchlaufen lassen. Leider bekomme ich nur eine Fehlermeldung, siehe unten. Jemand eine Idee wo der Fehler liegt?
Viele Grüße
Fabian
Fehler:
Exception: Controller = Category | Action = push | JTL-Wawi PK = 35 | Parent Wawi PK = 5 | Name = Spruchschilder / Rindenscheiben | [89f1e169-daf3-418a-b407-dd9952b0145c] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `category` (`version_id`, `id`, `parent_id`, `parent_version_id`, `after_category_id`, `after_category_version_id`, `media_id`, `cms_page_id`, `product_stream_id`, `display_nested_products`, `type`, `product_assignment_type`, `visible`, `active`, `created_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "\x1a\x1b\xc7\x29\xd8\x9c\x4c\x4a\x9d\x84\x3f\x31\x46\x11\x78\x9b", "\x73\x59\xec\xb7\x31\x34\x4c\xcc\x81\x49\x27\x8a\x1d\x64\x14\xfb", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, "\xb8\x23\x8d\xd7\x2f\x93\x49\x44\x9a\x11\x1a\x7c\x44\x82\x19\x62", null, 1, "page", "product", 1, 1, "2021-02-03 05:39:44.617"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`HolzFrankSW6`.`category`, CONSTRAINT `fk.category.parent_id` FOREIGN KEY (`parent_id`, `parent_version_id`) REFERENCES `category` (`id`, `version_id`) ON DELETE CASCADE ON UPDATE CASCADE)
Controller = Category | Action = push | JTL-Wawi PK = 35 | Parent Wawi PK = 5 | Name = Spruchschilder / Rindenscheiben | [f3a756d1-d9bb-4806-9116-b87736f34b64] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `category` (`version_id`, `id`, `parent_id`, `parent_version_id`, `after_category_id`, `after_category_version_id`, `media_id`, `cms_page_id`, `product_stream_id`, `display_nested_products`, `type`, `product_assignment_type`, `visible`, `active`, `created_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "\x1a\x1b\xc7\x29\xd8\x9c\x4c\x4a\x9d\x84\x3f\x31\x46\x11\x78\x9b", "\x73\x59\xec\xb7\x31\x34\x4c\xcc\x81\x49\x27\x8a\x1d\x64\x14\xfb", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, "\xb8\x23\x8d\xd7\x2f\x93\x49\x44\x9a\x11\x1a\x7c\x44\x82\x19\x62", null, 1, "page", "product", 1, 1, "2021-02-03 05:39:50.831"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`HolzFrankSW6`.`category`, CONSTRAINT `fk.category.parent_id` FOREIGN KEY (`parent_id`, `parent_version_id`) REFERENCES `category` (`id`, `version_id`) ON DELETE CASCADE ON UPDATE CASCADE)
Kategorien-Senden-Fehler: Bitte beachten Sie, dass zur Fehler-Diagnose ebenfalls die Log-Datei des Servers und das Abgleich-Log der JTL-Wawi notwendig sind!
Exception bei category.push: Controller = Category | Action = push | JTL-Wawi PK = 35 | Parent Wawi PK = 5 | Name = Spruchschilder / Rindenscheiben | [89f1e169-daf3-418a-b407-dd9952b0145c] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `category` (`version_id`, `id`, `parent_id`, `parent_version_id`, `after_category_id`, `after_category_version_id`, `media_id`, `cms_page_id`, `product_stream_id`, `display_nested_products`, `type`, `product_assignment_type`, `visible`, `active`, `created_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "\x1a\x1b\xc7\x29\xd8\x9c\x4c\x4a\x9d\x84\x3f\x31\x46\x11\x78\x9b", "\x73\x59\xec\xb7\x31\x34\x4c\xcc\x81\x49\x27\x8a\x1d\x64\x14\xfb", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, "\xb8\x23\x8d\xd7\x2f\x93\x49\x44\x9a\x11\x1a\x7c\x44\x82\x19\x62", null, 1, "page", "product", 1, 1, "2021-02-03 05:39:44.617"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`HolzFrankSW6`.`category`, CONSTRAINT `fk.category.parent_id` FOREIGN KEY (`parent_id`, `parent_version_id`) REFERENCES `category` (`id`, `version_id`) ON DELETE CASCADE ON UPDATE CASCADE)
Controller = Category | Action = push | JTL-Wawi PK = 35 | Parent Wawi PK = 5 | Name = Spruchschilder / Rindenscheiben | [f3a756d1-d9bb-4806-9116-b87736f34b64] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `category` (`version_id`, `id`, `parent_id`, `parent_version_id`, `after_category_id`, `after_category_version_id`, `media_id`, `cms_page_id`, `product_stream_id`, `display_nested_products`, `type`, `product_assignment_type`, `visible`, `active`, `created_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "\x1a\x1b\xc7\x29\xd8\x9c\x4c\x4a\x9d\x84\x3f\x31\x46\x11\x78\x9b", "\x73\x59\xec\xb7\x31\x34\x4c\xcc\x81\x49\x27\x8a\x1d\x64\x14\xfb", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, "\xb8\x23\x8d\xd7\x2f\x93\x49\x44\x9a\x11\x1a\x7c\x44\x82\x19\x62", null, 1, "page", "product", 1, 1, "2021-02-03 05:39:50.831"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`HolzFrankSW6`.`category`, CONSTRAINT `fk.category.parent_id` FOREIGN KEY (`parent_id`, `parent_version_id`) REFERENCES `category` (`id`, `version_id`) ON DELETE CASCADE ON UPDATE CASCADE)
Response: {"jtlrpc":"2.0","id":"c2776bce4f7c434398e53dd3f29de4d2","result":null,"error":{"code":400,"message":"Controller = Category | Action = push | JTL-Wawi PK = 35 | Parent Wawi PK = 5 | Name = Spruchschilder \/ Rindenscheiben | [5cca94c6-3f7d-49b9-9a73-6c6e7db79691] The Shopware 6 Admin API responded with an error: \nCode = 0 | Status = 500 | Detail = An exception occurred while executing \u0027INSERT INTO `category` (`version_id`, `id`, `parent_id`, `parent_version_id`, `after_category_id`, `after_category_version_id`, `media_id`, `cms_page_id`, `product_stream_id`, `display_nested_products`, `type`, `product_assignment_type`, `visible`, `active`, `created_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\u0027 with params [\u0022\\x0f\\xa9\\x1c\\xe3\\xe9\\x6a\\x4b\\xc2\\xbe\\x4b\\xd9\\xce\\x75\\x2c\\x34\\x25\u0022, \u0022\\x1a\\x1b\\xc7\\x29\\xd8\\x9c\\x4c\\x4a\\x9d\\x84\\x3f\\x31\\x46\\x11\\x78\\x9b\u0022, \u0022\\x73\\x59\\xec\\xb7\\x31\\x34\\x4c\\xcc\\x81\\x49\\x27\\x8a\\x1d\\x64\\x14\\xfb\u0022, \u0022\\x0f\\xa9\\x1c\\xe3\\xe9\\x6a\\x4b\\xc2\\xbe\\x4b\\xd9\\xce\\x75\\x2c\\x34\\x25\u0022, null, \u0022\\x0f\\xa9\\x1c\\xe3\\xe9\\x6a\\x4b\\xc2\\xbe\\x4b\\xd9\\xce\\x75\\x2c\\x34\\x25\u0022, null, \u0022\\xb8\\x23\\x8d\\xd7\\x2f\\x93\\x49\\x44\\x9a\\x11\\x1a\\x7c\\x44\\x82\\x19\\x62\u0022, null, 1, \u0022page\u0022, \u0022product\u0022, 1, 1, \u00222021-02-03 05:39:47.673\u0022]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`HolzFrankSW6`.`category`, CONSTRAINT `fk.category.parent_id` FOREIGN KEY (`parent_id`, `parent_version_id`) REFERENCES `category` (`id`, `version_id`) ON DELETE CASCADE ON UPDATE CASCADE)","data":"Jtl\\Shopware6\\Client\\Exception\\ClientException (Code: 400) in ...\/ClientException.php:98"}}
Exception bei category.push: Controller = Category | Action = push | JTL-Wawi PK = 35 | Parent Wawi PK = 5 | Name = Spruchschilder / Rindenscheiben | [89f1e169-daf3-418a-b407-dd9952b0145c] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `category` (`version_id`, `id`, `parent_id`, `parent_version_id`, `after_category_id`, `after_category_version_id`, `media_id`, `cms_page_id`, `product_stream_id`, `display_nested_products`, `type`, `product_assignment_type`, `visible`, `active`, `created_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "\x1a\x1b\xc7\x29\xd8\x9c\x4c\x4a\x9d\x84\x3f\x31\x46\x11\x78\x9b", "\x73\x59\xec\xb7\x31\x34\x4c\xcc\x81\x49\x27\x8a\x1d\x64\x14\xfb", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, "\xb8\x23\x8d\xd7\x2f\x93\x49\x44\x9a\x11\x1a\x7c\x44\x82\x19\x62", null, 1, "page", "product", 1, 1, "2021-02-03 05:39:44.617"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`HolzFrankSW6`.`category`, CONSTRAINT `fk.category.parent_id` FOREIGN KEY (`parent_id`, `parent_version_id`) REFERENCES `category` (`id`, `version_id`) ON DELETE CASCADE ON UPDATE CASCADE)
Controller = Category | Action = push | JTL-Wawi PK = 35 | Parent Wawi PK = 5 | Name = Spruchschilder / Rindenscheiben | [f3a756d1-d9bb-4806-9116-b87736f34b64] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `category` (`version_id`, `id`, `parent_id`, `parent_version_id`, `after_category_id`, `after_category_version_id`, `media_id`, `cms_page_id`, `product_stream_id`, `display_nested_products`, `type`,
Viele Grüße
Fabian
Fehler:
Exception: Controller = Category | Action = push | JTL-Wawi PK = 35 | Parent Wawi PK = 5 | Name = Spruchschilder / Rindenscheiben | [89f1e169-daf3-418a-b407-dd9952b0145c] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `category` (`version_id`, `id`, `parent_id`, `parent_version_id`, `after_category_id`, `after_category_version_id`, `media_id`, `cms_page_id`, `product_stream_id`, `display_nested_products`, `type`, `product_assignment_type`, `visible`, `active`, `created_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "\x1a\x1b\xc7\x29\xd8\x9c\x4c\x4a\x9d\x84\x3f\x31\x46\x11\x78\x9b", "\x73\x59\xec\xb7\x31\x34\x4c\xcc\x81\x49\x27\x8a\x1d\x64\x14\xfb", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, "\xb8\x23\x8d\xd7\x2f\x93\x49\x44\x9a\x11\x1a\x7c\x44\x82\x19\x62", null, 1, "page", "product", 1, 1, "2021-02-03 05:39:44.617"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`HolzFrankSW6`.`category`, CONSTRAINT `fk.category.parent_id` FOREIGN KEY (`parent_id`, `parent_version_id`) REFERENCES `category` (`id`, `version_id`) ON DELETE CASCADE ON UPDATE CASCADE)
Controller = Category | Action = push | JTL-Wawi PK = 35 | Parent Wawi PK = 5 | Name = Spruchschilder / Rindenscheiben | [f3a756d1-d9bb-4806-9116-b87736f34b64] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `category` (`version_id`, `id`, `parent_id`, `parent_version_id`, `after_category_id`, `after_category_version_id`, `media_id`, `cms_page_id`, `product_stream_id`, `display_nested_products`, `type`, `product_assignment_type`, `visible`, `active`, `created_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "\x1a\x1b\xc7\x29\xd8\x9c\x4c\x4a\x9d\x84\x3f\x31\x46\x11\x78\x9b", "\x73\x59\xec\xb7\x31\x34\x4c\xcc\x81\x49\x27\x8a\x1d\x64\x14\xfb", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, "\xb8\x23\x8d\xd7\x2f\x93\x49\x44\x9a\x11\x1a\x7c\x44\x82\x19\x62", null, 1, "page", "product", 1, 1, "2021-02-03 05:39:50.831"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`HolzFrankSW6`.`category`, CONSTRAINT `fk.category.parent_id` FOREIGN KEY (`parent_id`, `parent_version_id`) REFERENCES `category` (`id`, `version_id`) ON DELETE CASCADE ON UPDATE CASCADE)
Kategorien-Senden-Fehler: Bitte beachten Sie, dass zur Fehler-Diagnose ebenfalls die Log-Datei des Servers und das Abgleich-Log der JTL-Wawi notwendig sind!
Exception bei category.push: Controller = Category | Action = push | JTL-Wawi PK = 35 | Parent Wawi PK = 5 | Name = Spruchschilder / Rindenscheiben | [89f1e169-daf3-418a-b407-dd9952b0145c] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `category` (`version_id`, `id`, `parent_id`, `parent_version_id`, `after_category_id`, `after_category_version_id`, `media_id`, `cms_page_id`, `product_stream_id`, `display_nested_products`, `type`, `product_assignment_type`, `visible`, `active`, `created_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "\x1a\x1b\xc7\x29\xd8\x9c\x4c\x4a\x9d\x84\x3f\x31\x46\x11\x78\x9b", "\x73\x59\xec\xb7\x31\x34\x4c\xcc\x81\x49\x27\x8a\x1d\x64\x14\xfb", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, "\xb8\x23\x8d\xd7\x2f\x93\x49\x44\x9a\x11\x1a\x7c\x44\x82\x19\x62", null, 1, "page", "product", 1, 1, "2021-02-03 05:39:44.617"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`HolzFrankSW6`.`category`, CONSTRAINT `fk.category.parent_id` FOREIGN KEY (`parent_id`, `parent_version_id`) REFERENCES `category` (`id`, `version_id`) ON DELETE CASCADE ON UPDATE CASCADE)
Controller = Category | Action = push | JTL-Wawi PK = 35 | Parent Wawi PK = 5 | Name = Spruchschilder / Rindenscheiben | [f3a756d1-d9bb-4806-9116-b87736f34b64] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `category` (`version_id`, `id`, `parent_id`, `parent_version_id`, `after_category_id`, `after_category_version_id`, `media_id`, `cms_page_id`, `product_stream_id`, `display_nested_products`, `type`, `product_assignment_type`, `visible`, `active`, `created_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "\x1a\x1b\xc7\x29\xd8\x9c\x4c\x4a\x9d\x84\x3f\x31\x46\x11\x78\x9b", "\x73\x59\xec\xb7\x31\x34\x4c\xcc\x81\x49\x27\x8a\x1d\x64\x14\xfb", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, "\xb8\x23\x8d\xd7\x2f\x93\x49\x44\x9a\x11\x1a\x7c\x44\x82\x19\x62", null, 1, "page", "product", 1, 1, "2021-02-03 05:39:50.831"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`HolzFrankSW6`.`category`, CONSTRAINT `fk.category.parent_id` FOREIGN KEY (`parent_id`, `parent_version_id`) REFERENCES `category` (`id`, `version_id`) ON DELETE CASCADE ON UPDATE CASCADE)
Response: {"jtlrpc":"2.0","id":"c2776bce4f7c434398e53dd3f29de4d2","result":null,"error":{"code":400,"message":"Controller = Category | Action = push | JTL-Wawi PK = 35 | Parent Wawi PK = 5 | Name = Spruchschilder \/ Rindenscheiben | [5cca94c6-3f7d-49b9-9a73-6c6e7db79691] The Shopware 6 Admin API responded with an error: \nCode = 0 | Status = 500 | Detail = An exception occurred while executing \u0027INSERT INTO `category` (`version_id`, `id`, `parent_id`, `parent_version_id`, `after_category_id`, `after_category_version_id`, `media_id`, `cms_page_id`, `product_stream_id`, `display_nested_products`, `type`, `product_assignment_type`, `visible`, `active`, `created_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\u0027 with params [\u0022\\x0f\\xa9\\x1c\\xe3\\xe9\\x6a\\x4b\\xc2\\xbe\\x4b\\xd9\\xce\\x75\\x2c\\x34\\x25\u0022, \u0022\\x1a\\x1b\\xc7\\x29\\xd8\\x9c\\x4c\\x4a\\x9d\\x84\\x3f\\x31\\x46\\x11\\x78\\x9b\u0022, \u0022\\x73\\x59\\xec\\xb7\\x31\\x34\\x4c\\xcc\\x81\\x49\\x27\\x8a\\x1d\\x64\\x14\\xfb\u0022, \u0022\\x0f\\xa9\\x1c\\xe3\\xe9\\x6a\\x4b\\xc2\\xbe\\x4b\\xd9\\xce\\x75\\x2c\\x34\\x25\u0022, null, \u0022\\x0f\\xa9\\x1c\\xe3\\xe9\\x6a\\x4b\\xc2\\xbe\\x4b\\xd9\\xce\\x75\\x2c\\x34\\x25\u0022, null, \u0022\\xb8\\x23\\x8d\\xd7\\x2f\\x93\\x49\\x44\\x9a\\x11\\x1a\\x7c\\x44\\x82\\x19\\x62\u0022, null, 1, \u0022page\u0022, \u0022product\u0022, 1, 1, \u00222021-02-03 05:39:47.673\u0022]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`HolzFrankSW6`.`category`, CONSTRAINT `fk.category.parent_id` FOREIGN KEY (`parent_id`, `parent_version_id`) REFERENCES `category` (`id`, `version_id`) ON DELETE CASCADE ON UPDATE CASCADE)","data":"Jtl\\Shopware6\\Client\\Exception\\ClientException (Code: 400) in ...\/ClientException.php:98"}}
Exception bei category.push: Controller = Category | Action = push | JTL-Wawi PK = 35 | Parent Wawi PK = 5 | Name = Spruchschilder / Rindenscheiben | [89f1e169-daf3-418a-b407-dd9952b0145c] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `category` (`version_id`, `id`, `parent_id`, `parent_version_id`, `after_category_id`, `after_category_version_id`, `media_id`, `cms_page_id`, `product_stream_id`, `display_nested_products`, `type`, `product_assignment_type`, `visible`, `active`, `created_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "\x1a\x1b\xc7\x29\xd8\x9c\x4c\x4a\x9d\x84\x3f\x31\x46\x11\x78\x9b", "\x73\x59\xec\xb7\x31\x34\x4c\xcc\x81\x49\x27\x8a\x1d\x64\x14\xfb", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, "\xb8\x23\x8d\xd7\x2f\x93\x49\x44\x9a\x11\x1a\x7c\x44\x82\x19\x62", null, 1, "page", "product", 1, 1, "2021-02-03 05:39:44.617"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`HolzFrankSW6`.`category`, CONSTRAINT `fk.category.parent_id` FOREIGN KEY (`parent_id`, `parent_version_id`) REFERENCES `category` (`id`, `version_id`) ON DELETE CASCADE ON UPDATE CASCADE)
Controller = Category | Action = push | JTL-Wawi PK = 35 | Parent Wawi PK = 5 | Name = Spruchschilder / Rindenscheiben | [f3a756d1-d9bb-4806-9116-b87736f34b64] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `category` (`version_id`, `id`, `parent_id`, `parent_version_id`, `after_category_id`, `after_category_version_id`, `media_id`, `cms_page_id`, `product_stream_id`, `display_nested_products`, `type`,