[BUG]: Upgrading from 30.0.4 to 30.0.6 nextcloud - An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1932 Table 'nextcloud.oc_news_items' doesn't exist in engine

[FungY911]

⚠️ 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

Debug: Preparing update

Set log level to debug

Turned on maintenance mode

Repair step: Repair MySQL collation

Repair info: All tables already have the correct collation -> nothing to do

Repair step: Copy data from accounts table when migrating from ownCloud

Repair step: Drop account terms table when migrating from ownCloud

Updating database schema

Updated database

Exception: Database error when running migration 4000Date20250109163840 for app app_api An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1932 Table 'nextcloud.oc_news_items' doesn't exist in engine

Steps to reproduce

Expected behavior

Run upgrade smoothly

Nextcloud Server version

30

Operating system

Debian/Ubuntu

PHP engine version

PHP 8.2

Web server

Nginx

Database engine version

MariaDB

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

Updated from a MINOR version (ex. 32.0.1 to 32.0.2)

Are you using the Nextcloud Server Encryption module?

Encryption is Disabled

What user-backends are you using?

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

Configuration report

{
    "system": {
        "debug": false,
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "default_phone_region": "SK",
        "memcache.local": "\\OC\\Memcache\\Redis",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 6379,
            "timeout": 0
        },
        "trusted_domains": [
            "comp.local",
            "pcloud.mpatrik.eu"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "30.0.4.1",
        "overwrite.cli.url": "https:\/\/mycloud.mydomain.eu",
        "overwriteprotocol": "https",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "cron_log": true,
        "maintenance_window_start": "02:00",
        "maintenance_window_end": "04:00",
        "installed": true,
        "maintenance": false,
        "mail_smtpmode": "smtp",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_sendmailmode": "smtp",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "587",
        "mail_smtpauth": 1,
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "app_install_overwrite": [
            "files_rightclick"
        ],
        "defaultapp": "",
        "updater.secret": "***REMOVED SENSITIVE VALUE***",
        "theme": "",
        "loglevel": 2
    }
}

List of activated Apps

Nextcloud Signing status

Nextcloud Logs

Additional info

No response

[FungY911]

Activated Apps:
Enabled:

• activity: 3.0.0
• app_api: 4.0.3
• bruteforcesettings: 3.0.0
• camerarawpreviews: 0.8.6
• circles: 30.0.0
• cloud_federation_api: 1.13.0
• comments: 1.20.1
• contactsinteraction: 1.11.0
• dashboard: 7.10.0
• dav: 1.31.1
• federatedfilesharing: 1.20.0
• federation: 1.20.0
• files: 2.2.0
• files_downloadactivity: 1.17.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
• logreader: 3.0.0
• lookup_server_connector: 1.18.0
• metadata: 0.21.0
• nextcloud_announcements: 2.0.0
• notifications: 3.0.0
• oauth2: 1.18.1
• password_policy: 2.0.0
• photos: 3.0.2
• previewgenerator: 5.8.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
• 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
• encryption: 2.18.0
• files_external: 1.22.0
• files_markdown: 2.4.1
• files_rightclick: 0.15.1 (installed 0.15.1)
• imageconverter: 2.0.4
• mail: 4.2.0
• multiboards: 1.0.4
• news: 25.2.1
• suspicious_login: 8.0.0
• twofactor_nextcloud_notification: 4.0.0
• twofactor_totp: 12.0.0-dev
• user_ldap: 1.21.0

[joshtrichards]

An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1932 Table 'nextcloud.oc_news_items' doesn't exist in engine

The error is coming from a table used by the News app. It suggests the table was removed (perhaps manually).

This might be helpful: https://github.com/nextcloud/news/blob/master/docs/install.md#uninstall-with-cleanup

Beyond that I would suggest troubleshooting on the help forum (https://help.nextcloud.com) since this is not a bug in Server.