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.