Issue updating from 19.0.6 to 20.0.2

[pk198105]

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.

[j-ed]

@pk198105

ALTER TABLE oc_activity_mq ADD COLUMN amq_subjectparams

Have you seen this:

An exception occurred while executing 'ALTER TABLE oc_activity_mq ADD COLUMN amq_subjectparams CLOB NOT NULL'

[pk198105]

here is an example of what it does:

[j-ed]

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

[pk198105]

yes see previous post for output

[j-ed]

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

[pk198105]

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

[pk198105]

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…