-
-
Notifications
You must be signed in to change notification settings - Fork 4.1k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Relation does not exist #11085
Comments
GitMate.io thinks possibly related issues are #6054 (OCP\AppFramework\QueryException: Could not resolve OCA\BruteForceSettings\Settings\IPWhitelist! Class OCA\BruteForceSettings\Settings\IPWhitelist does not exist), #2733 (Class CardDavBackend does not exist after upgrade to NC11), #10446 (Unable to unshare link if ldap user does not exist anymore), #8402 (Error app in context "username"doesn't exist, can't verify user data.), and #9761 (No new encryption key is being created when old one exists but password does not match). |
Are there any news on this? I'm experiencing the exact same issue here on Arch Linux while trying to setup an instance from scratch with PostgreSQL as well. I haven't had this problem in with a previous installation with the same versions which had it's database migrated from an old installation but I'm setting up a new instance now and it seems the new version of Nextcloud isn't capable of initializing itself. |
I can reproduce this issue when I try to run the installer and config.php with installed => true already exist. Is there a config.php in config/? |
Of course. BTW, I've tried to setup my instance with MySQL as well and I get exactly the same errors. |
Yes. |
Thank you so much @danielkesselberg , that worked! |
Steps to reproduce
Follow installation instructions
php occ maintenance:install --database"pgsql" --database-name "nextcloud" --database-user "root" --database-pass"" --admin-user "admin" --admin-pass ""
Expected behaviour
Tell us what should happen
the command should complete
Actual behaviour
Tell us what happens instead
An unhandled exception has been thrown:
PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "oc_appconfig" does not exist
LINE 1: SELECT * FROM "oc_appconfig"
^ in /var/www/gentooserver/htdocs/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104
Stack trace:
#0 /var/www/gentooserver/htdocs/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(104): PDO->query('SELECT * FROM "...')
#1 /var/www/gentooserver/htdocs/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(852): Doctrine\DBAL\Driver\PDOConnection->query('SELECT * FROM "...')
#2 /var/www/gentooserver/htdocs/nextcloud/lib/private/DB/Connection.php(195): Doctrine\DBAL\Connection->executeQuery('SELECT * FROM "...', Array, Array, NULL)
#3 /var/www/gentooserver/htdocs/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): OC\DB\Connection->executeQuery('SELECT * FROM "...', Array, Array)
#4 /var/www/gentooserver/htdocs/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(214): Doctrine\DBAL\Query\QueryBuilder->execute()
#5 /var/www/gentooserver/htdocs/nextcloud/lib/private/AppConfig.php(320): OC\DB\QueryBuilder\QueryBuilder->execute()
#6 /var/www/gentooserver/htdocs/nextcloud/lib/private/AppConfig.php(94): OC\AppConfig->loadConfigValues()
#7 /var/www/gentooserver/htdocs/nextcloud/lib/private/AppConfig.php(277): OC\AppConfig->getApps()
#8 /var/www/gentooserver/htdocs/nextcloud/lib/private/legacy/app.php(964): OC\AppConfig->getValues(false, 'installed_versi...')
#9 /var/www/gentooserver/htdocs/nextcloud/lib/private/Server.php(494): OC_App::getAppVersions()
#10 /var/www/gentooserver/htdocs/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC{closure}(Object(OC\Server))
#11 /var/www/gentooserver/htdocs/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('OC\Memcache\Fac...')
#12 /var/www/gentooserver/htdocs/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OC\Memcache\Fac...')
#13 /var/www/gentooserver/htdocs/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(164): OC\ServerContainer->query('OC\Memcache\Fac...')
#14 /var/www/gentooserver/htdocs/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(109): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}(Object(OC\Server))
#15 /var/www/gentooserver/htdocs/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('MemCacheFactory')
#16 /var/www/gentooserver/htdocs/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('MemCacheFactory')
#17 /var/www/gentooserver/htdocs/nextcloud/lib/private/Server.php(1492): OC\ServerContainer->query('MemCacheFactory')
#18 /var/www/gentooserver/htdocs/nextcloud/lib/private/Server.php(691): OC\Server->getMemCacheFactory()
#19 /var/www/gentooserver/htdocs/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC{closure}(Object(OC\Server))
#20 /var/www/gentooserver/htdocs/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('OC\App\AppManag...')
#21 /var/www/gentooserver/htdocs/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OC\App\AppManag...')
#22 /var/www/gentooserver/htdocs/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(164): OC\ServerContainer->query('OC\App\AppManag...')
#23 /var/www/gentooserver/htdocs/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(109): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}(Object(OC\Server))
#24 /var/www/gentooserver/htdocs/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('AppManager')
#25 /var/www/gentooserver/htdocs/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('AppManager')
#26 /var/www/gentooserver/htdocs/nextcloud/lib/private/Server.php(1684): OC\ServerContainer->query('AppManager')
#27 /var/www/gentooserver/htdocs/nextcloud/lib/private/legacy/app.php(332): OC\Server->getAppManager()
#28 /var/www/gentooserver/htdocs/nextcloud/lib/private/legacy/app.php(113): OC_App::getEnabledApps()
#29 /var/www/gentooserver/htdocs/nextcloud/lib/base.php(662): OC_App::loadApps(Array)
#30 /var/www/gentooserver/htdocs/nextcloud/lib/base.php(1081): OC::init()
#31 /var/www/gentooserver/htdocs/nextcloud/console.php(46): require_once('/var/www/gentoo...')
#32 /var/www/gentooserver/htdocs/nextcloud/occ(11): require_once('/var/www/gentoo...')
#33 {main}
Next Doctrine\DBAL\Driver\PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "oc_appconfig" does not exist
LINE 1: SELECT * FROM "oc_appconfig"
^ in /var/www/gentooserver/htdocs/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:106
Stack trace:
#0 /var/www/gentooserver/htdocs/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(852): Doctrine\DBAL\Driver\PDOConnection->query('SELECT * FROM "...')
#1 /var/www/gentooserver/htdocs/nextcloud/lib/private/DB/Connection.php(195): Doctrine\DBAL\Connection->executeQuery('SELECT * FROM "...', Array, Array, NULL)
#2 /var/www/gentooserver/htdocs/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): OC\DB\Connection->executeQuery('SELECT * FROM "...', Array, Array)
#3 /var/www/gentooserver/htdocs/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(214): Doctrine\DBAL\Query\QueryBuilder->execute()
#4 /var/www/gentooserver/htdocs/nextcloud/lib/private/AppConfig.php(320): OC\DB\QueryBuilder\QueryBuilder->execute()
#5 /var/www/gentooserver/htdocs/nextcloud/lib/private/AppConfig.php(94): OC\AppConfig->loadConfigValues()
#6 /var/www/gentooserver/htdocs/nextcloud/lib/private/AppConfig.php(277): OC\AppConfig->getApps()
#7 /var/www/gentooserver/htdocs/nextcloud/lib/private/legacy/app.php(964): OC\AppConfig->getValues(false, 'installed_versi...')
#8 /var/www/gentooserver/htdocs/nextcloud/lib/private/Server.php(494): OC_App::getAppVersions()
#9 /var/www/gentooserver/htdocs/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC{closure}(Object(OC\Server))
#10 /var/www/gentooserver/htdocs/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('OC\Memcache\Fac...')
#11 /var/www/gentooserver/htdocs/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OC\Memcache\Fac...')
#12 /var/www/gentooserver/htdocs/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(164): OC\ServerContainer->query('OC\Memcache\Fac...')
#13 /var/www/gentooserver/htdocs/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(109): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}(Object(OC\Server))
#14 /var/www/gentooserver/htdocs/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('MemCacheFactory')
#15 /var/www/gentooserver/htdocs/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('MemCacheFactory')
#16 /var/www/gentooserver/htdocs/nextcloud/lib/private/Server.php(1492): OC\ServerContainer->query('MemCacheFactory')
#17 /var/www/gentooserver/htdocs/nextcloud/lib/private/Server.php(691): OC\Server->getMemCacheFactory()
#18 /var/www/gentooserver/htdocs/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC{closure}(Object(OC\Server))
#19 /var/www/gentooserver/htdocs/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('OC\App\AppManag...')
#20 /var/www/gentooserver/htdocs/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OC\App\AppManag...')
#21 /var/www/gentooserver/htdocs/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(164): OC\ServerContainer->query('OC\App\AppManag...')
#22 /var/www/gentooserver/htdocs/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(109): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}(Object(OC\Server))
#23 /var/www/gentooserver/htdocs/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('AppManager')
#24 /var/www/gentooserver/htdocs/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('AppManager')
#25 /var/www/gentooserver/htdocs/nextcloud/lib/private/Server.php(1684): OC\ServerContainer->query('AppManager')
#26 /var/www/gentooserver/htdocs/nextcloud/lib/private/legacy/app.php(332): OC\Server->getAppManager()
#27 /var/www/gentooserver/htdocs/nextcloud/lib/private/legacy/app.php(113): OC_App::getEnabledApps()
#28 /var/www/gentooserver/htdocs/nextcloud/lib/base.php(662): OC_App::loadApps(Array)
#29 /var/www/gentooserver/htdocs/nextcloud/lib/base.php(1081): OC::init()
#30 /var/www/gentooserver/htdocs/nextcloud/console.php(46): require_once('/var/www/gentoo...')
#31 /var/www/gentooserver/htdocs/nextcloud/occ(11): require_once('/var/www/gentoo...')
#32 {main}
Next Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing 'SELECT * FROM "oc_appconfig"':
SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "oc_appconfig" does not exist
LINE 1: SELECT * FROM "oc_appconfig"
^ in /var/www/gentooserver/htdocs/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php:76
Stack trace:
#0 /var/www/gentooserver/htdocs/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(128): Doctrine\DBAL\Driver\AbstractPostgreSQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException))
#1 /var/www/gentooserver/htdocs/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(855): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOPgSql\Driver), Object(Doctrine\DBAL\Driver\PDOException), 'SELECT * FROM "...', Array)
#2 /var/www/gentooserver/htdocs/nextcloud/lib/private/DB/Connection.php(195): Doctrine\DBAL\Connection->executeQuery('SELECT * FROM "...', Array, Array, NULL)
#3 /var/www/gentooserver/htdocs/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): OC\DB\Connection->executeQuery('SELECT * FROM "...', Array, Array)
#4 /var/www/gentooserver/htdocs/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(214): Doctrine\DBAL\Query\QueryBuilder->execute()
#5 /var/www/gentooserver/htdocs/nextcloud/lib/private/AppConfig.php(320): OC\DB\QueryBuilder\QueryBuilder->execute()
#6 /var/www/gentooserver/htdocs/nextcloud/lib/private/AppConfig.php(94): OC\AppConfig->loadConfigValues()
#7 /var/www/gentooserver/htdocs/nextcloud/lib/private/AppConfig.php(277): OC\AppConfig->getApps()
#8 /var/www/gentooserver/htdocs/nextcloud/lib/private/legacy/app.php(964): OC\AppConfig->getValues(false, 'installed_versi...')
#9 /var/www/gentooserver/htdocs/nextcloud/lib/private/Server.php(494): OC_App::getAppVersions()
#10 /var/www/gentooserver/htdocs/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC{closure}(Object(OC\Server))
#11 /var/www/gentooserver/htdocs/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('OC\Memcache\Fac...')
#12 /var/www/gentooserver/htdocs/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OC\Memcache\Fac...')
#13 /var/www/gentooserver/htdocs/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(164): OC\ServerContainer->query('OC\Memcache\Fac...')
#14 /var/www/gentooserver/htdocs/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(109): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}(Object(OC\Server))
#15 /var/www/gentooserver/htdocs/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('MemCacheFactory')
#16 /var/www/gentooserver/htdocs/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('MemCacheFactory')
#17 /var/www/gentooserver/htdocs/nextcloud/lib/private/Server.php(1492): OC\ServerContainer->query('MemCacheFactory')
#18 /var/www/gentooserver/htdocs/nextcloud/lib/private/Server.php(691): OC\Server->getMemCacheFactory()
#19 /var/www/gentooserver/htdocs/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC{closure}(Object(OC\Server))
#20 /var/www/gentooserver/htdocs/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('OC\App\AppManag...')
#21 /var/www/gentooserver/htdocs/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OC\App\AppManag...')
#22 /var/www/gentooserver/htdocs/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(164): OC\ServerContainer->query('OC\App\AppManag...')
#23 /var/www/gentooserver/htdocs/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(109): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}(Object(OC\Server))
#24 /var/www/gentooserver/htdocs/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('AppManager')
#25 /var/www/gentooserver/htdocs/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('AppManager')
#26 /var/www/gentooserver/htdocs/nextcloud/lib/private/Server.php(1684): OC\ServerContainer->query('AppManager')
#27 /var/www/gentooserver/htdocs/nextcloud/lib/private/legacy/app.php(332): OC\Server->getAppManager()
#28 /var/www/gentooserver/htdocs/nextcloud/lib/private/legacy/app.php(113): OC_App::getEnabledApps()
#29 /var/www/gentooserver/htdocs/nextcloud/lib/base.php(662): OC_App::loadApps(Array)
#30 /var/www/gentooserver/htdocs/nextcloud/lib/base.php(1081): OC::init()
#31 /var/www/gentooserver/htdocs/nextcloud/console.php(46): require_once('/var/www/gentoo...')
#32 /var/www/gentooserver/htdocs/nextcloud/occ(11): require_once('/var/www/gentoo...')
#33 {main}
Server configuration
Operating system: Gentoo Linux
Web server: apache-2.4.34-r2
Database: postgresql-10.5
PHP version: php-7.1.18
Nextcloud version: (see Nextcloud admin page) nextcloud-13.0.2
Updated from an older Nextcloud/ownCloud or fresh install: fresh
Where did you install Nextcloud from: portage
Signing status:
Signing status
List of activated apps:
App list
Nextcloud configuration:
Config report
Are you using external storage, if yes which one: local/smb/sftp/...
no
Are you using encryption: yes/no
no
Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/...
no
Client configuration
Browser:
chromium
Operating system:
gentoo
Logs
Web server error log
Web server error log
Nextcloud log (data/nextcloud.log)
Nextcloud log
Browser log
Browser log
The text was updated successfully, but these errors were encountered: