ps_layered_price_index too big. Impossible to activate module faceted search

[ietax]

Hi, i have an big issue
ps_layered_price_index for my shop is huge and I can't activate the module.

I have 7 languages and it generates a price reange for each product combined with each country and each language.
so for each product It generate 1715 rows in the table.
And I have 20000 products !!!

 

thanks

[ComGrafPL]

16 hours ago, ietax said:

Hi, i have an big issue
ps_layered_price_index for my shop is huge and I can't activate the module.

I have 7 languages and it generates a price reange for each product combined with each country and each language.
so for each product It generate 1715 rows in the table.
And I have 20000 products !!!

 

thanks

Prestashop / PHP version? What error did it gives you?

[ietax]

Hi, thanks for your interest ...

 

PS 1.7.7.3

PHP 7.2.34

 

I have no errors. It generates a huge table because for each product / country / currency it creates a combination and then a row in the table...

that becomes huge table.

[musicmaster]

The id_country field was added in Prestashop 1.7.6.

It takes the countries that are in the ps_tax_rule table - usually that are not all countries. So I wonder why that concerns all countries for you. Are you using some special module that has that effect.

BTW: what is the version of your ps_facetedsearch module?

[ietax]

thanks, I have v3.7.1

[musicmaster]

There is very little I can do if you answer only a part of my questions. 

One thing you could try is uninstalling the ps_facetedsearch module and replace it by an old version (2.x) that you can find on the Prestashop Github.

[ietax]

thank you for your interest, i don't think i use a special form involving all countries.
I will search for the previous version of the module, until I find a definitive solution.

[ietax]

ps_tax_rule is empty

[musicmaster]

I suggest that you file an error report on the Prestashop Github: https://github.com/PrestaShop/PrestaShop/issues

Include a mention that your tax rule table is empty.