From b5e1b2137fddf6a0ad854ffdb10c103a00c4f7fd Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Mon, 7 Aug 2023 15:13:46 -0300 Subject: [PATCH] Bug 33117: Make dbrev idempotent QA didn't spot the issue, nor I. So fixing now. Signed-off-by: Tomas Cohen Arazi (cherry picked from commit 951e67a1b3dd1f26eddeaecd2dc63991f9667927) Signed-off-by: Fridolin Somers (cherry picked from commit caa46019d07d89474feee02c7a2f8961e7414283) Signed-off-by: Pedro Amorim --- installer/data/mysql/db_revs/221107002.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/db_revs/221107002.pl b/installer/data/mysql/db_revs/221107002.pl index 4d1eac19c5..52828d97d4 100755 --- a/installer/data/mysql/db_revs/221107002.pl +++ b/installer/data/mysql/db_revs/221107002.pl @@ -8,7 +8,7 @@ return { my ( $dbh, $out ) = @$args{qw(dbh out)}; $dbh->do(q{ - INSERT INTO systempreferences (`variable`,`value`,`explanation`,`options`,`type`) + INSERT IGNORE INTO systempreferences (`variable`,`value`,`explanation`,`options`,`type`) VALUES ('DefaultPatronSearchMethod','starts_with','Allows staff to set a default method when searching for patrons with autocomplete','starts_with|contains','Choice'); }); -- 2.39.5