November 2024 - Koha-devel - lists.koha-community.org

Re: [Koha-devel] [Koha] Invalid value "0000-00-00 00:00:00" in field "borrowers.updated_on" with LDAP
by Michael Kuhn 05 May '25

05 May '25

Hi Chris Many thanks for your message! You wrote: > My far from optimal "workaround" (yeah... permanent workaround :) ) > for this issue was to cron a shellscript to run every minute during > library hours which does this: > > /usr/bin/mysql -u *db user* -D "*library database name*" -e "update > borrowers set updated_on = NULL where updated_on = '0000-00-00 > 00:00:00';" &>> /home/*user*/quickfix.log; > > Anything bookended by *'s is redacted. The log catches any errors or > messages. > > I keep meaning to experiment with inserting a NULL value from the xml > LDAP config, but am yet to find a quiet moment for that. Also, not > sure if it's any better a solution, since much as it pains me to run a > polling-type script every minute, it fixes the issue when it's there > but otherwise does nothing with little overhead, whereas re-inserting > a NULL value only has the benefit of being a non-polling approach. > > Anyway, that's one way to do it. I now just implemeted the command in the crontab. It's about the same idea I alread use on my Koha demo installation to prevent some wise guys to change the password of the supreuser so they have the whole installation for themselves - there I reset the password every minute to the original one every minute. As Alex Buckley pointed out in mailinglist "koha-devel" the error is probably fixed with https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36822 in Koha 24.05.06. Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch · W www.adminkuhn.ch > On Mon, Nov 18, 2024 at 8:51 PM Michael Kuhn <mik(a)adminkuhn.ch > <mailto:mik@adminkuhn.ch>> wrote: > > Hi > > In an installation of Koha 24.05.03 I am successfully authenticating > against an LDAP server which is writing the data of the authenticating > user into the Koha database. But as soon as I search for the added user > in the staff client I get the message: "500: Internal Server Error. > Month out of range." This is because table field "borrowers.updated_on" > is automatically filled with the value "0000-00-00 00:00:00". > > I am aware of bug > https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31143 > <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31143> (We > should attempt to fix/identify all cases where '0000-00-00' may still > remain in the database) but of course it is not possible to manually > change the value of field "borrowers.updated_on" from "0000-00-00 > 00:00:00" to NULL every time a user successfully logs into the OPAC. > > So I tried to set the value of "borrowers.updated_on" by using lines > like the following, but unfortunately they all resulted in the invalid > value "0000-00-00 00:00:00". > > <updated_on is="">NULL</updated_on> > <updated_on is="potato"></updated_on> > <updated_on is="">2024-11-18 00:00:00</updated_on> > > How can I prevent Koha filling in this invalid value when > authenticating > against LDAP and instead generate a NULL value? > > Best wishes: Michael > -- > Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis > Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz > T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch > <mailto:mik@adminkuhn.ch> · W www.adminkuhn.ch <http://www.adminkuhn.ch> > _______________________________________________ > > Koha mailing list http://koha-community.org <http://koha-community.org> > Koha(a)lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > <https://lists.katipo.co.nz/mailman/listinfo/koha> >

2 1

Koha Community Newsletter: November 2024
by Michael Kuhn 27 Nov '24

27 Nov '24

The Koha Community Newsletter for November 2024 is here: https://koha-community.org/koha-community-newsletter-november-2024/ Many thanks to everyone who submitted articles and news to this newsletter! Please feel free to email me (mik(a)adminkuhn.ch) with any corrections or suggestions. Michael Kuhn Editor, Koha Community Newsletter

1 0

Koha 24.11.00 is here!
by Fischer, Katrin 26 Nov '24

26 Nov '24

The Koha community is proud to announce the release of Koha 24.11.00. Koha 24.05.00 is a major release that comes with many new features. It includes 10 new features, 184 enhancements, and 647 bugfixes. The full release notes are available here: <https://koha-community.org/?p=10459&preview=true> https://koha-community.org/koha-24-11-00-released/ ‎ Debian packages are already available. Tarballs will be available soon.

4 3

Invalid value "0000-00-00 00:00:00" in field "borrowers.updated_on" with LDAP
by Michael Kuhn 20 Nov '24

20 Nov '24

Hi In an installation of Koha 24.05.03 I am successfully authenticating against an LDAP server which is writing the data of the authenticating user into the Koha database. But as soon as I search for the added user in the staff client I get the message: "500: Internal Server Error. Month out of range." This is because table field "borrowers.updated_on" is automatically filled with the value "0000-00-00 00:00:00". I am aware of bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31143 (We should attempt to fix/identify all cases where '0000-00-00' may still remain in the database) but of course it is not possible to manually change the value of field "borrowers.updated_on" from "0000-00-00 00:00:00" to NULL every time a user successfully logs into the OPAC. So I tried to set the value of "borrowers.updated_on" by using lines like the following, but unfortunately they all resulted in the invalid value "0000-00-00 00:00:00". <updated_on is="">NULL</updated_on> <updated_on is="potato"></updated_on> <updated_on is="">2024-11-18 00:00:00</updated_on> How can I prevent Koha filling in this invalid value when authenticating against LDAP and instead generate a NULL value? Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch · W www.adminkuhn.ch

