#0 MyPkSQLi->query( SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, ( SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ( (pd2.date_start = '0000-00-00' OR pd2.date_start < '2020-05-31 03:47:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2020-05-31 03:47:00') ) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1 ) AS discount, ( SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ( (ps.date_start = '0000-00-00' OR ps.date_start < '2020-05-31 03:47:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2020-05-31 03:47:00') ) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1 ) AS special, ( SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1' ) AS reward, ( SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1' ) AS stock_status, ( SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1' ) AS weight_class, ( SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1' ) AS length_class, ( SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) AS rating, ( SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id ) AS reviews, p.sort_order FROM oc_product p 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) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '39036' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2020-05-31 03:47:00' AND p2s.store_id = '0' ) called at [/var/www/www.heavymanuals.com/html/vqmod/vqcache/vq2-system_library_db.php:16] #1 DB->query( SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, ( SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ( (pd2.date_start = '0000-00-00' OR pd2.date_start < '2020-05-31 03:47:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2020-05-31 03:47:00') ) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1 ) AS discount, ( SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ( (ps.date_start = '0000-00-00' OR ps.date_start < '2020-05-31 03:47:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2020-05-31 03:47:00') ) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1 ) AS special, ( SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1' ) AS reward, ( SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1' ) AS stock_status, ( SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1' ) AS weight_class, ( SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1' ) AS length_class, ( SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) AS rating, ( SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id ) AS reviews, p.sort_order FROM oc_product p 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) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '39036' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2020-05-31 03:47:00' AND p2s.store_id = '0' ) called at [/var/www/www.heavymanuals.com/html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:110] #2 ModelCatalogProduct->getProduct(39036) called at [/var/www/www.heavymanuals.com/html/vqmod/vqcache/vq2-catalog_controller_product_product.php:167] #3 ControllerProductProduct->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/product.php,[*class] => Controllerproductproduct,[*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/product.php,[*class] => Controllerproductproduct,[*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_discount.MYD' (Errcode: 24 - Too many open files)
Error No: 23
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, ( SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ( (pd2.date_start = '0000-00-00' OR pd2.date_start < '2020-05-31 03:47:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2020-05-31 03:47:00') ) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1 ) AS discount, ( SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ( (ps.date_start = '0000-00-00' OR ps.date_start < '2020-05-31 03:47:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2020-05-31 03:47:00') ) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1 ) AS special, ( SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1' ) AS reward, ( SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1' ) AS stock_status, ( SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1' ) AS weight_class, ( SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1' ) AS length_class, ( SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) AS rating, ( SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id ) AS reviews, p.sort_order FROM oc_product p 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) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '39036' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2020-05-31 03:47:00' AND p2s.store_id = '0' in /var/www/www.heavymanuals.com/html/system/database/mypksqli.php on line 38