Search the Community

Hi, When I try to copy (duplicate) a product which has an assigned specific price (does not mater if it is on catalogue rules or specific prices on product prices tab) and added attrubutes combinations it generates error: Duplicate entry '23-0-0-0-2015-10-01 00:00:00-2016-04-09 00:00:00-1-0-0-0-3-1-1' for key 'id_product_2' INSERT INTO `ps1614_specific_price` (`id_shop_group`, `id_shop`, `id_cart`, `id_product`, `id_product_attribute`, `id_currency`, `id_specific_price_rule`, `id_country`, `id_group`, `id_customer`, `price`, `from_quantity`, `reduction`, `reduction_tax`, `reduction_type`, `from`, `to`) VALUES ('0', '1', '0', '23', '0', '0', '1', '0', '3', '0', '-1', '1', '0.1', '1', 'percentage', '2015-10-01 00:00:00', '2016-04-09 00:00:00') It also does not copy product photos. I tested it on two different hostings two versions of PrestaShop: running PrestaShop 1.6.1.3 and a fresh install 1.6.1.4 and results were the same - it looks like it is a 1.6.1 version bug, because it did not happen before. How to reproduce this error: 1. Add a new catalog rule with % discount (or create specific price with % discount on product prices tab - same result) 2. Add a product combinations in product's tab 3. Add a specific price in products's tab 4. Clone product Thank you for help. Regards.

Hi guys, I’m trying to install the theme ‘Show Me The Dvd 1.6’ onto my newly updated prestashop shop and had some issues due to the version on php my server was using. That dealt with, now when I try to ‘use this theme’ in backoffice, I get an error thrown up: Duplicate entry '69-0-1' for key 'PRIMARY' INSERT INTO `ps_hook_module` (`id_module`, `id_shop`, `id_hook`, `position`) VALUES (69, 1, 0, 1) I am not familiar with sql but I get the impression that this indicates that there is another installed module from my previous theme using the position that one of the modules that wants to be installed for this new theme is currently occupying? Is this the case? If so, I have no idea how to find out which module this is and therefore move it or disable it. I also have no idea how to work around this in sql either – like I said, I know nothing about it! If anyone can help, I’d be delighted, elsewise I can feel we’re going to end up deleting the whole store and starting from scratch in order to update and change theme. Thanks so much in advance! Kat Edit: Unable to solve this issue, I tried with a fresh install of prestashop and these issues were gone, however replaced by new ones! However, it would seem that in this error, there were some conflicts but I was never able to pin down what they were. Sorry!

Ik heb 2 dagen geleden een nieuwe installatie van prestashop gedaan en wil nu mijn shop inrichten. Ik heb elke keer als ik een product wil toevoegen, of een attribute een foutmelding. 1 x in het leuk, maar als je het elke keer krijgt wordt het vervelend. Nadat ik op wijzigen klik dan pakt hij het wel en wordt het goed opgeslagen. De eerste keer krijg ik deze melding: Duplicate entry '4-1' for key 'PRIMARY' INSERT INTO `ps_product_attribute_shop` (`id_product_attribute`, `wholesale_price`, `price`, `ecotax`, `weight`, `unit_price_impact`, `minimal_quantity`, `default_on`, `available_date`, `id_shop`) VALUES ('4', '0', '3', '0', '0', '0', '1', '1', '0000-00-00', '1') Ik heb er ook nog een bijlage bij gedaan. Is iemand bekend met deze foutmelding? Kan iemand mij helpen dit op te lossen?