Eugene Savitsky Posted September 6, 2018 Share Posted September 6, 2018 Please help. Prestashop 1.6.1.20. Enabling any Filters templates in the blocklayered (Layered navigation block 2.2.1) module I get this error (reinstalling does not helps): [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 '-500,500' at line 25 SELECT p.*, product_shop.*, product_shop.id_category_default, pl.*, image_shop.`id_image` id_image, il.legend, m.name manufacturer_name, product_attribute_shop.id_product_attribute id_product_attribute, DATEDIFF(product_shop.`date_add`, DATE_SUB("2018-09-06 00:00:00", INTERVAL 30 DAY)) > 0 AS new, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity FROM ps_cat_filter_restriction cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN ps_product_lang pl ON (pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 2) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 2) LEFT JOIN ps_manufacturer m ON (m.id_manufacturer = p.id_manufacturer) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY p.date_add desc , cp.id_product LIMIT -500,500 at line 791 in file classes/db/Db.php 786. if ($webservice_call && $errno) { 787. $dbg = debug_backtrace(); 788. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 789. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { 790. if ($sql) { 791. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 792. } 793. 794. throw new PrestaShopDatabaseException($this->getMsgError()); 795. } 796. } DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 643 - classes/db/Db.php] - [1 Arguments] DbCore->executeS - [line 438 - override/modules/blocklayered/blocklayered.php] - [3 Arguments] BlockLayeredOverride->getProductByFilters - [line 3201 - modules/blocklayered/blocklayered.php] - [1 Arguments] BlockLayered->getProducts - [line 655 - modules/blocklayered/blocklayered.php] - [9 Arguments] BlockLayered->hookProductListAssign - [line 591 - classes/Hook.php] - [1 Arguments] HookCore::coreCallHook - [line 548 - classes/Hook.php] - [3 Arguments] HookCore::exec - [line 216 - controllers/front/CategoryController.php] - [2 Arguments] CategoryControllerCore->assignProductList - [line 144 - controllers/front/CategoryController.php] CategoryControllerCore->initContent - [line 9 - override/controllers/front/CategoryController.php] CategoryController->initContent - [line 189 - classes/controller/Controller.php] ControllerCore->run - [line 128 - override/classes/Dispatcher.php] Dispatcher->dispatch - [line 28 - index.php] Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now