[Koha] Koha upgrade 3.18.11 --> 3.20.07

Tue Jan 12 06:13:48 NZDT 2016

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