Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email

Magento Forum

Integrity constraint violation: 1452 - Again! 
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.



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