2 3

Mailinglist "koha" does not accept e-mails from kohanews@gmail.com
by Michael Kuhn 17 Nov '24

17 Nov '24

Hi - to whom it may concern On 28 October I tried to send the e-mail about the current Koha newsletter as usual from the address kohanews(a)gmail.com to both mailinglists "koha" and "koha-devel", but it appeared only in "koha-devel". I also tried to reach the maintainers of list "koha" (as given at the end of page https://lists.katipo.co.nz/mailman/listinfo/koha) but to no avail, so far I didn't get any response. The same happened today with the e-mail concerning the current call for news for the next newsletter - mailinglist "koha-devel" accepted it, but it never appeared in mailinglist "koha". Please anyone tell me what to do to solve this problem with mailinglist "koha". Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch · W www.adminkuhn.ch

2 2

Request for Libraries using Koha to participate in the 2024 Library Automation Perceptions survey
by Marshall Breeding 14 Nov '24

14 Nov '24

To all libraries using Koha: I'm collecting data for the 2024 edition of the International Library Automation Perceptions survey. This survey, conducted annually since 2007, provides an opportunity for libraries to register their perceptions of the strategic automation products they use, organizations that provide these products, and the quality of support delivered. The survey also probes at considerations for migrating to new systems and the level of interest in open source products. As open source software supported both by the general community and by a variety of different service organizations, some special considerations apply to Koha. In the libraries.org directory, Koha is represented by a combination of the name Koha and the primary support organization involved. (For example Koha - Catalyst IT, Koha -- ByWater Solutions). Libraries relying entirely on community support or internal resources are represented as Koha - Independent. If there are any special support arrangements not covered by these conventions, just mention that in the comments area of the survey. In this way the survey will be able to reflect both the functionality of the Koha software and the quality of support provided. This model of representing libraries using Koha isn't perfect, but is a pragmatic approach that aggregates all users of Koha while also segregating the different support scenarios. Participation in this survey will help amplify the visibility of Koha among those interested in library automation. While the numeric rating scales support the statistical results of the study, it's the comments offered that provide the most insight into the current state of library automation satisfaction. Comments will be published in the survey results, redacted to conceal text that might identify the individual or organization responding. The raw data for the survey will not be shared, but reports are available that provide a variety of ways to view results. Please help your fellow librarians who might be in the process of evaluating library automation options by responding to the survey. Any information regarding vendor performance and product quality can be helpful when making strategic decisions regarding automation alternatives. A large number of responses strengthen the impact of the survey and the subsequent report. If you have responded in previous years, please respond again this year to help identify any trends regarding improvement or worsening of the products or support services. For more information about the survey, for instructions on how to participate, and to see results of previous year's survey reports, see: https://librarytechnology.org/perceptions/2024/invite/ I hope that all libraries using Koha will respond. Feel free to forward this request to any other library-related list. You can view the report summarizing the results of last year's survey, including data from all previous editions, here: https://librarytechnology.org/perceptions/2023/ Please let me know if there are any questions regarding the survey. Marshall Breeding Editor, Library Technology Guides www.librarytechnology.org Marshall.breeding(a)librarytechnology.org

1 0

Call for news - Newsletter November 2024
by Koha Newsletter 13 Nov '24

13 Nov '24

Hi I'm collecting news for the November 2024 Koha Community Newsletter. Please send anything noteworthy to: kohanews (at) gmail (dot) com News criteria: * Relevant 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

REMINDER: Development Jitsi meeting 13 November 2024
by Paul Derscheid 12 Nov '24

12 Nov '24

Hi all, We have a Development Jitsi meeting scheduled for tomorrow: https://wiki.koha-community.org/wiki/Development_IRC_meeting_13_November_20… Important: We are going to vote on the roles for 25.05, so it would be nice if many people (including the candidates) were present. Time converter: https://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+Developers+M… Please feel free to add any topics you’d like to discuss to the agenda or let me know and I am happy to add them for you. If you are lead or supporter of a roadmap project, we will be happy to get an update on progress. See you there! Paul

1 0

Koha November security release
by Fridolin SOMERS 12 Nov '24

12 Nov '24

The Koha community is proud to announce the following releases 🤗 : - 24.05.05 - 23.11.10 - 23.05.16 - 22.11.22 These are bugfix/maintenance releases including some important security fixes. It is highly recommended to upgrade 🚀 The full release notes will soon be available here: - https://koha-community.org/koha-24-05-05-released - https://koha-community.org/koha-23-11-10-released - https://koha-community.org/koha-23-05-16-released - https://koha-community.org/koha-22-11-22-released Debian packages are already available 📦 Tarballs will be available soon. Best regards 🤓

1 0