When i tried to add products i got this error: " An error occurred while creating an object. product ", then i enabled debug mode and when i go to my store it says this error: " Key 'id_product_2' doesn't exist in table 'ps_specific_price' "
SELECT *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 21, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price` USE INDEX (id_product_2)
WHERE `id_product` IN (0, 2)
AND `id_product_attribute` IN (0, 0)
AND `id_shop` IN (0, 1)
AND `id_currency` IN (0, 1)
AND `id_country` IN (0, 21)
AND `id_group` IN (0, 1)
AND `id_customer` IN (0, 0)
AND
(
(`from` = '0000-00-00 00:00:00' OR '2015-07-27 04:30:00' >= `from`)
AND
(`to` = '0000-00-00 00:00:00' OR '2015-07-27 04:30:00' <= `to`)
)
AND id_cart IN (0, 0)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
How to fix this? I reinstalled it many times, but always the same error.
EDIT: I use Prestashop 1.6.1.0