Issue updating from 19.0.6 to 20.0.2

Im running Nextcloud on Nethserver 7.9.2009 and Nextcloud popped a mandatory update to 20.0.2 (cant skip or bypass), I continued with the update by pressing Start Upgrade, now nextcloud is unavailable with the following log:

Detailed logs

Preparing update

Set log level to debug

Turned on maintenance mode

Repair step: Repair MySQL collation

Repair info: Not a mysql database -> nothing to do

Repair step: Repair SQLite autoincrement

Repair step: Copy data from accounts table when migrating from ownCloud

Repair step: Drop account terms table when migrating from ownCloud

Updating database schema

Updated database

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘ALTER TABLE oc_activity_mq ADD COLUMN amq_subjectparams CLOB NOT NULL’: SQLSTATE[HY000]: General error: 1 Cannot add a NOT NULL column with default value NULL

Nextcloud is stuck in maintenance mode.

This is the second time I tried to update Nextcloud in the last 6 months and each time there is an issue.

Have you seen this:

here is an example of what it does:

Have you tried to run “occ upgrade” as it is written in error message?

yes see previous post for output

Have you fixed the SQL error in advance as described in the shared github issue ticket?

yes no effect, I applied all the steps without error
I’m running Nextcloud on Nethserver. which user should I be applying the fix as. Should I restart nextcloud after applying the fix?

my sqlite is 3.7.17

Ok finally got it to update correctly:

  1. run occ app:update --all
  2. run occ app:disable activity
  3. run occ upgrade

Works fine afterwards…would be nice if this was part of the automatic updater…

1 Like