Issue:

We have used module version 1.1.0 on M2.3.4 CE. When testing on the backend, we cannot save the  catalog rule and got this error:

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`stgdb`.`catalogrule_website`, CONSTRAINT `CATALOGRULE_WEBSITE_ROW_ID_CATALOGRULE_ROW_ID` FOREIGN KEY (`row_id`) REFERENCES `catalogrule` (`row_id`) ON DELETE CASCADE), query was: INSERT  INTO `catalogrule_website` (`website_id`,`row_id`) VALUES (?, ?) ON DUPLICATE KEY UPDATE `row_id` = VALUES(`row_id`)

Please check and give us the solution.


Solution: 

First, we would like to confirm that when your Magento version is M2.3.4, please use our module version 1.0.9 since this version works well on M2.3.4 at this time.

In case you still want to use version 1.1.0 on M2.3.4, we would like to give the hot-fix solution as below.

+ Add this file 

app/code/Bss/CatalogRulePerStoreView/view/adminhtml/ui_component/catalogrulestaging_update_form.xml

+ Apply the new code on the site and flush the cache.


If you need any further assistance, please feel free to contact us.

We're more than happy to support you.