Installing/updating 18.0.10 from 17.0.10 error="oc_flow_operations"."entity" is NotNull, but has empty string or null as default

🚧 Installation
1

Updating NextCloud on ISP from 17.0.10 to 18.0.10. Received this error on detail log file…

“oc_flow_operations”.“entity” is NotNull, but has empty string or null as default.

Here’s the Detailed Log Report:

Update to 18.0.10
InvalidArgumentException: Column name “oc_flow_operations”.“entity” is NotNull, but has empty string or null as default.

Detailed logs
Preparing update

Set log level to debug

Turned on maintenance mode

Repair step: Repair MySQL collation

Repair info: All tables already have the correct collation -> 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

[2 / 0]: Migrate old user config

[3 / 0]: Migrate old user config

[3 / 3]: 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

Repair step: Switches from default updater server to the customer one if a valid subscription is available

Repair info: Repair step already executed

Updated “support” to 1.1.1

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.1

Updated “cloud_federation_api” to 1.1.0

Repair step: Fix component of birthday calendars

Repair info: 3 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

InvalidArgumentException: Column name “oc_flow_operations”.“entity” is NotNull, but has empty string or null as default.

The update was unsuccessful. Please report this issue to the Nextcloud community.

********************************* End of Detailed Log Report *********************

Appreciate any advise or links to resolve this issue. Would like to upgrade to NC version 18.0.10 from version 17.0.10. :smirk:

2

In most cases using the search function of this forum, helps finding an answer :wink:

1 Like
3

Thanks j-ed for your feedback. Nice to see someone is willing to help. I am a newbie with NC forum. I did search the forum and found the same article you did. Unfortunately, I posted my issue prior to searching for the issue I have.

1 Like