Hi all,
I need help to troubleshoot or directly fix an issue with my database. After upgrading my installation to the latest version (25.0.1), I got this “warning/error” after running the UPDATE process:
Repair warning: Failed to delete folder: "13", error: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nxc_database1810.photos_albums' doesn't exist
Repair warning: Failed to delete folder: "images", error: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nxc_database1810.photos_albums' doesn't exist
Is there a way to add missing tables like the occ db:add-missing-indices
!? or where can I find the cross-reverence? Is this some stale config/data from a plugIn or so?
Nextcloud version (eg, 20.0.5): 25.0.1
Operating system and version (eg, Ubuntu 20.04): docker based on 8.0-apache-buster running on DSM 6.2.4
Apache or nginx version (eg, Apache 2.4.25): based on 8.0-apache-buster
PHP version (eg, 7.4): based on 8.0-apache-buster
The issue you are facing:
I am not sure if this is an actual issue or if I can ignore it. But it would be great if I can get to an “issue-free” installation, not reporting issues like this.
Is this the first time you’ve seen this error? (Y/N): Yes… I guess. I have seen it the first time at least…
Steps to replicate it:
- run update to next minor version
The output of your Nextcloud log in Admin > Logging:
## output disappears after one second.... What should I look for? I need to hack into the logs from the CLI if needed.
The output of your config.php file in /path/to/nextcloud
(make sure you remove any identifiable information!):
<?php
$CONFIG = array (
'htaccess.RewriteBase' => '/',
'memcache.local' => '\\OC\\Memcache\\APCu',
'apps_paths' =>
array (
0 =>
array (
'path' => '/var/www/html/apps',
'url' => '/apps',
'writable' => false,
),
1 =>
array (
'path' => '/var/www/html/custom_apps',
'url' => '/custom_apps',
'writable' => true,
),
),
'forcessl' => true,
'overwriteprotocol' => 'https',
'instanceid' => '#########',
'passwordsalt' => '########################',
'secret' => '#################################################',
'default_phone_region' => 'DE',
'trusted_domains' =>
array (
0 => '172.##.##.###',
1 => '#######.###########.de',
2 => 'localhost',
),
'datadirectory' => '/var/www/html/data',
'dbtype' => 'mysql',
'version' => '23.0.11.1',
'overwrite.cli.url' => 'http://172.##.##.###:2080',
'dbname' => 'nxc_database1810',
'dbhost' => '172.##.##.###:3307',
'dbport' => '',
'dbtableprefix' => '',
'dbuser' => '##########',
'dbpassword' => '###############',
'installed' => true,
'mail_from_address' => 'nextcloud',
'mail_smtpmode' => 'smtp',
'mail_smtpauthtype' => 'LOGIN',
'mail_domain' => '##########.de',
'mail_smtpauth' => 1,
'mail_smtphost' => 'smtp.#######.de',
'mail_smtpport' => '465',
'mail_smtpname' => '#######@###########.de',
'mail_smtppassword' => '###########',
'mail_smtpsecure' => 'ssl',
'updater.secret' => '#######################################################',
'loglevel' => 0,
'maintenance' => false,
'mysql.utf8mb4' => true,
'theme' => '',
'app_install_overwrite' =>
array (
0 => 'occweb',
),
'has_rebuilt_cache' => true,
'ldapProviderFactory' => 'OCA\\User_LDAP\\LDAPProviderFactory',
);
Portainer config file:
services:
nextcloud:
image: mynextcloud:25.0.1.0
container_name: nextcloud
restart: always
ports:
- 2080:80
- 2443:443
volumes:
- /volume1/docker/nextcloud/nxc_www-main:/var/www/html
- /volume1/docker/nextcloud/nxc_themes:/var/www/html/themes
- /volume1/docker/nextcloud/nxc_data:/var/www/html/data
- /volume1/docker/nextcloud/nxc_custom_apps:/var/www/html/custom_apps
- /volume1/docker/nextcloud/nxc_config:/var/www/html/config
environment:
- MYSQL_PASSWORD=###############
- MYSQL_DATABASE=nxc_database1810
- MYSQL_USER=##########
- MYSQL_HOST=172.xx.xx.xxx:3307
- NEXTCLOUD_ADMIN_PASSWORD=###############
- NEXTCLOUD_ADMIN_USER=app########Admin