Attachment 154309 Details for Bug 33117 – Bug 33117: Make dbrev idempotent

[patch] Bug 33117: Make dbrev idempotent

Bug-33117-Make-dbrev-idempotent.patch (text/plain), 1.12 KB, created by Tomás Cohen Arazi (tcohen) on 2023-08-07 18:30:45 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Tomás Cohen Arazi (tcohen)

Created: 2023-08-07 18:30:45 UTC

Size: 1.12 KB

patch

obsolete

>From 951e67a1b3dd1f26eddeaecd2dc63991f9667927 Mon Sep 17 00:00:00 2001
>From: Tomas Cohen Arazi <tomascohen@theke.io>
>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 <tomascohen@theke.io>
>---
> 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 4d1eac19c59..52828d97d4c 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.41.0

Actions: View | Diff | Splinter Review

Attachments on bug 33117: 148018 | 148027 | 148095 | 148131 | 148138 | 148278 | 148279 | 148280 | 148282 | 148336 | 148383 | 148384 | 148443 | 148445 | 148467 | 148481 | 150781 | 150896 | 150897 | 150898 | 151090 | 151091 | 151302 | 151314 | 151317 | 151769 | 151771 | 151825 | 151845 | 152549 | 152552 | 152554 | 152555 | 152556 | 152562 | 152563 | 152564 | 152565 | 154309