[18.0.0 Beta1] [Update] InvalidFieldNameException in oc_flow_operations during update/repair #18327

MichaIng · 2019-12-10T12:04:48Z

Steps to reproduce

Update from 17.0.1.1 to 18.0.0 Beta1 via web-based updater
Running the update/repair steps, from web UI, the ones after new files have been installed already.

Expected behaviour

No errors

Actual behaviour

8 errors like this

[no app in context] Error: Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT DISTINCT `class`, `entity`, `events` FROM `oc_flow_operations` WHERE `events` <> ?' with params ["[]"]:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'entity' in 'field list' at <<closure>>

 0. /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 169
    Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException("An exception oc ... '", Doctrine\DBAL\Dr ... ]})
 1. /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 145
    Doctrine\DBAL\DBALException::wrapException(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr ... ]}, "An exception oc ... '")
 2. /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 911
    Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr ... ]}, "SELECT DISTINCT ... ?", {1: "[]"})
 3. /var/www/nextcloud/lib/private/DB/Connection.php line 196
    Doctrine\DBAL\Connection->executeQuery("SELECT DISTINCT ... ?", ["[]"], [2], null)
 4. /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php line 200
    OC\DB\Connection->executeQuery("SELECT DISTINCT ... 1", {dcValue1: "[]"}, {dcValue1: 2})
 5. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 214
    Doctrine\DBAL\Query\QueryBuilder->execute()
 6. /var/www/nextcloud/apps/workflowengine/lib/Manager.php line 137
    OC\DB\QueryBuilder\QueryBuilder->execute()
 7. /var/www/nextcloud/apps/workflowengine/lib/AppInfo/Application.php line 86
    OCA\WorkflowEngine\Manager->getAllConfiguredEvents()
 8. /var/www/nextcloud/apps/workflowengine/appinfo/app.php line 27
    OCA\WorkflowEngine\AppInfo\Application->registerRuleListeners()
 9. /var/www/nextcloud/lib/private/legacy/app.php line 264
    require_once("/var/www/nextcl ... p")
10. /var/www/nextcloud/lib/private/legacy/app.php line 155
    OC_App::requireAppFile("workflowengine")
11. /var/www/nextcloud/lib/private/legacy/app.php line 128
    OC_App::loadApp("workflowengine")
12. /var/www/nextcloud/lib/private/legacy/util.php line 196
    OC_App::loadApps(["filesystem"])
13. /var/www/nextcloud/lib/private/Files/Filesystem.php line 266
    OC_Util::setupFS("")
14. /var/www/nextcloud/lib/private/Server.php line 293
    OC\Files\Filesystem::getMountManager(null)
15. /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php line 118
    OC\Server->OC\{closure}("*** sensitive parameters replaced ***")
16. /var/www/nextcloud/lib/private/ServerContainer.php line 121
    Pimple\Container->offsetGet("RootFolder")
17. /var/www/nextcloud/lib/private/Server.php line 315
    OC\ServerContainer->query("RootFolder")
18. <<closure>>
    OC\Server->OC\{closure}("*** sensitive parameters replaced ***")
19. /var/www/nextcloud/lib/private/Files/Node/LazyRoot.php line 62
    call_user_func(Closure {})
20. /var/www/nextcloud/lib/private/Files/Node/LazyRoot.php line 79
    OC\Files\Node\LazyRoot->__call("listen", ["\\OC\\Files","postWrite",Closure {}])
21. /var/www/nextcloud/apps/previewgenerator/lib/AppInfo/Application.php line 50
    OC\Files\Node\LazyRoot->listen("\\OC\\Files", "postWrite", Closure {})
22. /var/www/nextcloud/apps/previewgenerator/lib/AppInfo/Application.php line 40
    OCA\PreviewGenerator\AppInfo\Application->connectWatcher(OC\AppFramework\ ... {})
23. /var/www/nextcloud/apps/previewgenerator/appinfo/app.php line 23
    OCA\PreviewGenerator\AppInfo\Application->__construct()
24. /var/www/nextcloud/lib/private/legacy/app.php line 264
    require_once("/var/www/nextcl ... p")
