SQL error while logging in

[pipeten]

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