[Bug]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'type' in 'field list' (upgrade 30.0.6 to 31)

[mistersixt]

⚠️ This issue respects the following points: ⚠️

• This is a bug, not a question or a configuration/webserver/proxy issue.
• This issue is not already reported on Github OR Nextcloud Community Forum (I've searched it).
• Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
• I agree to follow Nextcloud's Code of Conduct.

Bug description

I am trying to upgrade from version 30.0.6.2 to 31.0.0, but that fails (tried two installations now) with:

"user":"admin","app":"core","method":"GET","url":"/nextcloud/","message":"An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown>
{"reqId":"evzts5qz3GwxexxtwOuq","level":3,"time":"2025-02-25T13:20:38+00:00","remoteAddr":"95.90.255.148","user":"admin","app":"core","method":"GET","url":"/nextcloud/","message":"An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'type' in 'field list'"

... then this same message appears lot of times in that very same logfile line(s) from different modules/libs and ends with:

.../nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":130}}},"message":"An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'type' in 'field list'","exception":{},"CustomMessage":"An exception occurred while executing a query:: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'type' in 'field list'"}}

Steps to reproduce

see above.

Expected behavior

A successful upgrade.

Nextcloud Server version

31

Operating system

Debian/Ubuntu

PHP engine version

PHP 8.3

Web server

Apache (supported)

Database engine version

MariaDB

Is this bug present after an update or on a fresh install?

None

Are you using the Nextcloud Server Encryption module?

None

What user-backends are you using?

• Default user-backend (database)
• LDAP/ Active Directory
• SSO - SAML
• Other

Configuration report

{
    "system": {
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "www.masters-of-cloud.de",
            "www.masters-of-cloud.de:443"
        ],
        "memcache.local": "\\OC\\Memcache\\Redis",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "memcache.distributed": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 6379
        },
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "30.0.6.2",
        "overwrite.cli.url": "https:\/\/www.domain.de\/nextcloud",
        "overwriteprotocol": "https",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "maintenance": false,
        "has_rebuilt_cache": true,
        "mail_smtpmode": "sendmail",
        "mail_sendmailmode": "smtp",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "theme": "",
        "loglevel": 2,
        "preview_max_x": 2048,
        "preview_max_y": 2048,
        "jpeg_quality": 60,
        "default_language": "de",
        "default_phone_region": "DE",
        "default_locale": "de_DE",
        "trusted_proxies": "***REMOVED SENSITIVE VALUE***",
        "app_install_overwrite": [
            "joplin",
            "carnet"
        ],
        "updater.release.channel": "stable",
        "maintenance_window_start": 1,
        "memories.db.triggers.fcu": true,
        "memories.exiftool": "\/var\/www\/domain.de\/nextcloud\/apps\/memories\/bin-ext\/exiftool-amd64-glibc",
        "memories.vod.path": "\/var\/www\/domain.de\/nextcloud\/apps\/memories\/bin-ext\/go-vod-amd64",
        "updater.secret": "***REMOVED SENSITIVE VALUE***"
    }
}

List of activated Apps

Enabled:
  - activity: 3.0.0
  - app_api: 4.0.6
  - audioplayer: 3.4.1
  - bruteforcesettings: 3.0.0
  - calendar: 5.1.0
  - carnet: 0.25.6
  - circles: 30.0.0
  - cloud_federation_api: 1.13.0
  - comments: 1.20.1
  - contacts: 7.0.0
  - contactsinteraction: 1.11.0
  - cospend: 3.0.11
  - dashboard: 7.10.0
  - dav: 1.31.1
  - federatedfilesharing: 1.20.0
  - federation: 1.20.0
  - files: 2.2.0
  - files_downloadlimit: 3.0.0
  - files_external: 1.22.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: 5.0.0
  - integration_openai: 3.4.0
  - logreader: 3.0.0
  - lookup_server_connector: 1.18.0
  - mail: 4.2.1
  - notes: 4.11.0
  - notifications: 3.0.0
  - notify_push: 1.0.0
  - oauth2: 1.18.1
  - password_policy: 2.0.0
  - photos: 3.0.2
  - polls: 7.3.1
  - privacy: 2.0.0
  - provisioning_api: 1.20.0
  - recommendations: 3.0.0
  - related_resources: 1.5.0
  - richdocuments: 8.5.3
  - serverinfo: 2.0.0
  - settings: 1.13.0
  - sharebymail: 1.20.0
  - spreed: 20.1.4
  - support: 2.0.0
  - survey_client: 2.0.0
  - systemtags: 1.20.0
  - text: 4.1.0
  - theming: 2.6.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
  - workflowengine: 2.12.0
Disabled:
  - admin_audit: 1.20.0
  - cms_pico: 1.1.0-beta.1 (installed 1.0.21)
  - encryption: 2.18.0
  - files_fulltextsearch: 30.0.0 (installed 30.0.0)
  - files_fulltextsearch_tesseract: 27.0.0 (installed 27.0.0)
  - files_markdown: 2.4.1 (installed 2.4.1)
  - files_retention: 1.19.0 (installed 1.19.0)
  - files_rightclick: 0.15.1 (installed 1.6.0)
  - fulltextsearch: 30.0.0 (installed 30.0.0)
  - fulltextsearch_elasticsearch: 30.0.0 (installed 30.0.0)
  - memories: 7.4.1 (installed 7.4.1)
  - nextcloud_announcements: 2.0.0 (installed 1.7.0)
  - phonetrack: 0.8.2 (installed 0.8.2)
  - suspicious_login: 8.0.0
  - tasks: 0.16.1 (installed 0.16.1)
  - twofactor_nextcloud_notification: 4.0.0
  - twofactor_totp: 12.0.0-dev
  - user_ldap: 1.21.0

Nextcloud Signing status

Nextcloud Logs

Additional info

No response

[joshtrichards]

... then this same message appears lot of times in that very same logfile line(s) from different modules/libs and ends with:

Can you provide the full raw log entry?

[mistersixt]

Please see attached the updater.log and some lines with this "1054 Unknown" thing.

nextcloud.log
updater.log

[joshtrichards]

Finishing the upgrade from the command line (via occ upgrade) may work around what you're encountering.

The type column is a new one in e the preferences table for v31. And it looks like loadConfig() is trying to use it on the web upgrader page before the db migrations have happened.

server/lib/private/Config/UserConfig.php

Line 1671 in 9682ef7

$qb->select('appid', 'configkey', 'configvalue', 'type', 'flags');

EDIT: May be related:

• IUserConfig #47658 (comment)
• IUserConfig #47658 (comment)
• fix(userconfig): incrementing version to trigger migration #49376

Cc: @ArtificialOwl & @nickvergessen

[ArtificialOwl]

@mistersixt
I cannot reproduce the issue myself. Is your instance still in this state ? Would you be kind to contact me on maxence@nextcloud.com with the address of your nextcloud ?

Have you done any upgrade between nc30 to nc31 using pre-release package before the release of 31 ?