- Koha - lists.katipo.co.nz

Koha 23.05 released
by Tomas Cohen Arazi 01 Jun '23

01 Jun '23

The Koha community is proud to announce the release of Koha 23.05.00. Koha 23.05.00 is a major release, that comes with many new features. It includes 26 new features, 145 enhancements, 701 bugfixes. The full release notes are available here: https://koha-community.org/koha-23-05-released/ Debian packages should be available soon Best regards -- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F

7 6

Re: [Koha] Background job / Staging MARC import stuck at 0%
by Anna Shields 31 May '23

31 May '23

Michael, Did you ever have any luck resolving this? I'm having a similar issue in which my imports get stuck at 0% on the staging step. I, too, seem to have a functioning RabbitMQ, and none of the suggestions I saw in this thread seemed to make a difference. I'm now on v22.11.06-3, and updating hasn't seemed to make any difference, either. Anna On Tue, May 16, 2023 at 7:01 PM <koha-request(a)lists.katipo.co.nz> wrote: > Hi Michael, > > Did you also restart some services after changing the script including > memcache? > > Sometimes it is necessary but not remember for this case. > > You should also look > https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33412 > > Mengü Yazıcıoğlu > Devinim Yazılım Eğitim Danışmanlık > Reşit Galip Cad. No: 29/6 > Çankaya/ANKARA > > Tel: (312) 446 86 68 > Cep: (532) 701 90 27 > > On 13.05.2023 16:21, Michael Brown wrote: > > I tried Mengü's suggestion of editing manage-marc-import.pl, to no > avail. > > Still hangs at enqueuement; no messages, no errors, simply hangs and > spins > > my CPU into a frenzy. Responses to George's message below: > > > > On Wed, May 10, 2023 at 8:34 AM George Veranis <gveranis(a)dataly.gr> > wrote: > > > >> Hi Michael, > >> > >> Could you check the following things: > >> > >> 1) if your rabbitmq-server is running ? > >> > > Yes. > > > > > >> 1.1) if yes, then check if the cluster of nodes in rabbit exist , the > >> command is: > >> rabbitmqctl cluster_status > >> > > Cluster status of node rabbit@kiko ... > > Basics > > > > Cluster name: rabbit@kiko > > > > Disk Nodes > > rabbit@kiko > > > > Running Nodes > > rabbit@kiko > > > > Versions > > rabbit@kiko: RabbitMQ 3.9.21 on Erlang 24.3.4.2 > > > > Maintenance status > > > > Node: rabbit@kiko, status: not under maintenance > > > > Alarms > > > > (none) > > > > Network Partitions > > > > (none) > > > > Listeners > > > > Node: rabbit@kiko, interface: [::], port: 61613, protocol: stomp, > purpose: > > STOMP > > Node: rabbit@kiko, interface: [::], port: 25672, protocol: clustering, > > purpose: inter-node and CLI tool communication > > Node: rabbit@kiko, interface: [::], port: 5672, protocol: amqp, purpose: > > AMQP 0-9-1 and AMQP 1.0 > > > > Feature flags > > > > Flag: implicit_default_bindings, state: enabled > > Flag: maintenance_mode_status, state: enabled > > Flag: quorum_queue, state: enabled > > Flag: stream_queue, state: enabled > > Flag: user_limits, state: enabled > > Flag: virtual_host_metadata, state: enabled > > > > > > > >> 1.1.1) if not shows you something in json format you can try to start it > >> with command > >> rabbitmqctl start_app > >> > >> N/A, rabbitmq is already running. > > > >> 1.2 ) If no , start it and check the logs from your rabbitmq-server at > >> /var/log/rabbitmq/ and check if the service is start it normally . > >> > >> N/A, rabbitmq is already running. > > > >> 2) check the worker-output.log on your koha if koha write there > something > >> and have koha connection with rabbit server . > >> > >> I cannot find a file called "worker-output.log" anywhere in my Alma > > installation. > > > > > >> Best Regards, > >> George > >> > >> > >> -----Original Message----- > >> From: Koha <koha-bounces(a)lists.katipo.co.nz> On Behalf Of Michael Brown > >> Sent: Wednesday, May 10, 2023 3:50 PM > >> To: Cindy Murdock Ames <cmurdock(a)ccfls.org> > >> Cc: koha(a)lists.katipo.co.nz > >> Subject: Re: [Koha] Background job / Staging MARC import stuck at 0% > >> > >> Hi Cindy, apologies for the double-response: I had unsubscribed from > the > >> koha list so my response didn't get added to the thread. I wanted to > remedy > >> that, and also say that, because I had unsubscribed, I missed Mengü's > >> suggestion of updating manage-marc-import.pl. I am eager to try that > fix > >> and will report back later today or tomorrow with my findings. Here's my > >> original response to Cindy before re-subscribing to to the koha list: > >> > >> Yes, my koha-conf.xml does contain that block because I added it during > >> the initial setup. (You're right, it wasn't there originally.) > >> > >> However, it doesn't help; I still cannot import batch bib records in > Koha > >> 22.11 the way I could in Koha 22.05. The enqueuement hangs and sends my > >> cpu through the roof until I navigate away from that page. I've gotten > one > >> off-list suggestion that upgrading to the newest Koha fixes the problem. > >> Unfortunately for me, I don't really have time for that right now, so I > >> have (at least temporarily) abandoned my efforts with Koha. > >> > >> Thanks for your suggestion! > >> > >> Bests, > >> Michael > >> > >> On Tue, May 9, 2023 at 4:40 PM Michael Brown <michael8rown(a)gmail.com> > >> wrote: > >> > >>> Hi Cindy, > >>> > >>> Yes, my koha-conf.xml does contain that block because I added it > >>> during the initial setup. (You're right, it wasn't there originally.) > >>> > >>> However, it doesn't help; I still cannot import batch bib records in > >>> Koha > >>> 22.11 the way I could in Koha 22.05. The enqueuement hangs and sends > >>> my cpu through the roof until I navigate away from that page. I've > >>> gotten one off-list suggestion that upgrading to the newest Koha fixes > >> the problem. > >>> Unfortunately for me, I don't really have time for that right now, so > >>> I have (at least temporarily) abandoned my efforts with Koha. > >>> > >>> Thanks for your suggestion! > >>> > >>> Bests, > >>> Michael > >>> > >>> On Tue, May 9, 2023 at 1:37 PM Cindy Murdock Ames <cmurdock(a)ccfls.org> > >>> wrote: > >>> > >>>> Hi Michael, > >>>> > >>>> Can you confirm your koha-conf.xml contains a message broker section, > >>>> like this? > >>>> > >>>> <message_broker> > >>>> <hostname>localhost</hostname> > >>>> <port>61613</port> > >>>> <username>guest</username> > >>>> <password>guest</password> > >>>> <vhost></vhost> > >>>> </message_broker> > >>>> > >>>> I had the same problem after upgrading from 22.05 to 22.11; I'm > >>>> guessing > >>>> 22.05 must have had some defaults set in the code that allowed the > >>>> message broker to start automatically without this section whereas > >> 22.11 must not. > >>>> I was missing this section and added it and was able to complete > >>>> imports after restarting Koha. > >>>> > >>>> I'm still having the issue with zombie background jobs (I'm afraid to > >>>> test rolling back the code on a production server) but I made a hacky > >>>> bash script to run as a cron job to check for them and kill them off > >>>> so at least our staff can do batch imports without issue, but that's > >> another matter. > >>>> HTH! > >>>> Cindy > >>>> > >>>> > >>>> ----------------------------------------------------------- > >>>> Cindy Murdock Ames > >>>> IT Services Director > >>>> Meadville Public Library | CCFLS > >>>> https://meadvillelibrary.org | https://ccfls.org > >>>> > >>>> Please report tech support issues in Mantis: > >>>> https://mantis.ccfls.org > >>>> > >>>> > >>>> On Thu, Mar 2, 2023 at 8:51 AM Michael Brown <michael8rown(a)gmail.com> > >>>> wrote: > >>>> > >>>>> Greetings: > >>>>> > >>>>> My name is Michael Brown and I am a professional cataloger and > >>>>> SirsiDynix System Admin at the Texas State Library & Archives in > >>>>> Austin (20+ years now). I have been using Koha on Arch Linux in my > >>>>> home library for about a year now. I am migrating my home server to > >>>>> AlmaLinux and I'm having a problem. > >>>>> > >>>>> I am running Koha 22.11.03.000 Rosalie on AlmaLinux 9.1. Staging a > >>>>> MARC file for import gets stuck at 0%. On screen, I am able to > >>>>> select the file for import (bib.mrc), review the profile options > >>>>> (but I don't change any defaults), and then click on "Stage for > >>>>> import" at the bottom. Next screen > >>>>> reads: > >>>>> > >>>>> The job has been enqueued! It will be processed as soon as > >> possible. > >>>>> 0% > >>>>> View detail of the enqueued job > >>>>> > >>>>> After a few seconds, it changes to (and then hangs at): > >>>>> > >>>>> The job has been enqueued! It will be processed as soon as > >> possible. > >>>>> 0% Not started > >>>>> View detail of the enqueued job > >>>>> > >>>>> Clicking on "View detail of the enqueued job" I see: > >>>>> > >>>>> Details of job #22 > >>>>> > >>>>> Job ID: 22 > >>>>> Status: New > >>>>> Progress: 0 / 0 > >>>>> Type: Staged MARC records for import > >>>>> Queued: 03/02/2023 05:42 > >>>>> Started: > >>>>> Ended: > >>>>> > >>>>> Report > >>>>> Detailed messages > >>>>> Return to the job list > >>>>> > >>>>> The corresponding entry in mariadb is: > >>>>> > >>>>> id 22 > >>>>> status new > >>>>> progress NULL > >>>>> size 0 > >>>>> borrowernumber 1 > >>>>> type stage_marc_for_import > >>>>> queue Name of the queue the job is sent to long_tasks data > >>>>> {"encoding":"UTF-8","comments":"","basket_id":null... > >>>>> context JSON-serialized context information for the job > >>>>> {"flags":1,"branch":"ALMA","interface":"intranet",... > >>>>> enqueued_on 2023-03-02 05:42:33 > >>>>> started_on NULL > >>>>> ended_on NULL > >>>>> > >>>>> (If you need to see the full entries for "data" and "context", > >>>>> please let me know.) > >>>>> > >>>>> tmp, koha_upload, and lock directories have been tweaked and fine > >> tuned. > >>>>> I > >>>>> was getting early warnings about them not being set in koha-conf.xml > >>>>> so I created them (and set correct permissions) and I can see the > >>>>> uploaded file (for job 22 the name is > >>>>> 2287629673fb980ad4102f62ebeaa1b9_bib.mrc), so the actual upload > >>>>> function appears to be working. > >>>>> > >>>>> I am getting no apache errors and no other on-screen diagnostics. > >>>>> > >>>>> I have Koha 22.05.02.000 running on Arch Linux that imports this > >>>>> file just fine. Similarly, I have Koha latest running on a Debian VM > >>>>> that can import this file just fine, too. > >>>>> > >>>>> What am I missing? > >>>>> > >>>>> Details of my system: > >>>>> > >>>>> Koha version: 22.11.03.000 Rosalie > >>>>> OS version ('uname -a'): Linux alma 5.14.0-162.12.1.el9_1.x86_64 #1 > >>>>> SMP PREEMPT_DYNAMIC Mon Jan 23 14:51:52 EST 2023 x86_64 Perl > >>>>> interpreter: /usr/bin/perl Perl version: 5.032001 Perl @INC: > >>>>> /usr/share/koha/lib > >>>>> /usr/local/lib64/perl5/5.32 > >>>>> /usr/local/share/perl5/5.32 > >>>>> /usr/lib64/perl5/vendor_perl > >>>>> /usr/share/perl5/vendor_perl > >>>>> /usr/lib64/perl5 > >>>>> /usr/share/perl5 > >>>>> /var/lib/koha/plugins > >>>>> MySQL version: mysql Ver 15.1 Distrib 10.5.16-MariaDB, for Linux > >>>>> (x86_64) using EditLine wrapper Apache version: Server version: > >>>>> Apache/2.4.53 (AlmaLinux) Server built: > >>>>> Jul > >>>>> 20 2022 00:00:00 > >>>>> Memcached: Servers: 127.0.0.1:11211 | Namespace: KOHA | Status: > >>>>> running. | > >>>>> Config read from: koha-conf.xml > >>>>> Zebra version: Zebra 2.2.7 (C) 1994-2023, Index Data Zebra is free > >>>>> software, covered by the GNU General Public License, and you are > >>>>> welcome to change it and/or distribute copies of it under certain > >>>>> conditions. SHA1 > >>>>> ID: > >>>>> ac40f289672405a299436d73c1532f9906774cc6 Using ICU Zebra status: > >>>>> Running Message broker: Using RabbitMQ Date and time: 03/01/2023 > >>>>> 16:20 Time zone: Used: America/Chicago | Config: Undefined | > >>>>> Environment (TZ): > >>>>> Undefined > >>>>> > >>>>> Thanks, > >>>>> Michael > >>>>> _______________________________________________ > >>>>> > >>>>> 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 > >> > >> > > _______________________________________________ > > > > 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 211, Issue 15 > ************************************* >

5 4

Koha 22.11.5v Fine amount did not Calculate
by MASTeR Library 31 May '23

31 May '23

Hi Koha Community Members, I just updated my Koha from 22.11.3 to 22.11.5 when I upgraded the server from Ubuntu MATE 22.11. patrons' account book overdrive fine is not calculated, only the date shown on the red colour fine amount is not displayed. I try to manually fine script commands. cd /etc/cron.daily/ ./koha-common Get the following error/warning: No circulation ODUE letter transported by print at /usr/share/koha/lib/C4/Letters.pm line 585. Use of uninitialized value in string eq at /usr/share/koha/lib/C4/Overdues.pm line 612. I Enclosed the Error Screen message: https://i.ibb.co/W5DkRbk/Fine.png Can anybody tell me what this means? Is it a big problem? -- Thanking you.. Librarian, MAMCET <http://mamcet.com/> Trichy-Chennai Trunk Road, Siruganur, Tiruchirappalli-621 105.

3 8

Lists not downloading from OPAC
by Elaine Bradtke 30 May '23

30 May '23

Koha 22.11.04 Lists work as expected in the staff interface. But in the OPAC, the email and print features work, but the download does not. We get a 500 error message. I can save the information directly to Zotero, but attempting to download a list, in any format, gives the same error. I searched the system settings for lists and download, and even ISBD, but found nothing useful. Suggestions? Elaine Bradtke VWML <https://www.vwml.org> English Folk Dance and Song Society <https://www.efdss.org> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999

2 1

koha-US June 2023 Events & Meetings
by Jennifer Marlatt 30 May '23

30 May '23

Hello! koha-US online meetings and events are free and open to all. See our calendar for a full list: http://koha-us.org/calendar/. For Google Calendar users, add our events calendar to your list for easy access to meeting times and links: https://calendar.google.com/calendar/u/1?cid=a29oYS11cy5vcmdfZG1xb2pkczE5Zn… *Meetings* Board Meeting - Wednesday, June 7 @ 8:30a PT / 11:30a ET / 15:30 UTC General Meeting - Wednesday, June 14 @ 8:30a PT / 11:30a ET / 15:30 UTC *Special Interest Groups* Cataloging - June 2023 meeting CANCELLED Circulation - Thursday, June 8 @ 8:00a PT / 11:00a ET / 15:00 UTC System Administration - Tuesday, June 13 @ 8:00a PT / 11:00a ET / 15:00 UTC Web Development - Thursday, June 15 @ 10:00a PT / 1:00p ET / 17:00 UTC Acquisitions - Tuesday, June 20 @ 9:00a PT / 12:00p ET / 16:00 UTC Demonstration Instance - on hiatus Visit http://koha-us.org/special-interest-groups/ to learn more and sign up for topic-specific mailing lists. Most meetings and events are recorded and made available at https://www.youtube.com/kohaus Jennifer Marlatt koha-US Secretary secretary(a)koha-us.org

1 0

Provision to issue books to a department
by Rupinder Singh 30 May '23

30 May '23

Hi, Our University library has a provision to issue multiple books to the departments for longer durations, the responsibility of which is taken by the head of the respective departments. For example, we issue office rule books to the Administration section and DDC volumes to Library and Infomation Science department. These books can not be issued to any person, as they have defined circulation rules already. A person can only get limited books for a short period. Please suggest what provision we can make in Koha to issue such books. One is simple, just to make new patron records for each department and give them elevated rights. But I don't find it quite amusing. Is there any particular mechanism for this, like Book Bank, Course Reserver etc., (I don't know much about it) Thank You Rupinder Singh

2 1

Fwd: Koha 22.11.05 released
by Hector Gonzalez Jaime 29 May '23

29 May '23

Sorry, I didn't copy the list: Hi, it is strange, I was testing in english, anyway, koha-translate does not list english as it is the default language, and doesn't let me update it. The system also had another language, which was updated but it still gives the same set of errors for both: [Sat May 27 13:27:32.849826 2023] [cgi:error] [pid 6125] [client 192.168.1.1:50078] AH01215: Template process failed: undef error - : filter not found at /usr/share/koha/lib/C4/Templates.pm line 127.: /usr/share/koha/intranet/cgi-bin/circ/branchoverdues.pl, referer: http://bibliotecacho-intra.locales/cgi-bin/koha/circ/circulation-home.pl [Sat May 27 13:27:32.902038 2023] [cgi:error] [pid 6125] [client 192.168.1.1:50078] End of script output before headers: branchoverdues.pl, referer: http://bibliotecacho-intra.locales/cgi-bin/koha/circ/circulation-home.pl This is a test system, so I'm certain there are no other missing messages in the logs. I'll try deleting koha and installing it without an upgrade to see if this still is a problem or if it needs overdue fines to be triggered. On 5/27/23 01:06, Mason James wrote: > hi Hector > > this problem tests OK for me, on a 22.11.06 KTD instance > > > some suggestions... > > 1/ switch your language to 'en', and test problem again > > 2/ manually rebuild your koha languages, and test problem again > > > $ sudo koha-translate --list > en > fr-FR > > > $ sudo koha-translate -v --update en > $ sudo koha-translate -v --update fr-FR > > > > On 27/05/23 5:27 am, Hector Gonzalez Jaime wrote: >> Hello, thanks for all the hard work! >> >> I just tried this version on a development server, and get a 500 >> error trying to check overdue fines, this is in the logs: >> >> "GET /intranet/circ/branchoverdues.pl HTTP/1.1" 500 >> >> Template process failed: undef error - : filter not found at >> /usr/share/koha/lib/C4/Templates.pm line 127. >> >> It worked well with 22.11.05, and got broken with 22.11.06 >> >> >> On 5/26/23 09:00, Renvoize, Martin wrote: >>> Hello, Bonjour, Kia ora, >>> >>> The Koha community is pleased to announce the release of version >>> 22.11.05. >>> >>> This is a security and bugfix maintenance release, including 160 >>> bugfixes! >>> >>> Full release notes are available here: >>> https://koha-community.org/koha-22-11-06-released/ >>> >>> This is our last release as the stable branch maintainers, with the >>> community heading into the next cycle imminently. However, 22.11.x >>> will be >>> in the capable hands of Pedro and Matt for the next cycle having >>> been voted >>> in as the oldstable maintainers 💪 >>> >>> Thanks to anybody involved! 🚀 >>> >>> >>> Martin Renvoize, MPhys (Hons) >>> >>> Head of Development and Community Engagement >>> >>> >>> >>> E: martin.renvoize(a)ptfs-europe.com >>> >>> P: +44 (0) 1483 378728 >>> >>> M: +44 (0) 7725 985636 >>> >>> www.ptfs-europe.com >>> _______________________________________________ >>> >>> Koha mailing list http://koha-community.org >>> Koha(a)lists.katipo.co.nz >>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >> > -- Hector Gonzalez cacho(a)genac.org

2 3

Koha Community Newsletter: May 2023
by Koha Newsletter 29 May '23

29 May '23

The Koha Community Newsletter for May 2023 is here: https://koha-community.org/koha-community-newsletter-may-2023/ Many thanks to everyone who submitted articles and news to this newsletter! Please feel free to email me with any corrections or suggestions. -- Michael Kuhn Editor, Koha Community Newsletter

1 0

Koha upgrade error
by Daniel F. Twum 29 May '23

29 May '23

Upgrade to 22.11.05.010 [10:48:17]: Bug 33489 - Add indices to default patron search fields ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: BLOB/TEXT column 'middle_name' used in key specification without a key length at /usr/share/koha/lib/C4/Installer.pm line 743 -- 8181 Robinson Jefferson Drive APT 410 Elkridge, Maryland 21075-7271 USA 1 (404) 369-3966 -- http://www.mobilelinux.net

3 2

export our MARC21 records to other system
by Ruqaiya Said Alfarsi 29 May '23

29 May '23

Dear all Kindly, do you have any idea how to set our Z39 for other libraries that can import our cataloging records from koha?? Regards -- -- <https://www.unizwa.edu.om/> <https://ishraqa.unizwa.edu.om/> <https://alkhalil.unizwa.edu.om/> <https://instagram.com/unizwaoman?utm_medium=copy_link> <https://www.facebook.com/unizwaoman/> <https://twitter.com/unizwaoman>

3 2