aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--README.txt10
1 files 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.