From fbdf06df72ff7495d8734d3cb8cee46795f53ce5 Mon Sep 17 00:00:00 2001 From: Lucas Gass Date: Wed, 10 Dec 2025 14:06:51 +0000 Subject: [PATCH] Bug 41421: [22.11.x] Fix DB update --- installer/data/mysql/db_revs/221132001.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/db_revs/221132001.pl b/installer/data/mysql/db_revs/221132001.pl index 0e630b0aa8e..bc5c4236e4e 100755 --- a/installer/data/mysql/db_revs/221132001.pl +++ b/installer/data/mysql/db_revs/221132001.pl @@ -15,7 +15,7 @@ return { say $out "Added new permission 'merge_borrowers'"; $dbh->do( - q{INSERT INTO user_permissions (borrowernumber, module_bit, code) SELECT borrowernumber, module_bit, 'merge_borrowers' FROM user_permissions where module_bit = 4 and code = 'edit_borrowers';} + q{INSERT IGNORE INTO user_permissions (borrowernumber, module_bit, code) SELECT borrowernumber, module_bit, 'merge_borrowers' FROM user_permissions where module_bit = 4 and code = 'edit_borrowers';} ); say $out "Added 'merge_borrowers' permission to existing users with 'edit_borrowers'"; -- 2.39.5