small nextcloud installation less than 100 files, not expected to grow, so
‘dbtype’ => ‘sqlite3’
only used for contacts, addresses, calendar and with the news app as an rss reader
Support intro
Nextcloud
Update to 18.0.1
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'UPDATE "oc_flow_operations" SET "entity" = ? WHERE "entity" = ''' with params ["OCA\\WorkflowEngine\\Entity\\File"]: SQLSTATE[HY000]: General error: 1 no such column: entity
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
Repair step: Migrate old user config
[1 / 0]: Migrate old user config
[1 / 1]: Migrate old user config
Updated "accessibility" to 1.4.0
Updated "federatedfilesharing" to 1.8.0
Updated "files_pdfviewer" to 1.7.0
Updated "files_rightclick" to 0.15.2
Updated "files_videoplayer" to 1.7.0
Updated "logreader" to 2.3.0
Updated "password_policy" to 1.8.0
Updated "privacy" to 1.2.0
Updated "provisioning_api" to 1.8.0
Updated "recommendations" to 0.6.0
Updated "serverinfo" to 1.8.0
Updated "support" to 1.1.0
Updated "survey_client" to 1.6.0
Updated "text" to 2.0.0
Repair step: Add background job to check for backup codes
Updated "twofactor_backupcodes" to 1.7.0
Updated "updatenotification" to 1.8.0
Updated "federation" to 1.8.0
Updated "lookup_server_connector" to 1.6.0
Repair step: Update OAuth token expiration times
Updated "oauth2" to 1.6.0
Updated "files" to 1.13.1
Updated "activity" to 2.11.0
Updated "cloud_federation_api" to 1.1.0
Repair step: Fix component of birthday calendars
Repair info: 2 birthday calendars updated.
Repair step: Regenerating birthday calendars to use new icons and fix old birthday events without year
Repair info: Repair step already executed
Repair step: Fix broken values of calendar objects
[0 / 0]: Fix broken values of calendar objects
Repair step: Registering building of calendar search index as background job
Repair info: Repair step already executed
Repair step: Registering background jobs to update cache for webcal calendars
Repair info: Added 0 background jobs to update webcal calendars
Repair step: Registering building of calendar reminder index as background job
Repair info: Repair step already executed
Repair step: Clean up orphan event and contact data
Repair info: 0 events without a calendar have been cleaned up
Repair info: 0 properties without an events have been cleaned up
Repair info: 0 changes without a calendar have been cleaned up
Repair info: 0 cached events without a calendar subscription have been cleaned up
Repair info: 0 changes without a calendar subscription have been cleaned up
Repair info: 0 contacts without an addressbook have been cleaned up
Repair info: 0 properties without a contact have been cleaned up
Repair info: 0 changes without an addressbook have been cleaned up
Repair step: Remove activity entries of private events
Repair info: Removed 0 activity entries
Updated "dav" to 1.14.0
Repair step: Fix the share type of guest shares when migrating from ownCloud
Repair step: Copy the share password into the dedicated column
Repair step: Set existing shares as accepted
Updated "files_sharing" to 1.10.1
Updated "files_trashbin" to 1.8.0
Updated "files_versions" to 1.11.0
Updated "sharebymail" to 1.8.0
Repair step: Populating added database structures for workflows
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'UPDATE "oc_flow_operations" SET "entity" = ? WHERE "entity" = ''' with params ["OCA\\WorkflowEngine\\Entity\\File"]: SQLSTATE[HY000]: General error: 1 no such column: entity
The update was unsuccessful. Please report this issue to the Nextcloud community.
Nextcloud version (eg, 12.0.2): 17.0.3.1
Operating system and version (eg, Ubuntu 17.04): latest stable slackware 14.2 32bit
Apache or nginx version (eg, Apache 2.4.25): apache httpd-2.4.39
PHP version (eg, 7.1): php-7.2.22
The issue you are facing:
have a daily backup, tried the update via web and console occ
Is this the first time you’ve seen this error? (Y/N): Y
Steps to replicate it:
small sqlite3 database
- latest version nextcloud version: 17.0.3.1
- update via web or console to 18.0.1
- always an error
The output of your Nextcloud log in Admin > Logging:
Info updater \OC\Updater::maintenanceActive: Maintenance mode is kept active  2020-03-04T16:51:07+0100
Error updater \OC\Updater::updateEnd: Update failed  2020-03-04T16:51:07+0100
Error updater \OC\Updater::failure: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'UPDATE "oc_flow_operations" SET "entity" = ? WHERE "entity" = ''' with params ["OCA\\WorkflowEngine\\Entity\\File"]: SQLSTATE[HY000]: General error: 1 no such column: entity  2020-03-04T16:51:07+0100
Error core Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'UPDATE "oc_flow_operations" SET "entity" = ? WHERE "entity" = ''' with params ["OCA\\WorkflowEngine\\Entity\\File"]: SQLSTATE[HY000]: General error: 1 no such column: entity  2020-03-04T16:51:07+0100
Info updater \OC\Repair::step: Repair step: Populating added database structures for workflows
The output of your config.php file in /path/to/nextcloud
(make sure you remove any identifiable information!):
<?php
$CONFIG = array (
'instanceid' => '123',
'passwordsalt' => '456',
'secret' => '789',
'trusted_domains' =>
array (
),
'datadirectory' => '/var/nextcloud/data',
'dbtype' => 'sqlite3',
'version' => '17.0.3.1',
'overwrite.cli.url' => 'http://mydomain/~myuser/nextcloud',
'installed' => true,
'maintenance' => false,
'mail_smtpmode' => 'sendmail',
'mail_smtpsecure' => 'ssl',
'mail_sendmailmode' => 'pipe',
'mail_from_address' => 'myuser',
'mail_domain' => 'mydomain',
'mail_smtpauthtype' => 'LOGIN',
'mail_smtpauth' => 1,
'mail_smtphost' => 'mydomain',
'mail_smtpname' => 'myuser',
'mail_smtppassword' => '123',
'theme' => '',
'loglevel' => 2,
'updater.release.channel' => 'stable',
'app_install_overwrite' =>
array (
0 => 'files_reader',
),
'has_rebuilt_cache' => true,
'updater.secret' => '123456789hidden123456789',
);