[Koha-bugs] [Bug 32232] New: Koha crashes if dateofbirth is 1947-04-27, 1948-04-25, or 1949-04-24

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32232

            Bug ID: 32232
           Summary: Koha crashes if dateofbirth is 1947-04-27, 1948-04-25,
                    or 1949-04-24
 Change sponsored?: ---
           Product: Koha
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Patrons
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: caroline.cyr-la-rose at inlibro.com
        QA Contact: testopia at bugs.koha-community.org
                CC: gmcharlt at gmail.com, kyle.m.hall at gmail.com

I think this only happens if the server/computer is set to an Eastern Canadian
timezone. In 1947, 1948 and 1949, Canada decided to switch to daylight saving
time at midnight rather than the usual 2am. Therefore, 1947-04-27 00:00:00,
1948-04-25 00:00:00 and 1949-04-24 00:00:00 don't exist in this timezone.

Even if borrowers.dateofbirth is set to 'date' (not 'datetime'), Koha crashes,
saying the date doesn't exist. I suspect it would happen with any date, but
dateofbirth is the most likely (only) field to have dates in those years.

To test:
1. Create a patron, setting the date of birth to one of these three dates
- 1947-04-27
- 1948-04-25
- 1949-04-24
2. Save the patron
--> Error

I tested this on production installations in 21.05 and it works fine.
Production installations in 22.05, it crashes.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.