2

Unique constraint violation found on "catalog_product_entity_tier_price".

Magento version 2.2.6:

I have migrated data Magento1 to Magento2, i but some how catalog_product_entity_tier_price for this table constraint violation issue found.

query was: INSERT INTO `catalog_product_entity_tier_price` (`entity_id`, `all_groups`, `customer_group_id`, `qty`, `value`, `percentage_value`, `website_id`) VALUES (?, ?, ?, ?, ?, ?, ?) at /var/www/html/magento2/gsp/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:580, Zend_Db_Statement_Exception(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '65-0-7-1.0000-0' for key 'UNQ_E8AB433B9ACB00343ABB312AD2FAB087', query was: INSERT INTO `catalog_product_entity_tier_price` (`entity_id`, `all_groups`, `customer_group_id`, `qty`, `value`, `percentage_value`, `website_id`) VALUES (?, ?, ?, ?, ?, ?, ?) at /var/www/html/magento2/gsp/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:235, PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '65-0-7-1.0000-0' for key 'UNQ_E8AB433B9ACB00343ABB312AD2FAB087' at /var/www/html/magento2/gsp/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:228)"} []

CASE 1: I have set Tire price in Magento2 for all different customer Group, When I insert this entry it will violate my entry

CASE 2: For delete process not work properly

File : vendor/magento/framework/EntityManager/Operation/Update.php

This exception will comes with this file

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.