-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, I've just done this exact same thing, and I used the patch from 15341 to patch the running system live. It should be fixed in 3.20.08. Nasty little bug, that. Liz On 13/01/16 12:42, Bortel, Gary wrote:
Hmmm...
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
I updated to Koha 3.20.07 this morning and the staff site is now exhibiting behavior related to Bug 15431 (http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15431). After navigating to a patron with materials checked out, "Checkout(s)" at the bottom of the page shows "Loading..." indefinitely. Clicking on the "Check out" tab brings a pop-up message box " Loading…you may continue scanning.", but the checked out items never appear.
I assume checkouts and returns continue to work. (There's no way to verify since the checkout information doesn't appear.) This does, however, make it difficult for them to renew materials for patrons.
Any suggestions?
gcb ______________________
Gary C. Bortel Office of the Secretary of State, Washington State Library gary.bortel@sos.wa.gov 360.570.5588
Washington State Library: Empowering 21st Century Washington
-----Original Message----- From: Koha [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Jonathan Druart Sent: Monday, January 11, 2016 9:14 AM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Koha upgrade 3.18.11 --> 3.20.07
http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=installer/da ta/mysql/updatedatabase.pl;h=950ed2067dac0edd51cf5e49ff25862c6f53ecdb;hb =refs/heads/3.20.x#l10576
(course_reserves_ibfk_2), so everything is fine.
2016-01-11 17:01 GMT+00:00 Bortel, Gary <gary.bortel@sos.wa.gov>:
Hmmm...
Using "SHOW CREATE TABLE course_reserves" returns...
. . . PRIMARY KEY (`cr_id`), UNIQUE KEY `pseudo_key` (`course_id`,`ci_id`), KEY `course_id` (`course_id`), KEY `course_reserves_ibfk_2` (`ci_id`), CONSTRAINT `course_reserves_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `courses` (`course_id`), CONSTRAINT `course_reserves_ibfk_2` FOREIGN KEY (`ci_id`) REFERENCES `course_items` (`ci_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
The course reserves function is not enabled on this instance and both course_reserves and course_items are empty. Could it be updatedatabase.pl is expecting that function to be enabled and those tables to contain at least one item? I hate to admit it, but I don't see a line 10584 in updatedatabase.pl so it's difficult for me to determine what is throwing the error.
gcb ______________________
Gary C. Bortel Office of the Secretary of State, Washington State Library gary.bortel@sos.wa.gov 360.570.5588
Washington State Library: Empowering 21st Century Washington
-----Original Message----- From: Koha [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Jonathan Druart Sent: Monday, January 11, 2016 8:24 AM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Koha upgrade 3.18.11 --> 3.20.07
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
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
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@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
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
It exploded because you already had the constraint line 10584. line 10614. line 10584. Upgrade to 3.20.03.001 done (Bug 14205: Deleting an 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@sos.wa.gov<mailto:gbortel@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 _______________________________________________ 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
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQEcBAEBAgAGBQJWlaZQAAoJELbCpJ03Jji3fVQH/RLybgwrdA654iRjwuI+GkhV sJaicNjln9Ee5cP7ecM0FzkVmmXSvFTMOyflHomecD93U1iXfzYKXKA7cju+hlnV K2+N+woxZ1S87sOVxR2I4gL7nU49+GUlrUPsh1Apc+kpTLC43zXIfvowmqhnOG2L xHi5zHxM7ZNvNHXBgdegqYwMDv+bqRNmRchWTXZeEK6MHYACKZOWqvirmneBPiHX jbB1BVbDlJJSTdk0uyowe/8qquHOHvvDm61ezKxumRCFY8r1M/FMfn37+UQYIaxC AfGClVIDCT+TfMidWEuCNxmfAh/H3gJwTcLUcWg4SvoFiP0yFtxYFWZ29YT/Ptw= =KWgi -----END PGP SIGNATURE-----