- Koha - lists.katipo.co.nz

Re: [Koha] Koha Digest, Vol 210, Issue 5
by library＠ssst.edu.ba 06 Apr '23

06 Apr '23

Hello all, I need some help with the update to this version! I ran the update and got the following error: Get:1 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 update-notifier-common all 3.192.54.6 [185 kB] Get:2 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 libapparmor1 amd64 3.0.4-2ubuntu2.2 [39.2 kB] Get:3 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 netplan.io amd64 0.105-0ubuntu2~22.04.3 [92.9 kB] Get:4 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 libnetplan0 amd64 0.105-0ubuntu2~22.04.3 [103 kB] Get:5 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 apparmor amd64 3.0.4-2ubuntu2.2 [595 kB] Get:6 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 bind9-host amd64 1:9.18.12-0ubuntu0.22.04.1 [52.4 kB] Get:7 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 bind9-dnsutils amd64 1:9.18.12-0ubuntu0.22.04.1 [157 kB] Get:8 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 bind9-libs amd64 1:9.18.12-0ubuntu0.22.04.1 [1,240 kB] Get:9 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 rabbitmq-server all 3.9.13-1ubuntu0.22.04.1 [15.2 MB] Get:10 http://debian.koha-community.org/koha stable/main amd64 koha-common all 22.11.03-1 [48.4 MB] Get:11 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 libldap-2.5-0 amd64 2.5.14+dfsg-0ubuntu0.22.04.1 [183 kB] Get:12 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 libldap-common all 2.5.14+dfsg-0ubuntu0.22.04.1 [15.9 kB] Get:13 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 linux-firmware all 20220329.git681281e4-0ubuntu3.12 [249 MB] Get:14 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 thermald amd64 2.4.9-1ubuntu0.2 [212 kB] Get:15 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 cloud-init all 23.1.1-0ubuntu0~22.04.1 [530 kB] Fetched 316 MB in 44s (7,151 kB/s) Preconfiguring packages ... (Reading database ... 150255 files and directories currently installed.) Preparing to unpack .../00-update-notifier-common_3.192.54.6_all.deb ... Unpacking update-notifier-common (3.192.54.6) over (3.192.54.5) ... Preparing to unpack .../01-libapparmor1_3.0.4-2ubuntu2.2_amd64.deb ... Unpacking libapparmor1:amd64 (3.0.4-2ubuntu2.2) over (3.0.4-2ubuntu2.1) ... Preparing to unpack .../02-netplan.io_0.105-0ubuntu2~22.04.3_amd64.deb ... Unpacking netplan.io (0.105-0ubuntu2~22.04.3) over (0.105-0ubuntu2~22.04.1) ... Preparing to unpack .../03-libnetplan0_0.105-0ubuntu2~22.04.3_amd64.deb ... Unpacking libnetplan0:amd64 (0.105-0ubuntu2~22.04.3) over (0.105-0ubuntu2~22.04.1) ... Preparing to unpack .../04-apparmor_3.0.4-2ubuntu2.2_amd64.deb ... Unpacking apparmor (3.0.4-2ubuntu2.2) over (3.0.4-2ubuntu2.1) ... Preparing to unpack .../05-bind9-host_1%3a9.18.12-0ubuntu0.22.04.1_amd64.deb ... Unpacking bind9-host (1:9.18.12-0ubuntu0.22.04.1) over (1:9.18.1-1ubuntu1.3) ... Preparing to unpack .../06-bind9-dnsutils_1%3a9.18.12-0ubuntu0.22.04.1_amd64.deb ... Unpacking bind9-dnsutils (1:9.18.12-0ubuntu0.22.04.1) over (1:9.18.1-1ubuntu1.3) ... Preparing to unpack .../07-bind9-libs_1%3a9.18.12-0ubuntu0.22.04.1_amd64.deb ... Unpacking bind9-libs:amd64 (1:9.18.12-0ubuntu0.22.04.1) over (1:9.18.1-1ubuntu1.3) ... Preparing to unpack .../08-rabbitmq-server_3.9.13-1ubuntu0.22.04.1_all.deb ... Unpacking rabbitmq-server (3.9.13-1ubuntu0.22.04.1) over (3.9.13-1) ... Preparing to unpack .../09-koha-common_22.11.03-1_all.deb ... Unpacking koha-common (22.11.03-1) over (22.11.01-1) ... Preparing to unpack .../10-libldap-2.5-0_2.5.14+dfsg-0ubuntu0.22.04.1_amd64.deb ... Unpacking libldap-2.5-0:amd64 (2.5.14+dfsg-0ubuntu0.22.04.1) over (2.5.13+dfsg-0ubuntu0.22.04.1) ... Preparing to unpack .../11-libldap-common_2.5.14+dfsg-0ubuntu0.22.04.1_all.deb ... Unpacking libldap-common (2.5.14+dfsg-0ubuntu0.22.04.1) over (2.5.13+dfsg-0ubuntu0.22.04.1) ... Preparing to unpack .../12-linux-firmware_20220329.git681281e4-0ubuntu3.12_all.deb ... Unpacking linux-firmware (20220329.git681281e4-0ubuntu3.12) over (20220329.git681281e4-0ubuntu3.10) ... Preparing to unpack .../13-thermald_2.4.9-1ubuntu0.2_amd64.deb ... Unpacking thermald (2.4.9-1ubuntu0.2) over (2.4.9-1ubuntu0.1) ... Preparing to unpack .../14-cloud-init_23.1.1-0ubuntu0~22.04.1_all.deb ... Unpacking cloud-init (23.1.1-0ubuntu0~22.04.1) over (22.4.2-0ubuntu0~22.04.1) ... Setting up rabbitmq-server (3.9.13-1ubuntu0.22.04.1) ... Setting up libapparmor1:amd64 (3.0.4-2ubuntu2.2) ... Setting up bind9-libs:amd64 (1:9.18.12-0ubuntu0.22.04.1) ... Setting up linux-firmware (20220329.git681281e4-0ubuntu3.12) ... update-initramfs: Generating /boot/initrd.img-5.15.0-69-generic update-initramfs: Generating /boot/initrd.img-5.15.0-60-generic Setting up update-notifier-common (3.192.54.6) ... update-notifier-download.service is a disabled or a static unit not running, not starting it. update-notifier-motd.service is a disabled or a static unit not running, not starting it. Setting up libnetplan0:amd64 (0.105-0ubuntu2~22.04.3) ... Setting up libldap-common (2.5.14+dfsg-0ubuntu0.22.04.1) ... Setting up libldap-2.5-0:amd64 (2.5.14+dfsg-0ubuntu0.22.04.1) ... Setting up netplan.io (0.105-0ubuntu2~22.04.3) ... Setting up apparmor (3.0.4-2ubuntu2.2) ... Reloading AppArmor profiles Skipping profile in /etc/apparmor.d/disable: usr.sbin.rsyslogd Setting up bind9-host (1:9.18.12-0ubuntu0.22.04.1) ... Setting up thermald (2.4.9-1ubuntu0.2) ... Setting up koha-common (22.11.03-1) ... Installing new version of config file /etc/koha/log4perl-site.conf.in ... Installing new version of config file /etc/koha/zebradb/authorities/etc/bib1.att ... Installing new version of config file /etc/koha/zebradb/biblios/etc/bib1.att ... Installing new version of config file /etc/koha/zebradb/ccl.properties ... Upgrading database schema for library DBD::mysql::st execute failed: Table 'koha_library.systempreferences' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. DBD::mysql::st execute failed: Table 'koha_library.systempreferences' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. Use of uninitialized value in numeric lt (<) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 78. DBD::mysql::db do failed: Table 'koha_library.bookshelf' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. DBD::mysql::db do failed: Table 'koha_library.shelfcontents' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. DBD::mysql::db do failed: Table 'koha_library.virtualshelfcontents' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. DBD::mysql::db do failed: Table 'koha_library.virtualshelfcontents' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. Undefined subroutine &main::DropAllForeignKeys called at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 86. dpkg: error processing package koha-common (--configure): installed koha-common package post-installation script subprocess returned error exit status 255 Setting up cloud-init (23.1.1-0ubuntu0~22.04.1) ... Installing new version of config file /etc/cloud/cloud.cfg ... Setting up bind9-dnsutils (1:9.18.12-0ubuntu0.22.04.1) ... Processing triggers for rsyslog (8.2112.0-2ubuntu2.2) ... Processing triggers for man-db (2.10.2-1) ... Processing triggers for dbus (1.12.20-2ubuntu4.1) ... Processing triggers for libc-bin (2.35-0ubuntu3.1) ... Errors were encountered while processing: koha-common needrestart is being skipped since dpkg has failed E: Sub-process /usr/bin/dpkg returned an error code (1) I see in the error message that some tables don't exist (indented to be easier to see). I assume this is the cause of the problem. How do I fix this? Thank you in advance! Best regards Aida Đikić -----Original Message----- From: Koha <koha-bounces(a)lists.katipo.co.nz> On Behalf Of koha-request(a)lists.katipo.co.nz Sent: Thursday, April 6, 2023 2:00 AM To: koha(a)lists.katipo.co.nz Subject: Koha Digest, Vol 210, Issue 5 Send Koha mailing list submissions to koha(a)lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit https://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request(a)lists.katipo.co.nz You can reach the person managing the list at koha-owner(a)lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..."

