I am getting this error when i attempt to edit products in my catalog. I can add product with no issue but once they are in i can not edit them.
SQLSTATE: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`candcdb01/catalog_category_product_index`, CONSTRAINT `FK_CATALOG_CATEGORY_PRODUCT_INDEX_CATEGORY_ENTITY` FOREIGN KEY (`category_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DEL)
I am using version 1.1.8 on *nix set up
Thanks for the help in advance