- Koha-devel - lists.koha-community.org

Call for news - Newsletter April 2024
by Koha Newsletter 13 Apr '24

13 Apr '24

Hi I'm collecting news for the April 2024 Koha Community Newsletter. Please send anything noteworthy to: kohanews (at) gmail (dot) com News criteria: * News items can be of any length. * Images are fine. * Anything and everything Koha. * Submit by the 26th of the month. Text format criteria: * Just structured plain text, or * HTML text to include tables or similar For events: * Consider adding your event to the Koha Community calendar at https://koha-community.org/calendar/ Thank you! Michael Kuhn Editor, Koha Community Newsletter

1 0

Re: [Koha-devel] [Koha] Error 500 when searching in Koha 23.11.0
by Michael Kuhn 12 Apr '24

12 Apr '24

Hi Ketan Kulkarni You wrote: > There's a command to upgrade koha db schema. You need to run that > command. > > Following is an example. Here, 'library' is the name of the instance. > You will need to replace that with the name of your instance. > ===============================// > > Upgrade Database Schema > Database schema of old Koha should upgrade to new one. Apply following > commands in a terminal, > > sudo koha-upgrade-schema library > > Rebuild the Zebra Index. > > Apply following command in a terminal, > > sudo koha-rebuild-zebra -v -f library > ================================ I have already run these commands (upgrade and reindexing) - they both finished without an error. I do have a running Koha 23.11 instance and acn log in. But as written when I search for something and then click a single hit in the results list the error 500 appears... Any other ideas? 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 > There's a command to upgrade koha db schema. You need to run that command. > > Following is an example. Here, 'library' is the name of the instance. > You will need to replace that with the name of your instance. > ===============================// > > Upgrade Database Schema > Database schema of old Koha should upgrade to new one. Apply following > commands in a terminal, > > sudo koha-upgrade-schema library > > Rebuild the Zebra Index. > > Apply following command in a terminal, > > sudo koha-rebuild-zebra -v -f library > ================================ > > On Fri, 12 Apr 2024, 20:04 Michael Kuhn, <mik(a)adminkuhn.ch > <mailto:mik@adminkuhn.ch>> wrote: > > Hi Ketan Kulkarni > > Thanks for your answer! Youw rote: > > > Compare the database structure with the published schema of the > > version. > > How could I do that? There are hundreds of tables with many more > hundreds of fields. > > Is there a way how to extract the database structure from > https://schema.koha-community.org/23_11/ > <https://schema.koha-community.org/23_11/> and also from a running > database? > > > My guess is that the db upgrade has not gone through cleanly. > > 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 > <mailto:mik@adminkuhn.ch> · W www.adminkuhn.ch <http://www.adminkuhn.ch> > > > > > On Fri, 12 Apr 2024, 17:42 Michael Kuhn, <mik(a)adminkuhn.ch > <mailto:mik@adminkuhn.ch> > > <mailto:mik@adminkuhn.ch <mailto:mik@adminkuhn.ch>>> wrote: > > > > Hi > > > > I have updated our database from koha 21.11.10 to the current > Koha > > 23.11.04. > > > > When searching the catalogue I get a result list, but when > clicking a > > single hit I get an error 500. In file "plack-error.log" I > have found > > the following line which could be the reason: > > > > DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: > > DBD::mysql::st > > execute failed: Unknown column 'issue.renewals_count' in 'field > > list' at > > /usr/share/koha/lib/Koha/Objects.pm line 317 > > > > In fact there is no table "issue" in Koha 23.11, the correct > name of > > this table is "issues" (see > > https://schema.koha-community.org/23_11/tables/issues.html > <https://schema.koha-community.org/23_11/tables/issues.html> > > <https://schema.koha-community.org/23_11/tables/issues.html > <https://schema.koha-community.org/23_11/tables/issues.html>>). > > > > I have searched in Bugzilla but couldn't find a respective > bug. But I > > found the sequence "issue.renewals_count" in > > > https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=137152 > <https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=137152> > > > <https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=137152 <https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=137152>> so > > there may be some relation to > > https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30275 > <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30275> > > > <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30275 > <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30275>> > > > > Does anyone know how I can solve this problem with the 500 error? > > > > Best wishes: Michael Kuhn > > -- > > 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 > <mailto:mik@adminkuhn.ch> > > <mailto:mik@adminkuhn.ch <mailto:mik@adminkuhn.ch>> · W > www.adminkuhn.ch <http://www.adminkuhn.ch> <http://www.adminkuhn.ch > <http://www.adminkuhn.ch>> > > _______________________________________________ > > > > Koha mailing list http://koha-community.org > <http://koha-community.org> <http://koha-community.org > <http://koha-community.org>> > > Koha(a)lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> > <mailto:Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>> > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > <https://lists.katipo.co.nz/mailman/listinfo/koha> > > <https://lists.katipo.co.nz/mailman/listinfo/koha > <https://lists.katipo.co.nz/mailman/listinfo/koha>> > > > >

