I recently upgraded a clients website from 18.104.22.168 to 22.214.171.124 and I have noticed I am getting the following error message when trying to save a product. I am stumped as to how I would fix this. My Upgrade process included a fresh install of Magento which updated the old DB.
SQLSTATE: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (
FK_CATRULE_GROUP_WS_RULE_ID_CATRULE_RULE_IDFOREIGN KEY (
rule_id) ON DELETE CASCADE ON UPDATE CA)
I hope you guys can help.