Magento Integrity constraint violation: 1062

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

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.

Error:-

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:-

Structure

catalog_product_index_price_tmp Table Structure:-

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

MazeStricks
MazeStricks
July 19, 2018 07:06 AM

Related Questions




Error when editing products on Magento 2

Updated May 22, 2017 21:09 PM