Error: Error: MySQL server has gone away
Error No: 2006
SELECT DISTINCT p.*, `pd`.`name`, `p`.`image`, `m`.`name` AS manufacturer, (SELECT (CASE WHEN `pd2`.`type` = 'P' THEN (`p`.`price` - (`p`.`price` * (`pd2`.`price` / 100))) WHEN `pd2`.`type` = 'S' THEN (`p`.`price` - `pd2`.`price`) ELSE `pd2`.`price` END) FROM `oc_product_discount` `pd2` WHERE `pd2`.`product_id` = `p`.`product_id` AND `pd2`.`customer_group_id` = '1' AND `pd2`.`quantity` = '1' AND `pd2`.`special` = '0' 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 (CASE WHEN `ps`.`type` = 'P' THEN (`p`.`price` - (`p`.`price` * (`ps`.`price` / 100))) WHEN `ps`.`type` = 'S' THEN (`p`.`price` - `ps`.`price`) ELSE `ps`.`price` END) FROM `oc_product_discount` `ps` WHERE `ps`.`product_id` = `p`.`product_id` AND `ps`.`customer_group_id` = '1' AND `ps`.`quantity` = '1' AND `ps`.`special` = '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`, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status 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`) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE `p2s`.`store_id` = '0' AND `p2s`.`product_id` IN (43590,59180,67714,68005,99306,155195,161338,170565) AND `pd`.`language_id` = '2' File: /var/www/html/system/library/db/mysqli.php Line: 122 Backtrace: 0 File: /var/www/html/system/library/db.php Line: 63 Class: Opencart\System\Library\DB\MySQLi Function: query Backtrace: 1 File: /var/www/html/catalog/model/journal3/product.php Line: 45 Class: Opencart\System\Library\DB Function: query Backtrace: 2 File: /var/www/html/catalog/model/journal3/product.php Line: 471 Class: ModelJournal3Product Function: getProduct Backtrace: 3 File: /var/www/html/system/engine/loader.php Line: 343 Class: ModelJournal3Product Function: getRecentlyViewedProducts Backtrace: 4 File: /var/www/html/system/engine/proxy.php Line: 87 Class: Opencart\System\Engine\Loader Function: Opencart\System\Engine\{closure} Backtrace: 5 File: /var/www/html/catalog/controller/journal3/side_products.php Line: 237 Class: Opencart\System\Engine\Proxy Function: __call Backtrace: 6 File: /var/www/html/system/library/journal3/opencart/modulecontroller.php Line: 182 Class: ControllerJournal3SideProducts Function: beforeRender Backtrace: 7 File: /var/www/html/system/engine/loader.php Line: 112 Class: Journal3\Opencart\ModuleController Function: index Backtrace: 8 File: /var/www/html/catalog/controller/journal3/grid.php Line: 263 Class: Opencart\System\Engine\Loader Function: controller Backtrace: 9 File: /var/www/html/system/engine/loader.php Line: 112 Class: ControllerJournal3Grid Function: grid Backtrace: 10 File: /var/www/html/catalog/controller/journal3/footer_menu.php Line: 148 Class: Opencart\System\Engine\Loader Function: controller Backtrace: 11 File: /var/www/html/system/engine/loader.php Line: 112 Class: ControllerJournal3FooterMenu Function: index Backtrace: 12 File: /var/www/html/catalog/controller/journal3/event/layout.php Line: 656 Class: Opencart\System\Engine\Loader Function: controller Backtrace: 13 File: /var/www/html/system/engine/action.php Line: 96 Class: ControllerJournal3EventLayout Function: controller_common_footer_before Backtrace: 14 File: /var/www/html/system/engine/event.php Line: 72 Class: Opencart\System\Engine\Action Function: execute Backtrace: 15 File: /var/www/html/system/engine/loader.php Line: 110 Class: Opencart\System\Engine\Event Function: trigger Backtrace: 16 File: /var/www/html/catalog/controller/product/product.php Line: 488 Class: Opencart\System\Engine\Loader Function: controller Backtrace: 17 File: /var/www/html/system/engine/action.php Line: 96 Class: Opencart\Catalog\Controller\Product\Product Function: index Backtrace: 18 File: /var/www/html/system/framework.php Line: 259 Class: Opencart\System\Engine\Action Function: execute Backtrace: 19 File: /var/www/html/index.php Line: 20 Function: require_once
Fatal error: Uncaught Exception: Error: MySQL server has gone away<br/>Error No: 2006<br/>REPLACE INTO `oc_session` SET `session_id` = 'e49f09f012dfbedafd1360db49', `data` = '{\"currency\":\"AZN\",\"jrv\":[170565,161338,43590,155195,59180,99306,67714,68005],\"review_token\":\"cb453c5f2bf12dc21b3f5c2421fa8126\",\"api_id\":\"journal3_popup_1bf051591f\",\"upload_token\":\"253c3f0975c9a8b27f4826a159c3fd40\"}', `expire` = '2025-11-01 11:44:52' in /var/www/html/system/library/db/mysqli.php:122 Stack trace: #0 /var/www/html/system/library/db.php(63): Opencart\System\Library\DB\MySQLi->query('REPLACE INTO `o...') #1 /var/www/html/system/library/session/db.php(63): Opencart\System\Library\DB->query('REPLACE INTO `o...') #2 /var/www/html/system/library/session.php(89): Opencart\System\Library\Session\DB->write('e49f09f012dfbed...', Array) #3 [internal function]: Opencart\System\Library\Session->close() #4 {main} thrown in /var/www/html/system/library/db/mysqli.php on line 122