The plugin Customers have also seen can not be installed in Shopware v6.6.3.1
Error:
Internal Server Error
An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (sw6_mydb.#sql-1_61689, CONSTRAINT fk.customers_have_also_seen.target_product_id FOREIGN KEY (target_product_id) REFERENCES product (id) ON DELETE CASCADE ON UPDATE CASCADE)
Error in Prod Log:
Uncaught PHP Exception DoctrineDBALExceptionForeignKeyConstraintViolationException: „An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (sw6_mydb.#sql-1_61852, CONSTRAINT fk.customers_have_also_seen.target_product_id FOREIGN KEY (target_product_id) REFERENCES product (id) ON DELETE CASCADE ON UPDATE CASCADE)“ at ExceptionConverter.php line 56 {„exception“:„[object] (DoctrineDBALExceptionForeignKeyConstraintViolationException(code: 1452): An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (sw6_mydb.#sql-1_61852, CONSTRAINT fk.customers_have_also_seen.target_product_id FOREIGN KEY (target_product_id) REFERENCES product (id) ON DELETE CASCADE ON UPDATE CASCADE) at /var/www/vhosts/myproject.de/httpdocs/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:56)n[previous exception] [object] (DoctrineDBALDriverPDOException(code: 1452): SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (sw6_mydb.#sql-1_61852, CONSTRAINT fk.customers_have_also_seen.target_product_id FOREIGN KEY (target_product_id) REFERENCES product (id) ON DELETE CASCADE ON UPDATE CASCADE) at /var/www/vhosts/myproject.de/httpdocs/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)n[previous exception] [object] (PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (sw6_mydb.#sql-1_61852, CONSTRAINT fk.customers_have_also_seen.target_product_id FOREIGN KEY (target_product_id) REFERENCES product (id) ON DELETE CASCADE ON UPDATE CASCADE) at /var/www/vhosts/myproject.de/httpdocs/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:33)“}
2 Beiträge – 2 Teilnehmer