- Koha - lists.katipo.co.nz

It's Back! The Koha Community Challenge-Register Now!
by Jessica Zairo 15 Mar '22

15 Mar '22

Hello Koha Community! We are back for another Koha Community Challenge! https://bywatersolutions.com/news/spring-into-fitness-koha-community-challe… ByWater Solutions has partnered with koha-US https://koha-us.org/ to create a way for the open-source community to come together, move, and raise money for a good cause! Last year we raised over $1800 for the koha-US open source community--let's surpass that goal this year! Walk, Jog, Run, Swim, Bike, Hike, Yoga, Dance- whatever your activity of choice is-come join us for this community challenge! Be part of the open-source community sharing your daily activities, photos, and words of wisdom! The challenge is open to all and will go from April 1 - April 30. Have a great day! Jessie -- Jessica Zairo, MLIS Director of Library Sales and Outreach ByWater Solutions bywatersolutions.com Phone:(888)900-8944 <https://bywatersolutions.com/news/bywater-solutions-at-pla-2022>

1 0

Re: [Koha] Item Inventory Number Error 500
by Tadas G 15 Mar '22

15 Mar '22

Hello, Default framework i add screenshot: https://we.tl/t-6Tqx345tQJ Tag 001 and @ subfield is Koha link: biblio.biblionumber Tag 090a Koha link biblioitems.biblioitemnumber 995$k is Koha link items.itemcallnumber Koha to MARC mapping tab: biblio.biblionumber 001 @ control field biblioitems.biblioitemnumber 090 a Koha biblioitem number (autogenerated) items.itemcallnumber 995 k Call number (full call number) > Is Inventory number in 995$k linked to items.stocknumber? Where should this be linked? > you didn't answer the other question: could you catalog records and search for them before the update? Yes Thanks for the help

1 0

Fallout from DBMS Auto Increment Bug
by Charles Kelley 15 Mar '22

15 Mar '22

It looks like my library was hit by the auto increment bug. Yesterday, we implemented the Koha temporary fix on < https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix>. In addition to the Koha bug fix, we added the suggestions from the Open School Solutions < https://medium.com/@OpenSchoolZ/how-to-fix-the-koha-auto-increment-problem-… >. To our surprise, it worked. Everything worked, in fact. We even reindexed the catalog (koha-elasticsearch --rebuild -d -v {library_instance}). So we began testing the catalog again. In the course of our testing, we got an internal server error. As far as we can tell, the error occurred when we were working on both a cataloging record and an authority record. Then the cataloger saved the edits of the cataloging record. The cataloging record included a ‡9 link to the authority record, but Koha had not quite finished indexing the authority record. Since then, every attempt to reboot the server, restart MariaDB, run the DBMS auto increment fix -- yes, it's already in the boot-up routines -- reindex the catalog through koha-elasticsearch has failed. When we read the Server Information tab under About Koha, we read this little gem: ElasticSearch: Nodes: localhost:9200 | Status: running | Indices: koha_asdlib_biblios (count: 10000), koha_asdlib_authorities (count: 0) We can find only a few records in the catalog and no records in the authority headings. What's worse is that when I query MariaDB directly on the server, it tells me MAX (biblionumber) = 19276 MAX (authid) = 14373 Can someone tell us why MariaDB can get accurate counts, but ElasticSearch cannot? I am also perplexed that koha-elasticsearch cannot resolve host {library} and then proceeds to reindex the catalog. An insight into this would also be helpful. We'll probably back up to the last version of the catalog before the bugs began affecting it and then upload the changes anew. (At least, we can still download the bibliographic and authority records intact whether or not ElasticSearch can index them properly.) Many thanks. System information Koha v. 20.05 Debian 9 "Stretch" on VirtualBox 6.1.X -- よろしくお願いします。 -- 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

Re: [Koha] Item Inventory Number Error 500
by Tadas G 15 Mar '22

15 Mar '22

Hello, I installed the english version. And I think the freamwork is the same version. Maybe possible to reinstall the default freamwork? Zebra write this information: Records exported: 2491 12:52:40 [00:00:26] ==================== REINDEXING zebra 12:52:40 [00:00:26] ==================== ==================== Indexing complete: 12:52:49 [00:00:35] ==================== CLEANING ==================== Zebra configuration information ================================ Zebra biblio directory = /var/lib/koha/library/biblios Zebra authorities directory = /var/lib/koha/library/authorities Koha directory = /usr/share/koha/intranet/cgi-bin Lockfile = /var/lock/koha/library/rebuild/rebuild..LCK BIBLIONUMBER in : 001$@ BIBLIOITEMNUMBER in : 090$a ================================ Job started: 12:52:50 ==================== exporting authority 12:52:50 [00:00:00] ==================== Records exported: 0 12:52:50 [00:00:00] ==================== REINDEXING zebra 12:52:50 [00:00:00] ==================== skipping biblios ==================== Indexing complete: 12:52:50 [00:00:00] ==================== CLEANING

