0

I am unable to save product from magento2 admin Getting below error

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`catalog_product_entity`, CONSTRAINT `CAT_PRD_ENTT_ATTR_SET_ID_EAV_ATTR_SET_ATTR_SET_ID` FOREIGN KEY (`attribute_set_id`) REFERENCES `eav_attribute_set` (`attribute_set_id`) ON DELE), query was: UPDATE `catalog_product_entity` SET `attribute_set_id` = ?, `type_id` = ?, `sku` = ?, `has_options` = ?, `required_options` = ?, `created_at` = '2016-03-16 11:32:03', `updated_at` = '2016-09-15 11:48:26' WHERE (`entity_id`=21826)

Please help me to fix this issue

  • i am getting another error "Asymmetric transaction rollback." while saving the product from magento admin – Sudheer Singamsetti Sep 20 '16 at 13:05
1

I believe that I got this when I added a product to an attribute set then removed the attribute set or modified it.

Try to delete the attribute set for that product if that is an option?

  • Did trying that work? – LM_Fielding Sep 20 '16 at 12:52
  • I tried, it is working but i am getting another error " Asymmetric transaction rollback." – Sudheer Singamsetti Sep 20 '16 at 13:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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