[Koha-patches] [PATCH] [bug #2844] fix the sql request to work in all mysqls
Nahuel Angelinetti
nahuel.angelinetti at biblibre.com
Thu Dec 4 16:45:30 CET 2008
---
C4/Auth.pm | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/C4/Auth.pm b/C4/Auth.pm
index 029a957..ac98772 100755
--- 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)
--
1.5.6.3
More information about the Koha-patches
mailing list