1 0

Finding invalid XML characters in Koha data via SQL
by David Cook 12 Apr '24

12 Apr '24

Hi all, I just wanted to share a (MariaDB) SQL report that I wrote for finding bib records with invalid XML characters: select biblionumber from biblio_metadata where metadata REGEXP '[^\\x{0009}\\x{000A}\\x{000D}\\x{0020}-\\x{D7FF}\\x{E000}-\\x{FFFD}\\x{1000 0}-\\x{10FFFF}]+'; Newer versions of Koha strip invalid character from the XML so that you can fix your records. I figure this report is very valuable when coupled with that functionality. In fact, I just advised a library today to use them together to fix up some bad data in their catalogue. -- On a related note, I've noticed that you can have a record with good bib XML but invalid item XML, and you won't notice until your record fails to be indexed. So I'm planning on writing a report for that too. I'm thinking it might be good to add these reports to core Koha, so that people can find and fix their own metadata problems. What do people think? David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595

4 8

Update to Koha 23.11.04 fails
by Michael Kuhn 12 Apr '24

12 Apr '24

Hi Today I tried to update a Koha 21.11.10 database to Koha 23.11.04 but the update process failed at the following point: Upgrade to 23.06.00.068 [22:55:59]: Bug 23798 - Convert OpacMaintenanceNotice system preference to additional contents ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db selectrow_array failed: Unknown column 'id' in 'field list' at /usr/share/koha/lib/C4/Installer.pm line 741 I couldn't find anything regarding this error in Bugzilla, but maybe it is related to https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23798#c12 which shows a similar error regarding an "Unknown column 'title'". How should I proceed? 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 2

Bug 36586 - Self-checkouts will get CSRF errors if left inactive for 8 hours
by David Cook 12 Apr '24

12 Apr '24

Hi all, We recently noticed that self-checkouts will generate CSRF errors when left unattended for over 8 hours (the lifetime of the CSRF token). Our solution is to use a timer to refresh the page every 8 hours or so, but open to other ideas. This will potentially affect Vue.js driven pages that don't reload the whole page. Although maybe Jonathan has already come up with a solution for that. I'm not sure. David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595

1 0

IMPORTANT: Koha hotfix
by Tomas Cohen Arazi 11 Apr '24

11 Apr '24

Hi everyone, we just identified an error on last week's releases and are publishing a quick update. Packages are generally available with the patched versions and should be applied. Source tarballs are a bit delayed but will be published as well. Thanks to all involved -- Tomás Cohen Arazi Theke Solutions (https://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F

1 0

XZ Utils backdoor for Linux
by David Cook 04 Apr '24

04 Apr '24

Hi all, This isn't related to Koha per se, but I thought I'd share it for anyone who hasn't seen it: https://en.wikipedia.org/wiki/XZ_Utils_backdoor All the more reason to have things like Kohacon so that we actually know each other. David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595

3 2

Koha Mars release with security fixes
by Fridolin SOMERS 03 Apr '24

03 Apr '24

Hello everyone 🤗 The Koha community is proud to announce the release of Mars versions: 23.11.04 23.05.10 22.11.16 22.05.20 It is a bugfix/maintenance release including a lot of security fixes. It is highly recommended to upgrade. The full release notes will soon be available here: https://koha-community.org/koha-23-11-04-released/ https://koha-community.org/koha-23-05-10-released/ https://koha-community.org/koha-22-11-16-released/ https://koha-community.org/koha-22-05-20-released/ Debian packages are available. Next week is HackFest in Marseille 🌍 Best regards 🤓 -- Fridolin SOMERS <fridolin.somers(a)biblibre.com> Software and system maintainer 🦄 BibLibre, France

1 0

REMINDER: Development IRC meeting 3 April 2024
by Fischer, Katrin 02 Apr '24

02 Apr '24

Hi all, We have a Development IRC/Jitsi meeting scheduled for tomorrow: https://wiki.koha-community.org/wiki/Development_IRC_meeting_3_April_2024 Time converter: https://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+Developers+IR C+Meeting <https://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+Developers+I RC+Meeting&iso=20240403T1200> &iso=20240403T1200 Please feel free to add any topics you'd like to discuss to the agenda or let me know and I am happy to add them for you. If you are lead or supporter of a roadmap project, we will be happy to get an update on progress. See you there! Katrin

1 0

Koha Community Newsletter: March 2024
by Koha Newsletter 28 Mar '24

28 Mar '24

The Koha Community Newsletter for March 2024 is here: https://koha-community.org/koha-community-newsletter-march-2024/ 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