Bugzilla – Attachment 120680 Details for
Bug 28298
DBRev 19.12.00.076 broken
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 28298: fix DB update 19.12.00.076
Bug-28298-fix-DB-update-191200076.patch (text/plain), 2.04 KB, created by
Nick Clemens (kidclamp)
on 2021-05-07 11:26:13 UTC
(
hide
)
Description:
Bug 28298: fix DB update 19.12.00.076
Filename:
MIME Type:
Creator:
Nick Clemens (kidclamp)
Created:
2021-05-07 11:26:13 UTC
Size:
2.04 KB
patch
obsolete
>From 5fae9a2dbf3371f1df90107c6a4cddfcb548035f Mon Sep 17 00:00:00 2001 >From: Alex Arnaud <alex.arnaud@biblibre.com> >Date: Fri, 7 May 2021 09:58:09 +0200 >Subject: [PATCH] Bug 28298: fix DB update 19.12.00.076 > >Signed-off-by: Nick Clemens <nick@bywatersolutions.com> >--- > installer/data/mysql/updatedatabase.pl | 4 ++-- > 1 file changed, 2 insertions(+), 2 deletions(-) > >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index bb438f901f..d8301fb5cf 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -21708,7 +21708,7 @@ if( CheckVersion( $DBversion ) ) { > if ( @$serials ) { > push @warnings, q|WARNING - The following serials will be updated, they were attached to a different biblionumber than their related subscription: | . join ", ", map { $_->{serialid} } @$serials; > $dbh->do(q| >- UPDATE serial JOIN subscription USING (subcriptionid) SET serial.biblionumber = subscription.biblionumber WHERE serial.biblionumber != subscription.biblionumber >+ UPDATE serial JOIN subscription USING (subscriptionid) SET serial.biblionumber = subscription.biblionumber WHERE serial.biblionumber != subscription.biblionumber > |); > } > $serials = $dbh->selectall_arrayref(q| >@@ -21755,7 +21755,7 @@ if( CheckVersion( $DBversion ) ) { > > unless ( foreign_key_exists( 'subscriptionhistory', 'subscription_history_ibfk_1' ) ) { > $dbh->do(q| >- UPDATE subscriptionhistory JOIN subscription USING (subcriptionid) SET subscriptionhistory.biblionumber = subscription.biblionumber WHERE subscriptionhistory.biblionumber != subscription.biblionumber >+ UPDATE subscriptionhistory JOIN subscription USING (subscriptionid) SET subscriptionhistory.biblionumber = subscription.biblionumber WHERE subscriptionhistory.biblionumber != subscription.biblionumber > |); > $dbh->do(q| > DELETE FROM subscriptionhistory WHERE biblionumber NOT IN (SELECT biblionumber FROM biblio) >-- >2.11.0
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 28298
:
120660
| 120680