Specific Prices for Customers not working

[PeterVD]

Hello,

 

 

I've been having this problem (attaching a picture with it), where Fixed Price does not work.

 

I also searched the forum for several answers, none of them worked or were developed enough to solve them, does anyone know how to fix this? Or is this a known bug in the new version?

 

 

(It used to work before (version 1.6.0.x) I upgraded to version 1.6.1.1)

[PeterVD]

ALTER TABLE `ps_specific_price` ENGINE=MyISAM;

ALTER IGNORE TABLE `ps_specific_price` ADD UNIQUE KEY `id_product_2` (`id_cart`,`id_product`,`id_shop`,`id_shop_group`,`id_currency`,`id_country`,`id_group`,`id_customer`,`id_product_attribute`,`from_quantity`,`id_specific_price_rule`,`from`,`to`);

 

Tried to use this, but it gives me an error 

 

Comando SQL:

ALTER IGNORE TABLE `ps_specific_price` ADD UNIQUE KEY `id_product_2` ( `id_cart` , `id_product` , `id_shop` , `id_shop_group` ,`id_currency` , `id_country` , `id_group` , `id_customer` , `id_product_attribute` , `from_quantity` , `id_specific_price_rule` , `from` , `to`) ;
 

Mensagens do MySQL : 

#1062 - Duplicate entry '0-4010-0-0-0-0-2-0-0-1-0-0000-00-00 00:00:00-0000-00-00 00:00:00' for key 'id_product_2'