- Koha - lists.katipo.co.nz

Adding Z39.50 servers
by library＠ssst.edu.ba 14 Mar '23

14 Mar '23

Hi all, I'm currently reading up on using Z39.50 servers, and looking up prior messages in the archives. I added (presumably correctly) the Jisc Library Hub server using the data given at https://discover.libraryhub.jisc.ac.uk/support/api/#z3950 and even though I can see there is a catalog entry for the book "Computer architecture : a quantitative approach", ISBN 9780123838728, the only thing that comes up when I try adding it using New from Z39.50/SRU is the following message: You searched for: ISBN: 9780123838728 LIBRARY OF CONGRESS record 1: 239 DISCOVER.LIBRARYHUB.JISC.AC.UK record 1: 238 DISCOVER.LIBRARYHUB.JISC.AC.UK record 2: 238 Nothing found. When I look it up by title, I get You searched for: Title: Computer architecture : a quantitative approach DISCOVER.LIBRARYHUB.JISC.AC.UK record 1: 238 DISCOVER.LIBRARYHUB.JISC.AC.UK record 2: 238 DISCOVER.LIBRARYHUB.JISC.AC.UK record 3: 238 DISCOVER.LIBRARYHUB.JISC.AC.UK record 4: 238 DISCOVER.LIBRARYHUB.JISC.AC.UK record 5: 238 DISCOVER.LIBRARYHUB.JISC.AC.UK record 6: 238 DISCOVER.LIBRARYHUB.JISC.AC.UK record 7: 238 DISCOVER.LIBRARYHUB.JISC.AC.UK record 8: 238 DISCOVER.LIBRARYHUB.JISC.AC.UK record 9: 238 DISCOVER.LIBRARYHUB.JISC.AC.UK record 10: 238 DISCOVER.LIBRARYHUB.JISC.AC.UK record 11: 238 DISCOVER.LIBRARYHUB.JISC.AC.UK record 12: 238 DISCOVER.LIBRARYHUB.JISC.AC.UK record 13: 238 DISCOVER.LIBRARYHUB.JISC.AC.UK record 14: 238 plus the option to import one of 7 records from the National Library of France. Neither of them is the correct edition (I have the 5th ed.). I'm not sure why this is happening, and what I need to do to import the record as it exists on discover.libraryhub.jisc.ac.uk. Have any of you come accross something like this? Best regards Aida Đikić Librarian Sarajevo School of Science and Technology<https://ch1prd0106.outlook.com/owa/redir.aspx?C=iu4F3prvKk26qlF7uQhmd7OEU2z…> Hrasnička Cesta 3A <https://ch1prd0106.outlook.com/owa/redir.aspx?C=iu4F3prvKk26qlF7uQhmd7OEU2z…>Ilidža 71210 Bosnia and Herzegovina Work: +387 33 975-026 Fax: +387 33 975-030

3 4

Internal Server Errors
by Paul 13 Mar '23

13 Mar '23

I recently reported that we'd started to get internal server errors when looking at ISBD detail and making a hold when in the OPAC. Jonathan Druart asked if I'd run misc/maintenance/ search_for_data_inconsistencies.pl to catch potential problems with our data. There were numerous errors with respect to home branch and/or holding branch which I corrected. We've run search_for_data_inconsistencies.pl again and no problems are reported. We're still getting internal servers errors when looking at ISBD detail and making a hold when in the OPAC. Is there anything else I can check? We've also seen that the plack-error.log has a continuously generated error: DBD::mysql::db selectrow_array failed: Unknown column 'LOST' in 'field list' [for Statement "SELECT LOST from items where itemnumber = ?"] at /usr/share/koha/lib/C4/Items.pm line 1229. -- Paul Leman

4 3

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 13 Mar '23

13 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