2 1

Fine issue in branch libraries.
by Arshad Iqbal 15 Mar '22

15 Mar '22

Greetings to all. I am using koha 20.05. I am working on a multi branch library environment. In one of the branch libraries I have implemented a fine policy but in others branches I have not applied that fine policy. I am facing this issue. If the patron of the respective library where a fine policy is implemented checks the library material from other libraries, he has to pay a fine for other library books. Is there any solution to this issue??? -- Best Regards *Muhammad Arshad Iqbal* *Assistant Librarian* *NUST Central Library * *National University of Science and Technology (NUST)* *Sector H-12, Islamabad, Pakistan* *Tel. Office:051-90851087* *Cell no.+923444900809* * +923004900159*

2 1

Problem with the Koha Upgradation
by Shiva Kumara 15 Mar '22

15 Mar '22

Hi All, We have a koha backup of 3.23 version. We had installed Ubuntu 20.04.04 LTS and the Koha 21.11 version successfully. We tried to restore the old koha database to a new version of koha. When we run the command "*sudo koha-upgrade-schema library*" for upgrading, we are getting the following error. root@koha:/home/koha/Documents# sudo koha-upgrade-schema library Upgrading database schema for library Upgrade to 3.23.00.000 done (The year of the monkey will be here soon.) Upgrade to 3.23.00.001 done (Bug 11625 - Add pref DefaultToLoggedInLibraryCircRules and DefaultToLoggedInLibraryNoticesSlips) Upgrade to 3.23.00.002 done (Bug 11747 - add pref DefaultToLoggedInLibraryOverdueTriggers) Upgrade to 3.23.00.003 done (Bug 8085 - Rename 'Reserve slip' to 'Hold slip') Upgrade to 3.23.00.004 done (Bug 9819 - stopwords related code should be removed) Upgrade to 3.23.00.005 done (Bug 11569 - Typo in userpermissions.sql) Upgrade to 3.23.00.006 done ( Bug 8956 - Split serials enumeration data into separate fields ) Upgrade to 3.23.00.007 done (Bug 13624 - Remove columns branchcode, categorytype from table overduerules_transport_types) Upgrade to 3.23.00.008 done (Bug 9303 - relative's checkouts in the opac) Upgrade to 3.23.00.009 done (Bug 11622 - Add ability to pay fees and fines from OPAC via PayPal) Upgrade to 3.23.00.010 done (Bug 9129 - Add the ability to set the maximum fine for an item to its replacement price) Upgrade to 3.23.00.011 done (Bug 13592 - Hold fee not being applied on placing a hold) Upgrade to 3.23.00.012 done (Bug 15380 - Move the authority types related code to Koha::Authority::Type[s] - part 1) Upgrade to 3.23.00.013 done (Bug 14945 - Add the ability to store the last patron to return an item) Upgrade to 3.23.00.014 done (Bug 10076 - Add Bcc syspref for claimacquisition and clamissues) Upgrade to 3.23.00.015 done (Bug 15443 - Re-code RESERVESLIP as HOLD_SLIP) Upgrade to 3.23.00.016 done (Bug 8753 - Add forgot password link to OPAC) Upgrade to 3.23.00.017 done (Bug 14893 - Separate temporary storage per instance in Upload.pm) Upgrade to 3.23.00.018 done (Bug 15446 - Fix systempreferences rows where type=YesNo and value='') Upgrade to 3.23.00.019 done (Bug 15411 - Change Non Fiction to Non-fiction in authorised_values) Upgrade to 3.23.00.020 done (Bug 9021 - Add SMS via email as an alternative to SMS services via SMS::Send drivers) Upgrade to 3.23.00.021 done (Bug 15736 - Add a preference to control whether all items should be shown in checked-in items list) Upgrade to 3.23.00.022 done (Bug 13534 - Deleting staff patron will delete tags approved by this patron) Upgrade to 3.23.00.023 done (Bug 6624 - Allow Koha to use the new read API from OpenLibrary) Upgrade to 3.23.00.024 done (Bug 15517 - Tables borrowers and deletedborrowers differ again) Upgrade to 3.23.00.025 done (Bug 15526 - Drop nozebra database table) Upgrade to 3.23.00.026 done (Bug 15343 - Allow patrons to choose their own password on self registration) Upgrade to 3.23.00.027 done (Bug 4941 - Can't set branch in staff client when singleBranchMode is enabled) Upgrade to 3.23.00.028 done (Bug 14658 - Split PatronSelfRegistrationBorrowerUnwantedField into two preferences for creating and editing) Upgrade to 3.23.00.029 done (Bug 14199 - Unify all organization code plugins) Upgrade to 3.23.00.030 done (Bug 15311: Let libraries set text to display when OpacMaintenance = on) Upgrade to 3.23.00.031 done (Bug 14395 - Two different ways to calculate 'No renewal before') Upgrade to 3.23.00.032 done (Bug 15675 - Add issue_id column to accountlines and use it for updating fines) Upgrade to 3.23.00.033 done (Bug 14659 - Allow patrons to enter card number and patron category on OPAC registration page) Upgrade to 3.23.00.034 done (Bug 11023: Adds field 'new' in items and deleteditems tables) Upgrade to 3.23.00.035 done (Bug 14168 - enhance streaming cataloging to include youtube) Upgrade to 3.23.00.036 done (Bug 12803 - Add ability to skip closed libraries when generating the holds queue) Upgrade to 3.23.00.037 done (Bug 15084 - Move the currency related code to Koha::Acquisition::Currenc[y|ies]) Upgrade to 3.23.00.038 done (Bug 14694 - Make decreaseloanHighHolds more flexible) Upgrade to 3.23.00.039 done (Bug 15084 - Move the currency related code to Koha::Acquisition::Currenc[y|ies]) Upgrade to 3.23.00.040 done (Bug 16019 - Check intranetcolorstylesheet for blue.css) {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate column name 'letternumber' at /usr/share/perl5/DBIx/Class/Schema.pm line 1118. DBIx::Class::Schema::throw_exception(Koha::Schema=HASH(0x55991df77cb0), "DBI Exception: DBD::mysql::db do failed: Duplicate column nam"...) called at /usr/share/perl5/DBIx/Class/Storage.pm line 113 DBIx::Class::Storage::throw_exception(DBIx::Class::Storage::DBI::mysql=HASH(0x55992324bbb8), "DBI Exception: DBD::mysql::db do failed: Duplicate column nam"...) called at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1501 DBIx::Class::Storage::DBI::__ANON__("DBD::mysql::db do failed: Duplicate column name 'letternumber'", DBI::db=HASH(0x559923714e48), undef) called at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 12105 Kindly suggest a solution for this issue. Thank you -- ***With Regards*** Shivakumara RM Digital Library Analyst Institute for Social and Economic Change Dr. VKRV Rao Road, Nagarabhavi, Bangalore - 560 072 <https://sites.google.com/site/shivakumararm/>

4 5

forgot password" on the staff
by Victor Barroso Oliveira 14 Mar '22

14 Mar '22

Hi, How do I enter "forgot password" on the staff login screen? Thanks

3 2

Re: [Koha] Item Inventory Number Error 500 (Katrin Fischer)
by Tadas G 14 Mar '22

14 Mar '22

Hello, I installed the english version. And I think the freamwork is the same version. Maybe possible to reinstall the default freamwork? Zebra write this information: Records exported: 2491 12:52:40 [00:00:26] ==================== REINDEXING zebra 12:52:40 [00:00:26] ==================== ==================== Indexing complete: 12:52:49 [00:00:35] ==================== CLEANING ==================== Zebra configuration information ================================ Zebra biblio directory = /var/lib/koha/library/biblios Zebra authorities directory = /var/lib/koha/library/authorities Koha directory = /usr/share/koha/intranet/cgi-bin Lockfile = /var/lock/koha/library/rebuild/rebuild..LCK BIBLIONUMBER in : 001$@ BIBLIOITEMNUMBER in : 090$a ================================ Job started: 12:52:50 ==================== exporting authority 12:52:50 [00:00:00] ==================== Records exported: 0 12:52:50 [00:00:00] ==================== REINDEXING zebra 12:52:50 [00:00:00] ==================== skipping biblios ==================== Indexing complete: 12:52:50 [00:00:00] ==================== CLEANING

1 0

ElasticsearchCrossFields enabled returns no search results on OPAC
by Aleisha Amohia 14 Mar '22

14 Mar '22

Hi all, ElasticsearchCrossFields is a great syspref to enable if you need to search across indexes, for example your search term includes both title and author keywords. We've discovered this only works on the staff client, and returns no results when searching on the OPAC. After some investigation, this is because the OPAC will add a `suppress:false` to the search query, to hide records that are suppressed in OPAC. I'm not sure why, but this combination of suppress:false and ElasticsearchCrossFields means no results are returned in the OPAC. Has anyone seen this before or know a fix, or why it happens? I've reported this bug: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30141 -- Aleisha Amohia (she/her) Koha Developer Catalyst IT - Expert Open Source Solutions www.catalyst.net.nz CONFIDENTIALITY NOTICE: This email is intended for the named recipients only. It may contain privileged, confidential or copyright information. If you are not the named recipient, any use, reliance upon, disclosure or copying of this email or its attachments is unauthorised. If you have received this email in error, please reply via email or call +64 4 499 2267.

2 3

Call for news - Newsletter March 2022
by Michael Kuhn 13 Mar '22

13 Mar '22

Hi I'm collecting news for the March 2022 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 -- 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

1 0