From 168b3de75cd7161308eab89576df5353e40bae76 Mon Sep 17 00:00:00 2001
From: Phil Sturgeon
Date: Wed, 4 May 2011 09:44:22 +0100
Subject: Reverted partial MySQL driver change which double-escaped some
fields.
---
system/database/drivers/mysql/mysql_driver.php | 6 +++---
user_guide/changelog.html | 1 -
2 files changed, 3 insertions(+), 4 deletions(-)
diff --git a/system/database/drivers/mysql/mysql_driver.php b/system/database/drivers/mysql/mysql_driver.php
index c4691ba0b..4ff9b0a11 100644
--- a/system/database/drivers/mysql/mysql_driver.php
+++ b/system/database/drivers/mysql/mysql_driver.php
@@ -532,7 +532,7 @@ class CI_DB_mysql_driver extends CI_DB {
*/
function _insert($table, $keys, $values)
{
- return "INSERT INTO ".$table." (`".implode('`, `', $keys)."`) VALUES (".implode(', ', $values).")";
+ return "INSERT INTO ".$table." (".implode(', ', $keys).") VALUES (".implode(', ', $values).")";
}
// --------------------------------------------------------------------
@@ -551,7 +551,7 @@ class CI_DB_mysql_driver extends CI_DB {
*/
function _replace($table, $keys, $values)
{
- return "REPLACE INTO ".$table." (`".implode('`, `', $keys)."`) VALUES (".implode(', ', $values).")";
+ return "REPLACE INTO ".$table." (".implode(', ', $keys).") VALUES (".implode(', ', $values).")";
}
// --------------------------------------------------------------------
@@ -569,7 +569,7 @@ class CI_DB_mysql_driver extends CI_DB {
*/
function _insert_batch($table, $keys, $values)
{
- return "INSERT INTO ".$table." (`".implode('`, `', $keys)."`) VALUES ".implode(', ', $values);
+ return "INSERT INTO ".$table." (".implode(', ', $keys).") VALUES ".implode(', ', $values);
}
// --------------------------------------------------------------------
diff --git a/user_guide/changelog.html b/user_guide/changelog.html
index c22414d16..26e9bbc3b 100644
--- a/user_guide/changelog.html
+++ b/user_guide/changelog.html
@@ -128,7 +128,6 @@ Hg Tag: v2.0.1
Fixed issue #41: Added audio/mp3 mime type to mp3.
Fixed a bug (Core #329) where the file caching driver referenced the incorrect cache directory.
Fixed a bug (Reactor #69) where the SHA1 library was named incorrectly.
- MySQL Driver will now wrap field names for insert(), update() and replace() with backticks (`) so fields like "default" and "order" will not cause SQL errors.
Version 2.0.0
--
cgit v1.2.3-24-g4f1b