Fatal error: Uncaught Exception: 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 op.status = 0' at line 1<br />Error No: 1064<br />SELECT (op.description) AS description, date_start AS date_start_promotion, date_end AS date_end_promotion, op.order_promotion_id, od.tipo_promocao FROM oc_order_promotion op INNER JOIN oc_order_discount od ON (op.order_promotion_id = od.order_promotion_id) WHERE od.product_id = and op.status = 0 in /montagem/sdb1/vicem01207/public_html/system/database/mysqliclass.php:46
Stack trace:
#0 /montagem/sdb1/vicem01207/public_html/system/library/db.php(35): MySQLiClass->query('SELECT (op.desc...')
#1 /montagem/sdb1/vicem01207/public_html/catalog/model/catalog/product.php(2286): DB->query('SELECT (op.desc...')
#2 /montagem/sdb1/vicem01207/public_html/catalog/controller/product/productPage.php(187): ModelCatalogProduct->getProductPromotion(NULL)
#3 /montagem/sdb1/vicem01207/public_html/catalog/controller/product/product.php(110): ControllerProductProductPage->getDadosProduto()
#4 /montagem/sdb1/vicem01207/public_html/system/engine/front.php(42): ControllerProductProduct->index()
#5 /montagem/sdb1/vicem01207/public_html/system/engine/front.php(29): Front->execute(Object(Action))
#6 /montagem/sdb1/vicem01207/public_html/index.php(427): Front->dispatch(Object(Action), Object(Action))
#7 {main}
thrown in /montagem/sdb1/vicem01207/public_html/system/database/mysqliclass.php on line 46