nextcloud / server

☁️ Nextcloud server, a safe home for all your data
https://nextcloud.com
GNU Affero General Public License v3.0
27.46k stars 4.08k forks source link

Unable to enable File Sharing after migration from SQLite to Postgres #25414

Closed wsw70 closed 3 years ago

wsw70 commented 3 years ago

How to use GitHub

Steps to reproduce

  1. Running NExtcloud with SQLite
  2. Converting to Postgres backend
  3. Conversion went fine, except for the sharing feature

Expected behaviour

File sharing works like with SQLite

Actual behaviour

Error when trying to enable file sharing:

image

The message in the screenshot above is

An exception occurred while executing ' SELECT "remote", "share_token", "password", "mountpoint", "owner" FROM "oc_share_external" WHERE "user" = ? AND "accepted" = ? ' with params ["wojtek", 1]: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "oc_share_external" does not exist LINE 3: FROM "oc_share_external" ^

Server configuration

Operating system: Official docker image nextcloud:20

Database: SQLite → Postgress

Nextcloud version: (see Nextcloud admin page) 20.0.6

Signing status:

Signing status ``` No errors have been found. ```

List of activated apps:

App list ``` Enabled: - cloud_federation_api: 1.3.0 - dav: 1.16.2 - federatedfilesharing: 1.10.2 - files: 1.15.0 - files_pdfviewer: 2.0.1 - files_trashbin: 1.10.1 - lookup_server_connector: 1.8.0 - oauth2: 1.8.0 - password_policy: 1.10.1 - provisioning_api: 1.10.0 - quicknotes: 0.6.3 - settings: 1.2.0 - sharebymail: 1.10.0 - text: 3.1.0 - twofactor_backupcodes: 1.9.0 - twofactor_nextcloud_notification: 3.1.0 - twofactor_totp: 5.0.0 - twofactor_u2f: 6.1.0 - twofactor_webauthn: 0.2.6 - twofactor_yubikey: 0.4.1 - viewer: 1.4.0 - workflowengine: 2.2.0 Disabled: - accessibility - activity - admin_audit - comments - contactsinteraction - dashboard - encryption - federation - files_external - files_mindmap - files_rightclick - files_sharing - files_versions - files_videoplayer - firstrunwizard - logreader - nextcloud_announcements - notes - notifications - photos - privacy - recommendations - serverinfo - support - survey_client - systemtags - theming - twofactor_admin - updatenotification - user_ldap - user_status - weather_status ```

Nextcloud configuration:

