Warning: A non-numeric value encountered in /home/s/stm086gs/roof-store/public_html/system/storage/modification/catalog/controller/product/manufacturer.php on line 293 Fatal error: Uncaught Exception: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-20, 20' at line 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 = '1' ORDER BY pp.sort_order ASC, pd.name ASC LIMIT -20, 20 in /home/s/stm086gs/roof-store/public_html/system/storage/modification/system/library/db/mysqli.php:47 Stack trace: #0 /home/s/stm086gs/roof-store/public_html/system/library/db.php(16): DB\MySQLi->query(' SELECT p.*, pp...', Array) #1 /home/s/stm086gs/roof-store/public_html/system/storage/modification/catalog/model/catalog/product.php(77): DB->query(' SELECT p.*, pp...') #2 [internal function]: ModelCatalogProduct->getProducts(Array) #3 /home/s/stm086gs/roof-store/public_html/system/storage/modification/system/en in /home/s/stm086gs/roof-store/public_html/system/storage/modification/system/library/db/mysqli.php on line 47