Unknown column 'id_country' in 'field list'<br /><br /><pre>INSERT INTO `bb_layered_price_index` (id_product, id_currency, id_shop, price_min, price_max, id_country)

[jackpera]

Hello,

when adding a new product, we get the error attached to this (on PS 1.7.6.1).

Any Idea on this?

Further, there are some strange behaviours, like Categories and Subcategories that couldn't be erased.

We are running on php 7.1, but we tried also 7.2 even if I think there's no relation with php version.

I tried to add manually the missing column and get the following error:

Table 'db798029528.bb_layered_filter_block' doesn't exist<br /><br /><pre>TRUNCATE TABLE bb_layered_filter_block</pre>

when trying to create the product.

Any help would be greatly appreciated.

Thanks a lot

Jacopo

 

[Diana Hansen]

Hello Jacopo,

Did you find a solution for this problem?

Please let me know. I have the same situation.

Thanks and best regards,

Diana

[Diana Hansen]

Hello Ndiaga,

Thank you very much for your response. 

Yes. I reinstalled Prestashop 1.7, and I have been working with the different module developers to solve issues. I don't know what was wrong but I have moved further with my upgrade. 

Best regards,

Diana

[Diana Hansen]

Hi ndiaga,

Yes. I hope it helps him, too. Definitely, reinstalling and trying the different functions slowly and adding modules one by one is the only option.