Nextcloud version (eg, 20.0.5): Upgrade to 19.0.12 (from 19.0.3?)
Operating system and version (eg, Ubuntu 20.04): Debian 9.13
Apache or nginx version (eg, Apache 2.4.25): Do not find which version ?
PHP version (eg, 7.4): 7.4
I’m trying to upgrade form web upgrade but I have a problem with “music” module and the upgrade failed. Here is my French message:
Préparation de la mise à jour
Réglage du niveau de journalisation à “déboguage”
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 : Repair SQLite autoincrement
É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
Base de données mise à jour
Étape de réparation : Drop any incompatible music database entries
Étape de réparation : Remove any playlist files mistakenly added to music_tracks table
Étape de réparation : Combine multi-disk albums and store disk numbers per track
Étape de réparation : Set creation and update dates for the library entities without one
Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing ‘UPDATE
oc_music_albums
SETcreated
= ? WHEREcreated
IS NULL’ with params [“2021-06-30 11:13:05”]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘created’ in ‘where clause’
So I tried to upgrade form a terminal with:
sudo -u www-data php occ upgrade
But it is the same problem:
Nextcloud or one of the apps require upgrade - only a limited number of commands are available
You may use your browser or the occ upgrade command to do the upgrade
Set log level to debug
Turned on maintenance mode
Updating database schema
Updated database
Updating …
Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing ‘UPDATEoc_music_albums
SETcreated
= ? WHEREcreated
IS NULL’ with params [“2021-06-30 16:00:01”]:SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘created’ in ‘where clause’
Update failed
Maintenance mode is kept active
Reset log level
Finally, I’m locked in maintenance mode and no idea how to escape from this situation.
Any help will be really nice.
Regards,