Здравствуйте.
При переносе сайта но новый сервер с MySQL 8:
Цитата:
Exception: Query error HY000: SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: '0000-00-00 00:00:00'. Query: SELECT SQL_CALC_FOUND_ROWS `informationsystem_items`.* FROM `informationsystem_items` WHERE `informationsystem_items`.`informationsystem_id` = 24 AND ( `informationsystem_items`.`start_datetime` < '2023-04-19 00:52:19' OR `informationsystem_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `informationsystem_items`.`end_datetime` > '2023-04-19 00:52:19' OR `informationsystem_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `informationsystem_items`.`siteuser_group_id` IN (0, -1) AND `informationsystem_items`.`active` = 1 AND `informationsystem_items`.`closed` = 0 AND `informationsystem_items`.`deleted` = 0 ORDER BY `informationsystem_items`.`sorting` ASC, `informationsystem_items`.`name` ASC LIMIT 10 OFFSET 0
modules/core/database/pdo.php:630 Core_Exception->__construct
modules/core/querybuilder/statement.php:80 Core_DataBase_Pdo->query
modules/core/orm.php:524 Core_QueryBuilder_Statement->execute
modules/core/entity.php:553 Core_ORM->findAll
modules/informationsystem/controller/show.php:615 Core_Entity->findAll
templates/template13/template.htm:224 Informationsystem_Controller_Show->show
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
Как можно это исправить?
