- Koha - lists.katipo.co.nz

Koha-US System Administrator SIG
by Andrew Fuerste-Henry 13 Mar '23

13 Mar '23

Good morning! The Koha-US System Administration Special Interest Group will meet tomorrow, 3/14, at 8 PT / 9 MT / 10 CT / 11 ET. We'll discuss whatever fun stuff folks have been getting up to in the admin module and with SQL queries. Feel free to show up with questions or send them to me ahead of time. For full details see https://koha-us.org/event/system-administration-special-interest-group/?ins… Join us on Zoom at https://us02web.zoom.us/j/955473977?pwd=S3RGaW90SmxVVkRSaHk3ZERMOExBZz09 Andrew Fuerste-Henry Assistant Library Director Dubuque County Library District www.dubcolib.org | 563-582-0008 he|they<https://www.mypronouns.org/>

1 0

Koha Identity Provider Setup
by Agostino M. Nigro 13 Mar '23

13 Mar '23

Hello, I am looking to get more information on how to setup Koha OAuth2 Identity Providers - I have tried to figure it out myself and through trial and error with ADFS as well as with Azure Active Directory, but keep running into errors. Any assistance would be greatly appreciated! -- Agostino “Austin” Nigro agostino.nigro(a)nigroweb.com<mailto:agostino.nigro@nigroweb.com> This message is intended only for the personal and confidential use of the designated recipient(s) named above. The information contained in this e-mail transmission (including all attached files) is privileged and confidential and intended only for the use of the individual(s) and/or entity(ies) named above. If you are not the intended recipient, you are hereby notified that any unauthorized disclosure, copying, distribution or taking of any action in reliance on the contents of the e-mail materials is strictly prohibited. No confidentiality or privilege is waived or lost by any transmission errors. If you are not the intended recipient and have received this e-mail transmission in error, do not copy it, re-transmit it, use it or disclose its contents, but instead should notify myself, Agostino Nigro at Agostino.Nigro(a)nigroweb.com immediately and please delete it and all copies of it from your system. Thank you

3 2

Koha 22.05 OPAC Autocomplete Search Feature not working.
by MASTeR Library 13 Mar '23

13 Mar '23

Dear Team, The autocomplete search function in the Koha OPAC search box is not working in Wikipedia Java Code, The Koha 22.05 latest version, please provide any suggestions. Reference. https://libpowertech.blogspot.com/2021/03/how-to-adding-to-opac-autocomplet… https://en.wikipedia.org/w/api.php https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25532#c15 -- Thanking you. Librarian, MAMCET <http://mamcet.com/> Trichy-Chennai Trunk Road, Siruganur, Tiruchirappalli-621 105.

1 0

Call for news - Newsletter March 2023
by Koha Newsletter 13 Mar '23

13 Mar '23

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

500 Internal Server Error
by Thomas Daly 12 Mar '23

12 Mar '23

I'm finding that the Koha instance's intranet site is crashing with an Internal Server Error. It first happened when I tried to change the superlibrarian's user ID. I couldn't recover the system at all, and had to delete and re-create the instance. It has recurred in the installer when selecting the language. Log files are being filled with repeated errors about missing database tables, e.g. indexer-output.log: DBD::mysql::st execute failed: Table 'koha_zilib.zebraqueue' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() at /usr/share/koha/lib/Koha/Database.pm line 152. DBD::mysql::st execute failed: Table 'koha_zilib.zebraqueue' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() at /usr/share/koha/lib/Koha/Database.pm line 152. plack-intranet-error.log: [2023/02/27 14:28:08] [WARN] DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/Koha/Database.pm line 152. [2023/02/27 14:28:08] [WARN] DBD::mysql::st execute failed: Table 'koha_zilib.language_descriptions' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. [2023/02/27 14:28:08] [WARN] DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/Koha/Database.pm line 152. [2023/02/27 14:28:08] [WARN] DBD::mysql::st execute failed: Table 'koha_zilib.language_descriptions' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. [2023/02/27 14:28:08] [WARN] DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/Koha/Database.pm line 152. [2023/02/27 14:28:08] [WARN] DBD::mysql::st execute failed: Table 'koha_zilib.systempreferences' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. [2023/02/27 14:28:08] [WARN] DBD::mysql::st execute failed: Table 'koha_zilib.systempreferences' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. [2023/02/27 14:28:08] [WARN] DBD::mysql::st execute failed: Table 'koha_zilib.systempreferences' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. [2023/02/27 14:28:08] [WARN] DBD::mysql::st execute failed: Table 'koha_zilib.systempreferences' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. [2023/02/27 14:28:08] [WARN] Install required, redirecting to Installer at /usr/share/koha/lib/C4/Auth.pm line 762. plack-error.log: DBD::mysql::st execute failed: Table 'koha_zilib.systempreferences' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. DBD::mysql::st execute failed: Table 'koha_zilib.systempreferences' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. Template process failed: file error - /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en-GB/modules/installer/s tep1.tt: not found at /usr/share/koha/lib/C4/Templates.pm line 127. Template process failed: file error - /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en-GB/modules/installer/s tep1.tt: not found at /usr/share/koha/lib/C4/Templates.pm line 127. Any help appreciated.

1 1

Can't delete fresh created biblio. DBI Exception: DBD::mysql::db do failed: Duplicate entry
by DHIM IT 12 Mar '23

12 Mar '23

Dear colleagues, I have problem on one of koha instance Version 22.05.09.000. If I try to delete some biblio, fresh created too, I get this error: An error has occurred! Error 500 From: /var/log/koha/koha/plack-error.log {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry '61703-marcxml-MARC21' for key 'deletedbiblio_metadata_uniq_key' at /usr/share/koha/lib/C4/Biblio.pm line 2867 At the same time biblio landed in to the table deletedbiblio. After deleting of record from deletedbiblio and trying to delete the record again, it works. Maybe have somebody idea about the error? Mit besten Grüßen IT-Manager Eugen Bastron

3 5

Re: [Koha] Dispaly of OPAC Holdings on Mobile Devices
by BRANNON, CHRISTOPHER 11 Mar '23

11 Mar '23

This will be repaired with bug 31248 (https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31248) In the meantime, you can use this CSS in your OPACuser jQuery (thanks, Lucas): /* Fix table responsiveness */ @media (max-width: 608px) { .ui-tabs-panel .item-thumbnail, .tabs-container .item-thumbnail, #opac-user-views .item-thumbnail, #opac-user-readingrec .item-thumbnail, #topissues .item-thumbnail, #usertags .item-thumbnail, #usersuggestions .item-thumbnail { margin: 0.5em 0 0 0.5em; } .ui-tabs-panel .table-bordered, .tabs-container .table-bordered, #opac-user-views .table-bordered, #opac-user-readingrec .table-bordered, #topissues .table-bordered, #usertags .table-bordered, #usersuggestions .table-bordered { border: 0; } .ui-tabs-panel .table, .tabs-container .table, #opac-user-views .table, #opac-user-readingrec .table, #topissues .table, #usertags .table, #usersuggestions .table { width: 100%; } .ui-tabs-panel .table th, .tabs-container .table th, #opac-user-views .table th, #opac-user-readingrec .table th, #topissues .table th, #usertags .table th, #usersuggestions .table th, .ui-tabs-panel .table thead, .tabs-container .table thead, #opac-user-views .table thead, #opac-user-readingrec .table thead, #topissues .table thead, #usertags .table thead, #usersuggestions .table thead { display: none; } .ui-tabs-panel .table td, .tabs-container .table td, #opac-user-views .table td, #opac-user-readingrec .table td, #topissues .table td, #usertags .table td, #usersuggestions .table td { border: 0; display: block; padding: 0.4em 0.3em; } .ui-tabs-panel .table p, .tabs-container .table p, #opac-user-views .table p, #opac-user-readingrec .table p, #topissues .table p, #usertags .table p, #usersuggestions .table p { margin-bottom: 2px; } .ui-tabs-panel tr, .tabs-container tr, #opac-user-views tr, #opac-user-readingrec tr, #topissues tr, #usertags tr, #usersuggestions tr { display: block; } .ui-tabs-panel tr td:first-child, .tabs-container tr td:first-child, #opac-user-views tr td:first-child, #opac-user-readingrec tr td:first-child, #topissues tr td:first-child, #usertags tr td:first-child, #usersuggestions tr td:first-child { border-top: 0; } .ui-tabs-panel tr td:last-child, .tabs-container tr td:last-child, #opac-user-views tr td:last-child, #opac-user-readingrec tr td:last-child, #topissues tr td:last-child, #usertags tr td:last-child, #usersuggestions tr td:last-child { border-bottom: 0; } } Christopher Brannon Date: Sat, 11 Mar 2023 00:41:11 +1100 From: Rosewood Farm Library <library(a)rosewoodfarm.com.au> To: koha(a)lists.katipo.co.nz Subject: [Koha] Dispaly of OPAC Holdings on Mobile Devices Message-ID: <CAGLaEwbuQJA0TMHupz+oHDqwbRQ-u79GezDEUzNj8yna0=ZbLA(a)mail.gmail.com> Content-Type: text/plain; charset="UTF-8" Dear all, We are using Koha 22.05.06. When displaying OPAC holdings on a mobile device, they are in column (or table) format (like showing on a desktop computer). In earlier versions, they were not displayed in such a format. How can I change this to a non-column (or table) format, so information are more readable? Kind regards, Iming Chan *Rosewood Farm Library* *ROSEWOOD FARM GROUP PTY. LTD.* ACN 621 676 711 | ATF Bullas Chan Trust (ABN 95 696 171 924) 20 Research Road (PO Box 363), Lara, Victoria, 3212, Australia (03) 5275 2939 | https://rosewoodfarm.com.au <http://rosewoodfarm.com.au> Cat Boarding | Secured Storage | Canine Fitness

1 0

Re: [Koha] koha on virtualbox
by Tom Obrien 10 Mar '23

10 Mar '23

Hi all, I have installed koha on ubuntu 22. I have used oracle virtualbox hosted on windows 10 platform.There are other services running on the windows, how can i make ubuntu server and virtualbox start automatically whenever windows is restarted? Kindly assist and thanks in advance.

3 3

Dispaly of OPAC Holdings on Mobile Devices
by Rosewood Farm Library 10 Mar '23

10 Mar '23

Dear all, We are using Koha 22.05.06. When displaying OPAC holdings on a mobile device, they are in column (or table) format (like showing on a desktop computer). In earlier versions, they were not displayed in such a format. How can I change this to a non-column (or table) format, so information are more readable? Kind regards, Iming Chan *Rosewood Farm Library* *ROSEWOOD FARM GROUP PTY. LTD.* ACN 621 676 711 | ATF Bullas Chan Trust (ABN 95 696 171 924) 20 Research Road (PO Box 363), Lara, Victoria, 3212, Australia (03) 5275 2939 | https://rosewoodfarm.com.au <http://rosewoodfarm.com.au> Cat Boarding | Secured Storage | Canine Fitness

1 0

Australian Koha User group - Melbourne/Online
by Kathryn Tyree 10 Mar '23

10 Mar '23

Hello and Happy Friday, or almost Friday, wherever you may be. The Melbourne Athenaeum library have kindly offered to host a Koha user group, starting on the 29th of March, 6.00 - 7.30pm, in their beautiful Collins St building. The library will host and Catalyst will (remotely!) arrange the agenda. If you would like to attend, please let me know by email reply and delete the bits below that do not apply to you: *** YES I would like to come to the user group on 29 March at 6pm, hosted by the Melbourne Athenaeum library. I will join the meeting IN PERSON/ONLINE. Please keep me informed about future events. My accessibility requirements are... I would like it if the agenda included... I would like to present at a future meeting about... *** We will send further details to everyone who RSVPs. Best wishes for a lovely weekend ahead, Kathryn -- Kathryn Tyree Koha Services Manager Catalyst.Net Limited DDI: +64 4 803 2414 Tel: +64 4 499 2267 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.

1 0