Error: Table 'nextcloud.oc_appconfig' doesn't exist

diplodata · July 4, 2018, 3:14pm

I am trying to configure latest verision Nextcloud 13 on a Ubuntu 16.04 Apache 2.4 AWS platform to work with an RDS database. The application server can access the database user via command mysql -u nextcloud_user -h <endpoint>rds.amazonaws.com --password=xxx. nextcloud is an existing database. User nextcloud_user has GRANT ALL ON nextcloud.* privileges.

When calling from browser Apache2 returns Internal Server Error. Full error log is below, but key line seems to me to be:

An exception occurred while executing 'SELECT * FROMoc_appconfig':\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_appconfig' doesn't exist

Very grateful for assistance. Do I need to create tables? I’ve looked but can’t find any references to the process here.

If it helps my config.php is detailed here.

Many thanks in advance.

Full error log:

[Wed Jul 04 14:53:25.332546 2018] [php7:warn] [pid 19663] [client 10.100.xxx.xxx:46518] PHP Warning:  fileperms(): stat failed for /var/www/nextcloud/data/nextcloud.log in /var/www/nextcloud/lib/private/Log/File.php on line 136
[Wed Jul 04 14:53:25.332564 2018] [php7:notice] [pid 19663] [client 10.100.xxx.xxx:46518] {"reqId":"K0ImofzZtSzHnX3vhgxP","level":3,"time":"2018-07-04T14:53:25+00:00","remoteAddr":"10.100.xxx.xxx","user":"--","app":"PHP","method":"GET","url":"/index.php","message":"fileperms(): stat failed for /var/www/nextcloud/data/nextcloud.log at /var/www/nextcloud/lib/private/Log/File.php#136","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36","version":""}
[Wed Jul 04 14:53:25.332575 2018] [php7:notice] [pid 19663] [client 10.100.xxx.xxx:46518] {"reqId":"K0ImofzZtSzHnX3vhgxP","level":3,"time":"2018-07-04T14:53:25+00:00","remoteAddr":"10.100.xxx.xxx","user":"--","app":"core","method":"GET","url":"/index.php","message":"Exception: {\"Exception\":\"Doctrine\DBAL\Exception\TableNotFoundException\",\"Message\":\"An exception occurred while executing 'SELECT * FROM `oc_appconfig`':\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_appconfig' doesn't exist\",\"Code\":0,\"Trace\":\"#0 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(128): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException))\n#1 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(855): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), 'SELECT * FROM `...', Array)\n#2 /var/www/nextcloud/lib/private/DB/Connection.php(195): Doctrine\DBAL\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\n#3 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): OC\DB\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(214): Doctrine\DBAL\Query\QueryBuilder->execute()\n#5 /var/www/nextcloud/lib/private/AppConfig.php(320): OC\DB\QueryBuilder\QueryBuilder->execute()\n#6 /var/www/nextcloud/lib/private/AppConfig.php(94): OC\AppConfig->loadConfigValues()\n#7 /var/www/nextcloud/lib/private/AppConfig.php(277): OC\AppConfig->getApps()\n#8 /var/www/nextcloud/lib/private/legacy/app.php(964): OC\AppConfig->getValues(false, 'installed_versi...')\n#9 /var/www/nextcloud/lib/private/Server.php(494): OC_App::getAppVersions()\n#10 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(*** sensitive parameters replaced ***)\n#11 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('OC\Memcache\Fac...')\n#12 /var/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OC\Memcache\Fac...')\n#13 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(164): OC\ServerContainer->query('OC\Memcache\Fac...')\n#14 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(109): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(*** sensitive parameters replaced ***)\n#15 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('MemCacheFactory')\n#16 /var/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('MemCacheFactory')\n#17 /var/www/nextcloud/lib/private/Server.php(1492): OC\ServerContainer->query('MemCacheFactory')\n#18 /var/www/nextcloud/lib/private/Server.php(691): OC\Server->getMemCacheFactory()\n#19 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(*** sensitive parameters replaced ***)\n#20 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('OC\App\AppManag...')\n#21 /var/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OC\App\AppManag...')\n#22 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(164): OC\ServerContainer->query('OC\App\AppManag...')\n#23 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(109): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(*** sensitive parameters replaced ***)\n#24 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('AppManager')\n#25 /var/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('AppManager')\n#26 /var/www/nextcloud/lib/private/Server.php(1684): OC\ServerContainer->query('AppManager')\n#27 /var/www/nextcloud/lib/private/legacy/app.php(332): OC\Server->getAppManager()\n#28 /var/www/nextcloud/lib/private/legacy/app.php(113): OC_App::getEnabledApps()\n#29 /var/www/nextcloud/lib/base.php(662): OC_App::loadApps(Array)\n#30 /var/www/nextcloud/lib/base.php(1081): OC::init()\n#31 /var/www/nextcloud/index.php(40): require_once('/var/www/nextcl...')\n#32 {main}\",\"File\":\"/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php\",\"Line\":53}","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36","version":""}
[Wed Jul 04 14:53:25.332767 2018] [php7:warn] [pid 19663] [client 10.100.xxx.xxx:46518] PHP Warning:  fileperms(): stat failed for /var/www/nextcloud/data/nextcloud.log in /var/www/nextcloud/lib/private/Log/File.php on line 136
[Wed Jul 04 14:53:25.332774 2018] [php7:notice] [pid 19663] [client 10.100.xxx.xxx:46518] {"reqId":"K0ImofzZtSzHnX3vhgxP","level":3,"time":"2018-07-04T14:53:25+00:00","remoteAddr":"10.100.xxx.xxx","user":"--","app":"PHP","method":"GET","url":"/index.php","message":"fileperms(): stat failed for /var/www/nextcloud/data/nextcloud.log at /var/www/nextcloud/lib/private/Log/File.php#136","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36","version":""}
[Wed Jul 04 14:53:25.332783 2018] [php7:notice] [pid 19663] [client 10.100.xxx.xxx:46518] {"reqId":"K0ImofzZtSzHnX3vhgxP","level":3,"time":"2018-07-04T14:53:25+00:00","remoteAddr":"10.100.xxx.xxx","user":"--","app":"core","method":"GET","url":"/index.php","message":"Exception: {\"Exception\":\"Doctrine\DBAL\Exception\TableNotFoundException\",\"Message\":\"An exception occurred while executing 'SELECT * FROM `oc_appconfig`':\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_appconfig' doesn't exist\",\"Code\":0,\"Trace\":\"#0 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(128): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException))\n#1 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(855): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), 'SELECT * FROM `...', Array)\n#2 /var/www/nextcloud/lib/private/DB/Connection.php(195): Doctrine\DBAL\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\n#3 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): OC\DB\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(214): Doctrine\DBAL\Query\QueryBuilder->execute()\n#5 /var/www/nextcloud/lib/private/AppConfig.php(320): OC\DB\QueryBuilder\QueryBuilder->execute()\n#6 /var/www/nextcloud/lib/private/AppConfig.php(94): OC\AppConfig->loadConfigValues()\n#7 /var/www/nextcloud/lib/private/AppConfig.php(277): OC\AppConfig->getApps()\n#8 /var/www/nextcloud/lib/private/legacy/app.php(964): OC\AppConfig->getValues(false, 'installed_versi...')\n#9 /var/www/nextcloud/lib/private/TemplateLayout.php(137): OC_App::getAppVersions()\n#10 /var/www/nextcloud/lib/private/legacy/template.php(207): OC\TemplateLayout->__construct('error', '')\n#11 /var/www/nextcloud/lib/private/Template/Base.php(132): OC_Template->fetchPage()\n#12 /var/www/nextcloud/lib/private/legacy/template.php(351): OC\Template\Base->printPage()\n#13 /var/www/nextcloud/index.php(70): OC_Template::printExceptionErrorPage(Object(Doctrine\DBAL\Exception\TableNotFoundException))\n#14 {main}\",\"File\":\"/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php\",\"Line\":53}","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36","version":""}
[Wed Jul 04 14:53:25.332918 2018] [php7:warn] [pid 19663] [client 10.100.xxx.xxx:46518] PHP Warning:  fileperms(): stat failed for /var/www/nextcloud/data/nextcloud.log in /var/www/nextcloud/lib/private/Log/File.php on line 136
[Wed Jul 04 14:53:25.332924 2018] [php7:notice] [pid 19663] [client 10.100.xxx.xxx:46518] {"reqId":"K0ImofzZtSzHnX3vhgxP","level":3,"time":"2018-07-04T14:53:25+00:00","remoteAddr":"10.100.xxx.xxx","user":"--","app":"PHP","method":"GET","url":"/index.php","message":"fileperms(): stat failed for /var/www/nextcloud/data/nextcloud.log at /var/www/nextcloud/lib/private/Log/File.php#136","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36","version":""}
[Wed Jul 04 14:53:25.332933 2018] [php7:notice] [pid 19663] [client 10.100.xxx.xxx:46518] {"reqId":"K0ImofzZtSzHnX3vhgxP","level":3,"time":"2018-07-04T14:53:25+00:00","remoteAddr":"10.100.xxx.xxx","user":"--","app":"PHP","method":"GET","url":"/index.php","message":"chmod(): No such file or directory at /var/www/nextcloud/lib/private/Log/File.php#137","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36","version":""}

diplodata · July 4, 2018, 9:03pm

A couple of issues needed resolving:

I had set up a /var/www/nextcloud/config/config.php file manually when this should be autogenerated. I removed this.
I had omitted to sudo chown -R www-data:www-data /var/www/nextcloud

Now up and running

Joon · July 26, 2021, 11:42am

Hi everybody,

I have the same problem, but unfortunately this solution doesn’t help. The internal error still exists. Does anyone have an idea? I`m researching the net since yesterday. Nothing helped. It occured after a backup trail with MariaDB dump.

Enviroment:
MariaDB: 10.5.11
nginx: 1.21.1
php :7.4
redis: 5:5.0.7-2
smbd: 4.11.6-Ubuntu
coturn: 4.5.1.1-1.1ubuntu0.20.04.2
status off all: active, without error messages

Nextcloud: 22.0.0.11

This message is shown, when putting the cloud into maintance mode:
Next Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘nextcloud_db.oc_appconfig’ doesn’t exist in /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:47
Stack trace:
#0 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1728): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
#1 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1667): Doctrine\DBAL\Connection->handleDriverException()
#2 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1040): Doctrine\DBAL\Connection->convertExceptionDuringQuery()
#3 /var/www/nextcloud/lib/private/DB/Connection.php(231): Doctrine\DBAL\Connection->executeQuery()
#4 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(210): OC\DB\Connection->executeQuery()
#5 /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(287): Doctrine\DBAL\Query\QueryBuilder->execute()
#6 /var/www/nextcloud/lib/private/AppConfig.php(344): OC\DB\QueryBuilder\QueryBuilder->execute()
#7 /var/www/nextcloud/lib/private/AppConfig.php(109): OC\AppConfig->loadConfigValues()
#8 /var/www/nextcloud/lib/private/AppConfig.php(300): OC\AppConfig->getApps()
#9 /var/www/nextcloud/lib/private/legacy/OC_App.php(961): OC\AppConfig->getValues()
#10 /var/www/nextcloud/lib/private/Server.php(685): OC_App::getAppVersions()
#11 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(160): OC\Server->OC{closure}()
#12 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}()
#13 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(127): Pimple\Container->offsetGet()
#14 /var/www/nextcloud/lib/private/ServerContainer.php(136): OC\AppFramework\Utility\SimpleContainer->query()
#15 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(56): OC\ServerContainer->query()
#16 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(182): OC\AppFramework\Utility\SimpleContainer->get()
#17 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(160): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}()
#18 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}()
#19 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(127): Pimple\Container->offsetGet()
#20 /var/www/nextcloud/lib/private/ServerContainer.php(136): OC\AppFramework\Utility\SimpleContainer->query()
#21 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(56): OC\ServerContainer->query()
#22 /var/www/nextcloud/lib/private/Server.php(1050): OC\AppFramework\Utility\SimpleContainer->get()
#23 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(160): OC\Server->OC{closure}()
#24 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}()
#25 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(127): Pimple\Container->offsetGet()
#26 /var/www/nextcloud/lib/private/ServerContainer.php(136): OC\AppFramework\Utility\SimpleContainer->query()
#27 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(56): OC\ServerContainer->query()
#28 /var/www/nextcloud/lib/private/Server.php(2010): OC\AppFramework\Utility\SimpleContainer->get()
#29 /var/www/nextcloud/lib/private/Files/View.php(118): OC\Server->getLockingProvider()
#30 /var/www/nextcloud/lib/private/Server.php(433): OC\Files\View->__construct()
#31 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(160): OC\Server->OC{closure}()
#32 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}()
#33 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(127): Pimple\Container->offsetGet()
#34 /var/www/nextcloud/lib/private/ServerContainer.php(136): OC\AppFramework\Utility\SimpleContainer->query()
#35 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(56): OC\ServerContainer->query()
#36 /var/www/nextcloud/lib/private/Server.php(1373): OC\AppFramework\Utility\SimpleContainer->get()
#37 /var/www/nextcloud/lib/base.php(594): OC\Server->boot()
#38 /var/www/nextcloud/lib/base.php(1083): OC::init()
#39 /var/www/nextcloud/console.php(48): require_once(’/var/www/nextcl…’)
#40 /var/www/nextcloud/occ(11): require_once(’/var/www/nextcl…’)

Does anymore have any idea?

Cheers Jo

ldc71 · November 26, 2021, 3:41pm

hi,
did you solve it?

Joon · November 27, 2021, 12:01pm

Yes, Mageunic found a solution.. In my case, I had to reinstall the link between nextcloud + MariaDB. As all was still under development, I did a complete reinstallation. But you also “only” can reconnect Nextcloud and DB.
Best Jo

ldc71 · December 1, 2021, 2:04pm

Hi Joon,
how are to reinstall the link between nextcloud + MariaDB.?
I am now install nextcloud on another virtual machine to export the database “nextcloud” since now it does not contain any table in the primary nextcloud and i don’t have backup the database.
regards

Joon · December 1, 2021, 2:38pm

Hi Idc71,
fortunately I had a system under development. So I created a new database in MariaDB and installed a complete new nextcloud. So I went through the comment process of registering the DB new. My problem was: Even if the database was there, Nextcloud couldn’t connect anymore due to this missing link. If you have the path to your DB and know where to implement it in Nextcloud, you don’t have to install Nextcloud new.
Anyway: you should: 1. have the DB + 2. link it to NC
Hope it works for you, best