From 7304a2e89bfe9e0b1c933dfd279d3ce74826b71c Mon Sep 17 00:00:00 2001 From: Joshua Ferraro Date: Mon, 9 Jun 2008 09:53:23 -0500 Subject: [PATCH] Revert "Bug fixing : get_user_permissions SQL Fixing" From Galen: because code is part of the join, there is in fact no ambiguity This reverts commit 3a05ae40f6d03a8399e4653da1761f5dde7e23ea. --- C4/Auth.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Auth.pm b/C4/Auth.pm index 61711d91b1..355633600c 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, permissions.code + my $sth = $dbh->prepare("SELECT flag, code FROM user_permissions JOIN permissions USING (module_bit, code) JOIN userflags ON (module_bit = bit) -- 2.39.5