25. /var/www/nextcloud/lib/private/legacy/app.php line 155
    OC_App::requireAppFile("previewgenerator")
26. /var/www/nextcloud/lib/private/legacy/app.php line 128
    OC_App::loadApp("previewgenerator")
27. /var/www/nextcloud/lib/private/legacy/util.php line 196
    OC_App::loadApps(["filesystem"])
28. /var/www/nextcloud/lib/private/Files/Filesystem.php line 266
    OC_Util::setupFS("")
29. /var/www/nextcloud/lib/private/Server.php line 293
    OC\Files\Filesystem::getMountManager(null)
30. /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php line 118
    OC\Server->OC\{closure}("*** sensitive parameters replaced ***")
31. /var/www/nextcloud/lib/private/ServerContainer.php line 121
    Pimple\Container->offsetGet("RootFolder")
32. /var/www/nextcloud/lib/private/Server.php line 315
    OC\ServerContainer->query("RootFolder")
33. <<closure>>
    OC\Server->OC\{closure}("*** sensitive parameters replaced ***")
34. /var/www/nextcloud/lib/private/Files/Node/LazyRoot.php line 62
    call_user_func(Closure {})
35. /var/www/nextcloud/lib/private/Files/Node/LazyRoot.php line 142
    OC\Files\Node\LazyRoot->__call("get", ["appdata_ocv2j0skx6hk/js/core"])
36. /var/www/nextcloud/lib/private/Files/AppData/AppData.php line 140
    OC\Files\Node\LazyRoot->get("appdata_ocv2j0skx6hk/js/core")
37. /var/www/nextcloud/lib/private/Template/JSCombiner.php line 95
    OC\Files\AppData\AppData->getFolder("core")
38. /var/www/nextcloud/lib/private/Template/JSResourceLocator.php line 114
    OC\Template\JSCombiner->process("/var/www/nextcloud", "core/js/merged-template-prepend.json", "core")
39. /var/www/nextcloud/lib/private/Template/JSResourceLocator.php line 70
    OC\Template\JSResourceLocator->cacheAndAppendCombineJsonIfExist("/var/www/nextcloud", "core/js/merged-template-prepend.json")
40. /var/www/nextcloud/lib/private/Template/ResourceLocator.php line 78
    OC\Template\JSResourceLocator->doFind("js/merged-template-prepend")
41. /var/www/nextcloud/lib/private/TemplateLayout.php line 342
    OC\Template\ResourceLocator->find(["core/js/dist/m ... "])
42. /var/www/nextcloud/lib/private/TemplateLayout.php line 170
    OC\TemplateLayout::findJavascriptFiles(["core/js/dist/m ... "])
43. /var/www/nextcloud/lib/private/legacy/template.php line 183
    OC\TemplateLayout->__construct("error", "")
44. /var/www/nextcloud/lib/private/Template/Base.php line 131
    OC_Template->fetchPage()
45. /var/www/nextcloud/lib/private/legacy/template.php line 299
    OC\Template\Base->printPage()
46. /var/www/nextcloud/remote.php line 80
    OC_Template::printErrorPage("Service unavailable", "", 503)
47. /var/www/nextcloud/remote.php line 166
    handleException(RemoteException {})

PROPFIND /nextcloud/remote.php/dav/calendars/Micha/hamburg-holidays/
from 95.81.18.51 at 2019-12-10T10:26:14+01:00

Now I see the PROPFIND request, the other similar log entries show them for other calendars and contacts and there is as well:
GET /nextcloud/
and
GET /nextcloud/index.php/core/js/oc.js?v=a5601bfb
Two other probably related error log entries are in between, see below.

But I cannot see further issues that seem to be related.

Server configuration

Operating system: Raspbian Bullseye

Web server: Apache/2.4.41

Database: MariaDB 10.3.20

PHP version: 7.3.12-1

Nextcloud version: 18.0.0 Beta1

Updated from an older Nextcloud/ownCloud or fresh install: 17.0.1.1

Where did you install Nextcloud from: download.nextcloud.com + web-based updater

Signing status:

Signing status

No errors have been found.

List of activated apps:

App list

Enabled:
  - activity: 2.11.0
  - apporder: 0.8.0
  - calendar: 2.0.0-beta3
  - cloud_federation_api: 1.1.0
  - contacts: 3.1.6
  - dav: 1.14.0
  - federatedfilesharing: 1.8.0
  - files: 1.13.1
  - files_rightclick: 0.15.1
  - files_trashbin: 1.8.0
  - files_versions: 1.11.0
  - impersonate: 1.4.0
  - logreader: 2.3.0
  - lookup_server_connector: 1.6.0
  - nextcloud_announcements: 1.7.0
  - notes: 3.0.3
  - notifications: 2.6.0
  - oauth2: 1.6.0
  - photos: 19.0.0
  - previewgenerator: 2.2.0
  - provisioning_api: 1.8.0
  - ransomware_protection: 1.5.1
  - settings: 1.0.0
  - survey_client: 1.6.0
  - tasks: 0.11.3
  - twofactor_backupcodes: 1.7.0
  - updatenotification: 1.8.0
  - workflowengine: 2.0.0
Disabled:
  - accessibility
  - admin_audit
  - comments
  - encryption
  - federation
  - files_external
  - files_pdfviewer
  - files_sharing
  - files_videoplayer
  - firstrunwizard
  - password_policy
  - privacy
  - recommendations
  - serverinfo
  - sharebymail
  - support
  - systemtags
  - text
  - theming
  - user_ldap
  - viewer

Nextcloud configuration:

Config report

{
    "system": {
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "localhost",
            "my.domain.org"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "18.0.0.3",
        "memcache.local": "\\OC\\Memcache\\APCu",
        "filelocking.enabled": true,
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 0
        },
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "loglevel": 1,
        "logtimezone": "Europe\/Berlin",
        "trashbin_retention_obligation": "disabled",
        "versions_retention_obligation": "disabled",
        "skeletondirectory": "",
        "defaultapp": "apporder",
        "maintenance": false,
        "overwrite.cli.url": "https:\/\/my.domain.org\/nextcloud",
        "htaccess.RewriteBase": "\/nextcloud",
        "mail_smtpmode": "smtp",
        "mail_smtpauthtype": "LOGIN",
        "mail_smtpsecure": "ssl",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpauth": 1,
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "465",
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "theme": "",
        "mysql.utf8mb4": true,
        "updater.release.channel": "beta",
        "tempdirectory": "\/mnt\/sda\/ncdata\/tmp",
        "preview_max_x": "2048",
        "preview_max_y": "2048",
        "jpeg_quality": "60",
        "app_install_overwrite": [
            "apporder",
            "calendar",
            "impersonate",
            "ransomware_protection",
            "contacts"
        ],
        "updater.secret": "***REMOVED SENSITIVE VALUE***"
    }
}

Are you using external storage, if yes which one: no

Are you using encryption: no

Are you using an external user-backend, if yes which one: no

Client configuration

Browser: Opera developer 67.0.3523.0

Operating system: Windows 10 Pro N 1909 build 18363.476

Logs

Web server error log

nothing related

Nextcloud log (data/nextcloud.log)

Nextcloud log

[PHP] Error: Undefined index: name at /var/www/nextcloud/core/templates/update.admin.php#24

GET /nextcloud/
from 95.81.18.51 at 2019-12-10T10:26:14+01:00
...
[jsresourceloader] Error: Could not find resource js/config.js to load

GET /nextcloud/
from 95.81.18.51 at 2019-12-10T10:26:14+01:00

Browser log

nothing related

The text was updated successfully, but these errors were encountered:

haup · 2020-01-03T11:20:43Z

I am experiencing exactly the same error. My logging gets polluted of this message

stevleibelt · 2020-02-15T20:55:15Z

Same for me right now, just tried to update to 18.0.1 and that is the result.

