In table 'eav_attribute'.'attribute_id' = 121 and 164 are missing. Since many related tables have reference to them, I cannot import all the related data.

MySQL error #1452 - Cannot add or update a child row: a foreign key constraint fails
 (`DB`.`catalog_product_entity_int`, CONSTRAINT `FK_CAT_PRD_ENTT_INT_ATTR_ID_EAV_ATTR_ATTR_ID`
 FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`)

Could anyone just tell me what data to put into 'eav_attribute'.'attribute_id' = 121 and 164?

(It has a few more bugs, but I managed to fix them)

1 Answer 1


Sample data need to be installed prior to Magento installation. Not taking this into account might be the basic cause of all the problems you are experiencing.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.