offitser

Решил вопрос. Пагинацию исправил.

А как решить эту проблему?

Доброго времени суток! При переключении страниц в категориях выдает вот такую ошибку Fatal error: Uncaught exception 'Exception' with message '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 '-12, 12' at line 1<br />Error No: 1064<br /> SELECT p.product_id, p.sort_order, "1" AS match_filters, pp.sort_order FROM `oc_product` AS p INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id) INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id) INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id) 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 p2s.store_id = '0' AND p2c.category_id = '65' AND pd.language_id = '1' GROUP BY p.product_id HAVING match_filters = 1 ORDER BY pp.sort_order ASC, pd.name ASC LIMIT -12, 12' in /var/www/u0755052/data/www/near4you.ru/system/library/db/mysqli.php:40 Stack trace: #0 /var/www/u0755052/data/www/near4you.ru/system/library/db.php(16): DB\MyS in /var/www/u0755052/data/www/near4you.ru/system/library/db/mysqli.php on line 40 Подскажите пожалуйста,как ее исправить?