2FA broken in 27.x due to missing DB column
- Status
- Open
- Subject
- 2FA broken in 27.x due to missing DB column
- Version
- 27.x
- Category
- Bug
- Error
- Usability
- Feature
- User Administration (Registration, Login & Banning)
- Resolution status
- New
- Submitted by
- kinetix
- Lastmod by
- kinetix
- Rating
- Description
Enabling 2FA for a user works, but when trying to login, one is presented with a System Error page. With debug enabled, we see:
'''
System error.The following error message was returned:
Unknown column 'last_mfa_date' in 'SET'
The query was:
update `users_users` set `last_mfa_date` = ? WHERE `login` = ?Values:
1788618450
usernameThe built query was likely:
update `users_users` set `last_mfa_date` = '1788618450' WHERE `login` = 'username'
'''I can confirm that adding in the column manually with:
alter table users_users add column if not exists last_mfa_date bigint DEFAULT NULL;
has allowed me to login/logout with MFA enabled.
- Importance
- 10 high
- Easy to solve?
- 10 easy
- Priority
- 99
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 9024
- Created
- Saturday 05 September, 2026 14:48:51 UTC
by kinetix - LastModif
- Saturday 05 September, 2026 14:48:51 UTC