View | Details | Raw Unified | Return to bug 28298
Collapse All | Expand All

(-)a/installer/data/mysql/updatedatabase.pl (-3 / +2 lines)
Lines 21708-21714 if( CheckVersion( $DBversion ) ) { Link Here
21708
        if ( @$serials ) {
21708
        if ( @$serials ) {
21709
            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;
21709
            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;
21710
            $dbh->do(q|
21710
            $dbh->do(q|
21711
                UPDATE serial JOIN subscription USING (subcriptionid) SET serial.biblionumber = subscription.biblionumber WHERE serial.biblionumber != subscription.biblionumber
21711
                UPDATE serial JOIN subscription USING (subscriptionid) SET serial.biblionumber = subscription.biblionumber WHERE serial.biblionumber != subscription.biblionumber
21712
            |);
21712
            |);
21713
        }
21713
        }
21714
        $serials = $dbh->selectall_arrayref(q|
21714
        $serials = $dbh->selectall_arrayref(q|
Lines 21755-21761 if( CheckVersion( $DBversion ) ) { Link Here
21755
21755
21756
    unless ( foreign_key_exists( 'subscriptionhistory', 'subscription_history_ibfk_1' ) ) {
21756
    unless ( foreign_key_exists( 'subscriptionhistory', 'subscription_history_ibfk_1' ) ) {
21757
        $dbh->do(q|
21757
        $dbh->do(q|
21758
            UPDATE subscriptionhistory JOIN subscription USING (subcriptionid) SET subscriptionhistory.biblionumber = subscription.biblionumber WHERE subscriptionhistory.biblionumber != subscription.biblionumber
21758
            UPDATE subscriptionhistory JOIN subscription USING (subscriptionid) SET subscriptionhistory.biblionumber = subscription.biblionumber WHERE subscriptionhistory.biblionumber != subscription.biblionumber
21759
        |);
21759
        |);
21760
        $dbh->do(q|
21760
        $dbh->do(q|
21761
            DELETE FROM subscriptionhistory WHERE biblionumber NOT IN (SELECT biblionumber FROM biblio)
21761
            DELETE FROM subscriptionhistory WHERE biblionumber NOT IN (SELECT biblionumber FROM biblio)
21762
- 

Return to bug 28298