Back to the first page - problem
Posted: Sun Dec 18, 2016 5:58 pm
When I go to the 5th or 7th page of my product list and than I want to get back to the first one I get following error
Code: Select all
Fatal error: Uncaught exception 'Exception' with message 'Error: Something is wrong in your syntax obok '-30, 30' w linii 1
Error No: 1064
SELECT p.*, pp.sort_order FROM `oc_bf_tmp_product` AS p INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id) INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id) WHERE match_filters = 1 AND pd.language_id = '3' ORDER BY pp.sort_order ASC, pd.name ASC LIMIT -30, 30' in /home/visko12/domains/solidnedrzwi.pl/public_html/system/library/db/mysqli.php:40 Stack trace: #0 /home/visko12/domains/solidnedrzwi.pl/public_html/system/library/db.php(16): DB\MySQLi->query(' SELECT p.*, pp...', Array) #1 /home/visko12/domains/solidnedrzwi.pl/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php(90): DB->query(' SELECT p.*, pp...') #2 [internal function]: ModelCatalogProduct->getProducts(Array) #3 /home/visko12/domains/solidnedrzwi.pl/public_html/vqmod/vqcache/vq2-system_storage_modification_system_engine_loader.php(150): in /home/visko12/domains/solidnedrzwi.pl/public_html/system/library/db/mysqli.php on line 40