Warning: mysqli::query(): MySQL server has gone away in /home/robotindustrial/www/vqmod/vqcache/vq2-system_library_db_mysqli.php on line 225Warning: mysqli::query(): Error reading result set's header in /home/robotindustrial/www/vqmod/vqcache/vq2-system_library_db_mysqli.php on line 225OPL-DB-ERR-001: An internal database error occurred. Please contact your OpL administator. Log time : 01-07-2026 18:01:41 :: Message=[Error: MySQL server has gone away
Error No: 2006
. Error in: /home/robotindustrial/www/system/library/journal3/opencart/model.php line 48
SELECT p.product_id, ( SELECT AVG(rating) total FROM `oc_review` r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) rating, ( 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1 ) discount, ( SELECT price FROM `oc_product_special` ps WHERE ps.product_id = p.product_id AND (ps.customer_group_id = '1' OR ps.customer_group_id = -1) AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1 ) special, ( SELECT ROUND(( 100 * (p.price-ps.price))/p.price,2) FROM `oc_product_special` ps INNER JOIN `oc_product` p ON ps.product_id = p.product_id WHERE ps.product_id = p.product_id AND (ps.customer_group_id = '1' OR ps.customer_group_id = -1) AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1 ) AS special_percentage, p.viewed 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) WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '1' AND COALESCE( ( SELECT price FROM `oc_product_special` ps WHERE ps.product_id = p.product_id AND (ps.customer_group_id = '1' OR ps.customer_group_id = -1) AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1 ) , ( 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1 ) , p.price) >= 86.95 GROUP BY p.product_id ORDER BY p.is_spare ASC, p.is_accessory ASC, p.is_alternative ASC, p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0, 9999]