After a clean move to a new server, we thought all was well but now we get this when trying to update products in the admin. We have exhausted all resources. I see there are a TON of people with similar problems but very few answers. I understand that there is a SQL query that can be run that will show the records which aren’t matched up correctly or something but I have no idea how do to it for this error. :(
Can you help? My error is a little different that what others are seeing.
SQLSTATE: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`338528_csp/catalog_product_entity_tier_price`, CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_TIER_PRICE_GROUP` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON D)
Thanks in advance!