Upgrade from 17.0.3.1 to 18.0.1 broken, SQLSTATE[HY000]: General error: 1 no such column: entity

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

  1. latest version nextcloud version: 17.0.3.1
  2. update via web or console to 18.0.1
  3. 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',
);

Sounds like Read this before you update to Nextcloud 18

Hello, thanks for the answer,

I logged into my nextcloud, got a bell notification, "version 18.0.1 is available¨

looked into Administration, my current version

Nextcloud 17.0.3

A new version is available: Nextcloud 18.0.1

All apps have an update for this version available

Clicked on “open updater” and followed instructions on my browser.

the update is broken for me, I used my daily backup to recover my old version,

still getting the same update info for “18.0.1” again

have fun, Frank

I have console access.

This morning I tried with a new download, followed every step from:

https://docs.nextcloud.com/server/18/admin_manual/maintenance/manual_upgrade.html

still the same error. Upgrade to 18 from 17 is completely broken for me.