Thanks for reporting this, it is a problem in the fresh 3.18.12 release, see http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14820#c8 where I have just reported the issue to Liz.
2015-11-05 15:43 GMT+00:00 Bortel, Gary <gary.bor...@sos.wa.gov>: > I, too, am seeing these two MySQL errors (1060 & 1062) thrown when trying to > update from 3.18.11 --> 3.18.12. There never seemed to be a resolution posted > to this issue. Is it benign as Doug suggested or something about which > concern should be raised? > > The installation here is Ubuntu 14.04.3 with a package install of Koha. > > . > . > . > . > Upgrading database schema for abc > Upgrade to 3.18.11.001 > Done (Bug 14820: SMSSendUsername and SMSSendPassword are not listed in the > system preferences) > Upgrade to 3.18.12.000 > Done (3.18.12.000 release) > DEV atomic update: hourlyloans.sql > C4::Installer::load_sql returned the following errors while attempting to > load > /usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate/hourlyloans.sql: > ERROR 1060 (42S21) at line 1: Duplicate column name 'lengthunit' > DEV atomic update: oai_sets.sql > C4::Installer::load_sql returned the following errors while attempting to > load > /usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate/oai_sets.sql: > ERROR 1062 (23000) at line 35: Duplicate entry 'OAI-PMH:AutoUpdateSets' for > key 'PRIMARY' > Upgrading database schema for xyz > Upgrade to 3.18.11.001 > Done (Bug 14820: SMSSendUsername and SMSSendPassword are not listed in the > system preferences) > Upgrade to 3.18.12.000 > Done (3.18.12.000 release) > DEV atomic update: hourlyloans.sql > C4::Installer::load_sql returned the following errors while attempting to > load > /usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate/hourlyloans.sql: > ERROR 1060 (42S21) at line 1: Duplicate column name 'lengthunit' > DEV atomic update: oai_sets.sql > C4::Installer::load_sql returned the following errors while attempting to > load > /usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate/oai_sets.sql: > ERROR 1062 (23000) at line 35: Duplicate entry 'OAI-PMH:AutoUpdateSets' for > key 'PRIMARY' > . > . > . > . > > > Thanks > gcb > > >> While doing a upgrade on our test koha instance (based on a copy of >> production), I received the following errors.: >> >> - [Sat Oct 24 23:52:23 2015] updatedatabase.pl: C4::Installer::load_sql >> returned the following errors while attempting to load >> >> /home/koha/koha-test/intranet/cgi-bin/installer/data/mysql/atomicupdate/hourlyloans.sql: >> - [Sat Oct 24 23:52:23 2015] updatedatabase.pl: ERROR 1060 (42S21) at >> line 1: Duplicate column name 'lengthunit' >> - [Sat Oct 24 23:52:23 2015] updatedatabase.pl: C4::Installer::load_sql >> returned the following errors while attempting to load >> >> /home/koha/koha-test/intranet/cgi-bin/installer/data/mysql/atomicupdate/oai_sets.sql: >> - [Sat Oct 24 23:52:23 2015] updatedatabase.pl: ERROR 1062 (23000) at >> line 35: Duplicate entry 'OAI-PMH:AutoUpdateSets' for key 'PRIMARY' >> >> I know from previous experience that these kinds of error are sometimes >> benign, but I would like some feedback on whether I need to take any kind >> of action in this particular case. >> >> Thanks, >> -Doug- > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha