Integrity constraint violation: 1062 Duplicate entry [closed]

Navigation
-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 (?,?)

    
asked by anonymous 07.03.2016 / 13:47

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;
    
07.03.2016 / 13:49
How to recover the data of a page [closed] Delete Repeated Words from Variable