Correction: It comes from bug 14205 which has been pushed to 3.18.x and 3.20.x, so you already have the constraint (but double check!). You can also forget this one :)
2016-01-11 16:24 GMT+00:00 Jonathan Druart <jonathan.dru...@bugs.koha-community.org>: > 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.bor...@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.bor...@sos.wa.gov<mailto:gbor...@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@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