Error: Error: MySQL server has gone away
Error No: 2006
SELECT DISTINCT *, `pd`.`name`, `p`.`image`, (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` 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` = '0' AND `p2s`.`product_id` = '173268' 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/catalog/product.php
Line: 68
Class: Opencart\System\Library\DB
Function: query
Backtrace: 2
File: /var/www/html/system/engine/loader.php
Line: 343
Class: Opencart\Catalog\Model\Catalog\Product
Function: getProduct
Backtrace: 3
File: /var/www/html/system/engine/proxy.php
Line: 87
Class: Opencart\System\Engine\Loader
Function: Opencart\System\Engine\{closure}
Backtrace: 4
File: /var/www/html/catalog/controller/journal3/product_tabs.php
Line: 244
Class: Opencart\System\Engine\Proxy
Function: __call
Backtrace: 5
File: /var/www/html/catalog/controller/journal3/product_tabs.php
Line: 203
Class: ControllerJournal3ProductTabs
Function: productContent
Backtrace: 6
File: /var/www/html/catalog/controller/journal3/product_tabs.php
Line: 50
Class: ControllerJournal3ProductTabs
Function: parseGeneralSettings
Backtrace: 7
File: /var/www/html/system/engine/loader.php
Line: 112
Class: ControllerJournal3ProductTabs
Function: index
Backtrace: 8
File: /var/www/html/catalog/controller/journal3/event/product.php
Line: 73
Class: Opencart\System\Engine\Loader
Function: controller
Backtrace: 9
File: /var/www/html/system/engine/action.php
Line: 96
Class: ControllerJournal3EventProduct
Function: controller_product_product_before
Backtrace: 10
File: /var/www/html/system/engine/event.php
Line: 72
Class: Opencart\System\Engine\Action
Function: execute
Backtrace: 11
File: /var/www/html/system/framework.php
Line: 249
Class: Opencart\System\Engine\Event
Function: trigger
Backtrace: 12
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` = '1b32afa3af7665eaabf0809947', `data` = '{\"currency\":\"AZN\",\"jrv\":[173268,62115,78468,107464,136182,147018,78759,109129,123972,102092,78987,112393,103800,43048,115045,127603,109150,138700,67798,92799],\"review_token\":\"f80eeb5b3aaf9de02372bb64d3c75f5a\",\"api_id\":\"journal3_popup_b865da538e\",\"upload_token\":\"bcdeb04331ad27273529f0f776a3cbf6\"}', `expire` = '2025-11-02 19:51:02' 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('1b32afa3af7665e...', Array)
#3 [internal function]: Opencart\System\Library\Session->close()
#4 {main}
thrown in /var/www/html/system/library/db/mysqli.php on line 122