From 95c796b40a4ee8d32c119435f9b4cdbeaeae3f43 Mon Sep 17 00:00:00 2001 From: Owen Leonard 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 --- 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