Nextcloud version (eg, 18.0.11): 18.0.11
Operating system and version (eg, Ubuntu 20.04): Linux dd12012 4.15.0-124-generic #127-Ubuntu SMP
Apache or nginx version (eg, Apache 2.4.25):
PHP version (eg, 7.1): 7.3.22-nmm1
The issue you are facing:
I started the upgrade from my working Version 17 to 18.0.11, using WEB UI.
It is running on a shared hosting platform
The Upgrade at the end stalls with:
InvalidArgumentException: Column name “koXit_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]".
Any help aprecciated, worst case (if faster) I’d like to fallback to my previous version
Thanks
Is this the first time you’ve seen this error? Y !
Steps to replicate it:
- tried to restart the upgrade from WebUI
The output of your Nextcloud log in Admin > Logging:
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
[4 / 0]: Migrate old user config
[5 / 0]: Migrate old user config
[6 / 0]: Migrate old user config
[6 / 6]: 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: 6 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 "koXit_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.
The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):
<?php
$CONFIG = array (
'instanceid' => 'xxxxxxxxxxxxx',
'passwordsalt' => 'xxxxxxxxxxxxx',
'secret' => 'xxxxxxxxxxxxxx',
'trusted_domains' =>
array (
0 => 'xxxxxxxxxxxxx.de',
1 => 'www.xxxxxxxxxxxxx.de',
),
'datadirectory' => '/www/htdocs/xxxxxxxxxxxxxxxxxxxxxxxxx/cloud/data',
'overwrite.cli.url' => 'http://xxxxxxxxxxxxx/cloud',
'dbtype' => 'mysql',
'version' => '17.0.10.1',
'dbname' => 'xxxxxxxxxxxxx',
'dbhost' => 'localhost',
'dbport' => '',
'dbtableprefix' => 'koXit_',
'mysql.utf8mb4' => false,
'dbuser' => 'xxxxxxxxxxxxx',
'dbpassword' => 'xxxxxxxxxxxxx',
'installed' => true,
'tempdirectory' => '/www/htdocs/xxxxxxxxxxxxx/cloud/tmp/',
'mail_from_address' => 'xxxxxxxxxxxxx',
'mail_smtpmode' => 'php',
'mail_smtpauthtype' => 'LOGIN',
'mail_domain' => 'xxxxxxxxxxxxx.dex',
'maintenance' => false,
'theme' => '',
'loglevel' => 2,
'filelocking.enabled' => true,
'ldapIgnoreNamingRules' => false,
'ldapProviderFactory' => '\\OCA\\User_LDAP\\LDAPProviderFactory',
'app_install_overwrite' =>
array (
0 => 'calendar',
1 => 'tasks',
2 => 'groupfolders',
),
'updater.secret' => '$2y$10$FO/GRqodP1KW2lPkxxxxxxxxxxxxxxxxxF.qt6N9pJsdtb6XnEmS',
);
The output of your Apache/nginx/system log in /var/log/____:
PASTE HERE
