Nextcloud version (eg, 20.0.5): 27.1.4.1
Operating system and version (eg, Ubuntu 20.04): Unraid docker
Apache or nginx version (eg, Apache 2.4.25): ???
PHP version (eg, 7.4): ???
The issue you are facing:
I updated the dockers for Swag, MariaDB and Nextcloud and since then I’ve been stuck in maintenance mode with the below log:
I’ve tried to manually change the MaintenanceMode flag to false in the config.php file but on restarting Nextcloud it reverts back to true.
Restoring all three of the containers back to before the updates doesn’t help either.
Trying to run the “occ db:add-missing-indices” command produces the following:
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
Adding additional textstep_session index to the oc_text_steps table, this can take some time...
In ExceptionConverter.php line 117:
An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1932 Table 'nextcloud.oc_external_config' doesn't exist in engine
In Exception.php line 28:
SQLSTATE[42S02]: Base table or view not found: 1932 Table 'nextcloud.oc_external_config' doesn't exist in engine
In Connection.php line 71:
SQLSTATE[42S02]: Base table or view not found: 1932 Table 'nextcloud.oc_external_config' doesn't exist in engine
db:add-missing-indices [--dry-run]
Anyone have any suggestions?
Is this the first time you’ve seen this error? (Y/N): Y
The output of your Nextcloud log in Admin > Logging:
[migrations] started
[migrations] 01-nginx-site-confs-default: skipped
[migrations] 02-default-location: skipped
[migrations] done
usermod: no changes
───────────────────────────────────────
██╗ ███████╗██╗ ██████╗
██║ ██╔════╝██║██╔═══██╗
██║ ███████╗██║██║ ██║
██║ ╚════██║██║██║ ██║
███████╗███████║██║╚██████╔╝
╚══════╝╚══════╝╚═╝ ╚═════╝
Brought to you by linuxserver.io
───────────────────────────────────────
To support LSIO projects visit:
https://www.linuxserver.io/donate/
───────────────────────────────────────
GID/UID
───────────────────────────────────────
User UID: 99
User GID: 100
───────────────────────────────────────
using keys found in /config/keys
Initializing nextcloud 28.0.0.11 (this can take a while) ...
Upgrading nextcloud from 27.1.4.1 ...
Setting permissions
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
Updating database schema
Exception: Database error when running migration 28000Date20231103104802 for app core
An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1932 Table 'nextcloud.oc_external_config' doesn't exist in engine
Update failed
Maintenance mode is kept active
Resetting log level
Initializing finished
[custom-init] No custom files found, skipping...
[ls.io-init] done.
The output of your config.php file in /path/to/nextcloud
(make sure you remove any identifiable information!):
<?php
$CONFIG = array (
'memcache.local' => '\\OC\\Memcache\\APCu',
'datadirectory' => '/data',
'instanceid' => '###############',
'passwordsalt' => '################',
'secret' => '####################',
'trusted_domains' =>
array (
0 => '192.#############',
1 => 'nextcloud.############',
),
'trusted_proxies' =>
array (
0 => 'swag',
),
'dbtype' => 'mysql',
'version' => '27.1.4.1',
'overwrite.cli.url' => 'https://nextcloud.######',
'overwritehost' => 'nextcloud.###########',
'overwriteprotocol' => 'https',
'dbname' => 'nextcloud',
'dbhost' => '192.######',
'dbport' => '',
'dbtableprefix' => 'oc_',
'mysql.utf8mb4' => true,
'dbuser' => 'nextcloud',
'dbpassword' => '#########',
'installed' => true,
'maintenance' => true,
'default_phone_region' => 'GB',
'app_install_overwrite' =>
array (
0 => 'files_external_gdrive',
1 => 'files_external_onedrive',
2 => 'files_clipboard',
),
'mail_smtpmode' => 'smtp',
'mail_smtpsecure' => 'ssl',
'mail_sendmailmode' => 'smtp',
'mail_from_address' => '################',
'mail_domain' => 'gmail.com',
'mail_smtpauthtype' => 'LOGIN',
'mail_smtpauth' => 1,
'mail_smtphost' => 'smtp.gmail.com',
'mail_smtpport' => '465',
'mail_smtpname' => '############',
'mail_smtppassword' => '##########',
'theme' => '',
'loglevel' => 0,
'updater.release.channel' => 'stable',
'ldapProviderFactory' => 'OCA\\User_LDAP\\LDAPProviderFactory',
'filelocking.enabled' => 'true',
'memcache.locking' => '\\OC\\Memcache\\APCu',
'upgrade.disable-web' => true,
);
Sorry if this is a mess but I am very much a beginner with this. Any help would be hugely appreciated.