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@koha-fr.org ReportedBy: dubyk@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.