[Koha-bugs] [Bug 4014] New: Dublicate addition of issn key in updatedatabase30.pl

[bugzilla-daemon at kohaorg.ec2.liblime.com]

http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4014

           Summary: Dublicate addition of issn key in updatedatabase30.pl
           Product: Koha
           Version: rel_3_0
          Platform: PC
        OS/Version: Linux - Debian
            Status: NEW
          Severity: enhancement
          Priority: P5
         Component: Installation (web-based installer)
        AssignedTo: henridamien at koha-fr.org
        ReportedBy: dubyk at library.lviv.ua
   Estimated Hours: 0.0
 Change sponsored?: ---


After updationg Koha from 3.0.3 to 3.0.5
I have warning:
[Mon Dec 28 18:14:18 2009] updatedatabase.pl: DBD::mysql::db do failed:
Duplicate key name 'issn' at
/usr/share/koha3/intranet/cgi-bin/installer/data/mysql/updatedatabase30.pl line
443. 

After look on updatedatabase30.pl I found 2 next entries:
1)
$DBversion = "3.00.02.002";
#$DBversion = '3.01.00.006';
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
    $dbh->do("ALTER TABLE `biblioitems` ADD KEY issn (issn)");
    print "Upgrade to $DBversion done (add index on biblioitems.issn)\n";
    SetVersion ($DBversion);
}

2)
$DBversion = '3.00.04.006';
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
    $dbh->do("ALTER TABLE `biblioitems` ADD KEY issn (issn)");
    print "Upgrade to $DBversion done (add index on biblioitems.issn)\n";
    SetVersion ($DBversion);
}

One additon of biblioitems.issn need to be removed


-- 
Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.