Предупреждение: PDO::query(): MySQL server has gone away в файле /var/www/www-root/data/www/main/tula/modules/core/database/pdo.php (строка 594)Предупреждение: PDO::query(): Error reading result set's header в файле /var/www/www-root/data/www/main/tula/modules/core/database/pdo.php (строка 594)Exception: Query error HY000: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away. Query: SELECT MIN(t.price_absolute) AS `min`, MAX(t.price_absolute) AS `max` FROM (SELECT IF (`shop_items`.`shop_currency_id` = '3', IF (COUNT(`shop_discounts`.`id`), ((`shop_items`.`price` + IF(`shop_taxes`.`tax_is_included` IS NULL OR `shop_taxes`.`tax_is_included` = 1, 0, `shop_items`.`price` * `shop_taxes`.`rate` / 100)) * (1 - SUM(DISTINCT IF(`shop_discounts`.`type` = 0, `shop_discounts`.`value`, 0)) / 100)) * 53 - SUM(DISTINCT IF(`shop_discounts`.`type`, `shop_discounts`.`value`, 0)), (`shop_items`.`price`) * 53), IF (`shop_items`.`shop_currency_id` = '2', IF (COUNT(`shop_discounts`.`id`), ((`shop_items`.`price` + IF(`shop_taxes`.`tax_is_included` IS NULL OR `shop_taxes`.`tax_is_included` = 1, 0, `shop_items`.`price` * `shop_taxes`.`rate` / 100)) * (1 - SUM(DISTINCT IF(`shop_discounts`.`type` = 0, `shop_discounts`.`value`, 0)) / 100)) * 60 - SUM(DISTINCT IF(`shop_discounts`.`type`, `shop_discounts`.`value`, 0)), (`shop_items`.`price`) * 60), IF (`shop_items`.`shop_currency_id` = '1', IF (COUNT(`shop_discounts`.`id`), ((`shop_items`.`price` + IF(`shop_taxes`.`tax_is_included` IS NULL OR `shop_taxes`.`tax_is_included` = 1, 0, `shop_items`.`price` * `shop_taxes`.`rate` / 100)) * (1 - SUM(DISTINCT IF(`shop_discounts`.`type` = 0, `shop_discounts`.`value`, 0)) / 100)) * 1 - SUM(DISTINCT IF(`shop_discounts`.`type`, `shop_discounts`.`value`, 0)), (`shop_items`.`price`) * 1), `shop_items`.`price` + IF(`shop_taxes`.`tax_is_included` IS NULL OR `shop_taxes`.`tax_is_included` = 1, 0, `shop_items`.`price` * `shop_taxes`.`rate` / 100)))) AS `price_absolute` FROM `shop_items` LEFT OUTER JOIN `shop_item_discounts` ON `shop_items`.`id` = `shop_item_discounts`.`shop_item_id` LEFT OUTER JOIN `shop_discounts` ON `shop_item_discounts`.`shop_discount_id` = `shop_discounts`.`id` AND `shop_discounts`.`active` = 1 AND `shop_discounts`.`deleted` = 0 AND `shop_discounts`.`day4` = 1 AND `shop_discounts`.`start_time` <= '13:00:40' AND `shop_discounts`.`end_time` >= '13:00:40' AND `shop_discounts`.`start_datetime` <= '2024-05-16 13:00:40' AND ( `shop_discounts`.`end_datetime` >= '2024-05-16 13:00:40' OR `shop_discounts`.`end_datetime` = '0000-00-00 00:00:00' ) LEFT OUTER JOIN `shop_taxes` ON `shop_taxes`.`id` = `shop_items`.`shop_tax_id` WHERE `shop_items`.`deleted` = 0 AND `shop_items`.`shop_id` = '1' AND `shop_items`.`active` = 1 AND `shop_items`.`shortcut_id` = 0 AND `shop_items`.`shop_group_id` = '57' GROUP BY `shop_items`.`id`) AS `t`
modules/core/database/pdo.php:604 Core_Exception->__construct
modules/core/querybuilder/statement.php:80 Core_DataBase_Pdo->query
modules/shop/controller/show.php:3605 Core_QueryBuilder_Statement->execute
templates/template21/template.php:183 Shop_Controller_Show->addMinMaxPrice
templates/template21/template.htm:2 include
modules/template/model.php:103 include
modules/core/page.php:166 Template_Model->execute
templates/template13/template.php:139 Core_Page->execute
templates/template13/template.htm:2 include
modules/template/model.php:103 include
modules/core/page.php:166 Template_Model->execute
modules/core/command/controller/default.php:583 Core_Page->execute
modules/core/router/route.php:195 Core_Command_Controller_Default->showAction
index.php:238 Core_Router_Route->execute
Fatal error: Uncaught Core_Exception: Query error HY000: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away. Query: UPDATE `sessions` SET `value` = 'aG9zdGNtc1ZpZXdlZHxhOjE6e2k6MTthOjE6e2k6MDtzOjQ6IjI4MTMiO319', `time` = 1715853641 WHERE `id` = '09voklhoqv6mnrfcvdbdgck178' <br />modules/core/database/pdo.php:604 Core_Exception->__construct <br />modules/core/querybuilder/statement.php:80 Core_DataBase_Pdo->query <br />modules/core/session/database.php:140 Core_QueryBuilder_Statement->execute <br />modules/core/session.php:293 session_write_close <br />modules/core/core.php:464 Core_Session::close in /var/www/www-root/data/www/main/tula/modules/core/database/pdo.php:598 Stack trace: #0 /var/www/www-root/data/www/main/tula/modules/core/querybuilder/statement.php(80): Core_DataBase_Pdo->query('UPDATE `session...') #1 /var/www/www-root/data/www/main/tula/modules/core/session/database.php(140): Core_QueryBuilder_Statement->execute() #2 [internal function]: Core_Session_Database->sessionWrite('09voklhoqv6mnrf...', in /var/www/www-root/data/www/main/tula/modules/core/database/pdo.php on line 598