Attachment 116688 Details for Bug 27652 – Bug 27652: (follow-up) Correct typo in database update

[patch] Bug 27652: (follow-up) Correct typo in database update

Bug-27652-follow-up-Correct-typo-in-database-updat.patch (text/plain), 1.10 KB, created by Owen Leonard on 2021-02-10 19:27:16 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Owen Leonard

Created: 2021-02-10 19:27:16 UTC

Size: 1.10 KB

patch

obsolete

>From 969519217154cfed3cfc5d44af9ee7bc43efcc04 Mon Sep 17 00:00:00 2001
>From: Owen Leonard <oleonard@myacpl.org>
>Date: Wed, 10 Feb 2021 18:58:57 +0000
>Subject: [PATCH] Bug 27652: (follow-up) Correct typo in database update
>
>This patch adds a missing "SET" in the database update. Before:
>
>   UPDATE systempreferences
>   value=REPLACE(value, '|', ',')
>
>Corrected:
>
>   UPDATE systempreferences
>   SET value=REPLACE(value, '|', ',')
>---
> installer/data/mysql/atomicupdate/bug_27652.perl | 2 +-
> 1 file changed, 1 insertion(+), 1 deletion(-)
>
>diff --git a/installer/data/mysql/atomicupdate/bug_27652.perl b/installer/data/mysql/atomicupdate/bug_27652.perl
>index 13a1f75b91..ba0581bf3f 100644
>--- a/installer/data/mysql/atomicupdate/bug_27652.perl
>+++ b/installer/data/mysql/atomicupdate/bug_27652.perl
>@@ -3,7 +3,7 @@ if( CheckVersion( $DBversion ) ) {
> 
>     $dbh->do(q{
>         UPDATE systempreferences
>-        value=REPLACE(value, '|', ',')
>+        SET value=REPLACE(value, '|', ',')
>         WHERE variable="OPACHoldsIfAvailableAtPickupExceptions"
>            OR variable="BatchCheckoutsValidCategories"
>     });
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 27652: 116605 | 116687 | 116688 | 117225 | 117226 | 117892 | 117893