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 <[email protected]>: > 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 > [email protected]<mailto:[email protected]> > voice: 360.570.5588 > fax: 360.586.7575 > > Washington State Library: Empowering 21st Century Washington > > _______________________________________________ > Koha mailing list http://koha-community.org > [email protected] > https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
