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.0001 234912 1. {main}() /var/www/b2b/index.php:0 0.0014 352512 2. start() /var/www/b2b/index.php:17 0.0015 354192 3. require_once('/var/www/b2b/system/framework.php') /var/www/b2b/system/startup.php:130 0.0099 528480 4. Front->dispatch() /var/www/b2b/system/framework.php:115 0.0194 940712 5. Front->execute() /var/www/b2b/system/engine/front.php:28 0.0194 940712 6. Action->execute() /var/www/b2b/system/engine/front.php:33 0.0194 944928 7. call_user_func_array:{/var/www/b2b/system/engine/action.php:51}() /var/www/b2b/system/engine/action.php:51 0.0194 945312 8. ControllerStartupRouter->index() /var/www/b2b/system/engine/action.php:51 0.0196 946200 9. Action->execute() /var/www/b2b/catalog/controller/startup/router.php:25 0.0219 953904 10. call_user_func_array:{/var/www/b2b/system/engine/action.php:51}() /var/www/b2b/system/engine/action.php:51 0.0219 956512 11. ControllerProductSpecial->index() /var/www/b2b/system/engine/action.php:51 0.0241 1033328 12. Proxy->getTotalProductSpecials() /var/www/b2b/catalog/controller/product/special.php:97 0.0242 1033512 13. Proxy->__call() /var/www/b2b/catalog/controller/product/special.php:97 0.0242 1034496 14. call_user_func_array:{/var/www/b2b/system/engine/proxy.php:25}() /var/www/b2b/system/engine/proxy.php:25 0.0242 1035344 15. Loader->{closure:/var/www/b2b/system/engine/loader.php:149-193}() /var/www/b2b/system/engine/proxy.php:25 0.0244 1036776 16. call_user_func_array:{/var/www/b2b/system/engine/loader.php:180}() /var/www/b2b/system/engine/loader.php:180 0.0244 1037072 17. ModelCatalogProduct->getTotalProductSpecials() /var/www/b2b/system/engine/loader.php:180 0.0244 1037944 18. DB->query() /var/www/b2b/catalog/model/catalog/product.php:1022 0.0244 1038080 19. DB\MySQLi->query() /var/www/b2b/system/library/db.php:16