Hello all, My nextcloud instance often gives me an internal server error when I try and log in. Looking at my logs, this is the error that repeatedly shows up. Can someone help me correct this?
Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing 'SELECTm.mount_id, mount_point, storage_backend, auth_backend, priority, m.typeFROMoc_external_mounts mINNER JOINoc_external_applicable aONm.mount_id=a.mount_id WHERE ((a.type = ?) AND (a.value IS NULL)) OR ((a.type = ?) AND (a.value = ?)) OR ((a.type = ?) AND (a.value IN (?)))' with params [1, 3, "nevo", 2, "admin"]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_external_mounts' doesn't exist
/snap/nextcloud/21422/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 169:
Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException("An exceptio ... t", Doctrine\DBA ... ]})
/snap/nextcloud/21422/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 145:
Doctrine\DBAL\DBALException::wrapException(Doctrine\DBA ... {}, Doctrine\DBA ... ]}, "An exceptio ... t")
/snap/nextcloud/21422/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 911:
Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBA ... {}, Doctrine\DBA ... ]}, "SELECT `m`. ... )", { 1: 1,2: 3, ... "})
/snap/nextcloud/21422/htdocs/lib/private/DB/Connection.php - line 195:
Doctrine\DBAL\Connection->executeQuery("SELECT `m`. ... )", [ 1,3,"nevo",2,"admin"], [ 1,1,2,1,2], null)
/snap/nextcloud/21422/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php - line 200:
OC\DB\Connection->executeQuery("SELECT `m`. ... )", { dcValue1: ... ]}, { dcValue1: ... 2})
/snap/nextcloud/21422/htdocs/lib/private/DB/QueryBuilder/QueryBuilder.php - line 214:
Doctrine\DBAL\Query\QueryBuilder->execute()
/snap/nextcloud/21422/htdocs/apps/files_external/lib/Service/DBConfigService.php - line 406:
OC\DB\QueryBuilder\QueryBuilder->execute()
/snap/nextcloud/21422/htdocs/apps/files_external/lib/Service/DBConfigService.php - line 114:
OCA\Files_External\Service\DBConfigService->getMountsFromQuery(OC\DB\QueryB ... {})
/snap/nextcloud/21422/htdocs/apps/files_external/lib/Service/UserGlobalStoragesService.php - line 187:
OCA\Files_External\Service\DBConfigService->getMountsForUser("nevo", [ "admin"])
/snap/nextcloud/21422/htdocs/apps/files_external/lib/Config/ConfigAdapter.php - line 125:
OCA\Files_External\Service\UserGlobalStoragesService->getAllStoragesForUser()
/snap/nextcloud/21422/htdocs/lib/private/Files/Filesystem.php - line 479:
OCA\Files_External\Config\ConfigAdapter->getMountsForUser(OC\User\User {}, OC\Files\Sto ... {})
<<closure>>
OC\Files\Filesystem::OC\Files\{closure}("*** sensiti ... *")
/snap/nextcloud/21422/htdocs/lib/private/Hooks/EmitterTrait.php - line 99:
call_user_func_array(Closure {}, [ "*** sensi ... "])
/snap/nextcloud/21422/htdocs/lib/private/Files/Config/MountProviderCollection.php - line 152:
OC\Files\Config\MountProviderCollection->emit("\\OC\\Files\\Config", "registerMountProvider", [ "*** sensi ... "])
/snap/nextcloud/21422/htdocs/apps/files_external/appinfo/app.php - line 53:
OC\Files\Config\MountProviderCollection->registerProvider("*** sensiti ... *")
/snap/nextcloud/21422/htdocs/lib/private/legacy/app.php - line 265:
require_once("/snap/nextc ... p")
/snap/nextcloud/21422/htdocs/lib/private/legacy/app.php - line 155:
OC_App::requireAppFile("files_external")
/snap/nextcloud/21422/htdocs/lib/private/legacy/app.php - line 128:
OC_App::loadApp("files_external")
/snap/nextcloud/21422/htdocs/lib/base.php - line 982:
OC_App::loadApps()
/snap/nextcloud/21422/htdocs/index.php - line 42:
OC::handleRequest()
Cased by Doctrine\DBAL\Driver\PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_external_mounts' doesn't exist
/snap/nextcloud/21422/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 903:
Doctrine\DBAL\Driver\PDOStatement->execute()
/snap/nextcloud/21422/htdocs/lib/private/DB/Connection.php - line 195:
Doctrine\DBAL\Connection->executeQuery("SELECT `m`. ... )", [ 1,3,"nevo",2,"admin"], [ 1,1,2,1,2], null)
/snap/nextcloud/21422/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php - line 200:
OC\DB\Connection->executeQuery("SELECT `m`. ... )", { dcValue1: ... ]}, { dcValue1: ... 2})
/snap/nextcloud/21422/htdocs/lib/private/DB/QueryBuilder/QueryBuilder.php - line 214:
Doctrine\DBAL\Query\QueryBuilder->execute()
/snap/nextcloud/21422/htdocs/apps/files_external/lib/Service/DBConfigService.php - line 406:
OC\DB\QueryBuilder\QueryBuilder->execute()
/snap/nextcloud/21422/htdocs/apps/files_external/lib/Service/DBConfigService.php - line 114:
OCA\Files_External\Service\DBConfigService->getMountsFromQuery(OC\DB\QueryB ... {})
/snap/nextcloud/21422/htdocs/apps/files_external/lib/Service/UserGlobalStoragesService.php - line 187:
OCA\Files_External\Service\DBConfigService->getMountsForUser("nevo", [ "admin"])
/snap/nextcloud/21422/htdocs/apps/files_external/lib/Config/ConfigAdapter.php - line 125:
OCA\Files_External\Service\UserGlobalStoragesService->getAllStoragesForUser()
/snap/nextcloud/21422/htdocs/lib/private/Files/Filesystem.php - line 479:
OCA\Files_External\Config\ConfigAdapter->getMountsForUser(OC\User\User {}, OC\Files\Sto ... {})
<<closure>>
OC\Files\Filesystem::OC\Files\{closure}("*** sensiti ... *")
/snap/nextcloud/21422/htdocs/lib/private/Hooks/EmitterTrait.php - line 99:
call_user_func_array(Closure {}, [ "*** sensi ... "])
/snap/nextcloud/21422/htdocs/lib/private/Files/Config/MountProviderCollection.php - line 152:
OC\Files\Config\MountProviderCollection->emit("\\OC\\Files\\Config", "registerMountProvider", [ "*** sensi ... "])
/snap/nextcloud/21422/htdocs/apps/files_external/appinfo/app.php - line 53:
OC\Files\Config\MountProviderCollection->registerProvider("*** sensiti ... *")
/snap/nextcloud/21422/htdocs/lib/private/legacy/app.php - line 265:
require_once("/snap/nextc ... p")
/snap/nextcloud/21422/htdocs/lib/private/legacy/app.php - line 155:
OC_App::requireAppFile("files_external")
/snap/nextcloud/21422/htdocs/lib/private/legacy/app.php - line 128:
OC_App::loadApp("files_external")
/snap/nextcloud/21422/htdocs/lib/base.php - line 982:
OC_App::loadApps()
/snap/nextcloud/21422/htdocs/index.php - line 42:
OC::handleRequest()
Cased by PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_external_mounts' doesn't exist
/snap/nextcloud/21422/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php - line 117:
PDOStatement->execute(null)
/snap/nextcloud/21422/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 903:
Doctrine\DBAL\Driver\PDOStatement->execute()
/snap/nextcloud/21422/htdocs/lib/private/DB/Connection.php - line 195:
Doctrine\DBAL\Connection->executeQuery("SELECT `m`. ... )", [ 1,3,"nevo",2,"admin"], [ 1,1,2,1,2], null)
/snap/nextcloud/21422/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php - line 200:
OC\DB\Connection->executeQuery("SELECT `m`. ... )", { dcValue1: ... ]}, { dcValue1: ... 2})
/snap/nextcloud/21422/htdocs/lib/private/DB/QueryBuilder/QueryBuilder.php - line 214:
Doctrine\DBAL\Query\QueryBuilder->execute()
/snap/nextcloud/21422/htdocs/apps/files_external/lib/Service/DBConfigService.php - line 406:
OC\DB\QueryBuilder\QueryBuilder->execute()
/snap/nextcloud/21422/htdocs/apps/files_external/lib/Service/DBConfigService.php - line 114:
OCA\Files_External\Service\DBConfigService->getMountsFromQuery(OC\DB\QueryB ... {})
/snap/nextcloud/21422/htdocs/apps/files_external/lib/Service/UserGlobalStoragesService.php - line 187:
OCA\Files_External\Service\DBConfigService->getMountsForUser("nevo", [ "admin"])
/snap/nextcloud/21422/htdocs/apps/files_external/lib/Config/ConfigAdapter.php - line 125:
OCA\Files_External\Service\UserGlobalStoragesService->getAllStoragesForUser()
/snap/nextcloud/21422/htdocs/lib/private/Files/Filesystem.php - line 479:
OCA\Files_External\Config\ConfigAdapter->getMountsForUser(OC\User\User {}, OC\Files\Sto ... {})
<<closure>>
OC\Files\Filesystem::OC\Files\{closure}("*** sensiti ... *")
/snap/nextcloud/21422/htdocs/lib/private/Hooks/EmitterTrait.php - line 99:
call_user_func_array(Closure {}, [ "*** sensi ... "])
/snap/nextcloud/21422/htdocs/lib/private/Files/Config/MountProviderCollection.php - line 152:
OC\Files\Config\MountProviderCollection->emit("\\OC\\Files\\Config", "registerMountProvider", [ "*** sensi ... "])
/snap/nextcloud/21422/htdocs/apps/files_external/appinfo/app.php - line 53:
OC\Files\Config\MountProviderCollection->registerProvider("*** sensiti ... *")
/snap/nextcloud/21422/htdocs/lib/private/legacy/app.php - line 265:
require_once("/snap/nextc ... p")
/snap/nextcloud/21422/htdocs/lib/private/legacy/app.php - line 155:
OC_App::requireAppFile("files_external")
/snap/nextcloud/21422/htdocs/lib/private/legacy/app.php - line 128:
OC_App::loadApp("files_external")
/snap/nextcloud/21422/htdocs/lib/base.php - line 982:
OC_App::loadApps()
/snap/nextcloud/21422/htdocs/index.php - line 42:
OC::handleRequest()