From a82e1fe2b96af1d7ed2234562893a79c8207cb9e Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Thu, 21 Feb 2008 20:12:47 +0000
Subject: - Patch #212918 by chx: fixed SQL queries on mysqli.

---
 includes/database.mysqli.inc | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'includes')

diff --git a/includes/database.mysqli.inc b/includes/database.mysqli.inc
index b1b4f3b7f..4cc3945d0 100644
--- a/includes/database.mysqli.inc
+++ b/includes/database.mysqli.inc
@@ -81,6 +81,8 @@ function db_connect($url) {
 
   // Force UTF-8.
   mysqli_query($connection, 'SET NAMES "utf8"');
+  // Require ANSI mode to improve SQL portability.
+  mysqli_query($connection, "SET SESSION sql_mode='ANSI'");
 
   return $connection;
 }
@@ -120,8 +122,6 @@ function _db_query($query, $debug = 0) {
   }
 
   if (!mysqli_errno($active_db)) {
-    // Require ANSI mode to improve SQL portability.
-    mysqli_query($active_db, "SET SESSION sql_mode='ANSI'");
     return $result;
   }
   else {
-- 
cgit v1.2.3