1 0

22.05.11 is here!
by Lucas Gass 06 Apr '23

06 Apr '23

Hello! The Koha community is proud to announce the release of Koha 22.05.11! Koha 22.05.11 includes 1 enhancement and 52 bugfixes. The full release notes can be found here: https://koha-community.org/koha-22-05-11-released/ <https://koha-community.org/koha-22-05-02-release/> Debian packages should be available shortly! -- Lucas Gass Web Developer

1 0

koha-US Board Meeting Minutes - Wednesday, April 5, 2023
by Jennifer Marlatt 05 Apr '23

05 Apr '23

Hello, Here's a link to the minutes from the koha-US board meeting today - https://docs.google.com/document/d/1kUvO2argUYPf1kwDrLDxFzek1wr-Usk-iGUETNf… koha-US meetings are open to all! Board meetings are held on the first Wednesday of each month at 8:30 PT / 9:30 MT / 10:30 CT / 11:30 ET. The next koha-US general meeting will be on Wednesday, April 12 @ 8:30 PT / 9:30 MT / 10:30 CT / 11:30 ET (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+April+gen…> ). The agenda for the next general meeting is available here - https://docs.google.com/document/d/1Jb6ET1xhfVWqigh0ifnr85IYnK6510fd_h55EqZ… <https://docs.google.com/document/d/1Jb6ET1xhfVWqigh0ifnr85IYnK6510fd_h55EqZ…> If you have additional topics for the agenda, please send them to secretary(a)koha-us.org. Jennifer Marlatt koha-US Secretary <secretary(a)koha-us.org>secretary(a)koha-us.org

