Changeset 601 for trunk/lib/Utilities.inc.php

Timestamp:

Apr 27, 2017 4:43:35 PM (7 years ago)

Author:

anonymous

Message:

Updated every instance of 'zero' date 0000-00-00 to use 1000-01-01 if mysql version >= 5.7.4

File:

• trunk/lib/Utilities.inc.php (modified) (1 diff)

trunk/lib/Utilities.inc.php

@@ -939 +939 @@
     $db =& DB::getInstance();
 
-    if ($db->isConnected() && version_compare(mysql_get_server_info(), '5.7.4', '>=')) {
+    if ($db->isConnected() && mb_strpos($db->getParam('zero_date'), '-') !== false) {
         // Mysql version >= 5.7.4 stopped allowing a "zero" date of 0000-00-00.
         // https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_no_zero_date
-        $zero_y = '1000';
-        $zero_m = '01';
-        $zero_d = '01';
+        $zero_date_parts = explode('-', $db->getParam('zero_date'));
+        $zero_y = $zero_date_parts[0];
+        $zero_m = $zero_date_parts[1];
+        $zero_d = $zero_date_parts[2];
     } else {
         $zero_y = '0000';