From cdeda159e10d289d709f1f989ff8d51386f72dd5 Mon Sep 17 00:00:00 2001 From: Yuchen Pei Date: Fri, 30 Sep 2022 15:19:00 +1000 Subject: simplifying instruction to remove strict_trans_tables mode --- README.txt | 10 ++-------- 1 file changed, 2 insertions(+), 8 deletions(-) diff --git a/README.txt b/README.txt index d344de6..ecdd8d2 100644 --- a/README.txt +++ b/README.txt @@ -23,19 +23,13 @@ TODO: It is not clear what are the exact php modules required for the site to ru On a Debian-like system, the following command should be sufficient: # apt install apache2 mysql-server php libapache2-mod-php php-mysql php-xml - # a2enmod rewite + # a2enmod rewrite You may need to turn off the STRICT_TRANS_TABLES sql mode to avoid query errors. In a sql shell, do - > SELECT @@GLOBAL.sql_mode; - -Note all the modes in the output, and set the mode to exclude the STRICT_TRANS_TABLES. - -For example, if the output was "NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES", do - - > SET GLOBAL sql_mode = "NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"; + > SET GLOBAL sql_mode = REPLACE(@@GLOBAL.SQL_MODE, 'STRICT_TRANS_TABLES', ''); * FIXME: apparently this is not needed in some cases. Find the root cause. -- cgit v1.2.3