-----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 [email protected] 360.570.5588 > > Washington State Library: Empowering 21st Century Washington > > -----Original Message----- From: Koha > [mailto:[email protected]] On Behalf Of Jonathan > Druart Sent: Monday, January 11, 2016 9:14 AM To: > [email protected] 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 > > > It exploded because you already had the constraint > (course_reserves_ibfk_2), so everything is fine. > > 2016-01-11 17:01 GMT+00:00 Bortel, Gary <[email protected]>: >> 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 [email protected] 360.570.5588 >> >> Washington State Library: Empowering 21st Century Washington >> >> >> -----Original Message----- From: Koha >> [mailto:[email protected]] On Behalf Of Jonathan >> Druart Sent: Monday, January 11, 2016 8:24 AM To: >> [email protected] 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 >>> >>> 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 > _______________________________________________ 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 > -----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----- _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
