https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36488
--- Comment #20 from Katrin Fischer <[email protected]> --- We just confirmed: the difference is the strict sql mode. In 24.11 in ktd and package installations it's not possible to enter a false date. Entering more than one zero is blocked. In 22.11.23 it's possible in package installations with DateFormat DD.MM.YYYY to enter 00.00.0000 and it will store a false date. So ktd: DateFormat: ktd default * We checked out 22.11.x and reset the database. * Date of birth now allows to enter more than one zero. * Enter 8 zeros: 00000000 and click outside the field. * Date is shown as: 11/30/00-1 * On saving we get an error: Invalid value passed, borrowers.dateofbirth=00-1-11-30 expected type is date. BUT: the problem occurs without strict_sql_mode: * Deactivated strict_sql_mode in koha-conf.xml * Repeat steps: now you can save the user with the date shown as 11/30/00-1. * SELECT dateofbirth, borrowernumber from borrowers; * Newest entry shows the wrong date 0000-00-00. Updated to latest 23.05: * Wrong date can be entered and is stored. Updated to latest 23.11: * Wrong date can be entered and is stored. Updated to latest 24.05: * Fixed: it's not possible to enter invalid dates anymore. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
