From fe17e62308bac8b3d8d2564081e5bcc37f8f579f Mon Sep 17 00:00:00 2001 From: Michael Hafen Date: Wed, 14 Dec 2022 11:45:47 -0700 Subject: [PATCH] Bug 32470: (Bug 14783 follow-up) Fix mysql error in db_rev for 22.06.000.064 Fix MySQL error: ERROR 1093 (HY000): You can't specify target table 'systempreferences' for update in FROM clause introduced by db_rev 064 for bug 14783. Signed-off-by: Tomas Cohen Arazi (cherry picked from commit 42d60ad8505e5717c277ecfebb850123bd94ec21) Signed-off-by: Martin Renvoize --- installer/data/mysql/db_revs/220600064.pl | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/db_revs/220600064.pl b/installer/data/mysql/db_revs/220600064.pl index 7aaa4e5658..abf9aae279 100755 --- a/installer/data/mysql/db_revs/220600064.pl +++ b/installer/data/mysql/db_revs/220600064.pl @@ -14,11 +14,17 @@ return { say $out "Added new system preference 'OPACAllowUserToChangeBranch'"; + my ($value) = $dbh->selectrow_array(q{ + SELECT CASE WHEN value=1 THEN 'intransit' ELSE '' END + FROM systempreferences + WHERE variable='OPACInTransitHoldPickupLocationChange' + }); + $dbh->do(q{ UPDATE systempreferences - SET value=(SELECT CASE WHEN value=1 THEN 'intransit' ELSE '' END FROM systempreferences WHERE variable='OPACInTransitHoldPickupLocationChange') + SET value=(?) WHERE variable='OPACAllowUserToChangeBranch' - }); + }, undef, $value); $dbh->do(q{ DELETE FROM systempreferences -- 2.39.5