[Koha] Koha upgrade 3.18.11 --> 3.20.07

[Jonathan Druart]

Hi Gary,

> DBD::mysql::db do failed: Can't create table 'koha_library.#sql-4b9_42' (errno: 121) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10584.

I would say that the foreign key on course_reserves has not been created.
You should check the data in course_items (some don't have a
correspondence in course_reserves).

> DBD::mysql::db do failed: Duplicate entry '1-self_checkout' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10614.

You can forget this one, you already had the self_checkout syspref in
your database.

Regards,
Jonathan

2016-01-11 16:02 GMT+00:00 Bortel, Gary <gary.bortel at sos.wa.gov>:
> I am seeing two MySQL errors thrown when trying to update from 3.18.11 --> 3.20.07. Are these benign or something about which concern should be raised?
>
> The installation here is Ubuntu 14.04.3 with a multi-tenant package install of Koha. Mysql  Ver 14.14 Distrib 5.5.46, for debian-linux-gnu (x86_64) using readline 6.3
>
> .
> .
> .
> .
> Upgrade to 3.20.00.002 done (Bug 5010: Fix OPACBaseURL to include protocol)
> Upgrade to 3.20.01.000 done (Koha 3.20.1)
> Upgrade to 3.20.01.001 done (Bug 9942: Privacy is correctly set)
> Upgrade to 3.20.01.002 done (Bug 13993: Correct orderstatus for transferred orders)
> Upgrade to 3.20.02.000 done (Koha 3.20.2)
> Upgrade to 3.20.03.000 done (Koha 3.20.3)
> DBD::mysql::db do failed: Can't create table 'koha_library.#sql-4b9_42' (errno: 121) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10584.
> Upgrade to 3.20.03.001 done (Bug 14205: Deleting an Item/Record does not remove link to course reserve)
> Upgrade to 3.20.03.002 done (Bug 14717: Prevent 0000-00-00 dates in patron data)
> DBD::mysql::db do failed: Duplicate entry '1-self_checkout' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10614.
> Upgrade to 3.20.03.003 done (Bug 14298: AutoSelfCheckID user should only be able to access SCO )
> Upgrade to 3.20.04.000 done (Koha 3.20.4)
> Upgrade to 3.20.04.001 done (Bug 14820: SMSSendUsername and SMSSendPassword are not listed in the system preferences)
> Upgrade to 3.20.05.000 done (Koha 3.20.4)
> Upgrade to 3.20.06.000 done (Koha 3.20.5)
> Upgrade to 3.20.06.001 done (Bug 14978: Make sure issues.itemnumber is a unique key)
> Upgrade to 3.20.07.000 done (3.20.7 release)
>
> gcb
> ______________________
>
> Gary C. Bortel
> IT Services Manager, Library Development Program
> Office of the Secretary of State, Washington State Library
> 6880 Capitol Boulevard Southeast
> P.O. Box 42460
> Olympia, WA  98501-2460
> gary.bortel at sos.wa.gov<mailto:gbortel at secstate.wa.gov>
> voice: 360.570.5588
> fax: 360.586.7575
>
> Washington State Library: Empowering 21st Century Washington
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha