diff options
| author | anbr <vdr07@deltab.de> | 2013-05-02 16:47:58 +0200 |
|---|---|---|
| committer | anbr <vdr07@deltab.de> | 2013-05-02 16:47:58 +0200 |
| commit | d3aa7c5e0a45901004b40022ea8e66f358f6ce6d (patch) | |
| tree | e8c37f0e0ad2fe73751b045bd558db00d5bb5c4f | |
| parent | cd83cc4def4fd5b2be6e29adda788cfaf10cece9 (diff) | |
| download | xxv-d3aa7c5e0a45901004b40022ea8e66f358f6ce6d.tar.gz xxv-d3aa7c5e0a45901004b40022ea8e66f358f6ce6d.tar.bz2 | |
Option 'SQL_CACHE' used twice in statement (Closes: #1356)
| -rw-r--r-- | lib/XXV/MODULES/USER.pm | 2 |
1 files changed, 1 insertions, 1 deletions
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(); |