From 3a05ae40f6d03a8399e4653da1761f5dde7e23ea Mon Sep 17 00:00:00 2001 From: Henri-Damien LAURENT Date: Wed, 4 Jun 2008 11:58:17 +0200 Subject: [PATCH] Bug fixing : get_user_permissions SQL Fixing user_sub_permissions join introduced ambivalence for permissions field Signed-off-by: Joshua Ferraro --- C4/Auth.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Auth.pm b/C4/Auth.pm index 355633600c..61711d91b1 100755 --- a/C4/Auth.pm +++ b/C4/Auth.pm @@ -1263,7 +1263,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, permissions.code FROM user_permissions JOIN permissions USING (module_bit, code) JOIN userflags ON (module_bit = bit) -- 2.39.5