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

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +11 lines)
Lines 37-42 use Getopt::Long; Link Here
37
use C4::Context;
37
use C4::Context;
38
use C4::Installer;
38
use C4::Installer;
39
use C4::Dates;
39
use C4::Dates;
40
use Koha::Database;
40
41
41
use MARC::Record;
42
use MARC::Record;
42
use MARC::File::XML ( BinaryEncoding => 'utf8' );
43
use MARC::File::XML ( BinaryEncoding => 'utf8' );
Lines 8482-8487 if(CheckVersion($DBversion)) { Link Here
8482
    $dbh->do(qq{
8483
    $dbh->do(qq{
8483
        UPDATE issues SET issue_id = issue_id + ( SELECT COUNT(*) FROM old_issues ) ORDER BY issue_id DESC
8484
        UPDATE issues SET issue_id = issue_id + ( SELECT COUNT(*) FROM old_issues ) ORDER BY issue_id DESC
8484
    });
8485
    });
8486
8487
    my $schema = Koha::Database->new()->schema();
8488
    my $max_issue_id = $schema->resultset('Issue')->get_column('issue_id')->max();
8489
    $max_issue_id ||= $schema->resultset('OldIssue')->get_column('issue_id')->max();
8490
    $max_issue_id ||= 0;
8491
    $max_issue_id++;
8492
    $dbh->do(qq{
8493
        ALTER TABLE issues AUTO_INCREMENT = $max_issue_id
8494
    });
8495
8485
    print "Upgrade to $DBversion done (Bug 9303 - relative's checkouts in the opac)\n";
8496
    print "Upgrade to $DBversion done (Bug 9303 - relative's checkouts in the opac)\n";
8486
    SetVersion($DBversion);
8497
    SetVersion($DBversion);
8487
}
8498
}
8488
- 

Return to bug 9303