[Koha] Koha upgrade 3.18.11 --> 3.20.07

Bortel, Gary gary.bortel at sos.wa.gov
Wed Jan 13 12:42:07 NZDT 2016


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 at sos.wa.gov
360.570.5588

Washington State Library: Empowering 21st Century Washington

-----Original Message-----
From: Koha [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Jonathan Druart
Sent: Monday, January 11, 2016 9:14 AM
To: koha at 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/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 <gary.bortel at 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 at sos.wa.gov
> 360.570.5588
>
> Washington State Library: Empowering 21st Century Washington
>
>
> -----Original Message-----
> From: Koha [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of 
> Jonathan Druart
> Sent: Monday, January 11, 2016 8:24 AM
> To: koha at 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 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.bortel at 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.bortel at sos.wa.gov<mailto:gbortel at 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 at lists.katipo.co.nz 
>> https://lists.katipo.co.nz/mailman/listinfo/koha
> _______________________________________________
> Koha mailing list  http://koha-community.org Koha at lists.katipo.co.nz 
> https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list  http://koha-community.org Koha at lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha


More information about the Koha mailing list