HI
Upgrade to Ubuntu 20.04, this forced an upgrade of NC17. I am trying to upgrade to NC18 >NC19 and the NC20.
The NC18 manual upgrade has the message below:
gc@nextccer [/var/www/nextcloud]# sudo -u www-data php occ upgrade -vvv
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
2020-10-10T17:12:30+00:00 Set log level to debug
2020-10-10T17:12:30+00:00 Repair step: Repair MySQL collation
2020-10-10T17:12:30+00:00 Repair info: All tables already have the correct collation -> nothing to do
2020-10-10T17:12:30+00:00 Repair step: Repair SQLite autoincrement
2020-10-10T17:12:30+00:00 Repair step: Copy data from accounts table when migrating from ownCloud
2020-10-10T17:12:30+00:00 Repair step: Drop account terms table when migrating from ownCloud
2020-10-10T17:12:30+00:00 Updating database schema
2020-10-10T17:12:30+00:00 Updated database
2020-10-10T17:12:31+00:00 Updating âŚ
2020-10-10T17:12:31+00:00 InvalidArgumentException: Column name âoc_flow_operationsâ.âentityâ is NotNull, but has empty string or null as default.
2020-10-10T17:12:31+00:00 Update failed
2020-10-10T17:12:31+00:00 Maintenance mode is kept active
2020-10-10T17:12:31+00:00 Reset log level
I did not extract NC18 over /var/www/nextcloud , I renamed the old directory .
There is no apps/workflowengine/appinfo/database.xml file either.
Populating added database structures for workflows
In AbstractMySQLDriver.php line 42:
An exception occurred while executing âSELECT o.id FROM oc_flow_operationso LEFT JOIN oc_flow_operations_scopes O
N o.id = s.operation_id WHERE s.operation_id IS NULLâ:
SQLSTATE[42S02]: Base table or view not found: 1146 Table ânextcloud.oc_flow_operations_scopeâ doesnât exist
In PDOConnection.php line 90:
SQLSTATE[42S02]: Base table or view not found: 1146 Table ânextcloud.oc_flow_operations_scopeâ doesnât exist
In PDOConnection.php line 88:
SQLSTATE[42S02]: Base table or view not found: 1146 Table ânextcloud.oc_flow_operations_scopeâ doesnât exist
Hi Anutosho
I did not use SQLite and have no knowledge on it. Sorry
What I did for phpMyadmin was to setup as âno password for localhost accessâ as I am not a DB person.