Warning: Undefined variable $cart in /var/www/opencart/system/library/cart/cart.php on line 55Warning: Trying to access array offset on null in /var/www/opencart/system/library/cart/cart.php on line 55Warning: mysqli::query(): (42000/1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND po.is_active = '1' ORDER BY po.delivery_num ASC' at line 1 in /var/www/opencart/system/library/db/mysqli.php on line 25
Fatal error: Uncaught Exception: Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND po.is_active = '1' ORDER BY po.delivery_num ASC' at line 1<br />Error No: 1064<br />SELECT po.supplier_name, po.supplier_stock, po.supplier_code, po.supplier_id AS supplier_article_id, po.available_num as quantity, po.price_loaded as price, po.currency, po.delivery_num, COALESCE(NULLIF(cd.title, ''), p.article) as name, p.article as article, b.name as brand, b.id as brand_id, po.product_id, pi.file_name as image, piv.url as image_url, ptc.category_id as category_id, cd.title as category FROM cp_price_offer po LEFT JOIN cp_product p ON (po.product_id = p.id) LEFT JOIN cp_parts_brand b ON p.brand_id = b.id LEFT JOIN cp_product_image pi ON (po.product_id = pi.product_id AND pi.sort_order = (SELECT MIN(pi2.sort_order) FROM cp_product_image pi2 WHERE pi2.product_id = po.product_id)) LEFT JOIN cp_product_image_variant piv ON (piv.image_id = pi.id AND piv.size = '400') LEFT JOIN (SELECT ptc2.product_id, ptc2.category_id FROM cp_product_to_category ptc2 JOIN cp_catalog_category c2 ON c2.id = ptc2.category_id WHERE ptc2.product_id = '0' ORDER BY level DESC LIMIT 1) ptc ON po.product_id = ptc.product_id LEFT JOIN cp_catalog_category_description cd ON (ptc.category_id = cd.category_id AND cd.language_id = '2') WHERE po.product_id IN () AND po.is_active = '1' ORDER BY po.delivery_num ASC in /var/www/opencart/system/library/db/mysqli.php:49
Stack trace:
#0 /var/www/opencart/system/library/db.php(45): DB\MySQLi->query('SELECT po.suppl...')
#1 /var/www/opencart/system/library/cart/cart.php(55): DB->query('SELECT po.suppl...')
#2 /var/www/opencart/system/library/cart/cart.php(238): Cart\Cart->getProducts()
#3 /var/www/opencart/catalog/controller/common/cart.php(11): Cart\Cart->getTaxes()
#4 /var/www/opencart/system/engine/action.php(79): ControllerCommonCart->index(Array)
#5 /var/www/opencart/system/engine/loader.php(48): Action->execute(Object(Registry), Array)
#6 /var/www/opencart/catalog/controller/common/header.php(82): Loader->controller('common/cart')
#7 /var/www/opencart/system/engine/action.php(79): ControllerCommonHeader->index(Array)
#8 /var/www/opencart/system/engine/loader.php(48): Action->execute(Object(Registry), Array)
#9 /var/www/opencart/catalog/controller/account/login.php(151): Loader->controller('common/header')
#10 /var/www/opencart/system/engine/action.php(79): ControllerAccountLogin->index()
#11 /var/www/opencart/catalog/controller/startup/router.php(27): Action->execute(Object(Registry))
#12 /var/www/opencart/system/engine/action.php(79): ControllerStartupRouter->index()
#13 /var/www/opencart/system/engine/router.php(67): Action->execute(Object(Registry))
#14 /var/www/opencart/system/engine/router.php(56): Router->execute(Object(Action))
#15 /var/www/opencart/system/framework.php(179): Router->dispatch(Object(Action), Object(Action))
#16 /var/www/opencart/system/startup.php(105): require_once('/var/www/openca...')
#17 /var/www/opencart/index.php(20): start('catalog')
#18 {main}
thrown in /var/www/opencart/system/library/db/mysqli.php on line 49