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.bortel@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