Blank screen after updating to version 18.0.9

ℹ️ Support
,
1
Support intro

I tried update from version 17.0.9.2 to 18.0.9 and I stay stucked in blank screen. After running command sudo -u www-data php occ upgrade I got the exception
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
Update failed

Any suggestion to get from this situation or is possible go back to origin version 17.0.9.2 what I have before updating?

Nextcloud version :18.0.9
Operating system and version :Raspbian GNU/Linux 10 (buster)
Apache or nginx version (eg, Apache 2.4.25): Apache/2.4.38
PHP version (eg, 7.1): 7.3.19-1

The issue you are facing:

Is this the first time you’ve seen this error? : Y

Steps to replicate it:

  1. Open WEB UI updater
  2. Click update on version 18.0.9
  3. After all steps I click on No button in section Keep maintenance mode active?
  4. After redirecting stay blank screen
  5. Googling some information about this issue and try run command sudo -u www-data php occ upgrade
  6. Get this exception:
    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 output of your Nextcloud log in Admin > Logging:

I'm not able login to Admin > Logging

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

<?php
$CONFIG = array (
  'instanceid' => 'ocmbre6fjzxl',
  'passwordsalt' => 'XXX',
  'secret' => 'XXX',
  'trusted_domains' =>
  array (
    0 => '192.168.50.244',
    1 => 'example.eu',
  ),
  'datadirectory' => '/media/data/nextcloud/data',
  'dbtype' => 'sqlite3',
  'version' => '17.0.9.2',
  'overwrite.cli.url' => 'http://192.168.50.244/nextcloud',
  'installed' => true,
  'maintenance' => false,
  'theme' => '',
  'loglevel' => 2,
  'updater.secret' => 'XXX',
  'app_install_overwrite' =>
  array (
    0 => 'radio',
  ),
);

The output of your Apache/nginx/system log in /var/log/____:

Output from error.log
[Mon Oct 05 13:16:25.572707 2020] [php7:error] [pid 24685] [client 192.168.50.244:63823] PHP Fatal error:  Declaration of OCA\\FilesAccessControl\\Operation::validateOperation($name, array $checks, $operation) must be compatible with OCP\\WorkflowEngine\\IOperation::validateOperation(string $name, array $checks, string $operation): void in /var/www/html/nextcloud/apps/files_accesscontrol/lib/Operation.php on line 31

Output of UPDATE COMMAND

Nextcloud or one of the apps require upgrade - only a limited number of commands are available
You may use your browser or the occ upgrade command to do the upgrade
Set log level to debug
Turned on maintenance mode
Updating database schema
Updated database
Disabled incompatible app: files_accesscontrol
Disabled incompatible app: ransomware_protection
Updating <accessibility> ...
Migrate old user config

 Done
    2/2 [============================] 100%
Updated <accessibility> to 1.4.0
Updating <federatedfilesharing> ...
Updated <federatedfilesharing> to 1.8.0
Updating <files_pdfviewer> ...
Updated <files_pdfviewer> to 1.7.0
Updating <files_rightclick> ...
Updated <files_rightclick> to 0.15.2
Updating <files_videoplayer> ...
Updated <files_videoplayer> to 1.7.0
Updating <logreader> ...
Updated <logreader> to 2.3.0
Updating <password_policy> ...
Updated <password_policy> to 1.8.0
Updating <privacy> ...
Updated <privacy> to 1.2.0
Updating <provisioning_api> ...
Updated <provisioning_api> to 1.8.0
Updating <recommendations> ...
Updated <recommendations> to 0.6.0
Updating <serverinfo> ...
Updated <serverinfo> to 1.8.0
Updating <support> ...
Updated <support> to 1.1.1
Updating <survey_client> ...
Updated <survey_client> to 1.6.0
Updating <text> ...
Updated <text> to 2.0.0
Updating <twofactor_backupcodes> ...
Updated <twofactor_backupcodes> to 1.7.0
Updating <updatenotification> ...
Updated <updatenotification> to 1.8.0
Updating <federation> ...
Updated <federation> to 1.8.0
Updating <lookup_server_connector> ...
Updated <lookup_server_connector> to 1.6.0
Updating <oauth2> ...
Updated <oauth2> to 1.6.0
Updating <files> ...
Updated <files> to 1.13.1
Updating <activity> ...
Updated <activity> to 2.11.0
Updating <cloud_federation_api> ...
Updated <cloud_federation_api> to 1.1.0
Updating <dav> ...
Fix broken values of calendar objects
 Done
    0/0 [>---------------------------]   0%
Updated <dav> to 1.14.0
Updating <files_external> ...
Updated <files_external> to 1.9.0
Updating <files_sharing> ...
Updated <files_sharing> to 1.10.1
Updating <files_trashbin> ...
Updated <files_trashbin> to 1.8.0
Updating <files_versions> ...
Updated <files_versions> to 1.11.0
Updating <sharebymail> ...
Updated <sharebymail> to 1.8.0
Updating <workflowengine> ...
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
Update failed
Maintenance mode is kept active
Reset log level
2

This problem is being described in the following issue ticket which also provides a workaround:

1 Like
3

Thank you @j-ed this workaround work also for my issue.

For SQLITE3 I used this commands:

  1. found where is database stored and open it sqlite3 owncloud.db
  2. .tables (list of tables)
  3. select * from oc_flow_operations;
  4. alter table oc_flow_operations add entity varchar(256) default NULL;
1 Like