Integrity Constraint Violation: 1062 Duplicate entry

Asked

Viewed 923 times

-3

SQLSTATE[23000]: Integrity Constraint Violation: 1062 Duplicate entry '202-564' for key 'UNQ_CATALOG_PRODUCT_SUPER_ATTRIBUTE_PRODUCT_ID_ATTRIBUTE_ID', query was: INSERT INTO catalog_product_super_attribute (product_id, attribute_id) VALUES (?, ?)

php mysql magento
  • 2

    Welcome to the sopt. I believe your intention was to share a solution to a problem you had but you need to elaborate the question, not simply post an error code. Read [Ask] to know how to elaborate a good question.

1 answer

1

the solution was

delete ci FROM catalog_product_super_attribute as ci 
left join  catalog_product_entity as ce ON ci.product_id = ce.entity_id;

Browser other questions tagged php mysql magento

You are not signed in. Login or sign up in order to post.