diff options
-rw-r--r-- | README.txt | 10 |
1 files changed, 2 insertions, 8 deletions
@@ -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. |