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
, CONSTRAINTfk.customers_have_also_seen.target_product_id
FOREIGN KEY (target_product_id
) REFERENCESproduct
(id
) ON DELETE CASCADE ON UPDATE CASCADE)
Error in Prod Log:
Uncaught PHP Exception Doctrine\DBAL\Exception\ForeignKeyConstraintViolationException: „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
, CONSTRAINTfk.customers_have_also_seen.target_product_id
FOREIGN KEY (target_product_id
) REFERENCESproduct
(id
) ON DELETE CASCADE ON UPDATE CASCADE)“ at ExceptionConverter.php line 56 {„exception“:„[object] (Doctrine\DBAL\Exception\ForeignKeyConstraintViolationException(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
, CONSTRAINTfk.customers_have_also_seen.target_product_id
FOREIGN KEY (target_product_id
) REFERENCESproduct
(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] (Doctrine\DBAL\Driver\PDO\Exception(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
, CONSTRAINTfk.customers_have_also_seen.target_product_id
FOREIGN KEY (target_product_id
) REFERENCESproduct
(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
, CONSTRAINTfk.customers_have_also_seen.target_product_id
FOREIGN KEY (target_product_id
) REFERENCESproduct
(id
) ON DELETE CASCADE ON UPDATE CASCADE) at /var/www/vhosts/myproject.de/httpdocs/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:33)“}