Beim Shopabgleich bekommen wir folgenden Fehler.
Fehler:
Exception: Controller = Product | Action = push | JTL-Wawi PK = 7506 | SKU = WZG10 | Name = Weizenglas | [b3acbad1-7225-44ab-8b86-9cf343949003] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `product` (`version_id`, `id`, `parent_id`, `parent_version_id`, `product_manufacturer_id`, `product_manufacturer_version_id`, `unit_id`, `tax_id`, `product_media_id`, `product_media_version_id`, `delivery_time_id`, `main_variant_id`, `product_feature_set_id`, `swag_customized_products_template_version_id`, `price`, `product_number`, `stock`, `restock_time`, `active`, `is_closeout`, `configurator_group_config`, `variant_restrictions`, `manufacturer_number`, `ean`, `purchase_steps`, `max_purchase`, `min_purchase`, `purchase_unit`, `reference_unit`, `shipping_free`, `purchase_price`, `mark_as_topseller`, `weight`, `width`, `height`, `length`, `release_date`, `custom_field_set_selection_active`, `purchase_prices`, `created_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "\x36\xa0\xff\x63\x3c\xab\x41\x8e\x82\x43\x2e\x49\x18\xe1\xeb\xf7", null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "\x31\xc1\x0a\x52\xfd\x2e\x41\x9b\x87\xf1\x05\x86\xc7\x38\xa1\xf3", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, "\x7a\x1c\x00\x45\xa9\x2e\x42\x0c\xaf\xfa\x51\x8b\x49\x39\xa7\x38", null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, null, null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":9.20168067226891,\"gross\":10.950000000000003,\"linked\":true,\"listPrice\":null}}", "WZG10", 526, 0, 1, 1, "[]", "[]", null, null, 1, null, 1, null, null, 0, null, 0, 0, 0, 0, 0, "2015-10-20 14:04:40.000", null, "[]", "2021-05-23 09:15:42.141"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`usrdb_urbrvara`.`product`, CONSTRAINT `fk.product.product_manufacturer_id` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, )
Controller = Product | Action = push | JTL-Wawi PK = 7506 | SKU = WZG10 | Name = Weizenglas | [67e65767-4e60-43ae-85f2-d86064100178] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `product` (`version_id`, `id`, `parent_id`, `parent_version_id`, `product_manufacturer_id`, `product_manufacturer_version_id`, `unit_id`, `tax_id`, `product_media_id`, `product_media_version_id`, `delivery_time_id`, `main_variant_id`, `product_feature_set_id`, `swag_customized_products_template_version_id`, `price`, `product_number`, `stock`, `restock_time`, `active`, `is_closeout`, `configurator_group_config`, `variant_restrictions`, `manufacturer_number`, `ean`, `purchase_steps`, `max_purchase`, `min_purchase`, `purchase_unit`, `reference_unit`, `shipping_free`, `purchase_price`, `mark_as_topseller`, `weight`, `width`, `height`, `length`, `release_date`, `custom_field_set_selection_active`, `purchase_prices`, `created_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "\x70\x77\x90\x3c\x93\x96\x41\x21\xb4\x66\x2f\x43\x9c\x80\x69\x98", null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "\x31\xc1\x0a\x52\xfd\x2e\x41\x9b\x87\xf1\x05\x86\xc7\x38\xa1\xf3", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, "\x7a\x1c\x00\x45\xa9\x2e\x42\x0c\xaf\xfa\x51\x8b\x49\x39\xa7\x38", null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, null, null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":9.20168067226891,\"gross\":10.950000000000003,\"linked\":true,\"listPrice\":null}}", "WZG10", 526, 0, 1, 1, "[]", "[]", null, null, 1, null, 1, null, null, 0, null, 0, 0, 0, 0, 0, "2015-10-20 14:04:40.000", null, "[]", "2021-05-23 09:15:53.925"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`usrdb_urbrvara`.`product`, CONSTRAINT `fk.product.product_manufacturer_id` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, )
Artikel-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 product.push: Controller = Product | Action = push | JTL-Wawi PK = 7506 | SKU = WZG10 | Name = Weizenglas | [b3acbad1-7225-44ab-8b86-9cf343949003] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `product` (`version_id`, `id`, `parent_id`, `parent_version_id`, `product_manufacturer_id`, `product_manufacturer_version_id`, `unit_id`, `tax_id`, `product_media_id`, `product_media_version_id`, `delivery_time_id`, `main_variant_id`, `product_feature_set_id`, `swag_customized_products_template_version_id`, `price`, `product_number`, `stock`, `restock_time`, `active`, `is_closeout`, `configurator_group_config`, `variant_restrictions`, `manufacturer_number`, `ean`, `purchase_steps`, `max_purchase`, `min_purchase`, `purchase_unit`, `reference_unit`, `shipping_free`, `purchase_price`, `mark_as_topseller`, `weight`, `width`, `height`, `length`, `release_date`, `custom_field_set_selection_active`, `purchase_prices`, `created_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "\x36\xa0\xff\x63\x3c\xab\x41\x8e\x82\x43\x2e\x49\x18\xe1\xeb\xf7", null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "\x31\xc1\x0a\x52\xfd\x2e\x41\x9b\x87\xf1\x05\x86\xc7\x38\xa1\xf3", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, "\x7a\x1c\x00\x45\xa9\x2e\x42\x0c\xaf\xfa\x51\x8b\x49\x39\xa7\x38", null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, null, null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":9.20168067226891,\"gross\":10.950000000000003,\"linked\":true,\"listPrice\":null}}", "WZG10", 526, 0, 1, 1, "[]", "[]", null, null, 1, null, 1, null, null, 0, null, 0, 0, 0, 0, 0, "2015-10-20 14:04:40.000", null, "[]", "2021-05-23 09:15:42.141"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`usrdb_urbrvara`.`product`, CONSTRAINT `fk.product.product_manufacturer_id` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, )
Controller = Product | Action = push | JTL-Wawi PK = 7506 | SKU = WZG10 | Name = Weizenglas | [67e65767-4e60-43ae-85f2-d86064100178] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `product` (`version_id`, `id`, `parent_id`, `parent_version_id`, `product_manufacturer_id`, `product_manufacturer_version_id`, `unit_id`, `tax_id`, `product_media_id`, `product_media_version_id`, `delivery_time_id`, `main_variant_id`, `product_feature_set_id`, `swag_customized_products_template_version_id`, `price`, `product_number`, `stock`, `restock_time`, `active`, `is_closeout`, `configurator_group_config`, `variant_restrictions`, `manufacturer_number`, `ean`, `purchase_steps`, `max_purchase`, `min_purchase`, `purchase_unit`, `reference_unit`, `shipping_free`, `purchase_price`, `mark_as_topseller`, `weight`, `width`, `height`, `length`, `release_date`, `custom_field_set_selection_active`, `purchase_prices`, `created_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "\x70\x77\x90\x3c\x93\x96\x41\x21\xb4\x66\x2f\x43\x9c\x80\x69\x98", null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "\x31\xc1\x0a\x52\xfd\x2e\x41\x9b\x87\xf1\x05\x86\xc7\x38\xa1\xf3", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, "\x7a\x1c\x00\x45\xa9\x2e\x42\x0c\xaf\xfa\x51\x8b\x49\x39\xa7\x38", null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, null, null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":9.20168067226891,\"gross\":10.950000000000003,\"linked\":true,\"listPrice\":null}}", "WZG10", 526, 0, 1, 1, "[]", "[]", null, null, 1, null, 1, null, null, 0, null, 0, 0, 0, 0, 0, "2015-10-20 14:04:40.000", null, "[]", "2021-05-23 09:15:53.925"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key const
Wir haben alle möglichen Varianten ausprobiert. Nichts hilft.
Fehler:
Exception: Controller = Product | Action = push | JTL-Wawi PK = 7506 | SKU = WZG10 | Name = Weizenglas | [b3acbad1-7225-44ab-8b86-9cf343949003] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `product` (`version_id`, `id`, `parent_id`, `parent_version_id`, `product_manufacturer_id`, `product_manufacturer_version_id`, `unit_id`, `tax_id`, `product_media_id`, `product_media_version_id`, `delivery_time_id`, `main_variant_id`, `product_feature_set_id`, `swag_customized_products_template_version_id`, `price`, `product_number`, `stock`, `restock_time`, `active`, `is_closeout`, `configurator_group_config`, `variant_restrictions`, `manufacturer_number`, `ean`, `purchase_steps`, `max_purchase`, `min_purchase`, `purchase_unit`, `reference_unit`, `shipping_free`, `purchase_price`, `mark_as_topseller`, `weight`, `width`, `height`, `length`, `release_date`, `custom_field_set_selection_active`, `purchase_prices`, `created_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "\x36\xa0\xff\x63\x3c\xab\x41\x8e\x82\x43\x2e\x49\x18\xe1\xeb\xf7", null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "\x31\xc1\x0a\x52\xfd\x2e\x41\x9b\x87\xf1\x05\x86\xc7\x38\xa1\xf3", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, "\x7a\x1c\x00\x45\xa9\x2e\x42\x0c\xaf\xfa\x51\x8b\x49\x39\xa7\x38", null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, null, null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":9.20168067226891,\"gross\":10.950000000000003,\"linked\":true,\"listPrice\":null}}", "WZG10", 526, 0, 1, 1, "[]", "[]", null, null, 1, null, 1, null, null, 0, null, 0, 0, 0, 0, 0, "2015-10-20 14:04:40.000", null, "[]", "2021-05-23 09:15:42.141"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`usrdb_urbrvara`.`product`, CONSTRAINT `fk.product.product_manufacturer_id` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, )
Controller = Product | Action = push | JTL-Wawi PK = 7506 | SKU = WZG10 | Name = Weizenglas | [67e65767-4e60-43ae-85f2-d86064100178] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `product` (`version_id`, `id`, `parent_id`, `parent_version_id`, `product_manufacturer_id`, `product_manufacturer_version_id`, `unit_id`, `tax_id`, `product_media_id`, `product_media_version_id`, `delivery_time_id`, `main_variant_id`, `product_feature_set_id`, `swag_customized_products_template_version_id`, `price`, `product_number`, `stock`, `restock_time`, `active`, `is_closeout`, `configurator_group_config`, `variant_restrictions`, `manufacturer_number`, `ean`, `purchase_steps`, `max_purchase`, `min_purchase`, `purchase_unit`, `reference_unit`, `shipping_free`, `purchase_price`, `mark_as_topseller`, `weight`, `width`, `height`, `length`, `release_date`, `custom_field_set_selection_active`, `purchase_prices`, `created_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "\x70\x77\x90\x3c\x93\x96\x41\x21\xb4\x66\x2f\x43\x9c\x80\x69\x98", null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "\x31\xc1\x0a\x52\xfd\x2e\x41\x9b\x87\xf1\x05\x86\xc7\x38\xa1\xf3", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, "\x7a\x1c\x00\x45\xa9\x2e\x42\x0c\xaf\xfa\x51\x8b\x49\x39\xa7\x38", null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, null, null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":9.20168067226891,\"gross\":10.950000000000003,\"linked\":true,\"listPrice\":null}}", "WZG10", 526, 0, 1, 1, "[]", "[]", null, null, 1, null, 1, null, null, 0, null, 0, 0, 0, 0, 0, "2015-10-20 14:04:40.000", null, "[]", "2021-05-23 09:15:53.925"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`usrdb_urbrvara`.`product`, CONSTRAINT `fk.product.product_manufacturer_id` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, )
Artikel-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 product.push: Controller = Product | Action = push | JTL-Wawi PK = 7506 | SKU = WZG10 | Name = Weizenglas | [b3acbad1-7225-44ab-8b86-9cf343949003] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `product` (`version_id`, `id`, `parent_id`, `parent_version_id`, `product_manufacturer_id`, `product_manufacturer_version_id`, `unit_id`, `tax_id`, `product_media_id`, `product_media_version_id`, `delivery_time_id`, `main_variant_id`, `product_feature_set_id`, `swag_customized_products_template_version_id`, `price`, `product_number`, `stock`, `restock_time`, `active`, `is_closeout`, `configurator_group_config`, `variant_restrictions`, `manufacturer_number`, `ean`, `purchase_steps`, `max_purchase`, `min_purchase`, `purchase_unit`, `reference_unit`, `shipping_free`, `purchase_price`, `mark_as_topseller`, `weight`, `width`, `height`, `length`, `release_date`, `custom_field_set_selection_active`, `purchase_prices`, `created_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "\x36\xa0\xff\x63\x3c\xab\x41\x8e\x82\x43\x2e\x49\x18\xe1\xeb\xf7", null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "\x31\xc1\x0a\x52\xfd\x2e\x41\x9b\x87\xf1\x05\x86\xc7\x38\xa1\xf3", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, "\x7a\x1c\x00\x45\xa9\x2e\x42\x0c\xaf\xfa\x51\x8b\x49\x39\xa7\x38", null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, null, null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":9.20168067226891,\"gross\":10.950000000000003,\"linked\":true,\"listPrice\":null}}", "WZG10", 526, 0, 1, 1, "[]", "[]", null, null, 1, null, 1, null, null, 0, null, 0, 0, 0, 0, 0, "2015-10-20 14:04:40.000", null, "[]", "2021-05-23 09:15:42.141"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`usrdb_urbrvara`.`product`, CONSTRAINT `fk.product.product_manufacturer_id` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, )
Controller = Product | Action = push | JTL-Wawi PK = 7506 | SKU = WZG10 | Name = Weizenglas | [67e65767-4e60-43ae-85f2-d86064100178] The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `product` (`version_id`, `id`, `parent_id`, `parent_version_id`, `product_manufacturer_id`, `product_manufacturer_version_id`, `unit_id`, `tax_id`, `product_media_id`, `product_media_version_id`, `delivery_time_id`, `main_variant_id`, `product_feature_set_id`, `swag_customized_products_template_version_id`, `price`, `product_number`, `stock`, `restock_time`, `active`, `is_closeout`, `configurator_group_config`, `variant_restrictions`, `manufacturer_number`, `ean`, `purchase_steps`, `max_purchase`, `min_purchase`, `purchase_unit`, `reference_unit`, `shipping_free`, `purchase_price`, `mark_as_topseller`, `weight`, `width`, `height`, `length`, `release_date`, `custom_field_set_selection_active`, `purchase_prices`, `created_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "\x70\x77\x90\x3c\x93\x96\x41\x21\xb4\x66\x2f\x43\x9c\x80\x69\x98", null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "\x31\xc1\x0a\x52\xfd\x2e\x41\x9b\x87\xf1\x05\x86\xc7\x38\xa1\xf3", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, "\x7a\x1c\x00\x45\xa9\x2e\x42\x0c\xaf\xfa\x51\x8b\x49\x39\xa7\x38", null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", null, null, null, "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "{\"cb7d2554b0ce847cd82f3ac9bd1c0dfca\":{\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"net\":9.20168067226891,\"gross\":10.950000000000003,\"linked\":true,\"listPrice\":null}}", "WZG10", 526, 0, 1, 1, "[]", "[]", null, null, 1, null, 1, null, null, 0, null, 0, 0, 0, 0, 0, "2015-10-20 14:04:40.000", null, "[]", "2021-05-23 09:15:53.925"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key const
Wir haben alle möglichen Varianten ausprobiert. Nichts hilft.