From ab1e0a5d6ad2eb31e4322ec11a1e971386144f5d Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Tue, 18 Oct 2022 09:02:44 -0300 Subject: [PATCH] Bug 14783: (follow-up) Fix problematic db_rev Signed-off-by: Tomas Cohen Arazi --- installer/data/mysql/db_revs/220600064.pl | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/installer/data/mysql/db_revs/220600064.pl b/installer/data/mysql/db_revs/220600064.pl index fe5f7c04c4..afd6b73d88 100755 --- a/installer/data/mysql/db_revs/220600064.pl +++ b/installer/data/mysql/db_revs/220600064.pl @@ -13,9 +13,9 @@ return { }); $dbh->do(q{ - UPDATE systempreferences SET value = (SELECT CASE WHEN value = 1 THEN 'intransit' ELSE '' END - FROM systempreferences - WHERE variable = 'OPACInTransitHoldPickupLocationChange') + UPDATE systempreferences + SET value=(SELECT CASE WHEN value=1 THEN 'intransit' ELSE '' END FROM systempreferences WHERE variable='OPACInTransitHoldPickupLocationChange') + WHERE variable='OPACAllowUserToChangeBranch' }); say $out "Added new system preference 'OPACAllowUserToChangeBranch'"; -- 2.39.5