Jump to content

Error add new product


Recommended Posts

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

×
×
  • Create New...