I am getting a strange error while updating product info for my magento store.
Error is : SQLSTATE[HY000]: General error: 1452 Cannot add or update a child row: a foreign key constraint fails (`odesk_trainerprofile`.`catalog_category_product_index`, CONSTRAINT `FK_CATALOG_CATEGORY_PROD_IDX_CATEGORY_ENTITY` FOREIGN KEY (`category_id`) REFERENCES `catalog_category_entity` (`entity_id`)
I have several store view and in those stores I sevaral product some time I need to move the general product to some of the specific store. But when I tries to move the products to the another store view and change some product info especially when I change the Status of the product the it shows me the above error..
Can anyone please help me out of this scenario.. I have tried several approach to solve this issue but could not find any.
Click thumbnail to see full-size image