SQL error while logging in #21
Description
A recent issue has presented for one of our users. While logging in using their google account they receive a SQL error. The URL is
?controller=OAuthController&action=handler&plugin=GoogleAuth&state=STATE&scope=SCOPE
(SCOPE & STATE removed from URL for sec reasons)
Actual behaviour
While using the google account to login, the following error is received,
Internal Error: SQL Error[22001]: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'value' at row 1
If the page is refreshed then the following error is returned,
Internal Error: SQL Error[42000]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE id = '6'' at line 1
Expected behaviour
To login and present 2fa then view the dashboard
Steps to reproduce
Attempt to login using Google using the google auth plugin
Configuration
- Plugin version: 1.0.8
- Kanboard version: 1.2.26
- Database type and version: MariaDB 10.4.13
- PHP version: 8.1.9
- OS: Centos 7
- Browser: Chrome 109.0.5414.120