Error Field 'token_type doesn't have a default value' after NC 29.0.5 upgrade

[AmonBune]

Nextcloud version: Nextcloud Hub 8 (29.0.5)
Operating system and version: Arch Linux (fully updated)
nginx version: 1.26.2
PHP version: 8.3.10

The issue you are facing:

After upgrading from Nextcloud 29.0.4 to 29.0.5 I always get the following error when executing “occ maintenance:repair”:

 - Convert multi accounts
     - ERROR: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1364 Field 'token_type' doesn't have a default value

This error also gets reflected in the Logging together with another error:

Error	no app in context	
DbalException An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1364 Field 'token_type' doesn't have a default value
Exception while executing repair step Convert multi accounts 

Warning	no app in context	
DbalException An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory
exception while getMetadataFromDatabase() 

Is this the first time you’ve seen this error? : Yes

How can I fix the database table/data so the error goes away?

[HFNextcluduser]

Same issue here with my instance.

How can we solve it? This depends to a strict SQL Setting. But why is this an updrade issue and not in normal operations?

We are the upgrade scripts hidden?

[koelle25]

Same problem here with 28.0.9. I will create a bug report on GitHub.

EDIT: GitHub issue is here: [Bug]: maintenance:repair -> Convert multi accounts -> SQLSTATE ERROR · Issue #47478 · nextcloud/server · GitHub

[jtr]

It’s coming from the integration_gitlab app.