- Koha - lists.katipo.co.nz

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

500 errors in staff mode and forcing a database update
by Fairlamb, Christina 27 Jul '22

27 Jul '22

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

koha-US August 2022 Events & Meetings
by Jennifer Marlatt 27 Jul '22

27 Jul '22

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, August 3 @ 8:30a PT / 11:30a ET / 15:30 UTC General Meeting - Wednesday, August 10 @ 8:30a PT / 11:30a ET / 15:30 UTC *Special Interest Groups* Circulation - Tuesday, August 2 @ 10:00a PT / 1:00p ET / 17:00 UTC Cataloging - Thursday, August 4 @ 8:00a PT / 11:00a ET / 15:00 UTC System Administration - Tuesday, August 9 @ 8:00a PT / 11:00p ET / 15:00 UTC Acquisitions - Tuesday, August 16 @ 9:00a PT / 12:00p ET / 16:00 UTC Web Development - Thursday, August 18 @ 10:00a PT / 1:00p ET / 17:00 UTC Demonstration Instance - Tuesday, August 23 @ 8:00a PT / 11:00a ET / 15:00 UTC 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

Accessing DNB databases via SRU and HTTPS
by Michael Kuhn 26 Jul '22

26 Jul '22

Hi We had a working Koha configuration to access the database of the German national library (Deutsche Nationalbibliothek / DNB) via SRU and HTTP. But since 19 July requests using the HTTP-protocol will be redirected to the HTTPS-protocol by "HTTP-Statuscode 301 Moved Permanently" (see https://lists.dnb.de/pipermail/ons-sru-ru/2022-July/000015.html) The search via HTTPS is working via yaz-client: # yaz-client https://services.dnb.de/sru/dnb Z> sru GET 1.1 Z> find "Marx" Z> s 1 So in our Koha configuration we changed port 80 to port 443 - but when searching anything Koha immediately (apparently without really searching) returns "Nothing found". It's is the same with both databases "sru/dnb" (bibliographic data) and "sru/authorities" (authorities). Has anyone been successful recently when trying to access the DNB databases via SRU and HTTPS? 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 1

Re: [Koha] Accessing DNB databases via SRU and HTTPS
by Michael Kuhn 26 Jul '22

26 Jul '22

Hi Anke Thank you very much! You wrote: > our config still works well - see screenshot. We have exactly the same configuration - but when trying to access we are getting the following error message: Proxy Error The proxy server received an invalid response from an upstream server. The proxy server could not handle the request Reason: Error reading from remote server I tested the same configuration on my demo installation https://koha.adminkuhn.ch - there it works well. The demo installation is directly in the internet with no (outgoing) firewalls involved. > Changing 80 to 443 doesn't help - the SRU search doesn't work anymore > with that setting. Changing 80 to 443 didn't help either on my demo installation. Thus I think this is a problem of the local firewall of our library that doesn't like the redirect from port 80 to 443. It will have to be solved locally. 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

1 0

Koha 21.05.17 released, ⚠ security release
by Victor Grousset/tuxayo 26 Jul '22

26 Jul '22

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

1 0

500 Errors on search after update
by Keith Sorbo 26 Jul '22

26 Jul '22

After upgrading to the latest (22.05.02.000), I am getting 500 errors when a search should return a biblio entry. This happens on the OPAC and when I do a search under the cataloging section in the staff site. I am able to search for patrons with no apparent problem.(I did have quite a bit of trouble updating my database) I ran rebuild zebra and it made no difference. How do I detect what is causing this problem?

1 0

What is Shelving Control Number and how to apply & how to use it.
by Sanjay Uchcharia 25 Jul '22

25 Jul '22

What is Shelving Control Number and how to apply & how to use it.

2 1

Koha 21.11.10 released
by Arthur 25 Jul '22

25 Jul '22

Hello, I'm very proud to announce the release of Koha 21.11.10. This release contains several bugfixes, 2 enhancements and a security fix. More information can be found here : https://koha-community.org/koha-21-11-10-release/ Enjoy! 🌅🚀 Arthur Suzuki, Developper @BibLibre ---------------------- Releases notes for Koha 21.11.10 25 Jul 2022 Koha is the first free and open source software library automation package (ILS). Development is sponsored by libraries of varying types and sizes, volunteers, and support companies from around the world. The website for the Koha project is: * Koha Community <http://koha-community.org> Koha 21.11.10 can be downloaded from: * Download <http://download.koha-community.org/koha-21.11.10.tar.gz> Installation instructions can be found at: * Koha Wiki <http://wiki.koha-community.org/wiki/Installation_Documentation> * OR in the INSTALL files that come in the tarball Koha 21.11.10 is a bugfix/maintenance release with security fixes. It includes 1 security fixes, 2 enhancements, 13 bugfixes. System requirements You can learn about the system components (like OS and database) needed for running Koha here: https://wiki.koha-community.org/wiki/System_requirements_and_recommendations Security bugs Koha * [30969] <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30969> Cross site scripting (XSS) attack in OPAC authority search ( opac-authorities-home.pl ) Enhancements Cataloging * [30997] <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30997> "CGI::param called in list context" warning in detail.pl flooding error log This fixes the cause of "CGI::param called in list context from" warning messages that appear in the log files when viewing record detail pages in the staff interface. Templates * [30786] <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30786> Capitalization in (Opac)AdvancedSearchTypes This fixes the descriptions for the AdvancedSearchTypes and OpacAdvancedSearchTypes system preferences - sentence case is now used for "..Shelving location..". Critical bugs fixed Cataloging * [30234] <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30234> Serial local covers don't appear in the staff interface for other libraries with SeparateHoldings This fixes the display of item-specific local cover images in the staff interface. Before this, item images were not shown for holdings on the record's details view page. Circulation * [29504] <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29504> Confirm item parts requires force_checkout permission (checkouts tab) Lists * [30925] <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30925> Creating public list by adding items to new list creates a private list Patrons * [31005] <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31005> Cannot edit patrons in other categories if an extended attribute is mandatory and limited to a category This fixes an error when a mandatory patron attribute limited to a specific patron category was causing a '500 error' when editing a patron not in that category. REST API * [30677] <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30677> Unknown column 'biblioitem.title' in 'where clause' 500 error in API /api/v1/acquisitions/orders Searching - Elasticsearch * [30883] <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30883> Authorities merge is limited to 100 biblio with Elasticsearch This fixes the hard-coded limit of 100 when merging authorities (when Elasticsearch is the search engine). When merging authorities where the term is used over 100 times, only the first 100 authorities would be merged and the old term deleted, irrespective of the value set in the AuthorityMergeLimit system preference. Other bugs fixed Hold requests * [12630] <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12630> Prioritizing "Hold starts on date" -holds causes all other holds to be prioritized as well! * [28529] <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28529> Item type-constrained biblio-level holds should honour max_holds as item-level do * [30207] <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30207> Librarians with only "place_holds" permission can no longer update hold pickup locations I18N/L10N * [30958] <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30958> OPAC Overdrive search result page broken for translations *Sponsored by* /Melbourne Athenaeum Library, Australia/ Notices * [28355] <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28355> Add warning note about Email SMS driver option for SMSSendDriver This updates the text for the SMSSendDriver system preference. The Email SMS driver option is no longer recommended unless you use a dedicated SMS to Email gateway. Many mobile providers offer inconsistent support for the email to SMS gateway (sometimes it works, and sometimes it doesn't), which can cause frustration for patrons. OPAC * [30989] <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30989> Tags with some special characters are not encoded right This fixes tags with special characters (such as +) so that the searching returns results when the tag is selected (from the record detail view in the OPAC and staff interface, and from the search results, tag cloud, and list pages in the OPAC). Staff Client * [30970] <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30970> holdst columns don't match actual columns in 'Holds waiting' Documentation The Koha manual is maintained in Sphinx. The home page for Koha documentation is * Koha Documentation <http://koha-community.org/documentation/> The Git repository for the Koha manual can be found at * Koha Git Repository <https://gitlab.com/koha-community/koha-manual> Translations Complete or near-complete translations of the OPAC and staff interface are available in this release for the following languages: * Arabic (87.4%) * Armenian (100%) * Armenian (Classical) (89%) * Bulgarian (92.3%) * Chinese (Taiwan) (79.5%) * Czech (76.4%) * English (New Zealand) (59.1%) * English (USA) * Finnish (92.3%) * French (95.1%) * French (Canada) (92.9%) * German (100%) * German (Switzerland) (58.8%) * Greek (60.3%) * Hindi (99.9%) * Italian (100%) * Nederlands-Nederland (Dutch-The Netherlands) (86.9%) * Norwegian Bokmål (63.3%) * Polish (99.2%) * Portuguese (91.1%) * Portuguese (Brazil) (83.8%) * Russian (84.9%) * Slovak (73.2%) * Spanish (100%) * Swedish (82.3%) * Telugu (95.3%) * Turkish (99.6%) * Ukrainian (75.9%) Partial translations are available for various other languages. The Koha team welcomes additional translations; please see * Koha Translation Info <http://wiki.koha-community.org/wiki/Translating_Koha> For information about translating Koha, and join the koha-translate list to volunteer: * Koha Translate List <http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-translate> The most up-to-date translations can be found at: * Koha Translation <http://translate.koha-community.org/> Release Team The release team for Koha 21.11.10 is * Release Manager: Jonathan Druart * Release Manager assistants: o Martin Renvoize o Tomás Cohen Arazi * QA Manager: Katrin Fischer * QA Team: o Agustín Moyano o Andrew Nugged o David Cook o Joonas Kylmälä o Julian Maurice o Kyle M Hall o Marcel de Rooy o Martin Renvoize o Nick Clemens o Petro Vashchuk o Tomás Cohen Arazi o Victor Grousset * Topic Experts: o UI Design -- Owen Leonard o REST API -- Tomás Cohen Arazi o Elasticsearch -- Fridolin Somers o Zebra -- Fridolin Somers o Accounts -- Martin Renvoize * Bug Wranglers: o Sally Healey * Packaging Manager: * Documentation Manager: David Nind * Documentation Team: o David Nind o Lucy Vaux-Harvey * Translation Managers: o Bernardo González Kriegel * Wiki curators: o Thomas Dukleth * Release Maintainers: o 21.05 -- Kyle M Hall o 20.11 -- Fridolin Somers o 20.05 -- Victor Grousset o 19.11 -- Wainui Witika-Park * Release Maintainer assistants: o 21.05 -- Nick Clemens * Release Maintainer mentors: o 19.11 -- Aleisha Amohia Credits We thank the following libraries, companies, and other institutions who are known to have sponsored new features in Koha 21.11.10 * Melbourne Athenaeum Library, Australia We thank the following individuals who contributed patches to Koha 21.11.10 * Tomás Cohen Arazi (2) * Alex Buckley (1) * Nick Clemens (4) * Jonathan Druart (3) * Katrin Fischer (3) * Lucas Gass (1) * Kyle M Hall (4) * Olli-Antti Kivilahti (1) * David Nind (1) * Martin Renvoize (5) * Marcel de Rooy (1) * Fridolin Somers (1) * Arthur Suzuki (5) * Koha translators (1) * Petro Vashchuk (1) We thank the following libraries, companies, and other institutions who contributed patches to Koha 21.11.10 * BibLibre (7) * Bibliotheksservice-Zentrum Baden-Württemberg (BSZ) (3) * ByWater-Solutions (9) * Catalyst (1) * David Nind (1) * Independant Individuals (1) * Koha Community Developers (3) * PTFS-Europe (5) * Rijksmuseum (1) * Theke Solutions (2) We also especially thank the following individuals who tested patches for Koha * Tomás Cohen Arazi (22) * Christopher Brannon (1) * Chris Cormack (1) * Jonathan Druart (3) * Katrin Fischer (8) * Lucas Gass (21) * Victor Grousset (2) * Kyle M Hall (1) * Lucy Harrison (1) * Sally Healey (1) * Owen Leonard (1) * David Nind (12) * Martin Renvoize (7) * Marcel de Rooy (3) * Fridolin Somers (2) * Arthur Suzuki (26) We regret any omissions. If a contributor has been inadvertently missed, please send a patch against these release notes to koha-devel(a)lists.koha-community.org. Revision control notes The Koha project uses Git for version control. The current development version of Koha can be retrieved by checking out the master branch of: * Koha Git Repository <https://git.koha-community.org/koha-community/koha> The branch for this version of Koha and future bugfixes in this release line is 21.11.x. Bugs and feature requests Bug reports and feature requests can be filed at the Koha bug tracker at: * Koha Bugzilla <http://bugs.koha-community.org> He rau ringa e oti ai. (Many hands finish the work) Autogenerated release notes updated last on 25 Jul 2022 08:55:11.

1 0

Electronic resource management module (ERM) in Koha - quick update
by Jonathan Druart 25 Jul '22

25 Jul '22

Hi, I have been working during the last months on implementing a first version of what could be an ERM module in Koha. To help getting feedback from end-users we have created a sandbox that has the latest version of the code: https://staff-erm.sandboxes.biblibre.eu/cgi-bin/koha/erm/erm.pl For developers who would like to read the code and help get them onboard, an entry point page has been written with some details about the implementation: https://tree.taiga.io/project/joubu-koha-erm/wiki/home The code is available at https://gitlab.com/joubu/Koha/-/commits/erm An overview of the current state of the development can be found on this kanban board: https://tree.taiga.io/project/joubu-koha-erm/kanban Any feedback, ideas, contributions are greatly welcomed! Regards, Jonathan

1 0