- Koha - lists.katipo.co.nz

Template toolkit puzzle 1.
by Raymund Delahunty 07 Dec '22

07 Dec '22

We have a TT rule working perfectly in MEMBERSHIP_EXPIRY where staff receive one email wording, while students receive different wording, more appropriate for them. [% IF (borrower.categorycode == 'STAFF') %] <staff email wording> [% ELSE %] <student email wording> [% END %] But when I try to use a TT rule in the ODUE message, no email is sent at all- there appears to be an error: [% IF (borrower.dateexpiry == CURDATE() %] <leavers are told to bring all their items back as their account has expired> [% ELSE %] <other users are told to return their overdue items> [% END %] Any ideas? Is CURDATE() correct? This email and any attachments are intended solely for the addressee and may contain confidential information. If you are not the intended recipient of this email and/or its attachments you must not take any action based upon them and you must not copy or show them to anyone. Please send the email back to us and immediately and permanently delete it and its attachments. Where this email is unrelated to the business of University of the Arts London or of any of its group companies the opinions expressed in it are the opinions of the sender and do not necessarily constitute those of University of the Arts London (or the relevant group company). Where the sender's signature indicates that the email is sent on behalf of UAL Short Courses Limited the following also applies: UAL Short Courses Limited is a company registered in England and Wales under company number 02361261. Registered Office: University of the Arts London, 272 High Holborn, London WC1V 7EY

4 5

Patron search not working after upgrade to version 22
by Evan Stewart 06 Dec '22

06 Dec '22

Hello, I recently upgraded my Koka 21 to 22. Everything seemed to be working fine until I tried searching for patrons. Using the intranet portal to search for patrons provides zero results. I see my patrons in the borrowers table, but the GUI won't display them. It's like the search function sees no results. I upgraded to version 22.05.02, but the same problem still occurs. I'm using Raspberry Pi OS (Buster). I can add a new patron, but even the new patron does not show in the search results. Is there a way to refresh the indexer that handles patron searching? Any other suggestions? -Evan Stewart Africa's Hope, USA

5 15

koha-US Board Meeting reminder: Wednesday, December 7, 2022
by Jennifer Marlatt 06 Dec '22

06 Dec '22

The next koha-US Board Meeting is Wednesday, December 7, 2022. When: 8:30a PT / 11:30a ET (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+December+…> ) Where: https://us02web.zoom.us/j/293750042?pwd=SGQzS2pmU3prNFhYRHNaeTFhOHN4QT09 Agenda: https://docs.google.com/document/d/1zb_WnTVxkzTnjPiWfKNgC2_fHTuho0fiWOW9LLT… 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

koha 22.11.00.04: location
by Sebastian Krieg 05 Dec '22

05 Dec '22

Hello community, any idea wher I can manage the content of the field items.items_location as a part of the biblioitems record? I didn't find a configuration entry in "tools" or "administration" and I can't remember who I configure it because you get a list of suggested values. This list I configured in the past, but also the https://schema.koha-community.org/22_11/index.html can't help me. Thanks Sebastian --- mailto: sebastian.krieg(a)tuz-eisenach.de (mailto:sebastian.krieg@tuz-eisenach.de)

2 2

Give patron permission to export database
by Isabel Pineda 05 Dec '22

05 Dec '22

Hi. I have got enabled the Export Database Tab for the tool "Export data" and I would like to give my colleague access to this tool too. Although I give her patron permissions for all tools, the tab does not appear for her. Does anybody know how to give a patron the permissions to access the database export? Thank you Isabel Pineda

3 4

HTML coding
by erlanda_simonyan＠flib.sci.am 05 Dec '22

05 Dec '22

Dear List, we are using Koha 21.05. For the fields 504, 520, 563 we are using HTML coding. In the "Normal view" html tags are seen, which is not normal, but in the ISBD view HTML tags are suppressed and the display of the records is normal. Is this a bug? How can we correct the display? For more details on HTML display, please see: https://vmc.sci.am/cgi-bin/koha/opac-detail.pl?biblionumber=165 https://vmc.sci.am/cgi-bin/koha/opac-ISBDdetail.pl?biblionumber=165 Thanks in advance, Erlanda

2 1

Re: [Koha] koha 22.11 upgrading Error
by Giuseppe Angilella 05 Dec '22

05 Dec '22

Hi, same problem here. Googling around, I've found a related issue here: https://lists.katipo.co.nz/public/koha/2022-October/058542.html It seems to have to do with a constraint on a column, to be removed before the update can be applied, and then to be enforced again. But I wouldn't dare adapting that solution to this specific case without further guidance by someone more expert than me ... Could anyone help, please? Regards, Giuseppe (CC: Sami Rasheed)

3 2

Another DBI Exception for foreign key constraint in upgrade to Koha
by David L. Whelchel 05 Dec '22

05 Dec '22

Hi, The following message was sent and held by the moderator as being too long ten days ago. I have been unable to update to the current version because of this issue. I have removed the detail about the environment and installation that I included and that are usually asked for in a bug report. I will send the details if they are wanted Hi All, It seems like that for every other update I experience a DBI Exception in the update process. In the latest upgrade of 22.05.04-1 to 22.05.05-1 I have received the message: Upgrade to 22.05.04.002 [14:33:32]: Bug 31086 - Do not allow null values in branchcodes for reserves ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Cannot change column 'branchcode': used in a foreign key constraint 'reserves_ibfk_4' at /usr/share/koha/lib/C4/Installer.pm line 739 Indeed, there are null values for branchcodes in the reserves table as I do not have any courses or reserves in my system. Is there a fix for this error? I have included the console log below: Thanks --Dave ------------------------------------------------------------------------------- David L. Whelchel 725 SE Derby Street Pullman, WA 99163 whelchel(a)pullman.com

7 8

"Internal Server Error" after installing Koha -- Database has no tables
by Ryan W 04 Dec '22

04 Dec '22

Hello, I am seeing "Internal Server Error" in my browser after installing Koha locally. I see the error both when I visit the public interface and the staff interface. I followed the steps for installing Koha on Debian/Ubuntu: https://wiki.koha-community.org/wiki/Koha_on_Debian I have also looked at "How to set up a domain name for Koha": https://wiki.koha-community.org/wiki/How_to_set_up_a_domain_name_for_Koha In the plack-error.log I see some entries that suggest tables are missing: C4::Languages::language_get_description(): DBI Exception: DBD::mysql::st execute failed: Table 'koha_demo.language_descriptions' doesn't exist at /usr/share/koha/lib/C4/Languages.pm line 363 I presume these tables will be created by the web installer, once I can get to the web installer. But the 500 error prevents me from accessing the web installer. Or am I wrong that the web installer creates the db tables? Should the tables have been created when I ran... koha-create --create-db demo Thank you, Ryan

2 2

How to activate for edit in Staff Interface
by Sushant Panigrahi 04 Dec '22

04 Dec '22

Dear All, I want to edit to put some information for my staff in staff interface of Koha 20 version. Kindly help. Regards. Sushant

2 1