Error al Ingresar a cualquier categoria

[Ivan Rodriguez G]

Estimados PrestaShopper, temgo un reciente error en la tienda. Al ingresar a cualquier categoria, me da este error:

 

[PrestaShopDatabaseException]

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') INNER JOIN pspx_category_product cp ON (p.id_product = cp.id_product) INNER...' at line 1<br /><br /><pre>SELECT psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM pspx_product p INNER JOIN pspx_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = ) INNER JOIN pspx_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pspx_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN pspx_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND c.nleft>=3 AND c.nright<=4 AND ps.id_shop='1'</pre>
at line 769 in file classes/db/Db.php

764. if ($webservice_call && $errno) { 765. $dbg = debug_backtrace(); 766. WebserviceRequest::getInstance()->setError(500, '

 ' . $this->getMsgError() . '. From ' . (isset($dbg[3]['class']) ? $dbg[3]['class'] : '') . '->' . $dbg[3]['function'] . '() Query was : ' . $sql, 97); 767. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { 768. if ($sql) { 769. throw new PrestaShopDatabaseException($this->getMsgError() . '<br /><br /><pre>' . $sql . '</pre>'); 770. } 771. 772. throw new PrestaShopDatabaseException($this->getMsgError()); 773. } 774. }

DbCore->displayError - [line 385 - classes/db/Db.php] - [1 Arguments]

DbCore->query - [line 613 - classes/db/Db.php] - [1 Arguments]

DbCore->executeS - [line 92 - modules/ps_facetedsearch/src/Adapter/MySQL.php] - [1 Arguments]

PrestaShop\Module\FacetedSearch\Adapter\MySQL->execute - [line 64 - modules/ps_facetedsearch/src/Adapter/MySQL.php]

PrestaShop\Module\FacetedSearch\Adapter\MySQL->getMinMaxPriceValue - [line 271 - modules/ps_facetedsearch/src/Filters/Block.php]

PrestaShop\Module\FacetedSearch\Filters\Block->getPriceRangeBlock - [line 124 - modules/ps_facetedsearch/src/Filters/Block.php] - [3 Arguments]

PrestaShop\Module\FacetedSearch\Filters\Block->getFilterBlock - [line 168 - modules/ps_facetedsearch/src/Product/SearchProvider.php] - [2 Arguments]

PrestaShop\Module\FacetedSearch\Product\SearchProvider->runQuery - [line 308 - classes/controller/ProductListingFrontController.php] - [2 Arguments]

ProductListingFrontControllerCore->getProductSearchVariables - [line 580 - classes/controller/ProductListingFrontController.php]

ProductListingFrontControllerCore->doProductSearch - [line 137 - controllers/front/listing/CategoryController.php] - [2 Arguments]

CategoryControllerCore->initContent - [line 292 - classes/controller/Controller.php]

ControllerCore->run - [line 515 - classes/Dispatcher.php]

DispatcherCore->dispatch - [line 28 - index.php]

 

Alguien conoce la causa y como solucionarlo?

echenme un cable por favor.!!!