From 3213ffc859f8aeca8fb8bbf4cd9626a4f448f603 Mon Sep 17 00:00:00 2001
From: Nahuel Angelinetti <nahuel.angelinetti@biblibre.com>
Date: Thu, 4 Dec 2008 16:45:30 +0100
Subject: [PATCH] fix the sql request to work in all mysqls

Signed-off-by: Galen Charlton <galen.charlton@liblime.com>
---
 C4/Auth.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)
 mode change 100644 => 100755 C4/Auth.pm

diff --git a/C4/Auth.pm b/C4/Auth.pm
old mode 100644
new mode 100755
index b98c828078..ae7b2b2e8b
--- a/C4/Auth.pm
+++ b/C4/Auth.pm
@@ -1341,7 +1341,7 @@ sub get_user_subpermissions {
     my $userid = shift;
 
     my $dbh = C4::Context->dbh;
-    my $sth = $dbh->prepare("SELECT flag, code
+    my $sth = $dbh->prepare("SELECT flag, user_permissions.code
                              FROM user_permissions
                              JOIN permissions USING (module_bit, code)
                              JOIN userflags ON (module_bit = bit)
-- 
2.39.5