Can't share Files or Folders since Update to 22

Support intro

Sorry to hear you’re facing problems :slightly_frowning_face:

help.nextcloud.com is for home/non-enterprise users. If you’re running a business, paid support can be accessed via portal.nextcloud.com where we can ensure your business keeps running smoothly.

In order to help you as quickly as possible, before clicking Create Topic please provide as much of the below as you can. Feel free to use a pastebin service for logs, otherwise either indent short log examples with four spaces:

example

Or for longer, use three backticks above and below the code snippet:

longer
example
here

Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can :heart:

Nextcloud version (eg, 20.0.5): 23.0.0.10
Operating system and version (eg, Ubuntu 20.04): Ubuntu 18.04.6 LTS
Apache or nginx version (eg, Apache 2.4.25): 2.4.29
PHP version (eg, 7.4): 8.0.13

The issue you are facing:
If i create a new share from a folder it shows the following error:

Fehler beim Erstellen der Freigabe: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘icon’ in ‘field list’

It’s not possible to use or see the share if I login with the other account but i can see an entry in the database under oc_share.

In my desperation i updated to version 23 but nothing changed.

Need help :grimacing:

Is this the first time you’ve seen this error? (Y/N): Y

Steps to replicate it:

  1. Share a Folder

The output of your Nextcloud log in Admin > Logging:

"reqId":"MRLcz0VQh4Mo1cNDKQRc"
"level":3
"time":"2022-02-13T09:47:23+01:00"
"remoteAddr":"192.168.2.83"
"user":"ll"
"app":"no app in context"
"method":"POST"
"url":"/ocs/v2.php/apps/files_sharing/api/v1/shares"
"message":"An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'icon' in 'field list'"
"userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.80 Safari/537.36 Edg/98.0.1108.43"
"version":"23.0.0.10"
"exception":{"Exception":"OC\\DB\\Exceptions\\DbalException"
"Message":"An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'icon' in 'field list'"
"Code":1054,"Trace":[{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php"
"line":335,"function":"wrap"
"class":"OC\\DB\\Exceptions\\DbalException"
"type":"::"},{"file":"/var/www/nextcloud/apps/notifications/lib/Handler.php"
"line":57,"function":"executeStatement"
"class":"OC\\DB\\QueryBuilder\\QueryBuilder"
"type":"->"},{"file":"/var/www/nextcloud/apps/notifications/lib/App.php"
"line":54,"function":"add"
"class":"OCA\\Notifications\\Handler"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/Notification/Manager.php"
"line":337,"function":"notify"
"class":"OCA\\Notifications\\App"
"type":"->"},{"file":"/var/www/nextcloud/apps/files_sharing/lib/Notification/Listener.php"
"line":68,"function":"notify"
"class":"OC\\Notification\\Manager"
"type":"->"},{"file":"/var/www/nextcloud/apps/files_sharing/lib/AppInfo/Application.php"
"line":141,"function":"shareNotification"
"class":"OCA\\Files_Sharing\\Notification\\Listener"
"type":"->"},{"file":"/var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php"
"line":264,"function":"OCA\\Files_Sharing\\AppInfo\\{closure}"
"class":"OCA\\Files_Sharing\\AppInfo\\Application"
"type":"->"
"args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php"
"line":239,"function":"doDispatch"
"class":"Symfony\\Component\\EventDispatcher\\EventDispatcher"
"type":"->"},{"file":"/var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php"
"line":73,"function":"callListeners"
"class":"Symfony\\Component\\EventDispatcher\\EventDispatcher"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/EventDispatcher/SymfonyAdapter.php"
"line":123,"function":"dispatch"
"class":"Symfony\\Component\\EventDispatcher\\EventDispatcher"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/Share20/Manager.php"
"line":835,"function":"dispatch"
"class":"OC\\EventDispatcher\\SymfonyAdapter"
"type":"->"},{"file":"/var/www/nextcloud/apps/files_sharing/lib/Controller/ShareAPIController.php"
"line":657,"function":"createShare"
"class":"OC\\Share20\\Manager"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php"
"line":217,"function":"createShare"
"class":"OCA\\Files_Sharing\\Controller\\ShareAPIController"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php"
"line":126,"function":"executeController"
"class":"OC\\AppFramework\\Http\\Dispatcher"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php"
"line":157,"function":"dispatch"
"class":"OC\\AppFramework\\Http\\Dispatcher"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php"
"line":302,"function":"main"
"class":"OC\\AppFramework\\App"
"type":"::"},{"file":"/var/www/nextcloud/ocs/v1.php"
"line":62,"function":"match"
"class":"OC\\Route\\Router"
"type":"->"},{"file":"/var/www/nextcloud/ocs/v2.php"
"line":23,"args":["/var/www/nextcloud/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/nextcloud/lib/private/DB/Exceptions/DbalException.php"
"Line":71,"Previous":{"Exception":"Doctrine\\DBAL\\Exception\\InvalidFieldNameException"
"Message":"An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'icon' in 'field list'"
"Code":1054,"Trace":[{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php"
"line":1780,"function":"convert"
"class":"Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter"
"type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php"
"line":1719,"function":"handleDriverException"
"class":"Doctrine\\DBAL\\Connection"
"type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php"
"line":1173,"function":"convertExceptionDuringQuery"
"class":"Doctrine\\DBAL\\Connection"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php"
"line":267,"function":"executeStatement"
"class":"Doctrine\\DBAL\\Connection"
"type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php"
"line":354,"function":"executeStatement"
"class":"OC\\DB\\Connection"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php"
"line":287,"function":"execute"
"class":"Doctrine\\DBAL\\Query\\QueryBuilder"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php"
"line":333,"function":"execute"
"class":"OC\\DB\\QueryBuilder\\QueryBuilder"
"type":"->"},{"file":"/var/www/nextcloud/apps/notifications/lib/Handler.php"
"line":57,"function":"executeStatement"
"class":"OC\\DB\\QueryBuilder\\QueryBuilder"
"type":"->"},{"file":"/var/www/nextcloud/apps/notifications/lib/App.php"
"line":54,"function":"add"
"class":"OCA\\Notifications\\Handler"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/Notification/Manager.php"
"line":337,"function":"notify"
"class":"OCA\\Notifications\\App"
"type":"->"},{"file":"/var/www/nextcloud/apps/files_sharing/lib/Notification/Listener.php"
"line":68,"function":"notify"
"class":"OC\\Notification\\Manager"
"type":"->"},{"file":"/var/www/nextcloud/apps/files_sharing/lib/AppInfo/Application.php"
"line":141,"function":"shareNotification"
"class":"OCA\\Files_Sharing\\Notification\\Listener"
"type":"->"},{"file":"/var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php"
"line":264,"function":"OCA\\Files_Sharing\\AppInfo\\{closure}"
"class":"OCA\\Files_Sharing\\AppInfo\\Application"
"type":"->"
"args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php"
"line":239,"function":"doDispatch"
"class":"Symfony\\Component\\EventDispatcher\\EventDispatcher"
"type":"->"},{"file":"/var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php"
"line":73,"function":"callListeners"
"class":"Symfony\\Component\\EventDispatcher\\EventDispatcher"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/EventDispatcher/SymfonyAdapter.php"
"line":123,"function":"dispatch"
"class":"Symfony\\Component\\EventDispatcher\\EventDispatcher"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/Share20/Manager.php"
"line":835,"function":"dispatch"
"class":"OC\\EventDispatcher\\SymfonyAdapter"
"type":"->"},{"file":"/var/www/nextcloud/apps/files_sharing/lib/Controller/ShareAPIController.php"
"line":657,"function":"createShare"
"class":"OC\\Share20\\Manager"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php"
"line":217,"function":"createShare"
"class":"OCA\\Files_Sharing\\Controller\\ShareAPIController"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php"
"line":126,"function":"executeController"
"class":"OC\\AppFramework\\Http\\Dispatcher"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php"
"line":157,"function":"dispatch"
"class":"OC\\AppFramework\\Http\\Dispatcher"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php"
"line":302,"function":"main"
"class":"OC\\AppFramework\\App"
"type":"::"},{"file":"/var/www/nextcloud/ocs/v1.php"
"line":62,"function":"match"
"class":"OC\\Route\\Router"
"type":"->"},{"file":"/var/www/nextcloud/ocs/v2.php"
"line":23,"args":["/var/www/nextcloud/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php"
"Line":65,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception"
"Message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'icon' in 'field list'"
"Code":1054,"Trace":[{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php"
"line":94,"function":"new"
"class":"Doctrine\\DBAL\\Driver\\PDO\\Exception"
"type":"::"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php"
"line":1163,"function":"execute"
"class":"Doctrine\\DBAL\\Driver\\PDO\\Statement"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php"
"line":267,"function":"executeStatement"
"class":"Doctrine\\DBAL\\Connection"
"type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php"
"line":354,"function":"executeStatement"
"class":"OC\\DB\\Connection"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php"
"line":287,"function":"execute"
"class":"Doctrine\\DBAL\\Query\\QueryBuilder"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php"
"line":333,"function":"execute"
"class":"OC\\DB\\QueryBuilder\\QueryBuilder"
"type":"->"},{"file":"/var/www/nextcloud/apps/notifications/lib/Handler.php"
"line":57,"function":"executeStatement"
"class":"OC\\DB\\QueryBuilder\\QueryBuilder"
"type":"->"},{"file":"/var/www/nextcloud/apps/notifications/lib/App.php"
"line":54,"function":"add"
"class":"OCA\\Notifications\\Handler"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/Notification/Manager.php"
"line":337,"function":"notify"
"class":"OCA\\Notifications\\App"
"type":"->"},{"file":"/var/www/nextcloud/apps/files_sharing/lib/Notification/Listener.php"
"line":68,"function":"notify"
"class":"OC\\Notification\\Manager"
"type":"->"},{"file":"/var/www/nextcloud/apps/files_sharing/lib/AppInfo/Application.php"
"line":141,"function":"shareNotification"
"class":"OCA\\Files_Sharing\\Notification\\Listener"
"type":"->"},{"file":"/var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php"
"line":264,"function":"OCA\\Files_Sharing\\AppInfo\\{closure}"
"class":"OCA\\Files_Sharing\\AppInfo\\Application"
"type":"->"
"args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php"
"line":239,"function":"doDispatch"
"class":"Symfony\\Component\\EventDispatcher\\EventDispatcher"
"type":"->"},{"file":"/var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php"
"line":73,"function":"callListeners"
"class":"Symfony\\Component\\EventDispatcher\\EventDispatcher"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/EventDispatcher/SymfonyAdapter.php"
"line":123,"function":"dispatch"
"class":"Symfony\\Component\\EventDispatcher\\EventDispatcher"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/Share20/Manager.php"
"line":835,"function":"dispatch"
"class":"OC\\EventDispatcher\\SymfonyAdapter"
"type":"->"},{"file":"/var/www/nextcloud/apps/files_sharing/lib/Controller/ShareAPIController.php"
"line":657,"function":"createShare"
"class":"OC\\Share20\\Manager"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php"
"line":217,"function":"createShare"
"class":"OCA\\Files_Sharing\\Controller\\ShareAPIController"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php"
"line":126,"function":"executeController"
"class":"OC\\AppFramework\\Http\\Dispatcher"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php"
"line":157,"function":"dispatch"
"class":"OC\\AppFramework\\Http\\Dispatcher"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php"
"line":302,"function":"main"
"class":"OC\\AppFramework\\App"
"type":"::"},{"file":"/var/www/nextcloud/ocs/v1.php"
"line":62,"function":"match"
"class":"OC\\Route\\Router"
"type":"->"},{"file":"/var/www/nextcloud/ocs/v2.php"
"line":23,"args":["/var/www/nextcloud/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php"
"Line":26,"Previous":{"Exception":"PDOException"
"Message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'icon' in 'field list'"
"Code":"42S22"
"Trace":[{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php"
"line":92,"function":"execute"
"class":"PDOStatement"
"type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php"
"line":1163,"function":"execute"
"class":"Doctrine\\DBAL\\Driver\\PDO\\Statement"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php"
"line":267,"function":"executeStatement"
"class":"Doctrine\\DBAL\\Connection"
"type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php"
"line":354,"function":"executeStatement"
"class":"OC\\DB\\Connection"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php"
"line":287,"function":"execute"
"class":"Doctrine\\DBAL\\Query\\QueryBuilder"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php"
"line":333,"function":"execute"
"class":"OC\\DB\\QueryBuilder\\QueryBuilder"
"type":"->"},{"file":"/var/www/nextcloud/apps/notifications/lib/Handler.php"
"line":57,"function":"executeStatement"
"class":"OC\\DB\\QueryBuilder\\QueryBuilder"
"type":"->"},{"file":"/var/www/nextcloud/apps/notifications/lib/App.php"
"line":54,"function":"add"
"class":"OCA\\Notifications\\Handler"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/Notification/Manager.php"
"line":337,"function":"notify"
"class":"OCA\\Notifications\\App"
"type":"->"},{"file":"/var/www/nextcloud/apps/files_sharing/lib/Notification/Listener.php"
"line":68,"function":"notify"
"class":"OC\\Notification\\Manager"
"type":"->"},{"file":"/var/www/nextcloud/apps/files_sharing/lib/AppInfo/Application.php"
"line":141,"function":"shareNotification"
"class":"OCA\\Files_Sharing\\Notification\\Listener"
"type":"->"},{"file":"/var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php"
"line":264,"function":"OCA\\Files_Sharing\\AppInfo\\{closure}"
"class":"OCA\\Files_Sharing\\AppInfo\\Application"
"type":"->"
"args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php"
"line":239,"function":"doDispatch"
"class":"Symfony\\Component\\EventDispatcher\\EventDispatcher"
"type":"->"},{"file":"/var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php"
"line":73,"function":"callListeners"
"class":"Symfony\\Component\\EventDispatcher\\EventDispatcher"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/EventDispatcher/SymfonyAdapter.php"
"line":123,"function":"dispatch"
"class":"Symfony\\Component\\EventDispatcher\\EventDispatcher"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/Share20/Manager.php"
"line":835,"function":"dispatch"
"class":"OC\\EventDispatcher\\SymfonyAdapter"
"type":"->"},{"file":"/var/www/nextcloud/apps/files_sharing/lib/Controller/ShareAPIController.php"
"line":657,"function":"createShare"
"class":"OC\\Share20\\Manager"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php"
"line":217,"function":"createShare"
"class":"OCA\\Files_Sharing\\Controller\\ShareAPIController"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php"
"line":126,"function":"executeController"
"class":"OC\\AppFramework\\Http\\Dispatcher"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php"
"line":157,"function":"dispatch"
"class":"OC\\AppFramework\\Http\\Dispatcher"
"type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php"
"line":302,"function":"main"
"class":"OC\\AppFramework\\App"
"type":"::"},{"file":"/var/www/nextcloud/ocs/v1.php"
"line":62,"function":"match"
"class":"OC\\Route\\Router"
"type":"->"},{"file":"/var/www/nextcloud/ocs/v2.php"
"line":23,"args":["/var/www/nextcloud/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php"
"Line":92}}},"CustomMessage":"--"}}

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

<?php
$CONFIG = array (
  'updatechecker' => false,
  'instanceid' => 'xxxxxxxxxxxxxxxxxxxx',
  'passwordsalt' => 'xxxxxxxxxxxxxxxxxxxx',
  'secret' => 'xxxxxxxxxxxxxxxxxxxx',
  'trusted_domains' =>
  array (
    0 => 'nc.xxxx.de',
    1 => 'xxx.xxx.xxx.242',
  ),
  'overwritehost' => 'nc.xxxx.de',
  'datadirectory' => '/var/www/nextcloud/data',
  'trusted_proxies' =>
  array (
    0 => 'xxx.xxx.xxx.254',
  ),
  'dbtype' => 'mysql',
  'version' => '23.0.0.10',
  'dbname' => 'nc',
  'dbhost' => 'localhost',
  'dbtableprefix' => 'oc_',
  'dbuser' => 'nextclouduser',
  'dbpassword' => 'xxxxxxxxxxxxxxxxxxxx',
  'logtimezone' => 'Europe/Berlin',
  'installed' => true,
  'mail_smtpmode' => 'smtp',
  'mail_from_address' => 'nextcloud',
  'mail_domain' => 'xxxx.de',
  'maintenance' => false,
  'theme' => '',
  'logfile' => '/var/log/nextcloud/nextcloud.log',
  'loglevel' => 2,
  'updater.server.url' => 'https://updates.nextcloud.com/updater_server/',
  'trashbin_retention_obligation' => '14, auto',
  'versions_retention_obligation' => '14, auto',
  'mail_sendmailmode' => 'smtp',
  'memcache.local' => '\\OC\\Memcache\\Redis',
  'filelocking.enabled' => true,
  'memcache.locking' => '\\OC\\Memcache\\Redis',
  'redis' =>
  array (
    'host' => 'localhost',
    'port' => 6379,
    'timeout' => 0.0,
  ),
  'overwrite.cli.url' => 'https://xxx.xxx.xxx.242',
  'mysql.utf8mb4' => true,
  'default_phone_region' => 'DE',
  'filesystem_check_changes' => 1,
  'updater.release.channel' => 'stable',
  'mail_smtphost' => 'xxx.xxx.xxx.250',
);


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

No Entry

Column not found: 1054 Unknown column ‘icon’ in ‘field list’

How did you update your NC?

I usually execute the following after upgrade …

(if you have installed Nextcloud under /var/www/nextcloud/…) then

sudo -u www-data php /var/www/nextcloud/occ db:add-missing-indices
sudo -u www-data php /var/www/nextcloud/occ db:add-missing-columns
sudo -u www-data php /var/www/nextcloud/occ db:convert-filecache-bigint

When you get feedback of your system that missing columns and indices have been added successfully then you can restart your server.

Hope it helps.

Thank you for your comment! :slight_smile:

I updated the NC with updater.phar from the shell.

Unfortunately, the commands brought no improvement :confused:

# sudo -u www-data php /var/www/nextcloud/occ db:add-missing-indices
Check indices of the share table.
Check indices of the filecache table.
Check indices of the twofactor_providers table.
Check indices of the login_flow_v2 table.
Check indices of the whats_new table.
Check indices of the cards table.
Check indices of the cards_properties table.
Check indices of the calendarobjects_props table.
Check indices of the schedulingobjects table.
Check indices of the oc_properties table.
Done.
# sudo -u www-data php /var/www/nextcloud/occ db:add-missing-columns
Check columns of the comments table.
Done.
# sudo -u www-data php /var/www/nextcloud/occ db:convert-filecache-bigint
All tables already up to date!

Do you know any other options?

I was able to solve the problem!

Just did a db:convert-type from MySQL to PostgreSQL.

Everything works fine now :slight_smile: