- Koha - lists.katipo.co.nz

What is this? WG: 自动回复: Question on OPACUserCSS
by Bruns, Anke 27 Oct '22

27 Oct '22

Why do I get this message when posting to the Koha list? > -----Ursprüngliche Nachricht----- > Von: 214993372 <214993372(a)qq.com> > Gesendet: Donnerstag, 27. Oktober 2022 16:27 > An: Bruns, Anke <Anke.Bruns(a)gwdg.de> > Betreff: 自动回复: [Koha] Question on OPACUserCSS > > 您好，您的邮件已收到，我会尽快给给您联系。

2 1

Koha 21.05.20 released
by Victor Grousset/tuxayo 27 Oct '22

27 Oct '22

Hello! :-) The Koha Community is happy to announce the release of Koha 21.05.20 The full release notes can be found at: https://koha-community.org/koha-21-05-20-released/ Debian packages should be available shortly. Thanks to everyone involved :-) Cheers, -- Victor Grousset/tuxayo

1 0

Question regarding patron anonymization
by Andy Boze 26 Oct '22

26 Oct '22

Hi, all. We regularly run the patron anonymization script as documented at < https://koha-community.org/manual/21.11/en/html/cron_jobs.html#anonymize-pa… >. The documentation doesn't go into details of exactly what the script does. The documentation for the batch patron anonymization < https://koha-community.org/manual/21.11/en/html/tools.html#batch-patron-del… > say "This tool allows you to bulk anonymize circulation histories...", by which I assume it means it will replace the borrowernumber in the old_issues table with that of the anonymous patron. I'm wondering whether any anonymization is supposed to occur in the statistics table. Our statistics table goes back several years, and I don't see any anonymization of the borrowernumber there. Thanks for any thoughts. Andy -- Andy Boze, Associate Librarian University of Notre Dame 271H Hesburgh Library (574) 631-8708

2 2

Koha 22.05.06 is here!
by Lucas Gass 25 Oct '22

25 Oct '22

Hello, Hola, Bonjour, Guten tag, Olá! The Koha community is proud to announce the release of Koha 22.05.06! Koha 22.05.06 includes 8 enhancements, 42 bugfixes, and 1 security fix. The full release notes can be found here: https://koha-community.org/koha-22-05-06-released/ <https://koha-community.org/koha-22-05-02-release/> Debian packages should be available shortly! -- Lucas Gass Web Developer

2 1

Re: [Koha] Public list issue after recent upgrade
by BRANNON, CHRISTOPHER 25 Oct '22

25 Oct '22

This may be a no-brainer, but did you clear your cache on your browser? ___________________________ Christopher Brannon IT Coordinator 702 E Front Ave Coeur d'Alene, ID 83814 (208)769-2315 Ext. 456 cbrannon(a)cdalibrary.org www.cdalibrary.org Keep tabs on us at: ------------------------------ Message: 8 Date: Mon, 24 Oct 2022 17:49:21 -0400 From: "Steve Nickerson" <stevenanickerson(a)gmail.com> To: "'koha'" <koha(a)lists.katipo.co.nz> Subject: [Koha] Public list issue after recent upgrade Message-ID: <00c301d8e7f2$79e25e90$6da71bb0$(a)gmail.com> Content-Type: text/plain; charset="us-ascii" I recently upgraded the Debian package version from 19.11.03.000 to the latest 22.05.04.000 (including the underlying OS upgrades as well) and now no one is able to view any of the "Public Lists" and get a 500 error when trying. Opac-error.log shows this ("stnick" is my userid in the messages below): Mon Oct 24 17:44:32.268569 2022] [cgi:error] [pid 22000] [client x.x.x.x:5322] AH01215: DBIx::Class::Storage::DBI::select_single(): Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single at /usr/share/koha/lib/Koha/Objects.pm line 96: /usr/share/koha/opac/cgi-bin/opac/opac-suggestions.pl [Mon Oct 24 17:44:39.651936 2022] [cgi:error] [pid 21984] [client x.x.x.x:56417] AH01215: Use of inherited AUTOLOAD for non-method Koha::Virtualshelf::haspermission() is deprecated at /usr/share/koha/lib/Koha/Virtualshelf.pm line 247.: /usr/share/koha/opac/cgi-bin/opac/opac-shelves.pl, referer: http://koha.harrison.lib.me.us/cgi-bin/koha/opac-shelves.pl?op=list&public=1 [Mon Oct 24 17:44:39.652426 2022] [cgi:error] [pid 21984] [client x.x.x.x:56417] AH01215: Template process failed: undef error - Can't locate object method "_columns" via package "stnick" (perhaps you forgot to load "stnick"?) at /usr/share/koha/lib/Koha/Object.pm line 858.: /usr/share/koha/opac/cgi-bin/opac/opac-shelves.pl, referer: http://koha.harrison.lib.me.us/cgi-bin/koha/opac-shelves.pl?op=list&public=1 [Mon Oct 24 17:44:39.695408 2022] [cgi:error] [pid 21984] [client x.x.x.x:56417] End of script output before headers: opac-shelves.pl, referer: http://koha.harrison.lib.me.us/cgi-bin/koha/opac-shelves.pl?op=list <http://koha.harrison.lib.me.us/cgi-bin/koha/opac-shelves.pl?op=list&public= 1> &public=1 I did look in the database itself and do find a count of 93 items in the 'virtualshelves' table. Anyone have any suggestions? Thanks! Steve ------------------------------ 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 204, Issue 21 *************************************

