nextcloud / server

☁️ Nextcloud server, a safe home for all your data
https://nextcloud.com
GNU Affero General Public License v3.0
27.55k stars 4.08k forks source link

[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 #47172

Open Astral-8 opened 3 months ago

Astral-8 commented 3 months ago

⚠️ This issue respects the following points: ⚠️

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?

Configuration report

No response

List of activated Apps

No response

Nextcloud Signing status

No response

Nextcloud Logs

No response

Additional info

No response image_2024-08-10_195953789 image_2024-08-10_200028545

ArtificialOwl commented 3 months ago

what was the previous version before upgrade ?

nextcloud-command commented 2 months ago

This issue has been automatically marked as stale because it has not had recent activity and seems to be missing some essential information. It will be closed if no further activity occurs. Thank you for your contributions.