我不能在后台添加产品。Prestashop 1.6.1.0抛出异常:
'on子句‘中未知列'product_attribute_shop.id_product’
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
发布于 2015-07-30 00:17:04
这也许是一个快速的解决办法,但它对我有帮助。能够访问phpmyadmin?也不愿访问数据库并找到表。
product_attribute_shop。
使用INT(10)和not null向其添加列id_product。
也不愿在做完这事后进入你的商店。错误应该转到away.Hope,这是有帮助的。
此外,我建议采取备份,并升级你的预商店版本也。
https://stackoverflow.com/questions/31683928
复制相似问题