- Koha - lists.katipo.co.nz

/server-status?auto
by Keith Sorbo 30 Jul '22

30 Jul '22

My server is getting hit once a second from 127.0.0.1 on the url /server-status?auto What is hitting the server? It is clearly internal. Is it really necessary to hit every second? Is this set from the web 127.0.0.1 - - [29/Jul/2022:01:40:27 +0000] "GET /server-status?auto HTTP/1.1" 200 1052 "-" "-" 127.0.0.1 - - [29/Jul/2022:01:40:28 +0000] "GET /server-status?auto HTTP/1.1" 200 1061 "-" "-" 127.0.0.1 - - [29/Jul/2022:01:40:29 +0000] "GET /server-status?auto HTTP/1.1" 200 1062 "-" "-" 127.0.0.1 - - [29/Jul/2022:01:40:30 +0000] "GET /server-status?auto HTTP/1.1" 200 1062 "-" "-"

3 2

To companies selling Koha but rarely contributing or self-hosted libraries: testing enhancements or bug fixes is one of the easiest ways to give back and keep your product relevant in the future
by Victor Grousset/tuxayo 30 Jul '22

30 Jul '22

Hello :) To companies in Asia, like India or Pakistan (Koha seems very popular there :D) or any other country, be it in the Americas, Europe or Africa: If you are making a living out of Koha, it's a good and cheap business decision to test one or two patches from time to time. So you take part in keeping Koha competitive on the long run and secure all the time you invested in learning how to deploy and use it. That will help to ensure your customers will stay satisfied with Koha staying a state of the art ILS. Maybe there are bugfixes or enhancements that you are waiting to be released? There are more than 180 enhancements or bug fixes waiting and that means most of them wait months and some years to be released. It wastes a lot of developer time to keep the proposed patches working when the rest of Koha changes. So there is a big need to have more people test patches to rebalance the Koha development process and remove this big bottleneck. Again, cheap in time, it's doing your part in exchange for the software you got for free ready to be sold/use, and a long run investment to keep it a good sellable product. See my previous email about planning testing sessions: https://lists.katipo.co.nz/pipermail/koha/2022-July/058259.html Don't hesitate to message me if you want to try on your own outside the testing sessions. I will be very happy to help anyone that want to start testing patches from time to time. Cheers, -- Victor Grousset/tuxayo Just some Koha contributor.

1 1

Koha Community Newsletter: July 2022
by Koha Newsletter 28 Jul '22

28 Jul '22

The Koha Community Newsletter for July 2022 is here: https://koha-community.org/koha-community-newsletter-july-2022/ 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

Sharing library data with others via z30.50
by Noor Khalid 28 Jul '22

28 Jul '22

Hi everyone Can I share my books data in koha with others via Z39.50 for copy catalogue. If yes how?

2 1

500 errors in staff mode and forcing a database update
by Keith Sorbo 28 Jul '22

28 Jul '22

Christina, I have had quite a few of these types of errors while attempting to upgrade from 20.05 to 21.05. What I have been forced to do is to manually add the missing fields to the tables directly. This is far from ideal, but rerunning the koha-update-schema does not seem to perform the missing changes. You need to see from the error message which field is missing and which table it is missing from. It is not too hard if you have direct access to the database and know how to edit the table structure. (I use a free software called HeidiSQL on windows which allows you to tunnel via SSH. Much easier than editing using the mysql command line.) If you have no experience editing the table structure directly, I don't have a good answer for you. Hope that helps Keith From: "Fairlamb, Christina" <cjf(a)wmu.se> To: koha(a)lists.katipo.co.nz Cc: Bcc: Date: Wed, 27 Jul 2022 09:34:17 +0200 Subject: [Koha] 500 errors in staff mode and forcing a database update Hello all, We've had these issues since at least Koha 21.11 but are now on 22.05. Some links on the koha staff page result in a 500 error. Checking the plack-error.log, these are the lines linking to the page I was trying to access: *EDI accounts* DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Unknown column 'me.responses_enabled' in 'field list' at /usr/share/koha/intranet/cgi-bin/admin/edi_accounts.pl line 110 *Library EANs* DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Unknown column 'me.ee_id' in 'field list' at /usr/share/koha/intranet/cgi-bin/admin/edi_ean_accounts.pl line 93 We also still have the Patron relationship problems issue in this bug: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24263, which should have been fixed during past upgrades. (values have been used for guarantee/guarantor relationships, but do not exist in the 'borrowerRelationship') It seems as though our database schema is not updating fully during our latest koha upgrades. I've tried to run the Manual schema upgrade which results in this message only: DEV atomic update /usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate/ bug_30899.pl [07:15:11]: Bug 30899 - Check borrower_attribute_types FK constraint (30449 follow-up) Which, according to this bug report: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30899 - is a none issue and means the schema is up to date. Is there a way to force a schema update to go through all updates since a specific koha version? Christina

1 0

Adding items to a list not possible in Koha 21.11.09
by Michael Kuhn 27 Jul '22

27 Jul '22

Hi Recently we updated to Koha 21.11.09. Now in the staff client when selecting one or more items in a result list and trying to add it to a list by clicking "Add to list", then selecting the respective list, Koha says "No item was selected". Which is of course not true. However it is not possible to add any items from a result list to "Your lists" or "Public lists". Is this a bug or does anyone know the reason for this behaviour? Maybe there is some connection to bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24522 (Nothing happens when trying to add nothing to a list in staff) 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

5 13

n-Tier deployment of Koha
by Admire Mutsikiwa 27 Jul '22

27 Jul '22

My Koha implementation is sometimes overwhelmed as it is a two-tier implementation with a database on one server and a Koha application on another server. I am wondering if it is possible to have a 3 or 4 tier deployment architecture, with for instance, having a load balancer, koha application server and a clustered MySQL/Mariadb implementation. Kind Regards, -- *The information transmitted by this email is intended only for the person or entity to which it is addressed. This email may contain proprietary, business-confidential, and/or privileged material. If you are not the intended recipient of this message, be aware that any use, review, retransmission, distribution, reproduction or any action taken in reliance upon this message is strictly prohibited. If you received this in error, please contact the sender and delete the material from all computers*

1 0

Koha packages are available 🎁
by Mason James 27 Jul '22

27 Jul '22

kia ora community, the latest Koha packages are available an installation guide is below... https://wiki.koha-community.org/wiki/Koha_on_Debian cheers, Mason

1 0

Error message on upgrade
by Elaine Bradtke 27 Jul '22

27 Jul '22

We're not sure what this means, and or what we need to do to correct it, if anything. Upgrade to 22.05.02.000 [18:18:02]: Koha 22.05.02 release DEV atomic update /usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate/ bug_30899.pl [18:18:02]: Bug 30899 - Check borrower_attribute_types FK constraint (30449 follow-up) NO PLURAL FORM HEADER FOUND - DEFAULTING TO 2 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

3 2

Koha upgrade schema issue
by Sami M. Rasheed 27 Jul '22

27 Jul '22

Kindly, Koha Group Please let me know how to correct the Koha upgrade schema issue. The system displays the following error while I'm using the (koha-upgrade-schema library) to upgrade the Koha system: DEV atomic update /usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate/bug_30899.pl [11:37:44]: Bug 30899 - Check borrower_attribute_types FK constraint (30449 follow-up) I'm using: Koha version: 21.11 OS version: Ubuntu 20.04.4 LTS MySQL version: mysql Ver 8.0.29 -0ubuntu0.20.04.3 for Linux on x86_64 ((Ubuntu)) Thanks Sami Abu Darbeya

3 2