Change timestamp data type. #1228

New Issue

MrUnknownDE · 2026-04-06T01:41:31+02:00

MrUnknownDE commented

2026-04-06 01:41:31 +02:00

Originally created by @gzfrozen on 2/15/2024

Fix the "Year 2038 problem".

Change the data type of last_used in twofactor table.
Create migration files.
Delete unnessary type convertion.
Tested in SQlite, MySQL, Postgres.
- Test method: add the two step authenticator to a account using the original code, then update the code to see if it can still login

I am not confident if it is the only "Year 2038 problem". If there are still other problems please let me know.

Fixes #4177

*Originally created by @gzfrozen on 2/15/2024* Fix the "Year 2038 problem". - Change the data type of `last_used` in `twofactor` table. - Create migration files. - Delete unnessary type convertion. - Tested in SQlite, MySQL, Postgres. - Test method: add the two step authenticator to a account using the original code, then update the code to see if it can still login I am not confident if it is the only "Year 2038 problem". If there are still other problems please let me know. Fixes #4177

MrUnknownDE closed this issue

2026-04-06 01:41:32 +02:00

Sign in to join this conversation.

No Label

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github/vaultwarden#1228