Warning: mysqli::query(): (42S22/1054): Unknown column 'ps.product_id' in 'field list' in /home/admin/domains/vowt.dev.br/public_html/system/library/db/mysqli.php on line 25
Fatal error: Uncaught Exception: Error: Unknown column 'ps.product_id' in 'field list'<br />Error No: 1054<br />SELECT COUNT(DISTINCT ps.product_id) AS total FROM oc_product_special ps LEFT JOIN oc_product p ON (ps.product_id = p.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE ps.tenant_id = '06d2bf4a-03d1-4014-ab16-37ca7986b21e' AND p.tenant_id = '06d2bf4a-03d1-4014-ab16-37ca7986b21e' AND p2s.tenant_id = '06d2bf4a-03d1-4014-ab16-37ca7986b21e' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) in /home/admin/domains/vowt.dev.br/public_html/system/library/db/mysqli.php:49 Stack trace: #0 /home/admin/domains/vowt.dev.br/public_html/system/library/db.php(45): DB\MySQLi->query() #1 /home/admin/domains/vowt.dev.br/public_html/catalog/model/catalog/product.php(824): DB->query() #2 /home/admin/domains/vowt.dev.br/public_html/system/engine/loader.php(248): ModelCatalogProduct->getTotalProductSpecials() #3 /home/admin/domains/vowt.dev.br/public_html/system/engine/proxy.php(47): Loader->{closure}() #4 /home/admin/domains/vowt.dev.br/public_html/catalog/controller/product/special.php(79): Proxy->__call() #5 /home/admin/domains/vowt.dev.br/public_html/system/engine/action.php(79): ControllerProductSpecial->index() #6 /home/admin/domains/vowt.dev.br/public_html/catalog/controller/startup/router.php(27): Action->execute() #7 /home/admin/domains/vowt.dev.br/public_html/system/engine/action.php(79): ControllerStartupRouter->index() #8 /home/admin/domains/vowt.dev.br/public_html/system/engine/router.php(67): Action->execute() #9 /home/admin/domains/vowt.dev.br/public_html/system/engine/router.php(56): Router->execute() #10 /home/admin/domains/vowt.dev.br/public_html/system/framework.php(179): Router->dispatch() #11 /home/admin/domains/vowt.dev.br/public_html/system/startup.php(104): require_once('...') #12 /home/admin/domains/vowt.dev.br/public_html/index.php(19): start() #13 {main} thrown in /home/admin/domains/vowt.dev.br/public_html/system/library/db/mysqli.php on line 49