Error: Error: MySQL server has gone away
Error No: 2006
SELECT
MAX(c.category_id) id,
MAX(cd.name) value,
MAX(c.image) image,
COUNT(*) total
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
LEFT JOIN `oc_product_to_category`p2c ON (c.category_id = p2c.category_id)
LEFT JOIN `oc_product` p ON (p.product_id = p2c.product_id)
LEFT JOIN oc_product_viewed pw ON (p.product_id = pw.product_id)
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 = '2'
AND (p.product_id IN (101888,101911,101895,101857,101862,100155,101910,100156,99640,101873))
AND cd.language_id = '2'
AND c2s.store_id = '0'
AND c.status = '1'
GROUP BY c.category_id
HAVING COUNT(*) > 0
ORDER BY c.sort_order, LCASE(cd.name) ASC
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/filter.php
Line: 355
Class: Opencart\System\Library\DB
Function: query
Backtrace: 2
File: /var/www/html/system/engine/loader.php
Line: 343
Class: ModelJournal3Filter
Function: getCategories
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/filter.php
Line: 253
Class: Opencart\System\Engine\Proxy
Function: __call
Backtrace: 5
File: /var/www/html/catalog/controller/journal3/filter.php
Line: 151
Class: ControllerJournal3Filter
Function: beforeRender
Backtrace: 6
File: /var/www/html/system/engine/loader.php
Line: 112
Class: ControllerJournal3Filter
Function: index
Backtrace: 7
File: /var/www/html/catalog/controller/journal3/grid.php
Line: 263
Class: Opencart\System\Engine\Loader
Function: controller
Backtrace: 8
File: /var/www/html/system/engine/loader.php
Line: 112
Class: ControllerJournal3Grid
Function: grid
Backtrace: 9
File: /var/www/html/catalog/controller/journal3/event/layout.php
Line: 318
Class: Opencart\System\Engine\Loader
Function: controller
Backtrace: 10
File: /var/www/html/system/engine/action.php
Line: 96
Class: ControllerJournal3EventLayout
Function: controller_common_position_before
Backtrace: 11
File: /var/www/html/system/engine/event.php
Line: 72
Class: Opencart\System\Engine\Action
Function: execute
Backtrace: 12
File: /var/www/html/system/engine/loader.php
Line: 110
Class: Opencart\System\Engine\Event
Function: trigger
Backtrace: 13
File: /var/www/html/catalog/controller/product/search.php
Line: 416
Class: Opencart\System\Engine\Loader
Function: controller
Backtrace: 14
File: /var/www/html/system/engine/action.php
Line: 96
Class: Opencart\Catalog\Controller\Product\Search
Function: index
Backtrace: 15
File: /var/www/html/system/framework.php
Line: 259
Class: Opencart\System\Engine\Action
Function: execute
Backtrace: 16
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` = '1ece67fdf7c82bd8a98001fc00', `data` = '{\"currency\":\"AZN\",\"jrv\":[118955,123127,130986,108973,55110,131602,97587,51825,130581,27359,118563,18441,58578,52193,103813,18072,142837,24861,146729,70183],\"review_token\":\"f5fd50d06f94efa588293a9977ffb9a8\",\"api_id\":\"journal3_popup_6e705b4a32\",\"upload_token\":\"2596f40079cbf87987538dfb1162b967\"}', `expire` = '2025-11-03 20:04:28' 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('1ece67fdf7c82bd...', Array)
#3 [internal function]: Opencart\System\Library\Session->close()
#4 {main}
thrown in /var/www/html/system/library/db/mysqli.php on line 122