From: Alan Knowles <alan@roojs.com>
Date: Tue, 9 Oct 2018 07:42:53 +0000 (+0800)
Subject: UpdateDatabase.php
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=0218268810b9373c03e468ad2ab1930d0e9112cd

UpdateDatabase.php
---

diff --git a/UpdateDatabase.php b/UpdateDatabase.php
index 7c3a1cb4..e66b5b57 100644
--- a/UpdateDatabase.php
+++ b/UpdateDatabase.php
@@ -1055,7 +1055,9 @@ class Pman_Core_UpdateDatabase extends Pman
                     in_array('STRICT_TRANS_TABLES', $modes) || 
                     !in_array('ALLOW_INVALID_DATES', $modes)
             ){
-                die("Error: set sql_mode include 'ALLOW_INVALID_DATES', remove 'NO_ZERO_IN_DATE' AND 'STRICT_TRANS_TABLES' AND 'NO_ZERO_DATE' in my.cnf\n\n");
+                die("Error: set sql_mode include 'ALLOW_INVALID_DATES', remove 'NO_ZERO_IN_DATE' AND 'STRICT_TRANS_TABLES' AND 'NO_ZERO_DATE' in my.cnf\n\n".
+                    "Recommended line: \n\nsql_mode = ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,ALLOW_INVALID_DATES\n\n"
+                    );
             }
         }