I’ve looked for this, but can’t find any other threads on this error.
Upgrading from 9.1.6 to 10.0.8.
From command line.
apt-get update
sudo -u www-data ./occ maintenance:mode --on
service apache2 stop
apt-get update && apt-get install owncloud-files
sudo -u www-data php occ upgrade
… read some docs on disabling apps …
sudo -u www-data php /var/www/owncloud/occ app:disable calendar
sudo -u www-data php /var/www/owncloud/occ app:disable contacts
sudo -u www-data php /var/www/owncloud/occ app:disable documents
sudo -u www-data php /var/www/owncloud/occ app:disable ownnote
sudo -u www-data php /var/www/owncloud/occ app:disable activity
sudo -u www-data php /var/www/owncloud/occ maintenance:mode --off
sudo -u www-data php occ upgrade
I am getting the following error during upgrade:
ownCloud 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
June 12, 2018 23:05:54 Set log level to debug
June 12, 2018 23:05:54 Repair step: Repair MySQL database engine
June 12, 2018 23:05:54 Repair info: Not a mysql database -> nothing to do
June 12, 2018 23:05:54 Repair step: Repair MySQL collation
June 12, 2018 23:05:54 Repair info: Not a mysql database -> nothing to do
June 12, 2018 23:05:54 Repair step: Repair SQLite autoincrement
June 12, 2018 23:05:54 Repair step: Repair orphaned reshare
June 12, 2018 23:05:54 Repair step: Repair duplicate entries in oc_lucene_status
June 12, 2018 23:05:54 Repair info: removing duplicate entries from lucene_status
June 12, 2018 23:05:54 Repair step: Upgrade app code from the marketplace
June 12, 2018 23:05:54 Repair info: Enabling market app to assist with update
June 12, 2018 23:05:54 Repair info: Using market to update existing apps
June 12, 2018 23:05:54 Repair info: Attempting to update the following existing compatible apps from market:
June 12, 2018 23:05:54 Repair info: Fetching app from market: comments
June 12, 2018 23:05:56 Repair info: App (comments) is not known at the marketplace.
June 12, 2018 23:05:56 Repair info: Fetching app from market: configreport
June 12, 2018 23:05:57 Repair info: App (configreport) is not known at the marketplace.
June 12, 2018 23:05:57 Repair info: Fetching app from market: dav
June 12, 2018 23:05:58 Repair info: App (dav) is not known at the marketplace.
June 12, 2018 23:05:58 Repair info: Fetching app from market: federatedfilesharing
June 12, 2018 23:06:00 Repair info: App (federatedfilesharing) is not known at the marketplace.
June 12, 2018 23:06:00 Repair info: Fetching app from market: files
June 12, 2018 23:06:01 Repair info: App (files) is not known at the marketplace.
June 12, 2018 23:06:01 Repair info: Fetching app from market: files_external
June 12, 2018 23:06:01 Repair info: App (files_external) is not installed
June 12, 2018 23:06:01 Repair info: Fetching app from market: files_sharing
June 12, 2018 23:06:02 Repair info: App (files_sharing) is not known at the marketplace.
June 12, 2018 23:06:02 Repair info: Fetching app from market: files_texteditor
June 12, 2018 23:06:03 Repair info:
June 12, 2018 23:06:03 Repair info: Fetching app from market: files_trashbin
June 12, 2018 23:06:05 Repair info: App (files_trashbin) is not known at the marketplace.
June 12, 2018 23:06:05 Repair info: Fetching app from market: files_versions
June 12, 2018 23:06:07 Repair info: App (files_versions) is not known at the marketplace.
June 12, 2018 23:06:07 Repair info: Fetching app from market: firstrunwizard
June 12, 2018 23:06:08 Repair info: App (firstrunwizard) is not known at the marketplace.
June 12, 2018 23:06:08 Repair info: Fetching app from market: gallery
June 12, 2018 23:06:09 Repair info:
June 12, 2018 23:06:09 Repair info: Fetching app from market: market
June 12, 2018 23:06:11 Repair info:
June 12, 2018 23:06:11 Repair info: App was not updated: comments
June 12, 2018 23:06:11 Repair info: App was not updated: configreport
June 12, 2018 23:06:11 Repair info: App was not updated: dav
June 12, 2018 23:06:11 Repair info: App was not updated: federatedfilesharing
June 12, 2018 23:06:11 Repair info: App was not updated: files
June 12, 2018 23:06:11 Repair info: App was not updated: files_external
June 12, 2018 23:06:11 Repair info: App was not updated: files_sharing
June 12, 2018 23:06:11 Repair info: App was not updated: files_texteditor
June 12, 2018 23:06:11 Repair info: App was not updated: files_trashbin
June 12, 2018 23:06:11 Repair info: App was not updated: files_versions
June 12, 2018 23:06:11 Repair info: App was not updated: firstrunwizard
June 12, 2018 23:06:11 Repair info: App was not updated: gallery
June 12, 2018 23:06:11 Repair info: App was not updated: market
June 12, 2018 23:06:11 Updating database schema
June 12, 2018 23:06:11 Updated database
June 12, 2018 23:06:11 Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT quote_ident(table_name) AS table_name,
table_schema AS schema_name
FROM information_schema.tables
WHERE table_schema NOT LIKE ‘pg_%’
AND table_schema != ‘information_schema’
AND table_name != ‘geometry_columns’
AND table_name != ‘spatial_ref_sys’
AND table_type != ‘VIEW’’:
SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block
June 12, 2018 23:06:11 Update failed
June 12, 2018 23:06:11 Maintenance mode is kept active
June 12, 2018 23:06:11 Reset log level