From 6b9006ea616143af8e82e2fb46c766a43b944e51 Mon Sep 17 00:00:00 2001 From: Michael Hafen Date: Wed, 14 Dec 2022 11:45:47 -0700 Subject: [PATCH] (Bug 14783 follow-up) Fix mysql error in db_rev 22.06.000.064 Content-Type: text/plain; charset="utf-8" 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. --- 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.34.1