Some users from the community reported an issue with the last logged in date format after upgrading to 5.4.0. The following error occurs during database migration. Example of error:
2025-08-13 14:39:49 error: There was an error in V540PopulateLastLoggedInDate. SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '4/24/25, 8:38 AM' for column `passbolt`.`users`.`last_logged_in` at row 1
Query: UPDATE users SET last_logged_in = '4/24/25, 8:38 AM' WHERE id = '<UUID>'
This issue does not affect all users. We suspect it is related to certain locale or server configuration. The team is investigating and will publish a fix as soon as possible.
We apologize for the inconvenience and appreciate your patience while we work on resolving this issue.