My template around that lines is looking like this:

 20         <div class="infogroup">
 21             <span><?php p($l->t('These incompatible apps will be disabled:')) ?></span>
 22             <ul class="content appList">
 23                 <?php foreach ($_['incompatibleAppsList'] as $appInfo) { ?>
 24                 <li><?php p($appInfo['name']) ?> (<?php p($appInfo['id']) ?>)</li>
 25                 <?php } ?>
 26             </ul>
 27         </div

stevleibelt · 2020-02-15T21:00:51Z

What I've tried so far:

login on the server and run "php occ upgrade"

[...] 
Checking for update of app spreed in appstore
Update app spreed from appstore
Repair error: Repair step 'OCA\Talk\Migration\FixNamespaceInDatabaseTables' is unknown
Repair error: Repair step 'OCA\Talk\Migration\CreateHelpCommand' is unknown
Repair error: Repair step 'OCA\Talk\Migration\ClearResourceAccessCache' is unknown
Checked for update of app "spreed" in appstore 
Repair error: Repair step 'OCA\Talk\Migration\FixNamespaceInDatabaseTables' is unknown
Repair error: Repair step 'OCA\Talk\Migration\CreateHelpCommand' is unknown
Repair error: Repair step 'OCA\Talk\Migration\ClearResourceAccessCache' is unknown
Repair error: Repair step 'OCA\Talk\Migration\CreateHelpCommand' is unknown
Starting code integrity check...
[...]

Things are looking good so far.

Following the list of my applications.

php public/occ app:list
Enabled:
  - accessibility: 1.4.0
  - admin_audit: 1.8.0
  - analytics: 2.0.0
  - audioplayer: 2.9.0
  - bruteforcesettings: 1.5.0
  - calendar: 2.0.1
  - cloud_federation_api: 1.1.0
  - contacts: 3.1.8
  - dav: 1.14.0
  - encryption: 2.6.0
  - federatedfilesharing: 1.8.0
  - federation: 1.8.0
  - files: 1.13.1
  - files_automatedtagging: 1.8.0
  - files_markdown: 2.2.0
  - files_mindmap: 0.0.17
  - files_pdfviewer: 1.7.0
  - files_rightclick: 0.15.2
  - files_sharing: 1.10.1
  - files_videoplayer: 1.7.0
  - logreader: 2.3.0
  - lookup_server_connector: 1.6.0
  - mail: 1.1.2
  - news: 14.1.3
  - nextbackup: 19.12.1
  - nextcloud_announcements: 1.7.0
  - notifications: 2.6.0
  - oauth2: 1.6.0
  - password_policy: 1.8.0
  - photos: 1.0.0
  - polls: 1.1.6
  - previewgenerator: 2.2.0
  - privacy: 1.2.0
  - provisioning_api: 1.8.0
  - recommendations: 0.6.0
  - serverinfo: 1.8.0
  - settings: 1.0.0
  - sharebymail: 1.8.0
  - spreed: 8.0.4
  - support: 1.1.0
  - survey_client: 1.6.0
  - systemtags: 1.8.0
  - text: 2.0.0
  - theming: 1.9.0
  - twofactor_backupcodes: 1.7.0
  - updatenotification: 1.8.0
  - viewer: 1.2.0
  - workflowengine: 2.0.0

Midek · 2020-02-17T12:19:20Z

After upgrading from Nextcloud 17 to Nextcloud 18.0.1, occ upgrade errored out:

└> sudo -u http php ./occ upgrade               
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
Updating database schema
Updated database
Updating <workflowengine> ...
Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'UPDATE "oc_flow_operations" SET "entity" = ? WHERE "entity" = ''' with params ["OCA\\WorkflowEngine\\Entity\\File"]:

SQLSTATE[42703]: Undefined column: 7 ERROR:  column "entity" does not exist
LINE 1: ...DATE "oc_flow_operations" SET "entity" = $1 WHERE "entity" =...
                                                             ^
Update failed
Maintenance mode is kept active
Reset log level

Indeed, there was no column entity in flow_operations after the upgrade, so I created it on my own and now it looks like its working fine.
alter table oc_flow_operations add column entity character varying(256) not null;

AetherCollective · 2020-02-24T12:21:33Z

Indeed, there was no column entity in flow_operations after the upgrade, so I created it on my own and now it looks like its working fine.
alter table oc_flow_operations add column entity character varying(256) not null;

@stevleibelt I tried the same and unfortunately I wasn't able to reproduce your success. Did you try anything else in your attempt to fix this?

ncadmin@cloud:~$ sudo -u www-data php /var/www/nextcloud/occ upgrade
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
Updating database schema
Updated database
Updating <workflowengine> ...
Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'UPDATE "oc_flow_operations" SET "entity" = ? WHERE "entity" = ''' with params ["OCA\\Workfl owEngine\\Entity\\File"]:

SQLSTATE[42703]: Undefined column: 7 ERROR:  column "entity" does not exist
LINE 1: ...DATE "oc_flow_operations" SET "entity" = $1 WHERE "entity" =...
                                                             ^
Update failed
Maintenance mode is kept active
Reset log level
ncadmin@cloud:~$ sudo -u postgres psql
psql (10.12 (Ubuntu 10.12-0ubuntu0.18.04.1))
Type "help" for help.

postgres=# select * from oc_flow_operations;
 id | class | name | checks | operation | entity
----+-------+------+--------+-----------+--------
(0 rows)

Edit: I realized my problem. I forgot to select the nextcloud_db database.
sudo -u postgres psql nextcloud_db

solracsf · 2020-04-13T18:49:41Z

@MichaIng duplicate of #18265? Feel free to close if yes, as the other topic seems more advanced in the resolution.

MichaIng · 2020-04-15T19:06:03Z

@acsfer
Many thanks for linking. It seems that the originating issue is at least similar: Flow related database tables seem to be not reliably created or created too late or not fully created. However, in my case it was only a onetime error message, no follow up issues, while the issue you linked contains a broken instance.

I had a very similar other issue, related to a different database table: #18325
As said in both cases the issue is a minor one, not leading to any followup errors until now. Probably the required tables were created a bid too late, so that they were accessed during Nextcloud update process while not yet being (fully) created or such. I'll link the issue over just in case those are related at some point.

Nowaker · 2020-04-26T06:35:50Z

I confirm the following helped:

alter table oc_flow_operations add column entity character varying(256) not null

I encountered the problem on Nextcloud 18.0.4.

ghost · 2020-05-26T10:07:41Z

This issue has been automatically marked as stale because it has not had recent activity and seems to be missing some essential information. It will be closed if no further activity occurs. Thank you for your contributions.

Nowaker · 2020-05-26T15:00:03Z

Hold on bot

Nowaker · 2020-05-26T21:23:30Z

This ticket has a "needs info" label. It doesn't need any more info, there's even a fix in the thread. What if really needs is a dev to look at it, triage it and hopefully make a permanent fix.

MichaIng · 2020-05-27T11:48:40Z

Probably it has been fixed with NC19, at least I didn't recognised this error(s) anymore during NC19 beta updates. I'll have a closer look when updating to the hopefully soon offered final release.

Nowaker · 2020-05-27T14:33:03Z

This can't be ignored in v18 because it's required in the upgrade path from owncloud.

MichaIng · 2020-05-27T17:58:42Z

Earlier or later there will be a new upgrade path, and note that at least in my case it was really only the error messages during the update process while I didn't face any actual issues nor did the error occur at any time afterwards. So the motivation to move development time away from important topics to this is reasonably not very high 😉. And if it's resolved with NC19, the fix has probably been backported to 18.0.5: #21061

Nowaker · 2020-05-27T18:07:50Z

I didn't face any actual issues

I did. #18327 (comment)

Nowaker · 2020-05-27T18:09:26Z

Earlier or later there will be a new upgrade path

That would be nice! But today there's none, and one has to go through multiple versions of NC, many having different issues. (e.g. no support for PHP 7!).

MichaIng · 2020-06-04T11:17:13Z

The error does not show up anymore during update to NC19 here, @Nowaker probably you can verify?

Nowaker · 2020-06-06T00:18:28Z

The error does not show up anymore during update to NC19 here

