[Koha] DB errors during upgrade from 3.18.09 to 3.20.04

[Jonathan Druart]

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 at 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 at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha