Error: MySQL server has gone away
Error No: 2006
SELECT DISTINCT *, pd.`name`, `p`.`image`, (SELECT `pd2`.`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) AS `discount`, (SELECT `ps`.`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` < 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`, (SELECT `pr`.`points` FROM `oc_product_reward` `pr` WHERE `pr`.`product_id` = `p`.`product_id` AND `pr`.`customer_group_id` = '1') AS `reward`, (SELECT COUNT(*) FROM `oc_review` `r` WHERE `r`.`product_id` = `p`.`product_id` AND `r`.`status` = '1' GROUP BY `r`.`product_id`) AS `reviews` FROM `oc_product_to_store` `p2s` LEFT JOIN `oc_product` `p` ON (`p`.`product_id` = `p2s`.`product_id` AND `p`.`status` = '1' AND `p`.`date_available` <= NOW()) LEFT JOIN `oc_product_description` `pd` ON (`p`.`product_id` = `pd`.`product_id`) WHERE `p2s`.`store_id` = '4' AND `p2s`.`product_id` = '2504' AND `pd`.`language_id` = '3'
: in /home/oc4.bhs.lv/public_html/system/library/db/mysqli.php on line 76
Fatal error: Uncaught Exception: Error: MySQL server has gone away<br/>Error No: 2006<br/>REPLACE INTO `oc_session` SET `session_id` = '7e4d10d35b6aa8f0177cee116b', `data` = '{\"currency\":\"EUR\",\"jrv\":[2504,9270,12295,12156,61330,12574,61102,12513,8285,2518,2516,14435,25082,59649,18673,9928,16705,16957,25696,27005],\"review_token\":\"c46bc95841b04d3caf578f9a415b905c\",\"api_id\":\"journal3_newsletter_cf077d28cb\"}', `expire` = '2025-08-06 09:15:57' in /home/oc4.bhs.lv/public_html/system/library/db/mysqli.php:76 Stack trace: #0 /home/oc4.bhs.lv/public_html/vqmod/vqcache/vq2-system_library_db.php(59): Opencart\System\Library\DB\MySQLi->query() #1 /home/oc4.bhs.lv/public_html/vqmod/vqcache/vq2-system_library_session_db.php(59): Opencart\System\Library\DB->query() #2 /home/oc4.bhs.lv/public_html/vqmod/vqcache/vq2-system_library_session.php(97): Opencart\System\Library\Session\DB->write() #3 [internal function]: Opencart\System\Library\Session->close() #4 {main} thrown in /home/oc4.bhs.lv/public_html/system/library/db/mysqli.php on line 76