Notice: Undefined index: product_id in /home/vdtecno/public_html/peshwaai.com/catalog/controller/pavdeals/deals.php on line 272
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 'AND o.order_status_id=7' at line 2<br />Error No: 1064<br />SELECT sum(quantity) as total FROM `order_product` op LEFT JOIN `order` AS o ON op.order_id = o.order_id WHERE op.product_id = AND o.order_status_id=7' in /home/vdtecno/public_html/peshwaai.com/system/database/mysqli.php:41 Stack trace: #0 /home/vdtecno/public_html/peshwaai.com/system/library/db.php(20): DBMySQLi->query('SELECT sum(quan...') #1 /home/vdtecno/public_html/peshwaai.com/catalog/model/pavdeals/product.php(134): DB->query('SELECT sum(quan...') #2 /home/vdtecno/public_html/peshwaai.com/catalog/controller/pavdeals/deals.php(272): ModelPavdealsproduct->getTotalBought(NULL, 7) #3 /home/vdtecno/public_html/peshwaai.com/catalog/controller/pavdeals/deals.php(175): ControllerPavdealsDeals->getItemDeal(Array, Array) #4 [internal function]: ControllerPavde in /home/vdtecno/public_html/peshwaai.com/system/database/mysqli.php on line 41