Changeset 601 for trunk/lib/DB.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/DB.inc.php (modified) (3 diffs)

trunk/lib/DB.inc.php

@@ -65 +65 @@
         // Script stops on db error. TRUE recommended for production sites.
         'db_die_on_failure' => true,
+
+        // Special date settings. These will dynamically changes depending on MySQL version or settings.
+        'zero_date' => '0000-00-00',
+        'infinity_date' => '9999-12-31',
     );
 
@@ -78 +82 @@
 
     /**
+     * Constructor.
+     */
+    public function __construct()
+    {
+        // Initialize default parameters.
+        $this->_params = array_merge($this->_params, $this->_param_defaults);
+    }
+
+    /**
      * This method enforces the singleton pattern for this class.
      *
@@ -181 +194 @@
         } else {
             $app->logMsg(sprintf('%s is not a known character_set.', $app->getParam('character_set')), LOG_ERR, __FILE__, __LINE__);
+        }
+
+        // Update config for this version of MySQL.
+        if (version_compare(mysql_get_server_info(), '5.7.4', '>=')) {
+            $this->setParam(array('zero_date' => '1000-01-01'));
         }