@MichaIng This was during an update from NC17 to NC18. DB in v17, code in v18.

probably you can verify?

I'd love to but after applying the SQL fix, I successfully upgraded and there's no way to re-verify any more. :-)

MichaIng · 2020-06-06T09:57:42Z

Okay, I faced the error as well when upgrading from one NC18 patch version to the next, however it did never break the update or anything else anyway.

So I mark this issue as closed. The title should allow anyone to find the issue easily, when still facing this.

baldar-de · 2020-07-27T07:50:48Z

On Mon Jul 27 2020 I tried to update my nextcloud from 17.0.8 to 18 and I run into this issue.

Showstopper for me, I used my backup to get 17.0.8 back. So I'm still able to reproduce this error anytime.

I have barely any files in my nextcloud instance (less than 100) and I'm using only contacts, calendar and news app so I still have 'dbtype' => 'sqlite3'.

Doesn't matter if I use the web based upgrade or console commands.

MichaIng · 2020-07-27T11:53:48Z

What exactly happens when you run the update via web-based updater? Since in my cases it went through without any issues, I only see those log entries afterwards.
But from above I got that is appears when doing console-based upgrade instead. In this case it helped to alter the database manually:

sqlite3 /path/to/nextcloud/data/nextcloud.db 'alter table oc_flow_operations add column entity character varying(256) not null;'

Not sure where the database file is stored exactly 😉.

baldar-de · 2020-07-27T15:11:23Z

Thank you very much for the fast reply, will try again with the web based updater:

2020.07.27-Mon-16.09.13
_Version Nextcloud 17.0.8

A new version is available: Nextcloud 18.0.7
All apps have an update for this version available

Update channel: Stable

after a short time I get the message: Go back to your Nextcloud instance to finish the update_

2020.07.27-Mon-16.13.42
_Nextcloud will be updated to version 18.0.7
These apps will be updated:
Accessibility (accessibility)
Activity (activity)
Cloud Federation API (cloud_federation_api)
Comments (comments)
WebDAV (dav)
Federated file sharing (federatedfilesharing)
Federation (federation)
Files (files)
PDF viewer (files_pdfviewer)
Right click (files_rightclick)
File sharing (files_sharing)
Deleted files (files_trashbin)
Versions (files_versions)
Video player (files_videoplayer)
First run wizard (firstrunwizard)
Log Reader (logreader)
Lookup Server Connector (lookup_server_connector)
Nextcloud announcements (nextcloud_announcements)
Notifications (notifications)
OAuth 2.0 (oauth2)
Password policy (password_policy)
Privacy (privacy)
Provisioning API (provisioning_api)
Recommendations (recommendations)
Monitoring (serverinfo)
Share by mail (sharebymail)
Support (support)
Usage survey (survey_client)
Collaborative tags (systemtags)
Text (text)
Theming (theming)
Two factor backup codes (twofactor_backupcodes)
Update notification (updatenotification)
Nextcloud workflow engine (workflowengine)
Please make sure that the database, the config folder and the data folder have been backed up before proceeding.

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_

this is where my machine is busy doing nothing visible for a very long time
I have different directories for my nextcloud instance and data.
interesting, my owncloud.db is surprisingly big ~1.8GB, must be the news app
2020.07.27-Mon-16.58.00 now there is more visible action, 45min. later

_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

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

same error again, will use your advice in my next try

root@tyr: /var/lib/nextcloud/data # sqlite3 /var/lib/nextcloud/data/owncloud.db 'alter table oc_flow_operations add column entity character varying(256) not null;'                                                                         
Error: Cannot add a NOT NULL column with default value NULL

did use
root@tyr: /var/lib/nextcloud/data # sqlite3 /var/lib/nextcloud/data/owncloud.db 'alter table oc_flow_operations add column entity character varying(256) null;'
next try at
2020.07.27-Mon-17.09.56
upgrade will need again about 45min.

baldar-de · 2020-07-27T15:27:13Z

ups, changing "not null" to "null" wasn't a bright idea

Doctrine\DBAL\DBALException: Unknown database type character varying requested, OC\DB\OCSqlitePlatform may not support it.

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

