Magento Forum

   
Integrity constraint violation: 1452 - Again! 
 
afd001
Jr. Member
 
Total Posts:  6
Joined:  2011-07-06
 

For the past couple of weeks I have been trying to get my head around how Magento is working. I have made good progress and I am now facing a re-occuring error that has cropped up on the forums before and as of yet I have not found an actual solution to.

I am using Import from excel. If I add about 200 products to the file and then import them I am seeing the error below when the Import trys to run.

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`*****`.`mg_catalog_product_option_type_value`, CONSTRAINT `FK_mg_CAT_PRD_OPT_TYPE_VAL_OPT_ID_mg_CAT_PRD_OPT_OPT_ID` FOREIGN KEY (`option_id`) REFERENCES `mg_catalog_product_option`)

Is there a known fix for this please? Its holding up my publishing of my website and I am keen to find out whats causing this.

Thanks

AFD

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top