I can't add product in PrestaShop v1.6.1.0

[Magdalena123]

Hi ,

I have problem with Prestashop . I can't add product in admin . I read in formu chanege file in config/defines.ini.php .

Next go my shop show  this message .

 

Unknown column 'product_attribute_shop.id_product' in 'on clause'

 

 

SELECT product_shop.id_product, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute

FROM

`ps_product_reductions` pr,

`ps_product` p

INNER JOIN ps_product_shop product_shop

ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)

LEFT JOIN `ps_product_attribute_shop` product_attribute_shop

   ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)

WHERE p.id_product=pr.id_product AND (pr.id_product_attribute = 0 OR product_attribute_shop.id_product_attribute = pr.id_product_attribute) AND product_shop.`active` = 1

AND EXISTS(SELECT 1 FROM `ps_category_product` cp

JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` = 1)

WHERE cp.`id_product` = p.`id_product`)

AND product_shop.`visibility` IN ("both", "catalog")

ORDER BY RAND() LIMIT 1

 

I don't know what to do . Please help me !!!!

[bellini13]

Is this a new store, or did you upgrade your store to PS v1.6.1 recently?

[Magdalena123]

I not immediately installed .

Edited July 29, 2015 by Magdalena123 (see edit history)

[bellini13]

i don't know what that means

[Magdalena123]

I don't  upgrade my store .

Edited July 29, 2015 by Magdalena123 (see edit history)