From d3aa7c5e0a45901004b40022ea8e66f358f6ce6d Mon Sep 17 00:00:00 2001
From: anbr <vdr07@deltab.de>
Date: Thu, 2 May 2013 16:47:58 +0200
Subject: Option 'SQL_CACHE' used twice in statement (Closes: #1356)

---
 lib/XXV/MODULES/USER.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'lib')

diff --git a/lib/XXV/MODULES/USER.pm b/lib/XXV/MODULES/USER.pm
index e82cec5..3ffdda1 100644
--- a/lib/XXV/MODULES/USER.pm
+++ b/lib/XXV/MODULES/USER.pm
@@ -928,7 +928,7 @@ sub _checkSession {
 
     my $user;
     # check User
-    my $sth = $self->{dbh}->prepare('SELECT SQL_CACHE SQL_CACHE USER.Id as Id,Name,Level,Prefs,UserPrefs,Deny,MaxLifeTime,MaxPriority,sid from USER,SESSION where USER.Id = SESSION.uid and SESSION.sid = ( ? ) and SESSION.source = ( ? ) and SESSION.expires > NOW()');
+    my $sth = $self->{dbh}->prepare('SELECT SQL_CACHE USER.Id as Id,Name,Level,Prefs,UserPrefs,Deny,MaxLifeTime,MaxPriority,sid from USER,SESSION where USER.Id = SESSION.uid and SESSION.sid = ( ? ) and SESSION.source = ( ? ) and SESSION.expires > NOW()');
     $sth->execute($sid, $ip)
         or return error sprintf("Couldn't execute query: %s.",$sth->errstr);
     $user = $sth->fetchrow_hashref();
-- 
cgit v1.2.3