Skip to content

updated_at timezone bug #879

@kjporter

Description

@kjporter

Description
User reported bug that caused a failed insert during the DST switch. Dump:
SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '2026-03-08 02:44:39' for column 'updated_at' at row 1 (Connection: mysql, SQL: update `training_tickets` set `position` = 119, `session_id` = 253, `type` = 12, `date` = 03/07/2026, `start_date` = 2026-03-07, `start_time` = 20:40, `end_time` = 21:45, `duration` = 01:05, `comments` = *, `ins_comments` = *, `draft` = 0, `training_tickets`.`updated_at` = 2026-03-08 02:44:39 where `id` = 10501)

Acceptance Criteria

  • Insert works when in DST swap state

Accepted By:

Dev Notes

XD Notes

Working Branch

PR

Feature Toggle

QA Notes

Deployment Notes

Metadata

Metadata

Assignees

No one assigned

    Labels

    Approved by WMThis project is approved - work may begin nowbugSomething isn't working

    Type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions