Error: Error: MySQL server has gone away
Error No: 2006
SELECT
IF(p.quantity > 0, 1, 0) AS availability,
COUNT(*) AS total
FROM `oc_product` p
LEFT JOIN oc_product_viewed pw ON (p.product_id = pw.product_id)
LEFT JOIN `oc_product_to_category` p2c ON (p2c.product_id = p.product_id) LEFT JOIN `oc_category_path` cp ON (cp.category_id = p2c.category_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 cp.path_id = '4035'
GROUP BY
CASE
WHEN p.quantity > 0 THEN 1
ELSE 0
END
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: 789
Class: Opencart\System\Library\DB
Function: query
Backtrace: 2
File: /var/www/html/system/engine/loader.php
Line: 343
Class: ModelJournal3Filter
Function: getAvailability
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: 468
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/category.php
Line: 411
Class: Opencart\System\Engine\Loader
Function: controller
Backtrace: 14
File: /var/www/html/system/engine/action.php
Line: 96
Class: Opencart\Catalog\Controller\Product\Category
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` = 'd0af84f45d7facb9ce47a5f725', `data` = '{\"currency\":\"AZN\"}', `expire` = '2025-11-02 13:08:26' 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('d0af84f45d7facb...', Array)
#3 [internal function]: Opencart\System\Library\Session->close()
#4 {main}
thrown in /var/www/html/system/library/db/mysqli.php on line 122