'Array ( [0] => Array ( [file] => /mnt/adaxserver_home2/behsakala/public_html/vqmod/vqcache/vq2-system_library_db.php [line] => 20 [function] => query [class] => DBMySQLi [type] => -> ) [1] => Array ( [file] => /mnt/adaxserver_home2/behsakala/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php [line] => 679 [function] => query [class] => DB [type] => -> ) [2] => Array ( [file] => /mnt/adaxserver_home2/behsakala/public_html/vqmod/vqcache/vq2-catalog_controller_product_category.php [line] => 257 [function] => getTotalProducts [class] => ModelCatalogProduct [type] => -> ) [3] => Array ( [function] => index [class] => ControllerProductCategory [type] => -> ) [4] => Array ( [file] => /mnt/adaxserver_home2/behsakala/public_html/vqmod/vqcache/vq2-system_engine_front.php [line] => 48 [function] => call_user_func_array ) [5] => Array ( [file] => /mnt/adaxserver_home2/behsakala/public_html/vqmod/vqcache/vq2-system_engine_front.php [line] => 35 [function] => execute [class] => Front [type] => -> ) [6] => Array ( [file] => /mnt/adaxserver_home2/behsakala/public_html/index.php [line] => 254 [function] => dispatch [class] => Front [type] => -> ) ) '
Fatal error: Uncaught exception 'ErrorException' with message 'Error: Unknown column 'p.date_available' in 'where clause'<br />Error No: 1054<hr />SELECT COUNT(DISTINCT `product_id`) AS `total` FROM(SELECT COUNT(DISTINCT `product_id`) AS `total` FROM(SELECT DISTINCT `p`.`product_id` FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE `p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `p2c`.`category_id` = '731' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '787') AS `tmp` WHERE `p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `p2c`.`category_id` = '731' AND `product_id` IN( SELECT `product_id` FROM `oc_product_filter` WHERE `filter_id` I in /mnt/adaxserver_home2/behsakala/public_html/system/database/mysqli.php on line 43