SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry
'5580-299-10-137-5580'
for
key
'PRIMARY'
, query was: INSERT INTO `catalog_product_index_eav_temp` (`entity_id`,`attribute_id`,`store_id`,`value`,`source_id`) VALUES (?, ?, ?, ?, ?), (?, ?, ?, ?, ?)
解决方案:
查询记录 找到 对应 value_id 清除相关记录重新生成;
查询
SELECT * FROM catalog_product_entity_varchar where attribute_id = 299 and entity_id = 5580;
删除
delete FROM catalog_product_entity_varchar where value_id = 58753;