Ich bekommen beim Abgleich folgenden Fehler.
Da ich leider kein IT Profi bin, bin ich über jede Hilfe dankbar.
IST EINE GANZ NEUE INSTALLATION - und das passiert beim ersten Abgleich!
Fehler:
Exception: Controller = Category | Action = delete | JTL-Wawi PK = 444 | The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'DELETE FROM `category` WHERE id = ? AND version_id = ?' with params ["\xeb\x14\xf2\xcf\xf0\x03\x4f\x2a\x86\xc5\x10\xbe\x8e\xc9\x9c\x2b", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25"]:
SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`k001249_45_shopgsshop`.`sales_channel`, CONSTRAINT `fk.sales_channel.navigation_category_id` FOREIGN KEY (`navigation_category_id`, `navigation_category_version_id`) REFERENCES `category` (`i)
Controller = Category | Action = delete | JTL-Wawi PK = 444 | The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'DELETE FROM `category` WHERE id = ? AND version_id = ?' with params ["\xeb\x14\xf2\xcf\xf0\x03\x4f\x2a\x86\xc5\x10\xbe\x8e\xc9\x9c\x2b", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25"]:
SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`k001249_45_shopgsshop`.`sales_channel`, CONSTRAINT `fk.sales_channel.navigation_category_id` FOREIGN KEY (`navigation_category_id`, `navigation_category_version_id`) REFERENCES `category` (`i)
Kategorien-Löschen-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.delete: Controller = Category | Action = delete | JTL-Wawi PK = 444 | The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'DELETE FROM `category` WHERE id = ? AND version_id = ?' with params ["\xeb\x14\xf2\xcf\xf0\x03\x4f\x2a\x86\xc5\x10\xbe\x8e\xc9\x9c\x2b", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25"]:
SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`k001249_45_shopgsshop`.`sales_channel`, CONSTRAINT `fk.sales_channel.navigation_category_id` FOREIGN KEY (`navigation_category_id`, `navigation_category_version_id`) REFERENCES `category` (`i)
Controller = Category | Action = delete | JTL-Wawi PK = 444 | The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'DELETE FROM `category` WHERE id = ? AND version_id = ?' with params ["\xeb\x14\xf2\xcf\xf0\x03\x4f\x2a\x86\xc5\x10\xbe\x8e\xc9\x9c\x2b", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25"]:
SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`k001249_45_shopgsshop`.`sales_channel`, CONSTRAINT `fk.sales_channel.navigation_category_id` FOREIGN KEY (`navigation_category_id`, `navigation_category_version_id`) REFERENCES `category` (`i)
Response: {"jtlrpc":"2.0","id":"595da6599ff348dcad56e6adec2a3f5a","result":null,"error":{"code":500,"message":"Controller = Category | Action = delete | JTL-Wawi PK = 444 | The Shopware 6 Admin API responded with an error: \nCode = 0 | Status = 500 | Detail = An exception occurred while executing \u0027DELETE FROM `category` WHERE id = ? AND version_id = ?\u0027 with params [\u0022\\xeb\\x14\\xf2\\xcf\\xf0\\x03\\x4f\\x2a\\x86\\xc5\\x10\\xbe\\x8e\\xc9\\x9c\\x2b\u0022, \u0022\\x0f\\xa9\\x1c\\xe3\\xe9\\x6a\\x4b\\xc2\\xbe\\x4b\\xd9\\xce\\x75\\x2c\\x34\\x25\u0022]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`k001249_45_shopgsshop`.`sales_channel`, CONSTRAINT `fk.sales_channel.navigation_category_id` FOREIGN KEY (`navigation_category_id`, `navigation_category_version_id`) REFERENCES `category` (`i)","data":"Jtl\\Shopware6\\Client\\Exception\\ClientException (Code: 500) in ...\/ClientException.php:65"}}
Exception bei category.delete: Controller = Category | Action = delete | JTL-Wawi PK = 444 | The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'DELETE FROM `category` WHERE id = ? AND version_id = ?' with params ["\xeb\x14\xf2\xcf\xf0\x03\x4f\x2a\x86\xc5\x10\xbe\x8e\xc9\x9c\x2b", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25"]:
SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`k001249_45_shopgsshop`.`sales_channel`, CONSTRAINT `fk.sales_channel.navigation_category_id` FOREIGN KEY (`navigation_category_id`, `navigation_category_version_id`) REFERENCES `category` (`i)
Controller = Category | Action = delete | JTL-Wawi PK = 444 | The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'DELETE FROM `category` WHERE id = ? AND version_id = ?' with params ["\xeb\x14\xf2\xcf\xf0\x03\x4f\x2a\x86\xc5\x10\xbe\x8e\xc9\x9c\x2b", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25"]:
SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`k001249_45_shopgsshop`.`sales_channel`, CONSTRAINT `fk.sales_channel.navigation_category_id` FOREIGN KEY (`navigation_category_id`, `navigation_category_version_id`) REFERENCES `category` (`i)
Response: {"jtlrpc":"2.0","id":"598fc98e2d7b4b0682e6e84b94614d8a","result":null,"error":{"code":500,"message":"Controller = Category | Action = delete | JTL-Wawi PK = 444 | The Shopware 6 Admin API responded with an error: \nCode = 0 | Status = 500 | Detail = An exception occurred while executing \u0027DELETE FROM `category` WHERE id = ? AND version_id = ?\u0027 with params [\u0022\\xeb\\x14\\xf2\\xcf\\xf0\\x03\\x4f\\x2a\\x86\\xc5\\x10\\xbe\\x8e\\xc9\\x9c\\x2b\u0022, \u0022\\x0f\\xa9\\x1c\\xe3\\xe9\\x6a\\x4b\\xc2\\xbe\\x4b\\xd9\\xce\\x75\\x2c\\x34\\x25\u0022]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`k001249_45_shopgsshop`.`sales_channel`, CONSTRAINT `fk.sales_channel.navigation_category_id` FOREIGN KEY (`navigation_category_id`, `navigation_category_version_id`) REFERENCES `category` (`i)","data":"Jtl\\Shopware6\\Client\\Exception\\ClientException (Code: 500) in ...\/ClientException.php:65"}}
bei jtlCore.ControllerClasses. Connector.Abgleich.Connector.WppJK9RuYow(String , Object , Boolean , NetworkCredential )
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.mLQJKJx2eu0(String , Object , Boolean , NetworkCredential )
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.WppJK9RuYow(String , Object , Boolean , NetworkCredential )
Warnungen:
Abgleich abgebrochen.Abgleich abgebrochen.Abgleich abgebrochen.Abgleich abgebrochen.Abgleich abgebrochen.Abgleich abgebrochen.Abgleich abgebrochen.Abgleich abgebrochen.Abgleich abgebrochen.
Da ich leider kein IT Profi bin, bin ich über jede Hilfe dankbar.
IST EINE GANZ NEUE INSTALLATION - und das passiert beim ersten Abgleich!
Fehler:
Exception: Controller = Category | Action = delete | JTL-Wawi PK = 444 | The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'DELETE FROM `category` WHERE id = ? AND version_id = ?' with params ["\xeb\x14\xf2\xcf\xf0\x03\x4f\x2a\x86\xc5\x10\xbe\x8e\xc9\x9c\x2b", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25"]:
SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`k001249_45_shopgsshop`.`sales_channel`, CONSTRAINT `fk.sales_channel.navigation_category_id` FOREIGN KEY (`navigation_category_id`, `navigation_category_version_id`) REFERENCES `category` (`i)
Controller = Category | Action = delete | JTL-Wawi PK = 444 | The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'DELETE FROM `category` WHERE id = ? AND version_id = ?' with params ["\xeb\x14\xf2\xcf\xf0\x03\x4f\x2a\x86\xc5\x10\xbe\x8e\xc9\x9c\x2b", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25"]:
SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`k001249_45_shopgsshop`.`sales_channel`, CONSTRAINT `fk.sales_channel.navigation_category_id` FOREIGN KEY (`navigation_category_id`, `navigation_category_version_id`) REFERENCES `category` (`i)
Kategorien-Löschen-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.delete: Controller = Category | Action = delete | JTL-Wawi PK = 444 | The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'DELETE FROM `category` WHERE id = ? AND version_id = ?' with params ["\xeb\x14\xf2\xcf\xf0\x03\x4f\x2a\x86\xc5\x10\xbe\x8e\xc9\x9c\x2b", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25"]:
SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`k001249_45_shopgsshop`.`sales_channel`, CONSTRAINT `fk.sales_channel.navigation_category_id` FOREIGN KEY (`navigation_category_id`, `navigation_category_version_id`) REFERENCES `category` (`i)
Controller = Category | Action = delete | JTL-Wawi PK = 444 | The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'DELETE FROM `category` WHERE id = ? AND version_id = ?' with params ["\xeb\x14\xf2\xcf\xf0\x03\x4f\x2a\x86\xc5\x10\xbe\x8e\xc9\x9c\x2b", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25"]:
SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`k001249_45_shopgsshop`.`sales_channel`, CONSTRAINT `fk.sales_channel.navigation_category_id` FOREIGN KEY (`navigation_category_id`, `navigation_category_version_id`) REFERENCES `category` (`i)
Response: {"jtlrpc":"2.0","id":"595da6599ff348dcad56e6adec2a3f5a","result":null,"error":{"code":500,"message":"Controller = Category | Action = delete | JTL-Wawi PK = 444 | The Shopware 6 Admin API responded with an error: \nCode = 0 | Status = 500 | Detail = An exception occurred while executing \u0027DELETE FROM `category` WHERE id = ? AND version_id = ?\u0027 with params [\u0022\\xeb\\x14\\xf2\\xcf\\xf0\\x03\\x4f\\x2a\\x86\\xc5\\x10\\xbe\\x8e\\xc9\\x9c\\x2b\u0022, \u0022\\x0f\\xa9\\x1c\\xe3\\xe9\\x6a\\x4b\\xc2\\xbe\\x4b\\xd9\\xce\\x75\\x2c\\x34\\x25\u0022]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`k001249_45_shopgsshop`.`sales_channel`, CONSTRAINT `fk.sales_channel.navigation_category_id` FOREIGN KEY (`navigation_category_id`, `navigation_category_version_id`) REFERENCES `category` (`i)","data":"Jtl\\Shopware6\\Client\\Exception\\ClientException (Code: 500) in ...\/ClientException.php:65"}}
Exception bei category.delete: Controller = Category | Action = delete | JTL-Wawi PK = 444 | The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'DELETE FROM `category` WHERE id = ? AND version_id = ?' with params ["\xeb\x14\xf2\xcf\xf0\x03\x4f\x2a\x86\xc5\x10\xbe\x8e\xc9\x9c\x2b", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25"]:
SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`k001249_45_shopgsshop`.`sales_channel`, CONSTRAINT `fk.sales_channel.navigation_category_id` FOREIGN KEY (`navigation_category_id`, `navigation_category_version_id`) REFERENCES `category` (`i)
Controller = Category | Action = delete | JTL-Wawi PK = 444 | The Shopware 6 Admin API responded with an error:
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'DELETE FROM `category` WHERE id = ? AND version_id = ?' with params ["\xeb\x14\xf2\xcf\xf0\x03\x4f\x2a\x86\xc5\x10\xbe\x8e\xc9\x9c\x2b", "\x0f\xa9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25"]:
SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`k001249_45_shopgsshop`.`sales_channel`, CONSTRAINT `fk.sales_channel.navigation_category_id` FOREIGN KEY (`navigation_category_id`, `navigation_category_version_id`) REFERENCES `category` (`i)
Response: {"jtlrpc":"2.0","id":"598fc98e2d7b4b0682e6e84b94614d8a","result":null,"error":{"code":500,"message":"Controller = Category | Action = delete | JTL-Wawi PK = 444 | The Shopware 6 Admin API responded with an error: \nCode = 0 | Status = 500 | Detail = An exception occurred while executing \u0027DELETE FROM `category` WHERE id = ? AND version_id = ?\u0027 with params [\u0022\\xeb\\x14\\xf2\\xcf\\xf0\\x03\\x4f\\x2a\\x86\\xc5\\x10\\xbe\\x8e\\xc9\\x9c\\x2b\u0022, \u0022\\x0f\\xa9\\x1c\\xe3\\xe9\\x6a\\x4b\\xc2\\xbe\\x4b\\xd9\\xce\\x75\\x2c\\x34\\x25\u0022]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`k001249_45_shopgsshop`.`sales_channel`, CONSTRAINT `fk.sales_channel.navigation_category_id` FOREIGN KEY (`navigation_category_id`, `navigation_category_version_id`) REFERENCES `category` (`i)","data":"Jtl\\Shopware6\\Client\\Exception\\ClientException (Code: 500) in ...\/ClientException.php:65"}}
bei jtlCore.ControllerClasses. Connector.Abgleich.Connector.WppJK9RuYow(String , Object , Boolean , NetworkCredential )
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.mLQJKJx2eu0(String , Object , Boolean , NetworkCredential )
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.WppJK9RuYow(String , Object , Boolean , NetworkCredential )
Warnungen:
Abgleich abgebrochen.Abgleich abgebrochen.Abgleich abgebrochen.Abgleich abgebrochen.Abgleich abgebrochen.Abgleich abgebrochen.Abgleich abgebrochen.Abgleich abgebrochen.Abgleich abgebrochen.