- Koha - lists.katipo.co.nz

The Terrific Every-Other-Thursday Training Video | S3E10 | Custom Alerts
by BRANNON, CHRISTOPHER 19 Jan '23

19 Jan '23

Where's George? Probably doing something exciting. Sorry we didn't give you a heads up. But if you want a better heads up in Koha, then this week's video is for you. Christopher will share how to create custom alerts for check in, or whatever else floats your boat. He'll demonstrate how he created a custom alert for deactivated devices that have made their way back to the library. https://youtu.be/IMW_6DIoh4o Christopher Brannon koha-US 2023 President

1 0

[Docs] Screenshot update extravaganza at Hackfest
by Caroline Cyr La Rose 19 Jan '23

19 Jan '23

Hi everyone! I'm not sure if I'm allowed to say, "We're doing this at hackfest!" without consulting anyone, but here goes... We had a documentation meeting today and Aude raised the idea of using the hackfest to pool our resources to update the screenshots in the manual for the new staff interface design. We thought this was a great idea! We don't currently have an automation setup or anything so if any developer is open to help us with this it would be great. I know Jonathan talked to me of "Cucumber" many years ago, and David was also working on something, but neither panned out so far. Barring automation, if we all get into it and work as a team, we could do a lot of them manually too. Note that this is open to virtual participation! It's fun to be together to work alongside each other, but if someone can't make it to Marseille, the chat will be open or we can plan video chats too. Regards, Caroline <https://inLibro.com/en> Caroline Cyr-La-Rose, M.L.I.S. Librarian | Product Manager P 833-INLIBRO (465-4276) <tel:833-465-4276>, poste 221 E caroline.cyr-la-rose(a)inlibro.com www.inLibro.com <https://inLibro.com/en>

1 0

Sorry, your Google login failed
by tony.h 18 Jan '23

18 Jan '23

Greetings, I'm having trouble getting the Google login to work since upgrading/rebuilding Koha (we rebuilt the VPS and followed the install guide: https://wiki.koha-community.org/wiki/Debian) *The problem:* 1) I can log in through my local account, no problem. 2) I then try to login through my Google account 3) After pressing allow from the accounts.google.com site, a message is displayed: /Sorry, your Google login failed. .../ The full message is below. "Log in to your account Google login Sorry, your Google login failed. The email address you are trying to use is not associated with a borrower at this library. Please note that the Google login will only work if you are using the e-mail address registered with this library. If you want to, you can try to log in using a different account Log in with Google If you do not have a Google account, but do have a local account, you can still log in:" There are no errors in the Apache log files. *Configuration* Since we had troubles, I'm following the testing guide to configure the OAuth login: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10988#c68 I removed the Google OAuth entries: DELETE FROM systempreferences WHERE variable LIKE 'GoogleO%'; I then ran the upgrade schema tool, as I did when I imported the db: sudo koha-upgrade-schema keiin_lib I added values back in admin panel (Home › Administration › System preferences > Google OpenID Connect I confirmed the 4 values are displayed in the MySQL DB: SELECT * FROM systempreferences WHERE variable LIKE 'GoogleO%'; Any thoughts? Tony -- View this message in context: http://koha.1045719.n5.nabble.com/Sorry-your-Google-login-failed-tp5895227.… Sent from the Koha-general mailing list archive at Nabble.com.

5 5

22.11.02 Koha String Freeze
by O'Mara, Jacob 18 Jan '23

18 Jan '23

Hello all, Happy New Year! This email is to announce a String Freeze for the coming 22.11.02 release of Koha stable. Kind regards, -- *Jacob O'Mara* *Junior Software Engineer* E: jacob.omara(a)ptfs-europe.com <andrew.auld(a)ptfs-europe.com> P: +44 (0) 1483 378728 ext. 1019 www.ptfs-europe.com

1 0

Koha upgrade and restore issue
by vinod mishra 18 Jan '23

18 Jan '23

Hello I wish to restore the database from one server to other in same version (22.05.07.000) but while running the " *sudo koha-upgrade-schema library*" command it through following error. Almost same error getting while running " *sudo koha-rebuild-zebra -v -f library* " command. Please suggest the possible issue. root@koha-OptiPlex-9010:/home/koha# sudo koha-upgrade-schema library 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. root@koha-OptiPlex-9010:/home/koha# With Regards, Vinod Kumar Mishra, Assistant Librarian, Biju Patnaik Central Library (BPCL), NIT Rourkela, Sundergadh-769008, Odisha, India. Mob:91+9439420860 URL: http://vinod.itshelp.co.in/ ORCID ID: http://orcid.org/0000-0003-4666-7874 Scopus ID: 57223138343 *"Spiritual relationship is far more precious than physical. Physical relationship divorced from spiritual is body without soul" -- Mahatma Gandhi*

1 0

SQL for Report generation - Help needed
by Manoj Kumar 18 Jan '23

18 Jan '23

Can anyone help me to write the sql code for retrieving Most checked out books of a particular range of call numbers and the patron who took those books. Regards manoj -- manoj

1 0

Fine calculation on over dues books
by Banesh Hiremath 18 Jan '23

18 Jan '23

Hi, I'm using the KOHA 21.05.02.000 version. In this version, the fine does not appear on overdue items, but it appears after the book is returned. When students access the OPAC, the fine does not appear. Please assist us in resolving the above issue. -- Thanks and Regards B. K. Hiremath

4 3

debian OS image cd or dvd - which one to be used?
by SATISH 17 Jan '23

17 Jan '23

Hi, Regarding installation of Operating System (Debian for Koha) what is the difference between using cd image or dvd image. I understand that the DVD image has a complete set of packages whereas NetInst CD image has only a limited number of packages required to boot into installation. I follow wiki pages and other various blogs for installation. However, I would like to know, selecting cd or dvd really helps koha or maintenance of the system? because I am going to use the packages method of installation for koha. Kindly advise. -- *Satish MV* Librarian - Govt. Engineering College Opp. Dairy Circle, B.M.Road, Hassan 573 201 Karnataka, INDIA Mobile: +91 9449765737

2 1

Item page's display status text problem in staff
by 陳世強 16 Jan '23

16 Jan '23

Dear All, Our Koha version is 21.05.12. After I changed the 952$7 subfield of the items to "Not For Loan"(Chicese mean "不外借"), the status text of the item is displayed as "不外借 ()(不外借)" in the Chinese page, but that "()" is extra and unnecessary, it should be displayed as "Not for loan (不外借)" like the English page. The authorised value looks like no problem, you can view my screenshots at https://imgur.com/a/eLvAIWV In Chinese interface, the extra "()" will appear, but it doesn't appear in English interface, And I also went to Koha Translation website to check, but I didn't see any translation with the extra "()", how can I make it display as "不外借 (不外借)" ? Sincerely, Atron Chen

1 0

Koha releases are available 🎁
by Mason James 16 Jan '23

16 Jan '23

kia ora community, the latest Koha packages and tarballs are ready release notes are here... https://koha-community.org/koha-21-11-03-released https://koha-community.org/koha-21-05-11-released https://koha-community.org/koha-20-11-15-released https://koha-community.org/koha-19-11-26-released cheers, Mason

2 2