From ed6f891cbfcd370e5bbab2d3d12c2b30fa4640b7 Mon Sep 17 00:00:00 2001 From: Fridolyn SOMERS Date: Wed, 5 Jun 2013 14:16:14 +0200 Subject: [PATCH] [PASSED QA] Bug 6898 - updatedatabase second query not executed 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 --- 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 adc1e7f..ef67c6b 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 -- 1.7.9.5