Auto complete not working when creating an internal share

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):

    • 34.0.1 (same with 33.x)
  • Operating system and version (e.g., Ubuntu 24.04):

    • Debian

    Web server and version (e.g, Apache 2.4.25):

    • Apache 2.4
  • Reverse proxy and version _(e.g. nginx 1.27.2)
    *

  • PHP version (e.g, 8.3):

    • 8.4
  • Is this the first time you’ve seen this error? (Yes / No):

    • prior and post upgrade to 34.0.1
  • When did this problem seem to first start?

    • yesterday
  • Installation method (e.g. AlO, NCP, Bare Metal/Archive, etc.)

    • Existing bare metal install
  • Are you using CloudfIare, mod_security, or similar? (Yes / No)

    • No

Summary of the issue you are facing:

When creating or editing a share the autocomplete for username spins forever. Meaning we cant create a share.

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

  1. Click to add a share

  2. type useraname or part

  3. System waits with a spin.

Log entries

Nextcloud

Please provide the log entries from your Nextcloud log that are generated during the time of problem (via the Copy raw option from Administration settings->Logging screen or from your nextcloud.log located in your data directory). Feel free to use a pastebin/gist service if necessary.

Error no app in context DbalExceptionAn exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.sensitive' in 'SELECT'


Is the only error that relates in any time sense

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": {
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "localhost",
            "******"
        ],
        "auth.bruteforce.protection.enabled": false,
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "34.0.1.2",
        "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***",
        "maintenance": false,
        "theme": "",
        "logfile": "\/home\/data\/nextcloud.log",
        "loglevel": 1,
        "mail_smtpmode": "smtp",
        "mail_sendmailmode": "smtp",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "587",
        "mail_smtpauthtype": "LOGIN",
        "mail_smtpauth": true,
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "simpleSignUpLink.shown": false,
        "updater.release.channel": "stable",
        "mysql.utf8mb4": true,
        "trashbin_retention_obligation": "auto, 14",
        "memcache.local": "\\OC\\Memcache\\APCu",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 0,
            "timeout": 0,
            "mysql.utf8mb4": true
        },
        "has_rebuilt_cache": true,
        "filelocking.enabled": true,
        "app_install_overwrite": {
            "0": "mindmap_app",
            "1": "flowupload",
            "2": "shifts",
            "3": "carnet",
            "5": "files_bpm",
            "6": "mailnotifier",
            "7": "files_staticmimecontrol",
            "8": "sendent",
            "9": "theming_customcss",
            "10": "impersonate"
        },
        "default_phone_region": "GB",
        "data-fingerprint": "327aee50495a4f3f6e981274584aaea9",
        "maintenance_window_start": 1,
        "files.chunked_upload.max_size": 20971520,
        "mail_smtpstreamoptions": {
            "ssl": {
                "allow_self_signed": false,
                "verify_peer": true,
                "verify_peer_name": true
            }
        }
    }
}

Apps

Enabled:

  • activity: 7.0.0
  • admin_audit: 1.24.0
  • announcementcenter: 7.4.1
  • approval: 3.3.0
  • appstore: 1.0.0
  • bruteforcesettings: 7.0.0
  • calendar: 6.5.0
  • cloud_federation_api: 1.18.0
  • comments: 1.24.0
  • contactsinteraction: 1.15.0
  • dashboard: 7.14.0
  • dav: 1.39.0
  • deck: 1.18.2
  • event_update_notification: 2.9.0
  • federatedfilesharing: 1.24.0
  • federation: 1.24.0
  • files: 2.6.0
  • files_bpm: 1.8.3
  • files_downloadlimit: 5.2.0-dev.0
  • files_lock: 34.0.0
  • files_pdfviewer: 7.0.0-dev.0
  • files_reminders: 1.7.0
  • files_sharing: 1.26.0
  • files_trashbin: 1.24.0
  • files_versions: 1.27.0
  • firstrunwizard: 7.0.0-dev.0
  • flow_notifications: 5.0.0
  • forms: 5.3.2
  • impersonate: 4.0.0
  • integration_onedrive: 3.5.1
  • logreader: 7.0.0
  • lookup_server_connector: 1.22.0
  • nextcloud_announcements: 6.0.0
  • notes: 6.0.1
  • notifications: 7.0.0-dev.1
  • notify_push: 1.3.3
  • oauth2: 1.22.0
  • office: 1.0.0
  • password_policy: 6.0.0-dev.0
  • photos: 7.0.0
  • privacy: 6.0.0-dev.1
  • profile: 1.3.0
  • provisioning_api: 1.24.0
  • qownnotesapi: 26.5.0
  • quota_warning: 1.24.0
  • recommendations: 7.0.0
  • related_resources: 5.0.0-dev.0
  • sendent: 4.2.10
  • serverinfo: 6.0.0
  • settings: 1.17.0
  • sharebymail: 1.24.0
  • spreed: 24.0.1
  • support: 6.0.0
  • survey_client: 6.0.0-dev.0
  • systemtags: 1.24.0
  • tasks: 0.18.1
  • text: 8.0.0
  • theming: 2.9.0
  • theming_customcss: 1.20.0
  • twofactor_backupcodes: 1.23.0
  • twofactor_totp: 16.0.0
  • updatenotification: 1.24.0
  • user_status: 1.14.0
  • viewer: 7.0.0-dev.0
  • weather_status: 1.14.0
  • webhook_listeners: 1.6.0
  • welcome: 3.0.0
  • workflow_ocr: 1.34.0
  • workflow_script: 5.0.0
  • workflowengine: 2.16.0
    Disabled:
  • app_api: 34.0.0 (installed 32.0.0)
  • cadviewer: 10.10.7 (installed 10.10.7)
  • carnet: 0.25.13 (installed 0.25.13)
  • circles: 34.0.0 (installed 0.20.11)
  • encryption: 2.22.0
  • files_external: 1.26.0 (installed 1.6.0)
  • files_snapshots: 1.0.15 (installed 1.0.15)
  • libresign: 14.0.1 (installed 14.0.1)
  • mailnotifier: 0.0.3 (installed 0.0.3)
  • quicknotes: 0.8.50 (installed 0.8.50)
  • suspicious_login: 12.0.0-dev.0
  • twofactor_nextcloud_notification: 8.0.0
  • user_ldap: 1.25.0

Just to add, this isnt caused by the normal ommission of the Share settings not allowing autocomplete.

We can’t see where the DBAL error is from as it is not related to an app or any other context.

The issue remains with different browsers with no extensions etc.

We suspect it is perhaps a DB issue only because the DBAL error seems to be the only time related response in the logs. Any help locating the DB table/field would be great.