Jump to content

I can't add product in PrestaShop v1.6.1.0


Recommended Posts

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 !!!!
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...