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

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +21 lines)
Lines 9628-9633 if ( CheckVersion($DBversion) ) { Link Here
9628
    SetVersion($DBversion);
9628
    SetVersion($DBversion);
9629
}
9629
}
9630
9630
9631
$DBversion = "3.19.00.XXX";
9632
if ( CheckVersion($DBversion) ) {
9633
    $dbh->do(q{
9634
        UPDATE statistics
9635
        SET itemtype =
9636
        (
9637
            SELECT u.itype FROM
9638
            (
9639
                SELECT itype,itemnumber FROM items
9640
                UNION ALL
9641
                SELECT itype,itemnumber FROM deleteditems
9642
            ) u
9643
            WHERE statistics.itemnumber = u.itemnumber
9644
            LIMIT 1
9645
        )
9646
        WHERE type IN ('localuse', 'return')
9647
    });
9648
    print "upgrade to $DBversion done (Bug 9351 - item type not recorded correctly in statistics for returns and some local use)\n";
9649
    SetVersion ($DBversion);
9650
}
9651
9631
=head1 FUNCTIONS
9652
=head1 FUNCTIONS
9632
9653
9633
=head2 TableExists($table)
9654
=head2 TableExists($table)
9634
- 

Return to bug 9351