April 2025 - 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

REMINDER: Development Jitsi meeting 7 May 2025
by Paul Derscheid 30 Apr '25

30 Apr '25

Hi all, We have a Development Jitsi meeting scheduled for Wednesday next week: https://wiki.koha-community.org/wiki/Development_IRC_meeting_7_May_2025 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. Note: I was asked to send an additional reminder a week early and this is the first time I managed to remember on time :) See you there! Paul

1 0

Koha, hackfest, bibframe, initiating discussion
by Paul Poulain 30 Apr '25

30 Apr '25

Hello, Opening the thread here, so ppl not attending the hackfest know what I plan to talk about during the hackfest. The LoC is moving to bibframe. In France, ABES seems to plan the same movement. So, I want to look after bibframe, see what people think about it, how it could be implemented in Koha... I've started a presentation, it's a 1st step to start the discussion. Feel free to take a look at it and add some comment. If you want a "modify" access, just ask me. https://docs.google.com/presentation/d/18RniwMJROfMHWy_1eeJ2zscg-qrh1NcndPJ… Very excited to see some of you in 10 days ! -- Paul Poulain, Associé-gérant / co-owner BibLibre, Services en logiciels libres pour les bibliothèques BibLibre, Open Source software and services for libraries

2 2

Koha Community Newsletter: April 2025
by Michael Kuhn 29 Apr '25

29 Apr '25

The Koha Community Newsletter for April 2025 is here: https://koha-community.org/koha-community-newsletter-april-2025/ Many thanks to everyone who submitted articles and news to this newsletter! Please feel free to e-mail me (mik(a)adminkuhn.ch) with any corrections or suggestions. Michael Kuhn Editor, Koha Community Newsletter -- 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

1 0

REMINDER: Development Jitsi meeting 23 April 2025
by Paul Derscheid 22 Apr '25

22 Apr '25

Hi all, We have a Development Jitsi meeting scheduled for tomorrow: https://wiki.koha-community.org/wiki/Development_IRC_meeting_23_April_2025 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. See you there! Paul

1 0

25.05 Release schedule / Reminder
by Fischer, Katrin 17 Apr '25

17 Apr '25

Hi all, it's coming to an end. 25.05 is getting close! Deadlines . 2025-04-29 - Soft feature freeze . 2025-05-13 - Hard feature freeze and string warning . 2025-05-21 - Hard bug freeze and string freeze . 2025-05-27 - Release Day! For more details please check: https://wiki.koha-community.org/wiki/Roadmap_25.05 How can you help? . Make sure your patches apply, especially when waiting for QA or when waiting to be pushed. . Speedy reactions to questions and follow-up requests will help a lot. . Write release notes for any enhancements still missing them. . And of course the usual: sign off and QA! Also: We are looking for a new Release team - so now is the time to reach out if you want to learn more about any of the roles . or to sign up! https://wiki.koha-community.org/wiki/Roles_for_25.11 Katrin

1 0

Call for news - Newsletter April 2025
by Michael Kuhn 13 Apr '25

13 Apr '25

Hi I'm collecting news for the April 2025 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

Kohacon25 Registrations open
by Chris Cormack 13 Apr '25

13 Apr '25

