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

trunk/lib/Lock.inc.php

@@ -117 +117 @@
                 $app->logMsg(sprintf('Dropping and recreating table %s.', $this->getParam('db_table')), LOG_INFO, __FILE__, __LINE__);
             }
-            $db->query("CREATE TABLE IF NOT EXISTS " . $db->escapeString($this->getParam('db_table')) . " (
+            $db->query(sprintf("CREATE TABLE IF NOT EXISTS %s (
                 lock_id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
                 record_table varchar(255) NOT NULL default '',
@@ -124 +124 @@
                 title varchar(255) NOT NULL default '',
                 set_by_admin_id smallint(11) NOT NULL default '0',
-                lock_datetime datetime NOT NULL default '0000-00-00 00:00:00',
+                lock_datetime datetime NOT NULL default '%s 00:00:00',
                 KEY record_table (record_table),
                 KEY record_key (record_key),
                 KEY record_val (record_val)
-            )");
+            )", $db->escapeString($this->getParam('db_table')), $db->getParam('zero_date')));
 
             if (!$db->columnExists($this->getParam('db_table'), array(