Magento Integrity constraint violation: 1062

by Raj   Last Updated July 19, 2018 07:09 AM - source

Currently i'm facing following error when save any product from admin side. If i'm import new product or create new product from admin after that save it from admin still facing issue. Any help should be appreciated. Thanks.


SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '186899-0-2' for key 'PRIMARY', query was: INSERT INTO `catalog_product_index_price_tmp` SELECT `catalog_product_index_price_final_tmp`.`entity_id`, `catalog_product_index_price_final_tmp`.`customer_group_id`, `catalog_product_index_price_final_tmp`.`website_id`, `catalog_product_index_price_final_tmp`.`tax_class_id`, `catalog_product_index_price_final_tmp`.`orig_price` AS `price`, `catalog_product_index_price_final_tmp`.`price` AS `final_price`, `catalog_product_index_price_final_tmp`.`min_price`, `catalog_product_index_price_final_tmp`.`max_price`, `catalog_product_index_price_final_tmp`.`tier_price`, `catalog_product_index_price_final_tmp`.`group_price` FROM `catalog_product_index_price_final_tmp`

catalog_product_index_price_final_tmp Table Structure:-


catalog_product_index_price_tmp Table Structure:-


Answers 1

This should be the exact catalog_product_index_price_final_tmp table structure. s you can see entity_id, customer_group_id, and website_id is set to Primary.

enter image description here

July 19, 2018 07:06 AM

Related Questions

Product changes not appear in frontend

Updated October 16, 2018 19:09 PM