#0 MyPkSQLi->query(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 p.status = '1' AND p.date_available <= '2020-05-31 02:40:00' AND p2s.store_id = '0' AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2020-05-31 02:40:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2020-05-31 02:40:00'))) called at [/var/www/www.heavymanuals.com/html/vqmod/vqcache/vq2-system_library_db.php:16] #1 DB->query(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 p.status = '1' AND p.date_available <= '2020-05-31 02:40:00' AND p2s.store_id = '0' AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2020-05-31 02:40:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2020-05-31 02:40:00'))) called at [/var/www/www.heavymanuals.com/html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:911] #2 ModelCatalogProduct->getTotalProductSpecials(Array ([sort] => p.sort_order,[order] => ASC,[start] => 16800,[limit] => 30)) called at [/var/www/www.heavymanuals.com/html/catalog/controller/product/special.php:100] #3 ControllerProductSpecial->index() called at [/var/www/www.heavymanuals.com/html/vqmod/vqcache/vq2-system_engine_front.php:42] #4 Front->execute(Action Object ([*file] => /var/www/www.heavymanuals.com/html/catalog/controller/product/special.php,[*class] => Controllerproductspecial,[*method] => index,[*args] => Array ())) called at [/var/www/www.heavymanuals.com/html/vqmod/vqcache/vq2-system_engine_front.php:29] #5 Front->dispatch(Action Object ([*file] => /var/www/www.heavymanuals.com/html/catalog/controller/product/special.php,[*class] => Controllerproductspecial,[*method] => index,[*args] => Array ()), Action Object ([*file] => /var/www/www.heavymanuals.com/html/catalog/controller/error/not_found.php,[*class] => Controllererrornotfound,[*method] => index,[*args] => Array ())) called at [/var/www/www.heavymanuals.com/html/index.php:238] Notice: Error: Out of resources when opening file './heavymanuals/oc_product.MYD' (Errcode: 24 - Too many open files)
Error No: 23
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 p.status = '1' AND p.date_available <= '2020-05-31 02:40:00' AND p2s.store_id = '0' AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2020-05-31 02:40:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2020-05-31 02:40:00')) in /var/www/www.heavymanuals.com/html/system/database/mypksqli.php on line 38