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/data/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