1 0

Extended! Request for proposals to host KohaCon 2024
by Caroline Cyr La Rose 05 Apr '23

05 Apr '23

Hello dear community! The general meeting planned for today, when we would discuss the proposals, has been postponed to April 19 15 UTC. This means the request for proposals to host KohaCon24 is extended to *April 18 2023 23:59 UTC*! If you were on the fence, now is your chance! You can read the original request here: https://lists.katipo.co.nz/public/koha/2023-February/059031.html If you have any questions regarding hosting the conference, how do make the proposal, etc. don't hesitate to ask here on this mailing list, or on IRC (https://koha-community.org/get-involved/irc/) where there are usually people at all times in all time zones. Best regards, Caroline Caroline Cyr-La-Rose, M.L.I.S. (she/her) Librarian | Product Manager 1-833-INLIBRO (465-4276), ext. 221 caroline.cyr-la-rose(a)inlibro.com https://www.inLibro.com

1 0

Two April CatSIGs
by Hernandez, Heather H 04 Apr '23

04 Apr '23

Hi, all! Our next Koha-US Cataloging Special Interest Group ("CatSIG") is on Thursday, April 6, 2023, at 8 PT, 9 MT, 10 CT, 11 ET (16:00 UTC)! And since you don't have to be a member of Koha-US to join us, we're hoping you'll join us! But wait! There's more! The second CatSIG April meeting is on Thursday, January 26, 2023, at a later time, 1(13:00)PT / 4(16:00)ET /9NZT / 20UTC! You still don't have to be a member of Koha-US to join us, so we're hoping the different times will make it possible for more folks to join in! (We're trying these later, second meetings in a month four times a year.) And remember that you don't even need to self-identify as a cataloger! There will be our usual roundtable of questions, solutions and resource brainstorming, tips, tricks, suggestions, bug & development awareness, and the usual laughter, fun, and fellowship to discuss anything cataloging, authority, or metadata related in Koha. Not sure if it's cataloging related? It probably is! Actual catalogers do attend, as well as the cataloging curious and those who have had cataloging thrust upon them! Information on joining us is on the Koha-US calendar: Calendar – koha-US<https://koha-us.org/calendar/> Can't make it? No worries--it will be recorded and available on the Koha-US YouTube Channel: https://www.youtube.com/c/kohaUS/playlists (See the Cataloging Special Interest Group's playlist for more cataloging fun!) As ever, feel free to send me any questions or topics for discussion ahead of time! See you there! --h2 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Ms. Heather Hernandez (she, her, hers) Technical Services Librarian Library catalog: https://keys.bywatersolutions.com/<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fkeys.bywa…> San Francisco Maritime National Historical Park Research Center 2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA 94123-1284 415-561-7032 (office, generally M, W, F, telecommuting Tu,Th) heather_hernandez(a)nps.gov<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwebmail.l…>

1 1

April Koha-US System Admin and Reports SIG, 4/11
by Andrew Fuerste-Henry 04 Apr '23

04 Apr '23

The Koha-US Sys Admin and Reports SIG will meet next week to discuss whatever's fun and interesting in the Administration and Reports modules. Please join us and bring along your questions (and answers)! To join the meeting on Zoom: https://us02web.zoom.us/j/955473977?pwd=S3RGaW90SmxVVkRSaHk3ZERMOExBZz09 For full details: https://koha-us.org/event/system-administration-special-interest-group/?ins… 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-US Board Meeting Reminder: Wednesday, April 5, 2023
by Jennifer Marlatt 03 Apr '23

03 Apr '23

Hello! The next koha-US Board Meeting is Wednesday, April 5, 2023. When: 8:30a PT / 11:30a ET (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+Board+Mee…> ) Where: https://us02web.zoom.us/j/293750042?pwd=SGQzS2pmU3prNFhYRHNaeTFhOHN4QT09 Agenda: https://docs.google.com/document/d/1TuMgnkUJZCti-KyQBztkejnorUBrkNGZ3xWs-6E… If you have additional topics for the agenda, please send them to secretary(a)koha-us.org Meetings are held via Zoom video conferencing. A microphone and webcam are recommended but not required. Zoom is available for Windows, Mac, and Linux on desktops, and Android and iOS on mobile devices. For help getting started, visit: https://support.zoom.us/hc/en-us/categories/200101697 These meetings are always free and open to any and all. Jennifer Marlatt koha-US Secretary secretary(a)koha-US.org

1 0

Reminder: Request for proposals to host KohaCon 2024
by Caroline Cyr La Rose 03 Apr '23

03 Apr '23

Hello dear community! This is a reminder that proposals to host KohaCon 2024 are due tomorrow (*4 April 2023 23:59 UTC*). You can read the original request here: https://lists.katipo.co.nz/public/koha/2023-February/059031.html If you have any questions regarding hosting the conference, how do make the proposal, etc. don't hesitate to ask here on this mailing list, or on IRC (https://koha-community.org/get-involved/irc/) where there are usually people at all times in all time zones. Best regards, Caroline Caroline Cyr-La-Rose, M.L.I.S. (she/her) Librarian | Product Manager 1-833-INLIBRO (465-4276), ext. 221 caroline.cyr-la-rose(a)inlibro.com https://www.inLibro.com

1 0

Total Fine Paid
by Ma. Victoria H. Silva-Manuel 01 Apr '23

01 Apr '23

I am using the SQL report below for generating Total Fine Paid: SELECT accountlines.Date,borrowers.Cardnumber,borrowers.surname AS > "Students Name", borrowers.firstname AS "First Name", accountlines.Amount > As "Paid Amount" > FROM accountlines, borrowers > WHERE borrowers.borrowernumber = accountlines.borrowernumber AND > accounttype = 'pay' AND date BETWEEN <<Between Date (YYYY-DD-MM)|date>> > AND <<and (yyyy-dd-mm)|date>> > AND borrowers.branchcode=<<branchcode|branches>> > ORDER BY accountlines.Date Is it possible to add the shelving location? We use the shelving location as library sections and we want to determine the paid fines per library section. Thanks. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892

1 0

Analytical cataloguing causing a searching warning
by Aleisha Amohia 31 Mar '23

31 Mar '23

Hi Koha community! We're having some trouble with analytical cataloguing - linking host and child records. We have EasyAnalyticalRecords enabled, and UseControlNumber disabled. When we link the host item using the barcode, the detail page for the child item shows this warning above the title: "There was an error searching for analytic records, please see the logs for details." The Plack Intranet error log shows the following errors: [2022/02/15 13:59:09] [WARN] CCL parsing error (10014) Embedded truncation not supported ZOOM for query: Host-item=(BIBLIO_TITLE /) at /usr/share/koha/lib/C4/Search.pm line 241. [2022/02/15 13:59:09] [WARN] Warning from simple_search_compat: CCL parsing error (10014) Embedded truncation not supported ZOOM at /usr/share/koha/intranet/cgi-bin/catalogue/detail.pl line 152. I have tried also manually linking the host item by cataloguing directly into the 773 of the child item, the searching warning still shows. I have also tried enabling UseControlNumber and putting the 001 of the host record into 773$w of the child item, which has usually worked (the warning disappears), however this method does not work for us because the library doesn't usually fill in the 001. We'd rather keep UseControlNumber disabled. Is this a problem that other libraries have other seen? Have you been able to solve it while keeping EasyAnalyticalRecords enabled and UseControlNumber disabled? Would appreciate any help. Thanks all! -- 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.

4 5