2 1

OAI-PMH harvester
by BOUIS Sonia 25 Oct '22

25 Oct '22

Hi, KohaLA would like to finance an OAI-PMH client in Koha but, we have questions that we want to raise to the community. There was already tries to propose an OAI-PMH client : - https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10662 : it's an old project that doesnt seem compatible with the current version of Koha - https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25905 : the scope is more to use an external OAI-PMH client and to connect it to Koha Our main question is about the way to handle this. Do you think that it's a better idea to use an external software or PERL routine and to find a way to connect it to Koha. Or would it be better to a new module in Koha from scratch and that Koha have his own OAI-PMH client. Please, let us hear your toughts about this projet. Kind regards Sonia Sonia BOUIS ------------------------------------------------------ Responsable du Service informatique documentaire Département d'Appui à la Recherche et aux Projets (DARP) Bibliothèques universitaires Université Jean Moulin Lyon 3 ADRESSE GÉOGRAPHIQUE > Manufacture des Tabacs | 6 cours Albert Thomas | LYON 8e ADRESSE POSTALE > Bibliothèque de la Manufacture | 1C avenue des Frères Lumière | CS 78242 - 69372 LYON CEDEX 08 Ligne directe : 33 (0)4 78 78 79 03 http://bu.univ-lyon3.fr<http://bu.univ-lyon3.fr/>| Suivez-nous > Facebook<https://www.facebook.com/bulyon3/> | Twitter<https://twitter.com/bulyon3>| Instagram<https://www.instagram.com/bu.lyon3/?hl=fr>

3 2

Solved! Error upgrading to 22.05
by King, Fred 25 Oct '22

25 Oct '22

