Great, thanks Michael!
On 20/11/24 11:31 pm, Michael Kuhn via Koha-devel wrote:
Hi Alex
Many thanks for your message! You wrote:
> We have encountered similar problems with Shibboleth. However, the
> community has helpfully written an upstream fix for preventing
> borrowers.updated_on being filled with 0000-00-00 when a new patron is
> created via LDAP or Shibboleth:
> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36822
>
> So if you can upgrade from 24.05.03 to 24.05.06 (to get the 36822 fix)
> you might be able to stop future invalid borrowers.updated_on data
> being written to the Koha database.
>
> I hope this helps!
Yes, it does! So we will wait for Koha revision 24.05.06 and then
install it.
Meanwhile we implemented the following workaround in the crontab of
Linux user "root" which sets the value of field "borrowers.updated_on"
to NULL every minute if the current value is "0000-00-00 00:00:00":
* * * * * /usr/bin/mysql <databasename> -e "UPDATE borrowers SET
updated_on = NULL WHERE updated_on = '0000-00-00 00:00:00';" &>>
/tmp/bug36822-quickfix.log;
Best wishes: Michael
--
*Alex Buckley (he/him)*
Developer, Implementation Lead | Rōpū kohinga
*Catalyst.Net Limited - Expert Open Source Solutions*
*Catalyst.Net Limited - a Catalyst IT group company*
www.catalyst.net.nz <http://www.catalyst.net.nz>
Follow Catalyst Koha on Twitter <https://twitter.com/catalystkoha> |
Subscribe to the Catalyst Koha newsletter
<https://catalyst.us4.list-manage.com/subscribe?u=62457ff5060d15ee3c07d3fc4&id=b73fbdcac8>
Catalyst Logo
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._______________________________________________
Koha-devel mailing list
Koha-devel@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : https://www.koha-community.org/
git : https://git.koha-community.org/
bugs : https://bugs.koha-community.org/
