Post by grubybarti666 » 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

Newbie

Posts

Joined
Sun Dec 18, 2016 5:55 pm

Post by imdevlper18 » Mon Dec 19, 2016 3:10 pm

By default Opencart does not have such a bug.

It can only happen if you have changed the pagination code yourself or its happening from some module.
So you need to find the buggy module.

Just think which module shall be working on product file.
Disable it completely and try again.

You can then find the buggy module.

Opencart Extensions | Professional opencart support | Support Ticket | support@cartbinder.com


User avatar
Active Member

Posts

Joined
Sun May 11, 2014 2:04 pm
Who is online

Users browsing this forum: No registered users and 13 guests