From c6bf2670502afbd12981aa5e913779c38c19bdc4 Mon Sep 17 00:00:00 2001 From: Fridolyn SOMERS Date: Wed, 5 Jun 2013 14:16:14 +0200 Subject: [PATCH] Bug 6898: fix DB update that assigns the circulate/overdues_report permission This patch fixes a bug that prevented the circulate/overdues_report permission from being assigned to staff users during upgrade. This patch will not affect databases that are already running 3.12.x or later. Signed-off-by: Chris Cormack Signed-off-by: Katrin Fischer This will only fix the permissions for updates done after the patch has been applied. But I agree with Fridolyn, that we can not safely update permissions for existing installations. Signed-off-by: Katrin Fischer Signed-off-by: Galen Charlton --- installer/data/mysql/updatedatabase.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index adc1e7f60e..ef67c6b8ef 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -6492,7 +6492,7 @@ if ( CheckVersion($DBversion) ) { VALUES ( '1', 'overdues_report', 'Execute overdue items report' ) }); # add new permission for users with all report permissions and circulation remaining permission - my $sth = $dbh->prepare(q{ + $dbh->do(q{ INSERT INTO user_permissions (borrowernumber, module_bit, code) SELECT user_permissions.borrowernumber, 1, 'overdues_report' FROM user_permissions -- 2.39.5