Esteemed Colleagues, This may be something everybody else knows already, or may apply only in unusual circumstances, or may be valid only for my Koha instance. I don't know. I am only an egg. But just in case I'm not the only person having this problem, here's how I solved it. The solution is online if you look for it, but I'm putting it all together in one post, which I haven't found elsewhere. If you get bored, feel free to hit the delete key. When I tried to upgrade my Koha instance to 22.05, I got the following message: ERROR: {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 includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs at /usr/share/koha/lib/C4/Installer.pm line 739 When I tried to go to the admin page, I got the setup screen, which gave me a similar message. Nick Clemens (thanks Nick!) pointed me to this bug, and this specific message: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267#c16 The problem lay not in one row format, but in all of them. I set up my instance with 3.12, way back when the row format was Compact. Yes, maybe I should refresh entirely, but not today. I upgraded a scratch monkey instance and it went without a hitch. Then I upgraded the production instance. That worked, too. I also upgraded the scratch monkey to Ubuntu 20.22LTS without a problem, but I'm saving the production instance for another day. I also found out the difference between a backtick and a single quote. (` vs ' in Outlook) Here's what I did: Update and upgrade until nothing is left to upgrade. In this instance, fwupd and koha-common were hald back apt-get upgrade fwupd apt-get upgrade koha-common (21.05.19-1) apt autoremove After this, nothing is held back. Edit /etc/apt/sources.list.d/koha.list to say deb http://debian.liha-community.org/koha stable main Update/upgrade Upgrade packages held back EXCEPT koha-common: apt-get upgrade libmojolicious-perl Having Koha tables in Compact row format broke the upgrade process. Check the table status for current Koha instance. Start MariaDB mariadb use koha_library show table status Every table status was Compact, so I needed to change all of them to dynamic. Run this to find list the tables and the command to change them: SELECT CONCAT( 'ALTER TABLE `', TABLE_SCHEMA, '`.`', TABLE_NAME, '` ', 'ROW_FORMAT=DYNAMIC;' ) AS _alter FROM INFORMATION_SCHEMA.TABLES WHERE ENGINE='InnoDB' AND ROW_FORMAT <> 'DYNAMIC'; The output should look like several hundred rows of this after you remove all the "|" around it: ALTER TABLE `koha_library`.`borrower_attributes` ROW_FORMAT=DYNAMIC; ALTER TABLE `koha_library`.`borrower_message_preferences` ROW_FORMAT=DYNAMIC; ALTER TABLE `koha_library`.`oauth_access_tokens` ROW_FORMAT=DYNAMIC; Copy the output and past it into the MariaDB prompt. (I copied, pasted it into Notebook, then pasted back into MariaDB. Copying and pasting will depend on what interface you're using. Using Ctrl C to copy in MariaDB doesn't work.) MariaDB [koha_library]> (paste here) You probably don't ahve to do this, but it doesn't hurt anything: apt-get update apt-get upgrade But this might remove soemthing unnecessary: apt autoremove Then update to the version in /etc/apt/sources.list.d/koha.list apt-get upgrade koha-common This time, everything went smoothly. Fred King, MSLS, AHIP Medical Librarian, MedStar Washington Hospital Center fred.king(a)medstar.net 202-877-6670 ORCID 0000-0001-5266-0279 MedStar Authors Catalog: http://medstarauthors.org My parents sent me to mime camp when I was nine. I still can't talk about it. --Anon ---------------------------------------------------------------------- MedStar Health is a not-for-profit, integrated healthcare delivery system, the largest in Maryland and the Washington, D.C., region. Nationally recognized for clinical quality in heart, orthopedics, cancer and GI. IMPORTANT: This e-mail (including any attachments) may contain information that is private, confidential, or protected by attorney-client or other privilege. If you received this e-mail in error, please delete it from your system without copying it and notify sender by reply e-mail, so that our records can be corrected... Thank you. Help conserve valuable resources - only print this email if necessary.

1 0

Public list issue after recent upgrade
by Steve Nickerson 24 Oct '22

24 Oct '22

I recently upgraded the Debian package version from 19.11.03.000 to the latest 22.05.04.000 (including the underlying OS upgrades as well) and now no one is able to view any of the "Public Lists" and get a 500 error when trying. Opac-error.log shows this ("stnick" is my userid in the messages below): Mon Oct 24 17:44:32.268569 2022] [cgi:error] [pid 22000] [client x.x.x.x:5322] AH01215: DBIx::Class::Storage::DBI::select_single(): Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single at /usr/share/koha/lib/Koha/Objects.pm line 96: /usr/share/koha/opac/cgi-bin/opac/opac-suggestions.pl [Mon Oct 24 17:44:39.651936 2022] [cgi:error] [pid 21984] [client x.x.x.x:56417] AH01215: Use of inherited AUTOLOAD for non-method Koha::Virtualshelf::haspermission() is deprecated at /usr/share/koha/lib/Koha/Virtualshelf.pm line 247.: /usr/share/koha/opac/cgi-bin/opac/opac-shelves.pl, referer: http://koha.harrison.lib.me.us/cgi-bin/koha/opac-shelves.pl?op=list&public=1 [Mon Oct 24 17:44:39.652426 2022] [cgi:error] [pid 21984] [client x.x.x.x:56417] AH01215: Template process failed: undef error - Can't locate object method "_columns" via package "stnick" (perhaps you forgot to load "stnick"?) at /usr/share/koha/lib/Koha/Object.pm line 858.: /usr/share/koha/opac/cgi-bin/opac/opac-shelves.pl, referer: http://koha.harrison.lib.me.us/cgi-bin/koha/opac-shelves.pl?op=list&public=1 [Mon Oct 24 17:44:39.695408 2022] [cgi:error] [pid 21984] [client x.x.x.x:56417] End of script output before headers: opac-shelves.pl, referer: http://koha.harrison.lib.me.us/cgi-bin/koha/opac-shelves.pl?op=list <http://koha.harrison.lib.me.us/cgi-bin/koha/opac-shelves.pl?op=list&public= 1> &public=1 I did look in the database itself and do find a count of 93 items in the 'virtualshelves' table. Anyone have any suggestions? Thanks! Steve

1 0

Merging Bibliographic Records in Bulk [Koha version 22.05.05.000]
by Antony Kujenga 24 Oct '22

24 Oct '22

Dear Team, I successfully uploaded item records from Millennium into Koha. I now need to merge these item records in bulk. I am aware that I can merge by selecting records after a search but then I need to do this for quite a number of records so such a route is not practical. My question is: how can I possibly merge similar bib records with item numbers such that I'll only have one bib record and whatever number of items it may be associated with? Any quick help would be greatly appreciated. Regards AK __________________________________________ I SAMUEL 7:12 *Then Samuel took a stone, and set it between Mizpeh and Shen, and called the name of it Ebenezer, saying, Hitherto hath the LORD helped us.*

2 2

Koha 21.11.13 released
by Arthur Suzuki 24 Oct '22

24 Oct '22

Hello, I'm very proud to announce the release of Koha 21.11.13. This release contains 9 enhancements and 35 bugfixes More information can be found here : https://koha-community.org/koha-21-11-13-released/ Enjoy! 🌅🚀 Arthur Suzuki, 🌈🏔️ Développeur @BibLibre

1 0