[Bug]: Database error when running migration 29000Date20240124132201 for app core An exception occurred while executing a query: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'type' at row 1

⚠️ This issue respects the following points: ⚠️

• This is a bug, not a question or a configuration/webserver/proxy issue.
• This issue is not already reported on Github OR Nextcloud Community Forum (I've searched it).
• Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
• I agree to follow Nextcloud's Code of Conduct.

Bug description

I'm new to nextcloud and Github and I'm going around in circles without finding a solution to this problem...
My Nextcloud instance is on portainer/Docker which are on openmediavault

Mettre à jour vers 29.0.4
Exception: Database error when running migration 29000Date20240124132201 for app core An exception occurred while executing a query: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'type' at row 1

Journaux détaillés
Préparation de la mise à jour

Réglage du niveau de journalisation à « débogage »

Mode de maintenance activé

Étape de réparation : Repair MySQL collation

Informations de réparation : All tables already have the correct collation -> nothing to do

Étape de réparation : Copy data from accounts table when migrating from ownCloud

Étape de réparation : Drop account terms table when migrating from ownCloud

Mise à jour du schéma de la base de données

Exception: Database error when running migration 29000Date20240124132201 for app core An exception occurred while executing a query: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'type' at row 1

La mise à jour a échoué. Veuillez reporter le problème à la communauté Nextcloud.

Steps to reproduce

1. désactivé le mode maintenance
2. Ouvrir son url nextcloud
3. Mettre à jour

Expected behavior

que ça marche

Installation method

None

Nextcloud Server version

28

Operating system

None

PHP engine version

None

Web server

Nginx

Database engine version

MariaDB

Is this bug present after an update or on a fresh install?

None

Are you using the Nextcloud Server Encryption module?

None

What user-backends are you using?

• Default user-backend (database)
• LDAP/ Active Directory
• SSO - SAML
• Other

Configuration report

No response

List of activated Apps

No response

Nextcloud Signing status

No response

Nextcloud Logs

No response

Additional info

No response

Start with migration 29000Date20240124132201 and the reported MariaDB warning for the type column. Review the migration against the affected database schema and reproduce the update from Nextcloud 28 to 29. Done means the migration completes without the data-truncation error.