From 7957368c34f103bc07b3e439c3404ba82b0bf182 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 --- installer/data/mysql/db_revs/230600006.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/db_revs/230600006.pl b/installer/data/mysql/db_revs/230600006.pl index 4d1eac19c5..52828d97d4 100755 --- a/installer/data/mysql/db_revs/230600006.pl +++ b/installer/data/mysql/db_revs/230600006.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