Jump to content

Cant add products.


QuiqueHM

Recommended Posts

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

Link to comment
Share on other sites

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.

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...