Bugzilla – Attachment 144669 Details for
Bug 32470
(Bug 14783 follow-up) Fix mysql error in db_rev for 22.06.000.064
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 32470: (Bug 14783 follow-up) Fix mysql error in db_rev for 22.06.000.064
Bug-32470-Bug-14783-follow-up-Fix-mysql-error-in-d.patch (text/plain), 1.53 KB, created by
Tomás Cohen Arazi
on 2022-12-16 11:38:47 UTC
(
hide
)
Description:
Bug 32470: (Bug 14783 follow-up) Fix mysql error in db_rev for 22.06.000.064
Filename:
MIME Type:
Creator:
Tomás Cohen Arazi
Created:
2022-12-16 11:38:47 UTC
Size:
1.53 KB
patch
obsolete
>From 42d60ad8505e5717c277ecfebb850123bd94ec21 Mon Sep 17 00:00:00 2001 >From: Michael Hafen <michael.hafen@washk12.org> >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 <tomascohen@theke.io> >--- > 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 7aaa4e56584..abf9aae2792 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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 32470
:
144592
| 144669