From 3213ffc859f8aeca8fb8bbf4cd9626a4f448f603 Mon Sep 17 00:00:00 2001 From: Nahuel Angelinetti 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 --- 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