Update error to shopware 6.5.8.5

Shopware 6 (English)
, ,
1

Hi,

We tried to update the shopware 6.5.7.3 to 6.5.8.5, but the update was not successful. We are getting the error, „Doctrine\DBAL\Exception\ForeignKeyConstraintViolationException (1452)]
An exception occurred while executing a query: SQLSTATE[23000]: Integrity c
onstraint violation: 1452 Cannot add or update a child row: a foreign key c
onstraint fails (testserver.system_config, CONSTRAINT fk.system_config.sale s_channel_id FOREIGN KEY (sales_channel_id) REFERENCES sales_channel (
id) ON DELETE CASCADE ON UPDATE CASCADE)“ , while updating. We did it via backend. Can anyone help on this.

Thanks

2

Did you fix the problem? We are facing the same issue and raised a support request in the German forum. Sadly no replies there either.

Edit: As a temporary solution we removed all entries from product_export as they violate the constraint that the db migration script is trying to create. Not sure why they are referencing an incorrect ID in the first place. After dropping the rows the db migration script went through without a problem. Have to wait for feedback from a colleague if we can re-create the product_export entries in the backend again. AFAIK they are sales channels without storefront.