Cant add products.

[QuiqueHM]

Hello everybody, hope you can help.

I was trying to add products on my prestashop and it has an error.

• Bad SQL query
  Unknown column 'image_shop.id_product' in 'on clause'

  My prestashop version is 1.6.1. I was searching on the web but nobody has a problem like this.

• I would be very glad if someone can help me.

Thanks!

 

Regards,

Héctor Martínez

[presta.show]

Hi,

 

You have to check in table image_shop exists a column like id_product in your database,

 

If problem doesn't fixed you can try to repair this table for example with tool phpmyadmin. 

 

[QuiqueHM]

Thanks, I fixed that problem with phpmyadmin tool.

phpmyadmin -> Your database -> SQL

Run this: 

ALTER TABLE ps_image_shop ADD `id_product` int(10) unsigned NOT NULL, ADD KEY `id_product` (`id_product`, `id_shop`, `cover`);

(Source: https://www.prestashop.com/forums/topic/451419-mauvaise-requ%C3%AAte-sql-unknown-column-image-shopid-product-in-on-clause/)

Thank you.