Hi,
I see that you have raised a bug now, which is good:
*Bug 36822*
<https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36822> - When
creating a new patron via C4::Auth_with_ldap inserts 0000-00-00 for
invalid updated_on
Katrin
On 04.05.24 00:29, Betka, Corey A wrote:
Hello,
I've inherited a really old install of koha (3.18.11) and I'm trying to
get it migrated to current stable. I've figured out most of the database
upgrade issues along the way thanks to the mailing list archives and old bug
entries, but now I've run into something I can't find a solution for.
Relevant versions:
OS: Ubuntu 22.04
Koha: 23.11.04-4
MySQL: 8.0.36-0ubuntu0.22.04.1
Issue:
When a user is created via LDAP auth to the OPAC, the updated_on field in the borrowers
table is set to "0000-00-00 00:00:00" and this makes it fail to display in the
Intranet interface, showing a 500 error for that page of Patrons or if you search
directly for the patron. If I have the new patron request a change in their record via
OPAC and approve it in the Intranet, the updated_on field changes to a current value and
then things work as expected. That's obviously not scalable.
We have LDAP auth configured to connect to our campus active directory with the
following settings:
<replicate>1</replicate>
<update>1</update>
<auth_by_bind>1</auth_by_bind>
<mapping>
<firstname is="givenName" ></firstname>
<surname is="sn" ></surname>
<userid is="sAMAccountName" ></userid>
<email is="mail" ></email>
<address is="streetAddress" ></address>
<city is="l" >Champaign, IL</city>
<privacy is="" >1</privacy>
<branchcode is="" >TCC</branchcode>
<categorycode is="" >ST</categorycode>
</mapping>
I've done some slight modification to the logging in Patron.pm and the values
that are being logged for updated_on don't make much sense to me:
"updated_on" : { "after" : "SCALAR(0x55fff641bca0)", "before" : "2024-05-03
21:59:40" } }
Any suggestions? Is this a side effect of explicit_defaults_for_timestamp
changing in MySQL? Does mariadb handle this differently? I had to use mysql to
get past some foreign key issues early in the database upgrade scripts, but am
open to migrating to mariadb now that the data can be brought forward.
Thanks,
Corey Betka
Infrastructure Architect
University of Illinois at Urbana-Champaign │ Student Affairs │ Student Affairs
Technology
330 Clark Hall │ 1203 S 4th St │ M/C 548 │ Champaign, IL 61820
_______________________________________________
Koha mailing listhttp://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