Doctrine\DBAL\DBALException: Unknown database type character varying requested, OC\DB\OCSqlitePlatform may not support it.

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

MichaIng added bug 0. Needs triage Pending check for reproducibility or if it fits our roadmap labels Dec 10, 2019

MichaIng changed the title ~~[18.0.0 Beta1] [Update] Another InvalidFieldNameException~~ [18.0.0 Beta1] [Update] InvalidFieldNameException in oc_flow_operations during update/repair Dec 10, 2019

wiswedel added the 18-feedback label Jan 6, 2020

Nils160988 added the needs info label Apr 14, 2020

MichaIng mentioned this issue Apr 15, 2020

Issue while upgrading to 18 Beta1 (SQL, related to Flow) #18265

Closed

ghost added the stale Ticket or PR with no recent activity label May 26, 2020

ghost removed the stale Ticket or PR with no recent activity label May 26, 2020

MichaIng closed this as completed Jun 6, 2020

MichaIng removed 0. Needs triage Pending check for reproducibility or if it fits our roadmap needs info labels Jun 6, 2020

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

[18.0.0 Beta1] [Update] InvalidFieldNameException in oc_flow_operations during update/repair #18327

[18.0.0 Beta1] [Update] InvalidFieldNameException in oc_flow_operations during update/repair #18327

MichaIng commented Dec 10, 2019

haup commented Jan 3, 2020

stevleibelt commented Feb 15, 2020

stevleibelt commented Feb 15, 2020

Midek commented Feb 17, 2020

AetherCollective commented Feb 24, 2020 •

edited

Loading

solracsf commented Apr 13, 2020

MichaIng commented Apr 15, 2020 •

edited

Loading

Nowaker commented Apr 26, 2020 •

edited

Loading

ghost commented May 26, 2020

Nowaker commented May 26, 2020

Nowaker commented May 26, 2020

MichaIng commented May 27, 2020

Nowaker commented May 27, 2020

MichaIng commented May 27, 2020

Nowaker commented May 27, 2020

Nowaker commented May 27, 2020

MichaIng commented Jun 4, 2020

Nowaker commented Jun 6, 2020

MichaIng commented Jun 6, 2020

baldar-de commented Jul 27, 2020

MichaIng commented Jul 27, 2020

baldar-de commented Jul 27, 2020

baldar-de commented Jul 27, 2020

[18.0.0 Beta1] [Update] InvalidFieldNameException in oc_flow_operations during update/repair #18327

[18.0.0 Beta1] [Update] InvalidFieldNameException in oc_flow_operations during update/repair #18327

Comments

MichaIng commented Dec 10, 2019

Steps to reproduce

Expected behaviour

Actual behaviour

Server configuration

Client configuration

Logs

Web server error log

Nextcloud log (data/nextcloud.log)

Browser log

haup commented Jan 3, 2020

stevleibelt commented Feb 15, 2020

stevleibelt commented Feb 15, 2020

login on the server and run "php occ upgrade"

Midek commented Feb 17, 2020

AetherCollective commented Feb 24, 2020 • edited Loading

solracsf commented Apr 13, 2020

MichaIng commented Apr 15, 2020 • edited Loading

Nowaker commented Apr 26, 2020 • edited Loading

ghost commented May 26, 2020

Nowaker commented May 26, 2020

Nowaker commented May 26, 2020

MichaIng commented May 27, 2020

Nowaker commented May 27, 2020

MichaIng commented May 27, 2020

Nowaker commented May 27, 2020

Nowaker commented May 27, 2020

MichaIng commented Jun 4, 2020

Nowaker commented Jun 6, 2020

MichaIng commented Jun 6, 2020

baldar-de commented Jul 27, 2020

MichaIng commented Jul 27, 2020

baldar-de commented Jul 27, 2020

baldar-de commented Jul 27, 2020

AetherCollective commented Feb 24, 2020 •

edited

Loading

MichaIng commented Apr 15, 2020 •

edited

Loading

Nowaker commented Apr 26, 2020 •

edited

Loading