I tried to migrate my psql database to a new server, after that not even going back to the old database instance seems to work.
When I bring up the docker container and log into it, everytime I execute php occ I get An exception occurred while executing ‘SELECT * FROM “appconfig”’.
The table appconfig does not exist in the database, oc_appconfig does however. The config file includes dbtableprefix => ‘oc_’.
I don’t know where to go from this.
Steps to reproduce
- docker-compose up -d
- docker-compose exec owncloud bash
- php occ status
Expected behaviour
Get the status from owncloud
Actual behaviour
An unhandled exception has been thrown:
PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation “appconfig” does not exist
LINE 1: SELECT * FROM “appconfig”
^ in /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:88
Stack trace:
#0 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(88): PDO->query(‘SELECT * FROM "…’)
#1 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(910): Doctrine\DBAL\Driver\PDOConnection->query(‘SELECT * FROM "…’)
#2 /var/www/owncloud/lib/private/DB/Connection.php(187): Doctrine\DBAL\Connection->executeQuery(‘SELECT * FROM "…’, Array, Array, NULL)
#3 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(200): OC\DB\Connection->executeQuery(‘SELECT * FROM "…’, Array, Array)
#4 /var/www/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php(141): Doctrine\DBAL\Query\QueryBuilder->execute()
#5 /var/www/owncloud/lib/private/AppConfig.php(301): OC\DB\QueryBuilder\QueryBuilder->execute()
#6 /var/www/owncloud/lib/private/AppConfig.php(80): OC\AppConfig->loadConfigValues()
#7 /var/www/owncloud/lib/private/AppConfig.php(278): OC\AppConfig->getApps()
#8 /var/www/owncloud/lib/private/legacy/app.php(948): OC\AppConfig->getValues(false, ‘installed_versi…’)
#9 /var/www/owncloud/lib/private/Server.php(439): OC_App::getAppVersions()
#10 /var/www/owncloud/lib/composer/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC{closure}(Object(OC\Server))
#11 /var/www/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(108): Pimple\Container->offsetGet(‘MemCacheFactory’)
#12 /var/www/owncloud/lib/private/ServerContainer.php(86): OC\AppFramework\Utility\SimpleContainer->query(‘MemCacheFactory’)
#13 /var/www/owncloud/lib/private/Server.php(1203): OC\ServerContainer->query(‘MemCacheFactory’)
#14 /var/www/owncloud/lib/private/Server.php(598): OC\Server->getMemCacheFactory()
#15 /var/www/owncloud/lib/composer/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC{closure}(Object(OC\Server))
#16 /var/www/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(108): Pimple\Container->offsetGet(‘AppManager’)
#17 /var/www/owncloud/lib/private/ServerContainer.php(86): OC\AppFramework\Utility\SimpleContainer->query(‘AppManager’)
#18 /var/www/owncloud/lib/private/Server.php(1419): OC\ServerContainer->query(‘AppManager’)
#19 /var/www/owncloud/lib/private/legacy/app.php(343): OC\Server->getAppManager()
#20 /var/www/owncloud/lib/private/legacy/app.php(107): OC_App::getEnabledApps()
#21 /var/www/owncloud/lib/base.php(585): OC_App::loadApps(Array)
#22 /var/www/owncloud/lib/base.php(1059): OC::init()
#23 /var/www/owncloud/console.php(74): require_once(’/var/www/ownclo…’)
#24 /var/www/owncloud/occ(11): require_once(’/var/www/ownclo…’)
#25 {main}
Server configuration
Operating system: Ubuntu 20.04
Web server:
Database: Postgresql
PHP version: 7.3.11
ownCloud version: 10.4
The content of config/config.php:
<?php $CONFIG = array ( 'apps_paths' => array ( 0 => array ( 'path' => '/var/www/owncloud/apps', 'url' => '/apps', 'writable' => false, ), 1 => array ( 'path' => '/var/www/owncloud/custom', 'url' => '/custom', 'writable' => true, ), ), 'trusted_domains' => array ( 0 => 'localhost', ), 'datadirectory' => '/mnt/data', 'dbtype' => 'pgsql', 'dbhost' => '192.168.1.8:5432', 'dbname' => 'ownclouddb', 'dbuser' => 'ownclouduser', 'dbpassword' => # Removed 'dbtableprefix' => 'oc_', 'log_type' => 'owncloud', 'supportedDatabases' => array ( 0 => 'sqlite', 1 => 'mysql', 2 => 'pgsql', ), 'upgrade.disable-web' => true, 'default_language' => 'en', 'overwrite.cli.url' => 'htaccess.RewriteBase' => '/', 'logfile' => '/mnt/data/owncloud.log', 'loglevel' => 2, 'memcache.local' => '\\OC\\Memcache\\APCu', 'mysql.utf8mb4' => true, 'filelocking.enabled' => true, 'memcache.distributed' => '\\OC\\Memcache\\Redis', 'memcache.locking' => '\\OC\\Memcache\\Redis', 'redis' => array ( 'host' => 'redis', 'port' => '6379', ), 'passwordsalt' => # Removed 'secret' => '', # Removed 'version' => '10.4.1.3', 'logtimezone' => 'UTC', 'installed' => true, 'instanceid' => 'oct08v6ptu6q', );