- Koha - lists.katipo.co.nz

Authority records vie OAI-PMH
by Mike D. 28 Jun '21

28 Jun '21

Greetings to the community, I would like to ask if Koha can also issue authority records via the OAI set. I have searched the documentation but everywhere it only mentions biblio records? Does anyone have experience with this? Thank you for the information Michal

1 0

Koha Community Newsletter: June 2021
by Koha Newsletter 28 Jun '21

28 Jun '21

The Koha Community Newsletter for June 2021 is here: * https://koha-community.org/koha-community-newsletter-june-2021/ Many thanks to everyone who submitted articles and news to last month's newsletter! Please feel free to email me with any corrections or suggestions. -- Michael Kuhn Editor, Koha Community Newsletter

1 0

Upgrade OS - Ubuntu 18.04 to 20.04
by Isabel Pineda 28 Jun '21

28 Jun '21

Hi. One of these days I will have to upgrade the OS. Currently I am running Koha on a VPS with Ubuntu 18.04. I would like to ask the community for your experience: Is it advisable to upgrade the OS on the existing server (following the instructions here: https://ubuntu.com/blog/how-to-upgrade-from-ubuntu-18-04-lts-to-20-04-lts-t… Or will there be problems with the Koha installation? Maybe it is better to install Koha on a new server with a new OS version and then migrate the database from the old server to the new one? Apart from Koha (and the software required by Koha) there are only a few more programs installed on the server (Certbot, Postfix, vsftpd and the firewall). Can you tell me how you did it and if you were facing any difficulties? Thank you very much Isabel Pineda

3 4

upgrade from Koha 20.05.06.000 to latest version failing with Row size too large
by Mesfin Teshome 28 Jun '21

28 Jun '21

Greetings everyone, I have been trying to upgrade Koha 20.05.06.000 to the latest version for some time now and every time I try I get a DBI exception "Row size too large" message. The full error message below: Upgrade to 20.0t.00.030 done [18:40:59] Bug 20047 - Add new system preference 'AutoApprovePatronProfileSettings'Upgrade to 20.06.00.031 done [18:40:59] Bug 22789 - Add non_priority column on reserves and old_reserves tables{UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126.This incldues storage overhead, check the manual. You have to change some columns to TEXT or BLOBs [for Statement " ALTER TABLE `items` ADD COLUMN `exclude_from_local_holds_priority` tinyint(1) default NULL AFTER `new_status` Anyone who has any idea how I can address this and go on with the upgrade.I am running Koha on Debian 10 Buster, Perl 5.028001, Server version: Apache/2.4.38 (Debian), mysql Ver 15.1 Distrib 10.3.29-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 Kind regards, On Monday, June 28, 2021, 03:01:04 AM GMT+3, <koha-request(a)lists.katipo.co.nz> wrote: Send Koha mailing list submissions to koha(a)lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit https://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request(a)lists.katipo.co.nz You can reach the person managing the list at koha-owner(a)lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..." Today's Topics: 1. Re: Title search works, but Library catalog search fails in OPAC (Katrin Fischer) ---------------------------------------------------------------------- Message: 1 Date: Sun, 27 Jun 2021 10:38:15 +0200 From: Katrin Fischer <katrin.fischer.83(a)web.de> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Title search works, but Library catalog search fails in OPAC Message-ID: <67a02970-fa2e-c90e-1b63-92b671b5c535(a)web.de> Content-Type: text/plain; charset=utf-8; format=flowed Hi Tasha, there is currently a bug about some punctuation leading to no results in Elasticsearch that might relate to your problem: *Bug 28316* <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28316> - Fix ES crashes related to various punctuation characters Hope this helps, Katrin On 24.06.21 23:55, Bales (US), Tasha R wrote: > Follow-up to my problem searching the OPAC for phrases containing punctuation (i.e., Electroactive polymer (EAP) actuators). This Bywater Solutions<https://bywatersolutions.com/education/elastic-searching> article suggests that the problem is a feature of Elasticsearch. > > > > FYI, we are using Elasticsearch 6.1.1 on its own dedicated server, and I don’t believe we’ve installed the ICU Analysis plug-in (looks like it’s required for Zebra, but I can’t tell if it’s required for Elasticsearch), which could be a factor. I couldn’t replicate all aspects of my experience in a sandbox, although searches for phrases containing punctuation still failed in an OPAC “Library Catalog” sandbox search. I concluded that I needed to review our configuration. > > > > I’ve been reviewing the Koha Wiki and elastic.co documentation, and comparing to our index_config.yaml. > > By chance does anyone know how to interpret the syntax below? The documentation describes the parameters below, but I don’t see any usage of “-“ before options. Does the option “- punctuation“ mean “yes, remove punctuation”, or “no, don’t remove punctuation”, or does the phrase refer to some additional configuration file, or perhaps it’s commented out? > > > > analyzer_phrase: > > tokenizer: keyword > > filter: > > - icu_folding > > char_filter: > > - punctuation > > > > Thanks for your time and consideration, > > > > > > Tasha Bales > > Business Support Team | Information Services > > Enterprise Services | Enterprise Operations, Finance and Sustainability > > > > > > -----Original Message----- > > From: Bales (US), Tasha R > > Sent: Tuesday, June 22, 2021 7:54 AM > > To: 'Jonathan Druart' <jonathan.druart(a)bugs.koha-community.org> > > Cc: Discussion Group Koha <koha(a)lists.katipo.co.nz> > > Subject: RE: [EXTERNAL] Re: [Koha] Title search works, but Library catalog search fails in OPAC > > > > Jonathan, thank you! > > > > It does work without the parentheses. > > > > I would suspect an encoding problem, but for that the problem only manifests in the OPAC, and not the intranet. > > > > I came across this issue while testing after migrating from MariaDB to Percona MySQL. Your reply prompted me to check the encoding of the new database, and it's unfortunately Latin-1. Since these are parentheses and not diacritics, I’m not sure what my expectations should be, but changing to UTF-8 is a place to start. Httpd.conf does have UTF-8 set as the default. > > > > FWIW, my source records were encoded in MARC-8. I used MarcEdit to convert them to UTF-8, and it appears that Koha automatically converts anyway on import. When I loaded these records into Koha, I used bulkmarcimport.pl on the command line. > > > > I'll ask that the default character set of the database be changed, and see if that helps. Thanks again. I'm embarrassed that I didn't think to omit the parentheses, or rather was belligerently insisting to myself that they should not have been a problem, > > > > > > Tasha Bales > > Business Support Team | Information Services Enterprise Services | Enterprise Operations, Finance and Sustainability > > (480) 509-5415 > > https://is.web.boeing.com > > > > > > -----Original Message----- > > From: Jonathan Druart [mailto:jonathan.druart@bugs.koha-community.org] > > Sent: Tuesday, June 22, 2021 12:01 AM > > To: Bales (US), Tasha R <tasha.r.bales(a)boeing.com> > > Cc: Discussion Group Koha <koha(a)lists.katipo.co.nz> > > Subject: [EXTERNAL] Re: [Koha] Title search works, but Library catalog search fails in OPAC > > Importance: High > > > > EXT email: be mindful of links/attachments. > > > > > > > > Hello Tasha, > > > > I've created 2 records with > > 245$a Electroactive polymer (EAP) actuators as artificial muscles and the following query returns the 2 results. > > /opac-search.pl?idx=&q=Electroactive%20polymer%20%28EAP%29%20actuators&weight_search=1 > > > > Tried on master and 20.11.06. > > > > Maybe a silly idea: does it work without the parenthesis? > > > > Could you try and recreate it on a sandbox > > (https://wiki.koha-community.org/wiki/Sandboxes) and provide us a step by step plan to reproduce the problem? > > > > Regards, > > Jonathan > > > > Le mar. 22 juin 2021 à 00:46, Bales (US), Tasha R <tasha.r.bales(a)boeing.com> a écrit : > >> Good afternoon, >> I’m having trouble with Title vs. Library catalog keyword searching with several example titles. Searching the same phrase with either method yields different results. This problem occurs only in the OPAC. I hope to confirm whether the behavior I’m seeing is intended (i.e., the problem is me) or not. Thanks in advance. >> For example, given the ebook title, Electroactive polymer (EAP) >> actuators as artificial muscles, a Title keyword search in the OPAC is successful, but a plain, Library catalog (i.e., no index specified), keyword search fails. >> For reference, the title is recorded in the MARC record as: >> 245 00 - TITLE STATEMENT >> a Title Electroactive polymer (EAP) actuators as artificial muscles : >> Below I’ve copied in my search history as well as the tail of the search URL that shows the search parameters. >> · Library catalog keyword search with 0 results >> o 2021-06-21 02:34 PM  Electroactive polymer (EAP) actuators, suppress:false 0 >> o …opac-search.pl?idx=&q=Electroactive%20polymer%20%28EAP%29%20actuators&weight_search=1 >> · Title keyword search with 2 results >> o 2021-06-21 02:34 PM  Electroactive polymer (EAP) actuators, suppress:false 2 >> o …opac-search.pl?idx=ti&q=Electroactive+polymer+%28EAP%29+actuators&weight_search=1 >> As a test, I decided to enclose my Library catalog search terms in quotes, which yielded the desired results. However, I did not at all anticipate that quotes would be required to get hits: >> · Library catalog quoted keyword search with 2 results >> o 2021-06-21 02:46 PM  "Electroactive polymer (EAP) actuators", suppress:false 2 >> o … opac-search.pl?idx=&q=%22Electroactive+polymer+%28EAP%29+actuators%22&weight_search=1 >> On comparing the above URL query strings, it appears that the unquoted terms in the Library catalog keyword search aren’t “anded” together with a “+” the way other searches are, but I’m not sure what the implications are, if any. Also, the Koha manual indicates the following, which suggests to me that I ought to get hits on the unquoted string: >> When you have more than one word in the search box, Koha will still do a keyword search, but a bit differently. Each word will be searched on its own, then the Boolean connector ‘and’ will narrow your search to those items with all words contained in matching records. >> I understand and can predict pretty well the way our old ILS (Millennium, if context helps) will perform a keyword search, but I’m a little confused here. My expectation for this particular case is that all of the above methods would yield results. If there are any pointers to be had, I thank you if might point me to them so that I may be better poised to help users. >> I’m using Elasticsearch with Koha 20.11.06. I reindexed both authorities and biblios today, but that didn’t impact my experience. The records are not newly added. >> Thanks! >> Tasha Bales >> Business Support Team | Information Services Enterprise Services | >> Enterprise Operations, Finance and Sustainability >> _______________________________________________ >> Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > > _______________________________________________ > > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ Subject: Digest Footer _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ End of Koha Digest, Vol 188, Issue 26 *************************************

2 1

Upgrade Instruction
by Charles Kelley 28 Jun '21

28 Jun '21

Hi, all! My library would like to upgrade from Koha v. 20.05 to v. 21.05 and Debian 9 "Stretch" to Debian 10 "Buster" or later. Are there instructions on how to do upgrades and updates, e.g., YouTube videos? We will probably upgrade in August or September, so there is time aplenty to experiment, test, etc. Many thanks! -- 気を付けて。 /ki wo tukete/ = Take care. -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley Tsukimino 1-Chome 5-2 Tsukimino Gaadenia #210 Yamato-shi, Kanagawa-ken 〒242-0002 JAPAN +1-301-741-7122 [US cell] +81-80-4356-2178 [JPN cell] mnogojazyk(a)aol.com [h] cmkelleymls(a)gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.

1 0

Koha 20.11.07 released, ⚠ security release
by Victor Grousset/tuxayo 28 Jun '21

28 Jun '21

Hello! :) The Koha Community is happy to announce the release of Koha 20.11.07 The full release notes can be found at: https://koha-community.org/koha-20.11.07-released Debian packages should be available shortly. Thanks to everyone involved :) Fridolin will be back for the next release, I’m just replacing them for this one. Cheers, -- Victor Grousset/tuxayo

2 1

Re: [Koha] Title search works, but Library catalog search fails in OPAC
by Bales (US), Tasha R 27 Jun '21

27 Jun '21

Follow-up to my problem searching the OPAC for phrases containing punctuation (i.e., Electroactive polymer (EAP) actuators). This Bywater Solutions<https://bywatersolutions.com/education/elastic-searching> article suggests that the problem is a feature of Elasticsearch. FYI, we are using Elasticsearch 6.1.1 on its own dedicated server, and I don’t believe we’ve installed the ICU Analysis plug-in (looks like it’s required for Zebra, but I can’t tell if it’s required for Elasticsearch), which could be a factor. I couldn’t replicate all aspects of my experience in a sandbox, although searches for phrases containing punctuation still failed in an OPAC “Library Catalog” sandbox search. I concluded that I needed to review our configuration. I’ve been reviewing the Koha Wiki and elastic.co documentation, and comparing to our index_config.yaml. By chance does anyone know how to interpret the syntax below? The documentation describes the parameters below, but I don’t see any usage of “-“ before options. Does the option “- punctuation“ mean “yes, remove punctuation”, or “no, don’t remove punctuation”, or does the phrase refer to some additional configuration file, or perhaps it’s commented out? analyzer_phrase: tokenizer: keyword filter: - icu_folding char_filter: - punctuation Thanks for your time and consideration, Tasha Bales Business Support Team | Information Services Enterprise Services | Enterprise Operations, Finance and Sustainability -----Original Message----- From: Bales (US), Tasha R Sent: Tuesday, June 22, 2021 7:54 AM To: 'Jonathan Druart' <jonathan.druart(a)bugs.koha-community.org> Cc: Discussion Group Koha <koha(a)lists.katipo.co.nz> Subject: RE: [EXTERNAL] Re: [Koha] Title search works, but Library catalog search fails in OPAC Jonathan, thank you! It does work without the parentheses. I would suspect an encoding problem, but for that the problem only manifests in the OPAC, and not the intranet. I came across this issue while testing after migrating from MariaDB to Percona MySQL. Your reply prompted me to check the encoding of the new database, and it's unfortunately Latin-1. Since these are parentheses and not diacritics, I’m not sure what my expectations should be, but changing to UTF-8 is a place to start. Httpd.conf does have UTF-8 set as the default. FWIW, my source records were encoded in MARC-8. I used MarcEdit to convert them to UTF-8, and it appears that Koha automatically converts anyway on import. When I loaded these records into Koha, I used bulkmarcimport.pl on the command line. I'll ask that the default character set of the database be changed, and see if that helps. Thanks again. I'm embarrassed that I didn't think to omit the parentheses, or rather was belligerently insisting to myself that they should not have been a problem, Tasha Bales Business Support Team | Information Services Enterprise Services | Enterprise Operations, Finance and Sustainability (480) 509-5415 https://is.web.boeing.com -----Original Message----- From: Jonathan Druart [mailto:jonathan.druart@bugs.koha-community.org] Sent: Tuesday, June 22, 2021 12:01 AM To: Bales (US), Tasha R <tasha.r.bales(a)boeing.com> Cc: Discussion Group Koha <koha(a)lists.katipo.co.nz> Subject: [EXTERNAL] Re: [Koha] Title search works, but Library catalog search fails in OPAC Importance: High EXT email: be mindful of links/attachments. Hello Tasha, I've created 2 records with 245$a Electroactive polymer (EAP) actuators as artificial muscles and the following query returns the 2 results. /opac-search.pl?idx=&q=Electroactive%20polymer%20%28EAP%29%20actuators&weight_search=1 Tried on master and 20.11.06. Maybe a silly idea: does it work without the parenthesis? Could you try and recreate it on a sandbox (https://wiki.koha-community.org/wiki/Sandboxes) and provide us a step by step plan to reproduce the problem? Regards, Jonathan Le mar. 22 juin 2021 à 00:46, Bales (US), Tasha R <tasha.r.bales(a)boeing.com> a écrit : > > Good afternoon, > > I’m having trouble with Title vs. Library catalog keyword searching with several example titles. Searching the same phrase with either method yields different results. This problem occurs only in the OPAC. I hope to confirm whether the behavior I’m seeing is intended (i.e., the problem is me) or not. Thanks in advance. > > For example, given the ebook title, Electroactive polymer (EAP) > actuators as artificial muscles, a Title keyword search in the OPAC is successful, but a plain, Library catalog (i.e., no index specified), keyword search fails. > > For reference, the title is recorded in the MARC record as: > 245 00 - TITLE STATEMENT > a Title Electroactive polymer (EAP) actuators as artificial muscles : > > Below I’ve copied in my search history as well as the tail of the search URL that shows the search parameters. > > > · Library catalog keyword search with 0 results > > o 2021-06-21 02:34 PM  Electroactive polymer (EAP) actuators, suppress:false 0 > > o …opac-search.pl?idx=&q=Electroactive%20polymer%20%28EAP%29%20actuators&weight_search=1 > > > · Title keyword search with 2 results > > o 2021-06-21 02:34 PM  Electroactive polymer (EAP) actuators, suppress:false 2 > > o …opac-search.pl?idx=ti&q=Electroactive+polymer+%28EAP%29+actuators&weight_search=1 > > As a test, I decided to enclose my Library catalog search terms in quotes, which yielded the desired results. However, I did not at all anticipate that quotes would be required to get hits: > > > · Library catalog quoted keyword search with 2 results > > o 2021-06-21 02:46 PM  "Electroactive polymer (EAP) actuators", suppress:false 2 > > o … opac-search.pl?idx=&q=%22Electroactive+polymer+%28EAP%29+actuators%22&weight_search=1 > > On comparing the above URL query strings, it appears that the unquoted terms in the Library catalog keyword search aren’t “anded” together with a “+” the way other searches are, but I’m not sure what the implications are, if any. Also, the Koha manual indicates the following, which suggests to me that I ought to get hits on the unquoted string: > > When you have more than one word in the search box, Koha will still do a keyword search, but a bit differently. Each word will be searched on its own, then the Boolean connector ‘and’ will narrow your search to those items with all words contained in matching records. > > I understand and can predict pretty well the way our old ILS (Millennium, if context helps) will perform a keyword search, but I’m a little confused here. My expectation for this particular case is that all of the above methods would yield results. If there are any pointers to be had, I thank you if might point me to them so that I may be better poised to help users. > > I’m using Elasticsearch with Koha 20.11.06. I reindexed both authorities and biblios today, but that didn’t impact my experience. The records are not newly added. > > Thanks! > > > Tasha Bales > Business Support Team | Information Services Enterprise Services | > Enterprise Operations, Finance and Sustainability > > _______________________________________________ > > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

3 2

Re: [Koha] Update from version 20 to 21 - cannot edit patrons anymore
by Michael Kuhn 25 Jun '21

25 Jun '21

Hi Isabel > It is version 21.05.00.000. That's from "Server information". I asked for "System information" are there no warnings? > Someone has just told me that this is a > bug and will be resolved in version 21.05.01. This version is not yet > available on Ubuntu but I hope that it will be in the next days. Yes, that's why I asked. maybe it's the same bug that I experienced some days ago * https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27144 (Cannot delete any patrons) In this case it turned out it was just one missing ";" in a file. Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch · W www.adminkuhn.ch

2 1

Update from version 20 to 21 - cannot edit patrons anymore
by Isabel Pineda 25 Jun '21

25 Jun '21

Hi. I have just updated Koha to version 21.05 and now I am having a problem because I cannot edit patrons anymore. It seems that a javascript is missing? The log file intranet-error.log gives this output: File not found : default/js/locale_data.js at /usr/share/koha/lib/Koha/Template/Plugin/Asset.pm line 84.: /usr/share/koha/intranet/cgi-bin/members/memberentry.pl Does anybody know how to fix this? I am running Koha on Ubuntu 18.04. Thank you very much Isabel Pineda

2 2

Upgrade / migration questions
by Scott Owen 25 Jun '21

25 Jun '21

Hi all, I am in the process of upgrading my Koha instances to a newer version. Due to the age of the current version, I am going to have to do a database dump / restore I am following the basic Debian install (at the wiki https://wiki.koha-community.org/wiki/Koha_on_Debian ) and have just installed the mariadb-server. (I tried the MySQL but the install said the MySql-server package wasn't available ?? I'm assuming this is by design) Before I continue with the "defaults", setup Apache, and create a Koha instance, I was wondering if there are any steps I should take at this time, if I intend to restore a database on the instance? Should I make sure the names are the same ?? or should I make sure to NOT name the db instances (library name) the same ? Does it matter ? Should I continue and do a complete Koha instance install ?? or is this not required if I am going to dump a db onto this server? Thank you for any insight / advice. -S

1 1