[Koha] Koha upgrade 3.18.11 --> 3.20.07

Liz Rea liz at catalyst.net.nz
Wed Jan 13 14:20:16 NZDT 2016 

-----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 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/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 <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 
> _______________________________________________ Koha mailing list 
> http://koha-community.org Koha at 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-----

More information about the Koha mailing list