Fairly severe update bug in cospend (possibly requiring PostgreSQL)

Support intro

Sorry to hear you’re facing problems. :slightly_frowning_face:

The community help forum (help.nextcloud.com) is for home and non-enterprise users. Support is provided by other community members on a best effort / “as available” basis. All of those responding are volunteering their time to help you.

If you’re using Nextcloud in a business/critical setting, paid and SLA-based support services can be accessed via portal.nextcloud.com where Nextcloud engineers can help ensure your business keeps running smoothly.

Getting help

In order to help you as efficiently (and quickly!) as possible, please fill in as much of the below requested information as you can.

Before clicking submit: Please check if your query is already addressed via the following resources:

(Utilizing these existing resources is typically faster. It also helps reduce the load on our generous volunteers while elevating the signal to noise ratio of the forums otherwise arising from the same queries being posted repeatedly).

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:

The Basics

  • Nextcloud Server version (e.g., 29.x.x):
    • 30.0.4
  • Operating system and version (e.g., Ubuntu 24.04):
    • FreeBSD 14.1
  • Web server and version (e.g, Apache 2.4.25):
    • nginx 1.24.0
  • Reverse proxy and version _(e.g. nginx 1.27.2)
    • ?
  • PHP version (e.g, 8.3):
    • 8.2.14
  • Is this the first time you’ve seen this error? (Yes / No):
    • yes
  • When did this problem seem to first start?
    • after upgrading cospend
  • Installation method (e.g. AlO, NCP, Bare Metal/Archive, etc.)
    • various.
  • Are you using CloudfIare, mod_security, or similar? (Yes / No)
    • No.

Summary of the issue you are facing:

After upgrading cospend, the system is in maintenance mode and it wants to run an upgrade. The upgrade always fails. From my console:

