Warning: http_build_query(): Parameter 1 expected to be Array or Object. Incorrect value given in /home/jigneshp/public_html/vqmod/vqcache/vq2-assets_model_catalog_product.php on line 1334Warning: Illegal string offset 'filter_category_id' in /home/jigneshp/public_html/vqmod/vqcache/vq2-assets_model_catalog_product.php on line 1343Warning: Illegal string offset 'filter_category_id' in /home/jigneshp/public_html/vqmod/vqcache/vq2-assets_model_catalog_product.php on line 1349Warning: Illegal string offset 'filter_category_id' in /home/jigneshp/public_html/vqmod/vqcache/vq2-assets_model_catalog_product.php on line 1350Warning: Illegal string offset 'sort' in /home/jigneshp/public_html/vqmod/vqcache/vq2-assets_model_catalog_product.php on line 1420Warning: Illegal string offset 'order' in /home/jigneshp/public_html/vqmod/vqcache/vq2-assets_model_catalog_product.php on line 1420Warning: Illegal string offset 'sort' in /home/jigneshp/public_html/vqmod/vqcache/vq2-assets_model_catalog_product.php on line 1421Warning: Illegal string offset 'order' in /home/jigneshp/public_html/vqmod/vqcache/vq2-assets_model_catalog_product.php on line 1421Warning: Illegal string offset 'start' in /home/jigneshp/public_html/vqmod/vqcache/vq2-assets_model_catalog_product.php on line 1431Warning: Illegal string offset 'limit' in /home/jigneshp/public_html/vqmod/vqcache/vq2-assets_model_catalog_product.php on line 1431
Fatal error: Uncaught exception 'ErrorException' 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 '1 LIMIT 1, 1' at line 1<br />Error No: 1064<br />SELECT op.product_id, COUNT(*) AS total FROM order_product op LEFT JOIN `order` o ON (op.order_id = o.order_id) LEFT JOIN `product` p ON (op.product_id = p.product_id) LEFT JOIN product_variation_to_surat pv2l ON (p.product_id = pv2l.product_id) LEFT JOIN `product_to_category` pc ON (op.product_id = pc.product_id) WHERE o.order_status_id = '5' AND p.status = '1' AND pv2l.status = '1' AND pv2l.price > 0 AND op.location_id = '1' AND DATE(o.pick_date) > '2018-03-23' AND pc.category_id = 1 GROUP BY op.product_id HAVING total > 5 ORDER BY 1 1 LIMIT 1, 1' in /home/jigneshp/public_html/system/database/ipsmysqli.php:46 Stack trace: #0 /home/jigneshp/public_html/vqmod/vqcache/vq2-system_library_db.php(22): IPSMySQLi->query('SELECT op.produ...') #1 /home/jigneshp/public_html/vqmod/ in /home/jigneshp/public_html/system/database/ipsmysqli.php on line 46