From 759bf4fdce1dfaf0fa7231601d7a742e9918d847 Mon Sep 17 00:00:00 2001 From: David Cook Date: Tue, 21 Oct 2025 03:38:57 +0000 Subject: [PATCH] Bug 41045: Fix BZ 33363 database update This patch fixes the BZ 33363 database update, so that it selects uses with the "suggestions" permission rather than the "catalogue" permission. --- installer/data/mysql/db_revs/240600014.pl | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/db_revs/240600014.pl b/installer/data/mysql/db_revs/240600014.pl index afbbf31204..008085a6f7 100755 --- a/installer/data/mysql/db_revs/240600014.pl +++ b/installer/data/mysql/db_revs/240600014.pl @@ -17,10 +17,10 @@ return { ) && say_success( $out, "Added new permissions suggestions_delete" ); $dbh->do( - q{INSERT IGNORE INTO user_permissions (borrowernumber, module_bit, code) SELECT borrowernumber, 12, 'suggestions_create' FROM borrowers WHERE flags & (1 << 2)} + q{INSERT IGNORE INTO user_permissions (borrowernumber, module_bit, code) SELECT borrowernumber, 12, 'suggestions_create' FROM borrowers WHERE flags & (1 << 12)} ) && say_success( $out, "Added new permissions suggestions_create to patrons with suggestions_manage" ); $dbh->do( - q{INSERT IGNORE INTO user_permissions (borrowernumber, module_bit, code) SELECT borrowernumber, 12, 'suggestions_delete' FROM borrowers WHERE flags & (1 << 2)} + q{INSERT IGNORE INTO user_permissions (borrowernumber, module_bit, code) SELECT borrowernumber, 12, 'suggestions_delete' FROM borrowers WHERE flags & (1 << 12)} ) && say_success( $out, "Added new permissions suggestions_delete to patrons with suggestions_manage" ); }, -- 2.39.5