Config report ``` { "system": { "htaccess.RewriteBase": "\/", "memcache.local": "\\OC\\Memcache\\APCu", "apps_paths": [ { "path": "\/var\/www\/html\/apps", "url": "\/apps", "writable": false }, { "path": "\/var\/www\/html\/custom_apps", "url": "\/custom_apps", "writable": true } ], "instanceid": "***REMOVED SENSITIVE VALUE***", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "nextcloud.swtk.eu" ], "datadirectory": "***REMOVED SENSITIVE VALUE***", "dbtype": "pgsql", "version": "20.0.6.1", "overwrite.cli.url": "https:\/\/nextcloud.swtk.eu", "overwriteprotocol": "https", "auth.bruteforce.protection.enabled": false, "installed": true, "has_rebuilt_cache": true, "maintenance": false, "theme": "", "loglevel": 2, "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_smtpmode": "smtp", "mail_sendmailmode": "smtp", "mail_domain": "***REMOVED SENSITIVE VALUE***", "mail_smtpauthtype": "LOGIN", "mail_smtpauth": 1, "mail_smtphost": "***REMOVED SENSITIVE VALUE***", "mail_smtpsecure": "ssl", "mail_smtpport": "465", "mail_smtpname": "***REMOVED SENSITIVE VALUE***", "mail_smtppassword": "***REMOVED SENSITIVE VALUE***", "has_internet_connection": true, "twofactor_enforced": "false", "twofactor_enforced_groups": [], "twofactor_enforced_excluded_groups": [], "filelocking.enabled": true, "trusted_proxies": "***REMOVED SENSITIVE VALUE***", "forwarded_for_headers": [ "HTTP_X_FORWARDED_FOR" ], "app_install_overwrite": [ "mindmap_app", "twofactor_yubikey" ], "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***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: Chrome

Operating system: Windows 10

Logs

Web server error log

Web server error log The logs below are the ones that appear when I try to enable File Sharing ``` 172.19.0.6 - - [31/Jan/2021:18:39:47 +0000] "POST /settings/apps/enable HTTP/1.1" 500 1188 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.104 Safari/537.36" 172.19.0.6 - - [31/Jan/2021:18:39:47 +0000] "GET /ocs/v2.php/core/navigation/apps?format=json HTTP/1.1" 200 1002 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.104 Safari/537.36" ```

Nextcloud log (data/nextcloud.log)

Nextcloud log ``` {"reqId":"SLJPTglUkvkCdEZ5umnR","level":3,"time":"2021-01-31T18:49:57+00:00","remoteAddr":"172.19.0.6","user":"wojtek","app":"settings","method":"POST","url":"/settings/apps/enable","message":{"Exception":"Doctrine\\DBAL\\Exception\\TableNotFoundException","Message":"An exception occurred while executing '\n\t\t\t\tSELECT \"remote\", \"share_token\", \"password\", \"mountpoint\", \"owner\"\n\t\t\t\tFROM \"oc_share_external\"\n\t\t\t\tWHERE \"user\" = ? AND \"accepted\" = ?\n\t\t\t' with params [\"wojtek\", 1]:\n\nSQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"oc_share_external\" does not exist\nLINE 3: FROM \"oc_share_external\"\n ^","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":169,"function":"convertException","class":"Doctrine\\DBAL\\Driver\\AbstractPostgreSQLDriver","type":"->","args":["An exception occurred while executing '\n\t\t\t\tSELECT \"remote\", \"share_token\", \"password\", \"mountpoint\", \"owner\"\n\t\t\t\tFROM \"oc_share_external\"\n\t\t\t\tWHERE \"user\" = ? AND \"accepted\" = ?\n\t\t\t' with params [\"wojtek\", 1]:\n\nSQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"oc_share_external\" does not exist\nLINE 3: FROM \"oc_share_external\"\n ^",{"errorInfo":["42P01",7,"ERROR: relation \"oc_share_external\" does not exist\nLINE 3: FROM \"oc_share_external\"\n ^"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"}]},{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":149,"function":"wrapException","class":"Doctrine\\DBAL\\DBALException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDOPgSql\\Driver"},{"errorInfo":["42P01",7,"ERROR: relation \"oc_share_external\" does not exist\nLINE 3: FROM \"oc_share_external\"\n ^"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"},"An exception occurred while executing '\n\t\t\t\tSELECT \"remote\", \"share_token\", \"password\", \"mountpoint\", \"owner\"\n\t\t\t\tFROM \"oc_share_external\"\n\t\t\t\tWHERE \"user\" = ? AND \"accepted\" = ?\n\t\t\t' with params [\"wojtek\", 1]:\n\nSQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"oc_share_external\" does not exist\nLINE 3: FROM \"oc_share_external\"\n ^"]},{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Statement.php","line":162,"function":"driverExceptionDuringQuery","class":"Doctrine\\DBAL\\DBALException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDOPgSql\\Driver"},{"errorInfo":["42P01",7,"ERROR: relation \"oc_share_external\" does not exist\nLINE 3: FROM \"oc_share_external\"\n ^"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"},"\n\t\t\t\tSELECT \"remote\", \"share_token\", \"password\", \"mountpoint\", \"owner\"\n\t\t\t\tFROM \"oc_share_external\"\n\t\t\t\tWHERE \"user\" = ? AND \"accepted\" = ?\n\t\t\t",{"1":"wojtek","2":1}]},{"file":"/var/www/html/apps/files_sharing/lib/External/MountProvider.php","line":80,"function":"execute","class":"Doctrine\\DBAL\\Statement","type":"->","args":[["wojtek",1]]},{"file":"/var/www/html/lib/private/Files/Filesystem.php","line":484,"function":"getMountsForUser","class":"OCA\\Files_Sharing\\External\\MountProvider","type":"->","args":[{"__class__":"OC\\User\\User"},{"__class__":"OC\\Files\\Storage\\StorageFactory"}]},{"function":"OC\\Files\\{closure}","class":"OC\\Files\\Filesystem","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Hooks/EmitterTrait.php","line":101,"function":"call_user_func_array","args":[{"__class__":"Closure"},["*** sensitive parameter replaced ***"]]},{"file":"/var/www/html/lib/private/Files/Config/MountProviderCollection.php","line":158,"function":"emit","class":"OC\\Files\\Config\\MountProviderCollection","type":"->","args":["\\OC\\Files\\Config","registerMountProvider",["*** sensitive parameter replaced ***"]]},{"file":"/var/www/html/apps/files_sharing/lib/AppInfo/Application.php","line":140,"function":"registerProvider","class":"OC\\Files\\Config\\MountProviderCollection","type":"->","args":["*** sensitive parameter replaced ***"]},{"file":"/var/www/html/apps/files_sharing/lib/AppInfo/Application.php","line":128,"function":"registerMountProviders","class":"OCA\\Files_Sharing\\AppInfo\\Application","type":"->","args":[{"__class__":"OC\\Files\\Config\\MountProviderCollection"}]},{"file":"/var/www/html/lib/private/ServerContainer.php","line":108,"function":"__construct","class":"OCA\\Files_Sharing\\AppInfo\\Application","type":"->","args":[]},{"file":"/var/www/html/lib/private/ServerContainer.php","line":171,"function":"getAppContainer","class":"OC\\ServerContainer","type":"->","args":["files_sharing","Files_Sharing"]},{"file":"/var/www/html/lib/private/ServerContainer.php","line":138,"function":"getAppContainerForService","class":"OC\\ServerContainer","type":"->","args":["OCA\\Files_Sharing\\Migration\\Version11300Date20201120141438"]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":449,"function":"query","class":"OC\\ServerContainer","type":"->","args":["OCA\\Files_Sharing\\Migration\\Version11300Date20201120141438"]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":473,"function":"createInstance","class":"OC\\DB\\MigrationService","type":"->","args":["11300Date20201120141438"]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":419,"function":"executeStep","class":"OC\\DB\\MigrationService","type":"->","args":["11300Date20201120141438",false]},{"file":"/var/www/html/lib/private/Installer.php","line":157,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->","args":[]},{"file":"/var/www/html/apps/settings/lib/Controller/AppSettingsController.php","line":448,"function":"installApp","class":"OC\\Installer","type":"->","args":["files_sharing"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":169,"function":"enableApps","class":"OCA\\Settings\\Controller\\AppSettingsController","type":"->","args":[["files_sharing"],[]]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":100,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Settings\\Controller\\AppSettingsController"},"enableApps"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":152,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Settings\\Controller\\AppSettingsController"},"enableApps"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":309,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Settings\\Controller\\AppSettingsController","enableApps",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"_route":"settings.AppSettings.enableApps"}]},{"file":"/var/www/html/lib/base.php","line":1008,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/settings/apps/enable"]},{"file":"/var/www/html/index.php","line":37,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php","Line":63,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDOException","Message":"SQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"oc_share_external\" does not exist\nLINE 3: FROM \"oc_share_external\"\n ^","Code":"42P01","Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Statement.php","line":153,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->","args":[["wojtek",1]]},{"file":"/var/www/html/apps/files_sharing/lib/External/MountProvider.php","line":80,"function":"execute","class":"Doctrine\\DBAL\\Statement","type":"->","args":[["wojtek",1]]},{"file":"/var/www/html/lib/private/Files/Filesystem.php","line":484,"function":"getMountsForUser","class":"OCA\\Files_Sharing\\External\\MountProvider","type":"->","args":[{"__class__":"OC\\User\\User"},{"__class__":"OC\\Files\\Storage\\StorageFactory"}]},{"function":"OC\\Files\\{closure}","class":"OC\\Files\\Filesystem","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Hooks/EmitterTrait.php","line":101,"function":"call_user_func_array","args":[{"__class__":"Closure"},["*** sensitive parameter replaced ***"]]},{"file":"/var/www/html/lib/private/Files/Config/MountProviderCollection.php","line":158,"function":"emit","class":"OC\\Files\\Config\\MountProviderCollection","type":"->","args":["\\OC\\Files\\Config","registerMountProvider",["*** sensitive parameter replaced ***"]]},{"file":"/var/www/html/apps/files_sharing/lib/AppInfo/Application.php","line":140,"function":"registerProvider","class":"OC\\Files\\Config\\MountProviderCollection","type":"->","args":["*** sensitive parameter replaced ***"]},{"file":"/var/www/html/apps/files_sharing/lib/AppInfo/Application.php","line":128,"function":"registerMountProviders","class":"OCA\\Files_Sharing\\AppInfo\\Application","type":"->","args":[{"__class__":"OC\\Files\\Config\\MountProviderCollection"}]},{"file":"/var/www/html/lib/private/ServerContainer.php","line":108,"function":"__construct","class":"OCA\\Files_Sharing\\AppInfo\\Application","type":"->","args":[]},{"file":"/var/www/html/lib/private/ServerContainer.php","line":171,"function":"getAppContainer","class":"OC\\ServerContainer","type":"->","args":["files_sharing","Files_Sharing"]},{"file":"/var/www/html/lib/private/ServerContainer.php","line":138,"function":"getAppContainerForService","class":"OC\\ServerContainer","type":"->","args":["OCA\\Files_Sharing\\Migration\\Version11300Date20201120141438"]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":449,"function":"query","class":"OC\\ServerContainer","type":"->","args":["OCA\\Files_Sharing\\Migration\\Version11300Date20201120141438"]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":473,"function":"createInstance","class":"OC\\DB\\MigrationService","type":"->","args":["11300Date20201120141438"]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":419,"function":"executeStep","class":"OC\\DB\\MigrationService","type":"->","args":["11300Date20201120141438",false]},{"file":"/var/www/html/lib/private/Installer.php","line":157,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->","args":[]},{"file":"/var/www/html/apps/settings/lib/Controller/AppSettingsController.php","line":448,"function":"installApp","class":"OC\\Installer","type":"->","args":["files_sharing"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":169,"function":"enableApps","class":"OCA\\Settings\\Controller\\AppSettingsController","type":"->","args":[["files_sharing"],[]]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":100,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Settings\\Controller\\AppSettingsController"},"enableApps"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":152,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Settings\\Controller\\AppSettingsController"},"enableApps"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":309,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Settings\\Controller\\AppSettingsController","enableApps",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"_route":"settings.AppSettings.enableApps"}]},{"file":"/var/www/html/lib/base.php","line":1008,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/settings/apps/enable"]},{"file":"/var/www/html/index.php","line":37,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","Line":129,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"oc_share_external\" does not exist\nLINE 3: FROM \"oc_share_external\"\n ^","Code":"42P01","Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","line":127,"function":"execute","class":"PDOStatement","type":"->","args":[["wojtek",1]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Statement.php","line":153,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->","args":[["wojtek",1]]},{"file":"/var/www/html/apps/files_sharing/lib/External/MountProvider.php","line":80,"function":"execute","class":"Doctrine\\DBAL\\Statement","type":"->","args":[["wojtek",1]]},{"file":"/var/www/html/lib/private/Files/Filesystem.php","line":484,"function":"getMountsForUser","class":"OCA\\Files_Sharing\\External\\MountProvider","type":"->","args":[{"__class__":"OC\\User\\User"},{"__class__":"OC\\Files\\Storage\\StorageFactory"}]},{"function":"OC\\Files\\{closure}","class":"OC\\Files\\Filesystem","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Hooks/EmitterTrait.php","line":101,"function":"call_user_func_array","args":[{"__class__":"Closure"},["*** sensitive parameter replaced ***"]]},{"file":"/var/www/html/lib/private/Files/Config/MountProviderCollection.php","line":158,"function":"emit","class":"OC\\Files\\Config\\MountProviderCollection","type":"->","args":["\\OC\\Files\\Config","registerMountProvider",["*** sensitive parameter replaced ***"]]},{"file":"/var/www/html/apps/files_sharing/lib/AppInfo/Application.php","line":140,"function":"registerProvider","class":"OC\\Files\\Config\\MountProviderCollection","type":"->","args":["*** sensitive parameter replaced ***"]},{"file":"/var/www/html/apps/files_sharing/lib/AppInfo/Application.php","line":128,"function":"registerMountProviders","class":"OCA\\Files_Sharing\\AppInfo\\Application","type":"->","args":[{"__class__":"OC\\Files\\Config\\MountProviderCollection"}]},{"file":"/var/www/html/lib/private/ServerContainer.php","line":108,"function":"__construct","class":"OCA\\Files_Sharing\\AppInfo\\Application","type":"->","args":[]},{"file":"/var/www/html/lib/private/ServerContainer.php","line":171,"function":"getAppContainer","class":"OC\\ServerContainer","type":"->","args":["files_sharing","Files_Sharing"]},{"file":"/var/www/html/lib/private/ServerContainer.php","line":138,"function":"getAppContainerForService","class":"OC\\ServerContainer","type":"->","args":["OCA\\Files_Sharing\\Migration\\Version11300Date20201120141438"]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":449,"function":"query","class":"OC\\ServerContainer","type":"->","args":["OCA\\Files_Sharing\\Migration\\Version11300Date20201120141438"]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":473,"function":"createInstance","class":"OC\\DB\\MigrationService","type":"->","args":["11300Date20201120141438"]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":419,"function":"executeStep","class":"OC\\DB\\MigrationService","type":"->","args":["11300Date20201120141438",false]},{"file":"/var/www/html/lib/private/Installer.php","line":157,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->","args":[]},{"file":"/var/www/html/apps/settings/lib/Controller/AppSettingsController.php","line":448,"function":"installApp","class":"OC\\Installer","type":"->","args":["files_sharing"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":169,"function":"enableApps","class":"OCA\\Settings\\Controller\\AppSettingsController","type":"->","args":[["files_sharing"],[]]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":100,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Settings\\Controller\\AppSettingsController"},"enableApps"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":152,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Settings\\Controller\\AppSettingsController"},"enableApps"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":309,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Settings\\Controller\\AppSettingsController","enableApps",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"_route":"settings.AppSettings.enableApps"}]},{"file":"/var/www/html/lib/base.php","line":1008,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/settings/apps/enable"]},{"file":"/var/www/html/index.php","line":37,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","Line":127}},"CustomMessage":"--"},"userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.104 Safari/537.36","version":"20.0.6.1"} ```

Browser log

Browser log ``` apps.js:39 {…}apps: (...)categories: (...)loading: (...)loadingList: (...)updateCount: (...)__ob__: xt {value: {…}, dep: ft, vmCount: 0}get apps: ƒ ()set apps: ƒ (e)get categories: ƒ ()set categories: ƒ (e)get loading: ƒ ()set loading: ƒ (e)get loadingList: ƒ ()set loadingList: ƒ (e)get updateCount: ƒ ()set updateCount: ƒ (e)__proto__: Object {appId: "files_sharing", error: Error: Request failed with status code 500 at t.exports (https://nextcloud.swtk.eu/apps/setting…} APPS_API_FAILURE @ apps.js:39 (anonymous) @ vuex.esm.js:840 (anonymous) @ vuex.esm.js:462 (anonymous) @ vuex.esm.js:461 f._withCommit @ vuex.esm.js:620 f.commit @ vuex.esm.js:460 commit @ vuex.esm.js:405 (anonymous) @ apps.js:213 Promise.catch (async) (anonymous) @ apps.js:206 Promise.then (async) enableApp @ apps.js:166 (anonymous) @ vuex.esm.js:847 f.dispatch @ vuex.esm.js:512 dispatch @ vuex.esm.js:402 enable @ AppManagement.js:117 click @ AppItem.vue?2c9b:1 zt @ vue.runtime.esm.js:1854 n @ vue.runtime.esm.js:2179 i._wrapper @ vue.runtime.esm.js:6917 ```
wsw70 commented 3 years ago

I managed to find a solution, but this is quite miraculous

~ ➤ docker exec --user www-data nextcloud php occ app:install files_sharing
files_sharing already installed
~ ➤ docker exec --user www-data nextcloud php occ app:update files_sharing
~ ➤ docker exec --user www-data nextcloud php occ app:enable files_sharing
files_sharing 1.12.2 enabled
szaimen commented 3 years ago

Is this Issue still valid in NC21.0.2? If not, please close this issue. Thanks! :)