Fatal error: Uncaught exception 'Exception' with message 'Error: Unknown column 'ps.stockid' in 'field list'
Error No: 1054
SELECT COUNT(DISTINCT ps.stockid) AS total FROM product_special ps LEFT JOIN product p ON (ps.stockid = p.stockid) LEFT JOIN product_to_store p2s ON (p.stockid = p2s.stockid) WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND ps.customer_group_id = '1' AND ((ps.startdate = '0000-00-00' OR ps.startdate < NOW()) AND (ps.enddate = '0000-00-00' OR ps.enddate > NOW()))' in /var/www/b2b/system/library/db/mysqli.php on line 50 Exception: Error: Unknown column 'ps.stockid' in 'field list'
Error No: 1054
SELECT COUNT(DISTINCT ps.stockid) AS total FROM product_special ps LEFT JOIN product p ON (ps.stockid = p.stockid) LEFT JOIN product_to_store p2s ON (p.stockid = p2s.stockid) WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND ps.customer_group_id = '1' AND ((ps.startdate = '0000-00-00' OR ps.startdate < NOW()) AND (ps.enddate = '0000-00-00' OR ps.enddate > NOW())) in /var/www/b2b/system/library/db/mysqli.php on line 50 Call Stack: 0.0000 235328 1. {main}() /var/www/b2b/index.php:0 0.0013 353064 2. start() /var/www/b2b/index.php:17 0.0013 354744 3. require_once('/var/www/b2b/system/framework.php') /var/www/b2b/system/startup.php:130 0.0051 529696 4. Front->dispatch() /var/www/b2b/system/framework.php:115 0.0182 942152 5. Front->execute() /var/www/b2b/system/engine/front.php:28 0.0182 942152 6. Action->execute() /var/www/b2b/system/engine/front.php:33 0.0183 946368 7. call_user_func_array:{/var/www/b2b/system/engine/action.php:51}() /var/www/b2b/system/engine/action.php:51 0.0183 946752 8. ControllerStartupRouter->index() /var/www/b2b/system/engine/action.php:51 0.0192 947640 9. Action->execute() /var/www/b2b/catalog/controller/startup/router.php:25 0.0193 951856 10. call_user_func_array:{/var/www/b2b/system/engine/action.php:51}() /var/www/b2b/system/engine/action.php:51 0.0193 954464 11. ControllerProductSpecial->index() /var/www/b2b/system/engine/action.php:51 0.0213 1030880 12. Proxy->getTotalProductSpecials() /var/www/b2b/catalog/controller/product/special.php:97 0.0213 1031064 13. Proxy->__call() /var/www/b2b/catalog/controller/product/special.php:97 0.0213 1032048 14. call_user_func_array:{/var/www/b2b/system/engine/proxy.php:25}() /var/www/b2b/system/engine/proxy.php:25 0.0213 1032896 15. Loader->{closure:/var/www/b2b/system/engine/loader.php:149-193}() /var/www/b2b/system/engine/proxy.php:25 0.0215 1034336 16. call_user_func_array:{/var/www/b2b/system/engine/loader.php:180}() /var/www/b2b/system/engine/loader.php:180 0.0215 1034632 17. ModelCatalogProduct->getTotalProductSpecials() /var/www/b2b/system/engine/loader.php:180 0.0215 1035512 18. DB->query() /var/www/b2b/catalog/model/catalog/product.php:1022 0.0215 1035648 19. DB\MySQLi->query() /var/www/b2b/system/library/db.php:16