Bugzilla – Attachment 188182 Details for
Bug 41045
Suggestions manage permissions added to patrons who previously had no permissions in that category
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 41045: Fix BZ 33363 database update
Bug-41045-Fix-BZ-33363-database-update.patch (text/plain), 1.74 KB, created by
David Cook
on 2025-10-21 03:40:06 UTC
(
hide
)
Description:
Bug 41045: Fix BZ 33363 database update
Filename:
MIME Type:
Creator:
David Cook
Created:
2025-10-21 03:40:06 UTC
Size:
1.74 KB
patch
obsolete
>From 759bf4fdce1dfaf0fa7231601d7a742e9918d847 Mon Sep 17 00:00:00 2001 >From: David Cook <dcook@prosentient.com.au> >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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 41045
: 188182