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

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`XXX`.`catalog_product_bundle_
Jr. Member
Total Posts:  5
Joined:  2011-04-21


I get the following issue when i want to create a bundle product and add simple product to my bundle product… i can add more ore less 100 products and then i get this issue..

SQLSTATE[23000]Integrity constraint violation1452 Cannot add or update a child rowa foreign key constraint fails (`XXX`.`catalog_product_bundle_selection`, CONSTRAINT `FK_CAT_PRD_BNDL_SELECTION_PRD_ID_CAT_PRD_ENTT_ENTT_IDFOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_i)

does anyone has a solution for this problem?

i found a “fix” that says i have to set my DB engine to innodb.. i’ve done this, but i get the same issue over and over again.. i get crazy..

magento 1.6


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