[PrestaShop 1.6.1.1] Bad SQL query

[WeepingAngel]

Hello, I'm currently having a major issue with my online store. I can't seem to acces any products I have because of this error.

 

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

 

I've been trying to find a solution and found this thread:

 

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

 

Which links to this solution:

 

http://www.templatemonster.com/help/prestashop-1-6-x-how-to-fix-an-error-occurred-while-updating-an-object-product.html?#prettyPhoto

 

But, this solution isn't working for me, I am getting this error:

 

Erro

Comando SQL:

ALTER TABLE `ps_product` ADD `pack_stock_type` INT( 11 ) UNSIGNED DEFAULT '3';
 

Mensagens do MySQL : 

#1060 - Duplicate column name 'pack_stock_type' 

 

I was wondering if it is because the PrestaShop version I am using is 1.6.1.1

 

For reference, this is the theme I am currently using: http://www.templatemonster.com/prestashop-themes/54945.html

 

If anyone could help me with a solution for this fix it'll be much obliged.

[mervisoft]

Hi there, we have the same Problem. Did you find out what to do ?

 

Kind Regards

 

Dirk

[WeepingAngel]

Hi there, we have the same Problem. Did you find out what to do ?

 

Kind Regards

 

Dirk

 

Hi, it turns out my problem was with the demo that came with the theme, if I installed the demo this problem would occur, so I just created a new installation and didn't add the theme demo.