MaxSaff Posted July 9, 2012 Share Posted July 9, 2012 Prestashop version 1.4.8. After restoring the database from a backup, I receive an error when adding a new product: Unknown column 'id_shop' in 'field list' INSERT INTO `pt_layered_product_attribute` (`id_attribute`, `id_product`, `id_attribute_group`, `id_shop`) SELECT pac.id_attribute, pa.id_product, ag.id_attribute_group, 1 FROM pt_product_attribute pa INNER JOIN pt_product_attribute_combination pac ON pac.id_product_attribute = pa.id_product_attribute INNER JOIN pt_attribute a ON (a.id_attribute = pac.id_attribute) INNER JOIN pt_attribute_group ag ON ag.id_attribute_group = a.id_attribute_group AND pa.id_product = 54 GROUP BY a.id_attribute, pa.id_product Link to comment Share on other sites More sharing options...
shacker Posted July 12, 2012 Share Posted July 12, 2012 Install the module layered navigation ad try again Link to comment Share on other sites More sharing options...
Recommended Posts