Re: [Koha] Koha upgrade 3.18.11 --> 3.20.07

2016-01-12 Thread Frédéric Demians 
> 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.

Yes, no visual feedback but it works.

> Any suggestions?

The 3.20 package will be updated, fixing this bug, this week-end. In the
meantime, if you want, you can apply a quick fix following this procedure:

- Access your Koha server with shell.

- Locate the file 'checkouts' in your local Koha installation. It is in 'svc'
  subdirectory of the Koha home directory.

- Change your working directory to the directory containing 'checkouts'.

- Run this command:

  wget -O checkouts http://tinyurl.com/zg6ukte

  It retrieves a valid 'checkouts' program.

Kind regards,
-- 
Frédéric DEMIANS
http://www.tamil.fr/fdemians
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha upgrade 3.18.11 --> 3.20.07

2016-01-12 Thread Liz Rea 
-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.bor...@sos.wa.gov 360.570.5588
> 
> Washington State Library: Empowering 21st Century Washington
> 
> -Original Message- From: Koha 
> [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Jonathan 
> Druart Sent: Monday, January 11, 2016 9:14 AM To: 
> koha@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.bor...@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.bor...@sos.wa.gov 360.570.5588
>> 
>> Washington State Library: Empowering 21st Century Washington
>> 
>> 
>> -Original Message- From: Koha 
>> [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Jonathan 
>> Druart Sent: Monday, January 11, 2016 8:24 AM To: 
>> koha@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.bor...@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

Re: [Koha] Koha upgrade 3.18.11 --> 3.20.07

2016-01-12 Thread Bortel, Gary 
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.bor...@sos.wa.gov
360.570.5588

Washington State Library: Empowering 21st Century Washington

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Jonathan Druart
Sent: Monday, January 11, 2016 9:14 AM
To: koha@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.bor...@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.bor...@sos.wa.gov
> 360.570.5588
>
> Washington State Library: Empowering 21st Century Washington
>
>
> -Original Message-----
> From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of 
> Jonathan Druart
> Sent: Monday, January 11, 2016 8:24 AM
> To: koha@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.bor...@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-4

Re: [Koha] Koha upgrade 3.18.11 --> 3.20.07

2016-01-11 Thread Jonathan Druart 
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.bor...@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.bor...@sos.wa.gov
> 360.570.5588
>
> Washington State Library: Empowering 21st Century Washington
>
>
> -Original Message-
> From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Jonathan 
> Druart
> Sent: Monday, January 11, 2016 8:24 AM
> To: koha@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.bor...@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 -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  98

Re: [Koha] Koha upgrade 3.18.11 --> 3.20.07

2016-01-11 Thread Jonathan Druart 
Correction:
It comes from bug 14205 which has been pushed to 3.18.x and 3.20.x, so
you already have the constraint (but double check!).
You can also forget this one :)

2016-01-11 16:24 GMT+00:00 Jonathan Druart
:
> 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 :
>> 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 -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.bor...@sos.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@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha upgrade 3.18.11 --> 3.20.07

2016-01-11 Thread Bortel, Gary 
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.bor...@sos.wa.gov
360.570.5588

Washington State Library: Empowering 21st Century Washington


-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Jonathan Druart
Sent: Monday, January 11, 2016 8:24 AM
To: koha@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.bor...@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 -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.bor...@sos.wa.gov<mailto:gbor...@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@lists.katipo.co.nz 
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz 
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Koha upgrade 3.18.11 --> 3.20.07

2016-01-11 Thread Bortel, Gary 
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 -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.bor...@sos.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@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha