From a8c04261610eac36d92f794541c4bb6f43456695 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Tim=20D=C3=BCsterhus?= Date: Mon, 11 Feb 2019 12:01:06 +0100 Subject: [PATCH] Update sql_mode to use with MySQL Add: - NO_ZERO_IN_DATE - ERROR_FOR_DIVISION_BY_ZERO - NO_ENGINE_SUBSTITUTION Closes #2827 --- .../install/files/lib/system/database/MySQLDatabase.class.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/wcfsetup/install/files/lib/system/database/MySQLDatabase.class.php b/wcfsetup/install/files/lib/system/database/MySQLDatabase.class.php index 5cc07591e3..0894980730 100644 --- a/wcfsetup/install/files/lib/system/database/MySQLDatabase.class.php +++ b/wcfsetup/install/files/lib/system/database/MySQLDatabase.class.php @@ -29,7 +29,7 @@ class MySQLDatabase extends Database { ]; if (!$this->failsafeTest) { $driverOptions = [ - \PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8mb4', SESSION sql_mode = 'ANSI,ONLY_FULL_GROUP_BY,STRICT_ALL_TABLES'" + \PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8mb4', SESSION sql_mode = 'ANSI,ONLY_FULL_GROUP_BY,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'" ]; } -- 2.20.1