https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42868
Bug ID: 42868
Summary: Bookings are storing incorrect timezone values
Initiative type: ---
Sponsorship ---
status:
Product: Koha
Version: Main
Hardware: All
OS: All
Status: NEW
Severity: major
Priority: P5 - low
Component: Staff interface
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
CC: [email protected]
Target Milestone: ---
Somehow, between the date picker and the DB, the bookings module is converting
dates incorrectly and setting the wrong dates.
To recreate:
1 - Edit koha-conf.xml
2 - Set timezone:
<timezone>America/New_York</timezone>
3 - In Koha, enable bookings syspref
4 - Find a record, click the items tab, make an item bookable
5 - Place new booking, choose a date range
6 - View the bookings tab - note the booking extends into the date before
7- Check the DB:
MariaDB [koha_kohadev]> select * from bookings WHERE booking_id=2;
+------------+-----------+-----------+---------+-------------------+---------------------+---------------------+---------------------+---------------------+--------+---------------------+
| booking_id | patron_id | biblio_id | item_id | pickup_library_id | start_date
| end_date | creation_date | modification_date |
status | cancellation_reason |
+------------+-----------+-----------+---------+-------------------+---------------------+---------------------+---------------------+---------------------+--------+---------------------+
| 2 | 12 | 437 | 971 | FPL | 2026-06-23
20:00:00 | 2026-06-26 19:59:59 | 2026-06-17 15:00:40 | 2026-06-17 15:00:40 |
new | NULL |
+------------+-----------+-----------+---------+-------------------+---------------------+---------------------+---------------------+---------------------+--------+---------------------+
1 row in set (0.000 sec)
Start date time is 20:00 - really 00:00 minus 4 - New York is UTC minus 4 - it
seems we shouldn't subtract more
--
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/