We arepleased to announce that registrations are now open for KohaCon25, the global gathering celebrating 25 years of Koha, the world's first open-source library management system. This milestone event marks Koha's return to its birthplace in Aotearoa New Zealand. Registration Details Registration Link: https://kohacon25-1.lilregie.com/ Conference Website: https://2025.kohacon.org/ Important Registration Guidelines - Registration is mandatory for all in-person attendees - Registration is free of charge but required for planning purposes - Please register only if you will attend in person in Te Whanganui-a-Tara | Wellington = Do not register if you cannot attend in person = Online participants do not need to register for live-streamed sessions Event Overview KohaCon25 will take place in Te Whanganui-a-Tara | Wellington from 17-23 November 2025, featuring: Conference Days (17-19 November): Presentations, keynotes, and discussions exploring Koha's journey and future Cultural Activities Day (20 November): Opportunities to experience Wellington Working Together Days (21-23 November): Collaborative workshops, development sprints, and community building Why Attend? KohaCon25 represents a significant homecoming as we celebrate a quarter-century since Koha emerged from the Horowhenua Library Trust. Named after the Māori concept of 'koha' - a gift that strengthens communities - this gathering offers an opportunity to honour the system's whakapapa while creating pathways for its continued evolution. Join library professionals, developers, and open-source advocates from around the world as we reflect on the journey of Koha from a local initiative to a global phenomenon serving thousands of libraries worldwide. Ngā mihi nui | With appreciation KohaCon25 is made possible through the generous support of our sponsors: Pounamu Sponsors: ByWater Solutions, Catalyst IT, Biteca Tūhua Sponsors: Auckland University of Technology (AUT), LMSCloud Pāua Sponsors: Bob and Irma Birchall, Patu To The Face As a Service For questions or further information, please contact: organisers(a)kohacon.org Nau mai, haere mai ki Te Whanganui-a-Tara, ki Aotearoa | Welcome to Wellington, New Zealand

1 1

Community positions for 25.11 cycle
by Paul Derscheid 09 Apr '25

09 Apr '25

Hi all, It’s that time again; we’re coming up to release time for 25.05, and that means picking the team for the 25.11 cycle! Please see the roles page at https://wiki.koha-community.org/wiki/Roles_for_25.11 and add your name to a role if you would like to propose volunteering for it. The team vote will take place on May 7th at the development meeting after the next. We’d love to see some new faces on the team, and it’s just as important to have non-developers helping to guide the ship as it is the developers! Some roles we’d like to draw your attention to: * Bug Wranglers <https://wiki.koha-community.org/wiki/Project_roles#Bug_wrangler> - We can always do with more bug wranglers! These people love to keep things tidy, and Bugzilla is always in need of your help. We need people to help manage ‘the list’, identify the duplicates, promote bugs to specialists, and find people to do signoffs and testing. Everyone is invited to this party; we need you! This is a great first-time role to take on, and it makes a real difference to active community contributors’ lives! * Documentation Team <https://wiki.koha-community.org/wiki/Project_roles#Documentation_team> - The documentation team is a growing team that’s made great inroads into bringing Koha’s documentation up to date and ensuring we have a well-documented piece of software. There’s plenty more to do, and they’re always on the lookout for new contributors. The documentation team is a super-friendly group and would love to see you join them. What I’d also love to see are developers taking a look at the documentation team to support with infrastructure, approaches, or more technically challenging parts of Koha. * Wiki Curators <https://wiki.koha-community.org/wiki/Project_roles#Wiki_team> - Koha’s wiki is bursting at the seams with good information, but we need your help to bring order to the chaos and keep improving the content. If you’ve got an interest in maintaining an area of the Wiki, helping identify out-of-date information, or categorising data, then this is a job for you. * Meeting Facilitators <https://wiki.koha-community.org/wiki/Project_roles#Meeting_facilitators> - We have regular meetings in the community to discuss development progress, documentation tasks, and general community needs. It would be really helpful to have someone to help promote those meetings, keep them on track, and work on the minutes. Right now, these meetings are run by me with help from the attendees, except for the documentation team, where the burden currently lies on the team managers. I’d also like to initiate and work on the meeting automations and especially: share knowledge! * Accessibility Advocate <https://wiki.koha-community.org/wiki/Project_roles#Accessibility_advocate> - In Koha, we really want to be open and accessible to all, but accessibility is an area that many of us are not as aware of as we should be. We’d like to have some people helping to promote best practices and report accessibility issues we might not be aware of. If you’d like to volunteer for any of the roles, I am happy to chat about the ones I have experience in or point you to a person that is better suited to give you an overview. We don’t bite, so be curious and be confident. No matter what you do, in the end, it’s always a rewarding experience and an opportunity to grow that you don’t find just anywhere. Kind regards, Paul Derscheid

1 0

REMINDER: Development Jitsi meeting 9 April 2025
by Paul Derscheid 09 Apr '25

09 Apr '25

Hi all, We have a Development Jitsi meeting scheduled for today: https://wiki.koha-community.org/wiki/Development_IRC_meeting_9_April_2025 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