[nextcloud@nextcloud ~/nextcloud]$ 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
Setting log level to debug
Turned on maintenance mode
Updating database schema
Updated database
Updating <cospend> ...
Exception: Database error when running migration 020001Date20240901171117 for app cospend
An exception occurred while executing a query: SQLSTATE[42501]: Insufficient privilege: 7 ERROR:  permission denied for schema public
LINE 1: CREATE TABLE oc_cospend_invitations (id BIGSERIAL NOT NULL, ...
                     ^
Update failed
Maintenance mode is kept active
Resetting log level

The only way I was able to get things running again was to disable the cospend app and then exit maintenance mode.

My strong suspicion is that this is due to PostgreSQL requiring something that mysql does not — and the app author never fully testing that upgrade.

Steps to replicate it (hint: details matter!):

  1. upgrade cospend
  2. phail.

Log entries

Nextcloud

see above

Web Browser

If the problem is related to the Web interface, open your browser inspector Console and Network tabs while refreshing (reloading) and reproducing the problem. Provide any relevant output/errors here that appear.

PASTE

Web server / Reverse Proxy

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

PASTE HERE

Configuration

Nextcloud

The output of occ config:list system or similar is best, but, if not possible, the contents of your config.php file from /path/to/nextcloud is fine (make sure to remove any identifiable information!):

{
    "system": {
        "filelocking.enabled": true,
        "memcache.local": "\\OC\\Memcache\\APCu",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 0,
            "timeout": 0,
            "password": "***REMOVED SENSITIVE VALUE***"
        },
        "apps_paths": [
            {
                "path": "\/usr\/local\/www\/nextcloud\/apps",
                "url": "\/apps",
                "writable": true
            }
        ],
        "logfile": "\/var\/log\/nextcloud\/nextcloud.log",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "localhost",
            "nextcloud.adomain.ca",
            "nextcloud.adomainworks.ca",
            "nextcloud.adomain.ca",
            "v4.nextcloud.adomain.ca",
            "v6.nextcloud.adomain.ca"
        ],
        "config_is_read_only": false,
        "default_phone_region": "ISO 3166-2:CA",
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "pgsql",
        "version": "30.0.4.1",
        "overwrite.cli.url": "http:\/\/localhost",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpmode": "smtp",
        "mail_sendmailmode": "smtp",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "maintenance_window_start": 7,
        "maintenance": false,
        "theme": "",
        "loglevel": 0,
        "updater.release.channel": "stable",
        "app_install_overwrite": [
            "spreed"
        ],
        "debug": false,
        "memories.exiftool_no_local": true,
        "memories.vod.path": "\/usr\/local\/www\/nextcloud\/apps\/memories\/bin-ext\/go-vod-amd64",
        "memories.vod.ffmpeg": "\/usr\/local\/bin\/ffmpeg",
        "memories.vod.ffprobe": "\/usr\/local\/bin\/ffprobe"
    },
    "apps": {
        "activity": {
            "types": "filesystem",
            "enabled": "yes",
            "notify_notification_group_settings": "1",
            "notify_notification_security": "1",
            "notify_notification_personal_settings": "0",
            "notify_notification_favorite": "0",
            "notify_email_favorite": "0",
            "notify_notification_file_changed": "0",
            "notify_email_file_changed": "0",
            "notify_notification_file_favorite_changed": "1",
            "notify_email_file_favorite_changed": "0",
            "notify_notification_comments": "0",
            "notify_email_comments": "0",
            "notify_notification_deck": "0",
            "notify_email_deck": "0",
            "notify_notification_deck_comment": "0",
            "notify_email_deck_comment": "0",
            "notify_notification_deck_card_description": "0",
            "notify_email_deck_card_description": "0",
            "notify_notification_calendar": "0",
            "notify_email_calendar": "0",
            "notify_notification_calendar_event": "0",
            "notify_email_calendar_event": "0",
            "notify_notification_calendar_todo": "0",
            "notify_email_calendar_todo": "0",
            "notify_notification_shared": "0",
            "notify_email_shared": "0",
            "notify_notification_remote_share": "0",
            "notify_email_remote_share": "0",
            "notify_notification_public_links": "0",
            "notify_email_public_links": "0",
            "notify_notification_spreed": "1",
            "notify_email_spreed": "0",
            "notify_notification_systemtags": "0",
            "notify_email_systemtags": "0",
            "notify_setting_batchtime": "3600",
            "notify_setting_self": "0",
            "notify_setting_selfemail": "0",
            "installed_version": "3.0.0"
        },
        "admin_audit": {
            "types": "logging",
            "enabled": "yes",
            "installed_version": "1.20.0"
        },
        "analytics": {
            "types": "",
            "installed_version": "5.2.0",
            "enabled": "no"
        },
        "announcementcenter": {
            "types": "logging",
            "enabled": "yes",
            "installed_version": "7.0.1"
        },
        "app_api": {
            "types": "",
            "enabled": "yes",
            "installed_version": "4.0.3"
        },
        "audioplayer": {
            "types": "filesystem",
            "installed_version": "3.2.4",
            "enabled": "no"
        },
        "backgroundjob": {
            "lastjob": "731864"
        },
        "breezedark": {
            "theme_enabled": "1",
            "theme_login_page": "1",
            "installed_version": "25.0.1",
            "enabled": "no",
            "types": "",
            "theme_settings_version": "2"
        },
        "bruteForce": {
            "whitelist_1": "2001:1111::\/32",
            "whitelist_3": "172.17.100.0\/20"
        },
        "bruteforcesettings": {
            "types": "",
            "enabled": "yes",
            "installed_version": "3.0.0"
        },
        "calendar": {
            "types": "",
            "enabled": "yes",
            "installed_version": "5.0.8"
        },
        "camerarawpreviews": {
            "types": "filesystem",
            "installed_version": "0.8.6",
            "enabled": "no"
        },
        "circles": {
            "migration_22": "1",
            "migration_22_1": "1",
            "types": "filesystem,dav",
            "enabled": "yes",
            "loopback_tmp_scheme": "http",
            "migration_run": "0",
            "installed_version": "30.0.0",
            "maintenance_run": "0",
            "maintenance_update": "{\"maximum\":4,\"3\":1735070440,\"2\":1735070440,\"1\":1735070440,\"4\":1653616801,\"5\":1653102000}"
        },
        "cloud_federation_api": {
            "types": "filesystem",
            "enabled": "yes",
            "installed_version": "1.13.0"
        },
        "comments": {
            "types": "logging",
            "enabled": "yes",
            "installed_version": "1.20.1"
        },
        "contacts": {
            "types": "dav",
            "enabled": "yes",
            "installed_version": "6.1.2"
        },
        "contactsinteraction": {
            "types": "dav",
            "enabled": "yes",
            "installed_version": "1.11.0"
        },
        "cookbook": {
            "types": "",
            "enabled": "yes",
            "installed_version": "0.11.2"
        },
        "core": {
            "installedat": "1546479189.5067",
            "vendor": "nextcloud",
            "public_files": "files_sharing\/public.php",
            "public_webdav": "dav\/appinfo\/v1\/publicwebdav.php",
            "backgroundjobs_mode": "cron",
            "updater.secret.created": 1734158502,
            "files_metadata_installed": "1",
            "scss.variables": "db81cddf52fdb3c8ca1e4c859e214124",
            "enterpriseLogoChecked": "yes",
            "moveavatarsdone": "yes",
            "previewsCleanedUp": "1",
            "shareapi_default_internal_expire_date": "no",
            "default_encryption_module": "OC_DEFAULT_MODULE",
            "theming.variables": "b92d206521717ac032f8aa58d3c7ff2f",
            "metadataGenerationDone": true,
            "lastupdatedat": 1735070041,
            "lastupdateResult": "[]",
            "lastcron": 1735070439,
            "files_metadata": {
                "photos-original_date_time": {
                    "value": null,
                    "type": "int",
                    "etag": "",
                    "indexed": true,
                    "editPermission": 0
                },
                "photos-size": {
                    "value": null,
                    "type": "array",
                    "etag": "",
                    "indexed": false,
                    "editPermission": 0
                },
                "photos-exif": {
                    "value": null,
                    "type": "array",
                    "etag": "",
                    "indexed": false,
                    "editPermission": 0
                },
                "photos-ifd0": {
                    "value": null,
                    "type": "array",
                    "etag": "",
                    "indexed": false,
                    "editPermission": 0
                },
                "photos-gps": {
                    "value": null,
                    "type": "array",
                    "etag": "",
                    "indexed": false,
                    "editPermission": 0
                },
                "photos-place": {
                    "value": null,
                    "type": "string",
                    "etag": "",
                    "indexed": true,
                    "editPermission": 0
                },
                "files-live-photo": {
                    "value": null,
                    "type": "string",
                    "etag": "",
                    "indexed": false,
                    "editPermission": 0
                },
                "blurhash": {
                    "value": null,
                    "type": "string",
                    "etag": "13413a698c63cc66b838b643540e0ff7",
                    "indexed": false,
                    "editPermission": 0
                }
            },
            "oc.integritycheck.checker": []
        },
        "cospend": {
            "installed_version": "2.0.0",
            "types": "",
            "enabled": "no"
        },
        "dashboard": {
            "types": "",
            "enabled": "yes",
            "installed_version": "7.10.0"
        },
        "dav": {
            "types": "filesystem",
            "enabled": "yes",
            "sendEventRemindersPush": "yes",
            "buildCalendarSearchIndex": "yes",
            "buildCalendarReminderIndex": "yes",
            "regeneratedBirthdayCalendarsForYearFix": "yes",
            "chunks_migrated": "1",
            "installed_version": "1.31.1",
            "builtSocialSearchIndex": "yes"
        },
        "deck": {
            "types": "dav",
            "enabled": "yes",
            "installed_version": "1.14.2"
        },
        "drawio": {
            "types": "filesystem",
            "enabled": "yes",
            "installed_version": "3.0.3"
        },
        "encryption": {
            "installed_version": "2.8.1",
            "types": "filesystem",
            "enabled": "no",
            "recoveryKeyId": "recoveryKey_1018c59e",
            "publicShareKeyId": "pubShare_1018c59e",
            "masterKeyId": "master_1018c59e"
        },
        "end_to_end_encryption": {
            "installed_version": "1.12.4",
            "types": "filesystem,dav",
            "enabled": "no"
        },
        "epubviewer": {
            "types": "",
            "enabled": "no",
            "installed_version": "1.6.3"
        },
        "federatedfilesharing": {
            "types": "",
            "enabled": "yes",
            "installed_version": "1.20.0"
        },
        "federation": {
            "types": "authentication",
            "enabled": "yes",
            "autoAddServers": "1",
            "installed_version": "1.20.0"
        },
        "files": {
            "types": "filesystem",
            "enabled": "yes",
            "cronjob_scan_files": "500",
            "mimetype_version": "30.0.2.2",
            "installed_version": "2.2.0"
        },
        "files_3dmodelviewer": {
            "types": "",
            "enabled": "yes",
            "installed_version": "0.0.15"
        },
        "files_accesscontrol": {
            "installed_version": "1.16.0",
            "enabled": "no",
            "types": "filesystem"
        },
        "files_automatedtagging": {
            "types": "filesystem",
            "installed_version": "1.20.0",
            "enabled": "yes"
        },
        "files_downloadlimit": {
            "types": "",
            "enabled": "yes",
            "installed_version": "3.0.0"
        },
        "files_markdown": {
            "types": "",
            "installed_version": "2.4.0",
            "enabled": "no"
        },
        "files_pdfviewer": {
            "types": "",
            "enabled": "yes",
            "installed_version": "3.0.0"
        },
        "files_reminders": {
            "types": "",
            "enabled": "yes",
            "installed_version": "1.3.0"
        },
        "files_rightclick": {
            "types": "",
            "enabled": "no",
            "installed_version": "1.6.0"
        },
        "files_sharing": {
            "types": "filesystem",
            "enabled": "yes",
            "outgoing_server2server_group_share_enabled": "yes",
            "incoming_server2server_group_share_enabled": "yes",
            "installed_version": "1.22.0"
        },
        "files_texteditor": {
            "types": "",
            "enabled": "no",
            "installed_version": "2.8.0"
        },
        "files_trashbin": {
            "types": "filesystem,dav",
            "enabled": "yes",
            "installed_version": "1.20.1"
        },
        "files_versions": {
            "types": "filesystem,dav",
            "enabled": "yes",
            "installed_version": "1.23.0"
        },
        "firstrunwizard": {
            "types": "logging",
            "enabled": "yes",
            "installed_version": "3.0.0"
        },
        "forms": {
            "types": "",
            "enabled": "yes",
            "installed_version": "4.3.4"
        },
        "fulltextsearch": {
            "installed_version": "26.0.0",
            "types": "",
            "enabled": "no",
            "migration_24": "0"
        },
        "gallery": {
            "types": "",
            "enabled": "no",
            "installed_version": "18.4.0"
        },
        "gpxpod": {
            "maptiler_api_key": "***REMOVED SENSITIVE VALUE***",
            "installed_version": "7.0.4",
            "enabled": "yes",
            "types": ""
        },
        "groupfolders": {
            "types": "filesystem,dav",
            "enabled": "yes",
            "installed_version": "18.0.8"
        },
        "impersonate": {
            "types": "",
            "installed_version": "1.10.0",
            "enabled": "no"
        },
        "integration_github": {
            "types": "",
            "enabled": "no",
            "client_id": "***REMOVED SENSITIVE VALUE***",
            "client_secret": "***REMOVED SENSITIVE VALUE***",
            "installed_version": "3.1.1"
        },
        "integration_mastodon": {
            "installed_version": "2.0.6",
            "types": "",
            "enabled": "yes",
            "oauth_instance_url": "nojack.easydns.ca",
            "use_popup": "1"
        },
        "logreader": {
            "enabled": "yes",
            "types": "logging",
            "installed_version": "3.0.0"
        },
        "lookup_server_connector": {
            "types": "authentication",
            "enabled": "yes",
            "installed_version": "1.18.0"
        },
        "mail": {
            "types": "",
            "enabled": "yes",
            "installed_version": "4.1.1"
        },
        "maps": {
            "types": "filesystem",
            "enabled": "no",
            "lastAddressLookup": "1653626019",
            "installed_version": "1.5.0"
        },
        "memories": {
            "last_index_job_status": "Indexing process stopped before completion. Will continue on next run",
            "last_index_job_status_type": "info",
            "installed_version": "7.4.1",
            "types": "",
            "enabled": "yes",
            "last_index_job_duration": "300.02",
            "last_index_job_start": "1735070139"
        },
        "news": {
            "types": "",
            "enabled": "no",
            "installed_version": "25.1.2"
        },
        "nextcloud_announcements": {
            "types": "logging",
            "enabled": "yes",
            "pub_date": "Thu, 24 Oct 2019 00:00:00 +0200",
            "installed_version": "2.0.0"
        },
        "notes": {
            "types": "",
            "enabled": "yes",
            "installed_version": "4.11.0"
        },
        "notifications": {
            "types": "logging",
            "enabled": "yes",
            "installed_version": "3.0.0"
        },
        "oauth2": {
            "types": "authentication",
            "enabled": "yes",
            "installed_version": "1.18.1"
        },
        "onlyoffice": {
            "types": "prevent_group_restriction",
            "demo": "{\"available\":true,\"enabled\":false,\"start\":{\"date\":\"2020-12-27 22:34:16.936642\",\"timezone_type\":3,\"timezone\":\"UTC\"}}",
            "DocumentServerUrl": "https:\/\/zbeeble.net\/",
            "verify_peer_off": "false",
            "DocumentServerInternalUrl": "",
            "jwt_secret": "***REMOVED SENSITIVE VALUE***",
            "StorageUrl": "",
            "settings_error": "cURL error 7: Failed to connect to zbeeble.net port 443: Connection refused (see https:\/\/curl.haxx.se\/libcurl\/c\/libcurl-errors.html)",
            "enabled": "yes",
            "installed_version": "9.5.0"
        },
        "password_policy": {
            "enabled": "yes",
            "types": "authentication",
            "installed_version": "2.0.0",
            "enforceHaveIBeenPwned": "1"
        },
        "photos": {
            "enabled": "yes",
            "types": "dav,authentication",
            "lastPlaceMappedUser": "will",
            "lastPlaceMappingDone": "true",
            "installed_version": "3.0.2"
        },
        "previewgenerator": {
            "types": "filesystem",
            "enabled": "yes",
            "installed_version": "5.7.0"
        },
        "privacy": {
            "readableLocation": "ca",
            "types": "",
            "enabled": "yes",
            "installed_version": "2.0.0"
        },
        "provisioning_api": {
            "types": "prevent_group_restriction",
            "enabled": "yes",
            "installed_version": "1.20.0"
        },
        "quicknotes": {
            "enabled": "no",
            "types": "",
            "installed_version": "0.8.5"
        },
        "recommendations": {
            "types": "",
            "enabled": "yes",
            "installed_version": "3.0.0"
        },
        "related_resources": {
            "types": "",
            "enabled": "yes",
            "installed_version": "1.5.0"
        },
        "serverinfo": {
            "types": "",
            "enabled": "yes",
            "installed_version": "2.0.0",
            "cached_count_storages": "50",
            "cached_count_filecache": "5821218"
        },
        "settings": {
            "types": "",
            "enabled": "yes",
            "installed_version": "1.13.0"
        },
        "sharebymail": {
            "types": "filesystem",
            "enabled": "yes",
            "installed_version": "1.20.0"
        },
        "socialsharing_email": {
            "types": "",
            "enabled": "yes",
            "installed_version": "3.2.0"
        },
        "spreed": {
            "signaling_ticket_secret": "***REMOVED SENSITIVE VALUE***",
            "federation_enabled": "yes",
            "has_reference_id": "yes",
            "types": "dav,prevent_group_restriction",
            "stun_servers": "***REMOVED SENSITIVE VALUE***",
            "project_access_invalidated": "1",
            "signaling_token_privkey_es256": "***REMOVED SENSITIVE VALUE***",
            "signaling_token_pubkey_es256": "***REMOVED SENSITIVE VALUE***",
            "turn_servers": "***REMOVED SENSITIVE VALUE***",
            "federation_only_trusted_servers": "1",
            "enabled": "yes",
            "installed_version": "20.1.1"
        },
        "support": {
            "enabled": "yes",
            "SwitchUpdaterServerHasRun": "yes",
            "types": "session",
            "installed_version": "2.0.0"
        },
        "survey_client": {
            "types": "",
            "enabled": "yes",
            "installed_version": "2.0.0",
            "last_sent": "1733475315",
            "last_report": "{\"id\":\"oc21rultxsk7\",\"items\":[[\"server\",\"version\",\"30.0.2.2\"],[\"server\",\"code\",\"other\"],[\"server\",\"enable_avatars\",\"yes\"],[\"server\",\"enable_previews\",\"yes\"],[\"server\",\"memcache.local\",\"\\\\OC\\\\Memcache\\\\APCu\"],[\"server\",\"memcache.distributed\",\"none\"],[\"server\",\"asset-pipeline.enabled\",\"no\"],[\"server\",\"filelocking.enabled\",\"yes\"],[\"server\",\"memcache.locking\",\"\\\\OC\\\\Memcache\\\\Redis\"],[\"server\",\"debug\",\"no\"],[\"server\",\"cron\",\"cron\"],[\"php\",\"version\",\"8.2.14\"],[\"php\",\"memory_limit\",536870912],[\"php\",\"max_execution_time\",0],[\"php\",\"upload_max_filesize\",10737418240],[\"database\",\"type\",\"pgsql\"],[\"database\",\"version\",\"PostgreSQL 16.4 on amd64-portbld-freebsd13.4, compiled by clang version 15.0.7, 64-bit\"],[\"database\",\"size\",5030801891],[\"apps\",\"files_accesscontrol\",\"disabled\"],[\"apps\",\"quicknotes\",\"disabled\"],[\"apps\",\"gallery\",\"disabled\"],[\"apps\",\"files_texteditor\",\"disabled\"],[\"apps\",\"fulltextsearch\",\"disabled\"],[\"apps\",\"integration_mastodon\",\"2.0.6\"],[\"apps\",\"tasks\",\"0.16.1\"],[\"apps\",\"epubviewer\",\"disabled\"],[\"apps\",\"files_reminders\",\"1.3.0\"],[\"apps\",\"camerarawpreviews\",\"disabled\"],[\"apps\",\"analytics\",\"disabled\"],[\"apps\",\"audioplayer\",\"disabled\"],[\"apps\",\"files_markdown\",\"disabled\"],[\"apps\",\"end_to_end_encryption\",\"disabled\"],[\"apps\",\"provisioning_api\",\"1.20.0\"],[\"apps\",\"sharebymail\",\"1.20.0\"],[\"apps\",\"integration_github\",\"disabled\"],[\"apps\",\"maps\",\"disabled\"],[\"apps\",\"files_rightclick\",\"disabled\"],[\"apps\",\"twofactor_backupcodes\",\"1.19.0\"],[\"apps\",\"whiteboard\",\"1.0.4\"],[\"apps\",\"encryption\",\"disabled\"],[\"apps\",\"breezedark\",\"disabled\"],[\"apps\",\"news\",\"disabled\"],[\"apps\",\"oauth2\",\"1.18.1\"],[\"apps\",\"photos\",\"3.0.2\"],[\"apps\",\"files\",\"2.2.0\"],[\"apps\",\"dav\",\"1.31.1\"],[\"apps\",\"files_sharing\",\"1.22.0\"],[\"apps\",\"socialsharing_email\",\"3.2.0\"],[\"apps\",\"files_trashbin\",\"1.20.1\"],[\"apps\",\"files_versions\",\"1.23.0\"],[\"apps\",\"workflowengine\",\"2.12.0\"],[\"apps\",\"admin_audit\",\"1.20.0\"],[\"apps\",\"comments\",\"1.20.1\"],[\"apps\",\"firstrunwizard\",\"3.0.0\"],[\"apps\",\"logreader\",\"3.0.0\"],[\"apps\",\"nextcloud_announcements\",\"2.0.0\"],[\"apps\",\"notifications\",\"3.0.0\"],[\"apps\",\"systemtags\",\"1.20.0\"],[\"apps\",\"theming\",\"2.5.0\"],[\"apps\",\"bruteforcesettings\",\"3.0.0\"],[\"apps\",\"contactsinteraction\",\"1.11.0\"],[\"apps\",\"dashboard\",\"7.10.0\"],[\"apps\",\"federatedfilesharing\",\"1.20.0\"],[\"apps\",\"files_pdfviewer\",\"3.0.0\"],[\"apps\",\"privacy\",\"2.0.0\"],[\"apps\",\"recommendations\",\"3.0.0\"],[\"apps\",\"settings\",\"1.13.0\"],[\"apps\",\"support\",\"2.0.0\"],[\"apps\",\"survey_client\",\"2.0.0\"],[\"apps\",\"text\",\"4.1.0\"],[\"apps\",\"updatenotification\",\"1.20.0\"],[\"apps\",\"user_status\",\"1.10.0\"],[\"apps\",\"viewer\",\"3.0.0\"],[\"apps\",\"weather_status\",\"1.10.0\"],[\"apps\",\"password_policy\",\"2.0.0\"],[\"apps\",\"activity\",\"3.0.0\"],[\"apps\",\"impersonate\",\"disabled\"],[\"apps\",\"forms\",\"4.3.4\"],[\"apps\",\"unsplash\",\"disabled\"],[\"apps\",\"related_resources\",\"1.5.0\"],[\"apps\",\"serverinfo\",\"2.0.0\"],[\"apps\",\"announcementcenter\",\"7.0.1\"],[\"apps\",\"onlyoffice\",\"9.5.0\"],[\"apps\",\"files_3dmodelviewer\",\"0.0.14\"],[\"apps\",\"cospend\",\"2.0.0\"],[\"apps\",\"federation\",\"1.20.0\"],[\"apps\",\"files_automatedtagging\",\"1.20.0\"],[\"apps\",\"cookbook\",\"0.11.2\"],[\"apps\",\"drawio\",\"3.0.3\"],[\"apps\",\"notes\",\"4.11.0\"],[\"apps\",\"suspicious_login\",\"8.0.0\"],[\"apps\",\"spreed\",\"20.0.2\"],[\"apps\",\"circles\",\"30.0.0\"],[\"apps\",\"cloud_federation_api\",\"1.13.0\"],[\"apps\",\"files_downloadlimit\",\"3.0.0\"],[\"apps\",\"memories\",\"7.4.1\"],[\"apps\",\"lookup_server_connector\",\"1.18.0\"],[\"apps\",\"app_api\",\"4.0.0\"],[\"apps\",\"webhook_listeners\",\"1.1.0-dev\"],[\"apps\",\"gpxpod\",\"7.0.4\"],[\"apps\",\"contacts\",\"6.1.1\"],[\"apps\",\"deck\",\"1.14.2\"],[\"apps\",\"calendar\",\"5.0.6\"],[\"apps\",\"groupfolders\",\"18.0.6\"],[\"apps\",\"mail\",\"4.0.5\"],[\"apps\",\"previewgenerator\",\"5.7.0\"],[\"stats\",\"num_files\",5820924],[\"stats\",\"num_users\",43],[\"stats\",\"num_storages\",50],[\"stats\",\"num_storages_local\",1],[\"stats\",\"num_storages_home\",49],[\"stats\",\"num_storages_other\",0],[\"stats\",\"num_comments\",37072],[\"stats\",\"num_comment_markers\",5],[\"stats\",\"num_systemtags\",0],[\"stats\",\"num_systemtags_mappings\",0],[\"files_sharing\",\"num_shares\",8934],[\"files_sharing\",\"num_shares_user\",32],[\"files_sharing\",\"num_shares_groups\",18],[\"files_sharing\",\"num_shares_link\",362],[\"files_sharing\",\"num_shares_link_no_password\",362],[\"files_sharing\",\"num_fed_shares_sent\",0],[\"files_sharing\",\"num_fed_shares_received\",0],[\"files_sharing\",\"permissions_10_19\",1668],[\"files_sharing\",\"permissions_3_4\",4],[\"files_sharing\",\"permissions_3_17\",318],[\"files_sharing\",\"permissions_1_31\",10],[\"files_sharing\",\"permissions_11_19\",6715],[\"files_sharing\",\"permissions_1_1\",1],[\"files_sharing\",\"permissions_0_15\",1],[\"files_sharing\",\"permissions_0_31\",16],[\"files_sharing\",\"permissions_4_17\",7],[\"files_sharing\",\"permissions_3_31\",5],[\"files_sharing\",\"permissions_2_31\",72],[\"files_sharing\",\"permissions_2_1\",2],[\"files_sharing\",\"permissions_2_17\",2],[\"files_sharing\",\"permissions_3_3\",1],[\"files_sharing\",\"permissions_4_3\",1],[\"files_sharing\",\"permissions_3_19\",2],[\"files_sharing\",\"permissions_0_19\",10],[\"files_sharing\",\"permissions_1_17\",1],[\"files_sharing\",\"permissions_2_19\",15],[\"files_sharing\",\"permissions_2_0\",2],[\"files_sharing\",\"permissions_3_1\",31],[\"files_sharing\",\"permissions_3_15\",1],[\"files_sharing\",\"permissions_4_19\",1],[\"files_sharing\",\"permissions_10_31\",3],[\"files_sharing\",\"permissions_0_17\",4],[\"files_sharing\",\"permissions_11_31\",21],[\"files_sharing\",\"permissions_0_1\",1],[\"files_sharing\",\"permissions_4_1\",4],[\"files_sharing\",\"permissions_4_31\",9],[\"files_sharing\",\"permissions_1_19\",6],[\"encryption\",\"enabled\",\"no\"],[\"encryption\",\"default_module\",\"yes\"]]}"
        },
        "suspicious_login": {
            "types": "authentication",
            "enabled": "yes",
            "installed_version": "8.0.0"
        },
        "systemtags": {
            "types": "logging",
            "enabled": "yes",
            "installed_version": "1.20.0"
        },
        "tasks": {
            "enabled": "yes",
            "types": "",
            "installed_version": "0.16.1"
        },
        "text": {
            "enabled": "yes",
            "types": "dav",
            "installed_version": "4.1.0"
        },
        "theming": {
            "types": "logging",
            "enabled": "yes",
            "installed_version": "2.5.0"
        },
        "twofactor_backupcodes": {
            "types": "",
            "enabled": "yes",
            "installed_version": "1.19.0"
        },
        "unsplash": {
            "unsplash\/style\/dashborad": "1",
            "types": "",
            "enabled": "no",
            "installed_version": "3.0.3"
        },
        "updatenotification": {
            "related_resources": "1.0.4",
            "news": "21.2.0",
            "integration_github": "2.0.4",
            "types": "",
            "enabled": "yes",
            "files_automatedtagging": "1.15.3",
            "onlyoffice": "9.3.0",
            "breezedark": "24.0.2",
            "cookbook": "0.11.1",
            "tasks": "0.16.0",
            "notes": "4.10.1",
            "previewgenerator": "5.7.0",
            "contacts": "6.1.2",
            "files_rightclick": "0.15.1",
            "update_check_errors": "0",
            "unsplash": "2.2.1",
            "files_markdown": "2.3.6",
            "quicknotes": "0.7.3",
            "fulltextsearch": "21.0.3",
            "socialsharing_email": "3.1.0",
            "epubviewer": "1.6.3",
            "audioplayer": "3.3.0",
            "bruteforcesettings": "2.4.0",
            "integration_mastodon": "2.0.4",
            "announcementcenter": "6.8.1",
            "installed_version": "1.20.0",
            "core": "30.0.4.1",
            "mail": "4.1.1",
            "groupfolders": "18.0.7",
            "spreed": "20.1.1",
            "calendar": "5.0.8",
            "deck": "1.14.2",
            "forms": "4.3.3",
            "files_3dmodelviewer": "0.0.15",
            "cospend": "3.0.5"
        },
        "user_status": {
            "types": "",
            "enabled": "yes",
            "installed_version": "1.10.0"
        },
        "viewer": {
            "types": "",
            "enabled": "yes",
            "installed_version": "3.0.0"
        },
        "weather_status": {
            "types": "",
            "enabled": "yes",
            "installed_version": "1.10.0"
        },
        "webhook_listeners": {
            "installed_version": "1.1.0-dev",
            "types": "filesystem",
            "enabled": "yes"
        },
        "whiteboard": {
            "installed_version": "1.0.4",
            "types": "",
            "enabled": "yes"
        },
        "workflowengine": {
            "types": "filesystem",
            "enabled": "yes",
            "installed_version": "2.12.0"
        }
    }
}

Apps

The output of occ app:list (if possible).

[nextcloud@nextcloud ~/nextcloud]$ php occ app:list
Enabled:
  - activity: 3.0.0
  - admin_audit: 1.20.0
  - announcementcenter: 7.0.1
  - app_api: 4.0.3
  - bruteforcesettings: 3.0.0
  - calendar: 5.0.8
  - circles: 30.0.0
  - cloud_federation_api: 1.13.0
  - comments: 1.20.1
  - contacts: 6.1.2
  - contactsinteraction: 1.11.0
  - cookbook: 0.11.2
  - dashboard: 7.10.0
  - dav: 1.31.1
  - deck: 1.14.2
  - drawio: 3.0.3
  - federatedfilesharing: 1.20.0
  - federation: 1.20.0
  - files: 2.2.0
  - files_3dmodelviewer: 0.0.15
  - files_automatedtagging: 1.20.0
  - files_downloadlimit: 3.0.0
  - files_pdfviewer: 3.0.0
  - files_reminders: 1.3.0
  - files_sharing: 1.22.0
  - files_trashbin: 1.20.1
  - files_versions: 1.23.0
  - firstrunwizard: 3.0.0
  - forms: 4.3.4
  - gpxpod: 7.0.4
  - groupfolders: 18.0.8
  - integration_mastodon: 2.0.6
  - logreader: 3.0.0
  - lookup_server_connector: 1.18.0
  - mail: 4.1.1
  - memories: 7.4.1
  - nextcloud_announcements: 2.0.0
  - notes: 4.11.0
  - notifications: 3.0.0
  - oauth2: 1.18.1
  - onlyoffice: 9.5.0
  - password_policy: 2.0.0
  - photos: 3.0.2
  - previewgenerator: 5.7.0
  - privacy: 2.0.0
  - provisioning_api: 1.20.0
  - recommendations: 3.0.0
  - related_resources: 1.5.0
  - serverinfo: 2.0.0
  - settings: 1.13.0
  - sharebymail: 1.20.0
  - socialsharing_email: 3.2.0
  - spreed: 20.1.1
  - support: 2.0.0
  - survey_client: 2.0.0
  - suspicious_login: 8.0.0
  - systemtags: 1.20.0
  - tasks: 0.16.1
  - text: 4.1.0
  - theming: 2.5.0
  - twofactor_backupcodes: 1.19.0
  - updatenotification: 1.20.0
  - user_status: 1.10.0
  - viewer: 3.0.0
  - weather_status: 1.10.0
  - webhook_listeners: 1.1.0-dev
  - whiteboard: 1.0.4
  - workflowengine: 2.12.0
Disabled:
  - analytics: 5.2.0 (installed 5.2.0)
  - camerarawpreviews: 0.8.6 (installed 0.8.6)
  - cospend: 3.0.5 (installed 2.0.0)
  - encryption: 2.18.0 (installed 2.8.1)
  - epubviewer: 1.6.7 (installed 1.6.3)
  - files_external: 1.22.0
  - files_rightclick: 0.15.1 (installed 1.6.0)
  - integration_github: 3.1.1 (installed 3.1.1)
  - maps: 1.5.0 (installed 1.5.0)
  - news: 25.1.2 (installed 25.1.2)
  - twofactor_nextcloud_notification: 4.0.0
  - twofactor_totp: 12.0.0-dev
  - unsplash: 3.0.3 (installed 3.0.3)
  - user_ldap: 1.21.0
[nextcloud@nextcloud ~/nextcloud]$

Tips for increasing the likelihood of a response

  • Use the preformatted text formatting option in the editor for all log entries and configuration output.
  • If screenshots are useful, feel free to include them.
    • If possible, also include key error output in text form so it can be searched for.
  • Try to edit log output only minimally (if at all) so that it can be ran through analyzers / formatters by those trying to help you.

Sounds more like the database user is not allowed to create new tables?