From 6b25e526bfeee0b4537e132caca32a10d2ade4e7 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, '|', ',')

Signed-off-by: David Nind <david@davidnind.com>

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
---
 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.20.1