Hallo,
ich muss dazu etwas aussholen. Ich habe von owncloud 12 auf NextCloud gewechselt und dabei anscheinend meine “Einstellungen” irgendwie “zerstört”. Ich vermute eine Fehler in einer Einstellung in der DB. denn wenn ich folgendes aufrufe https://ownlcoud.TLD.ICU//index.php/settings/user
Sehe ich den Screen und im Log finde ich dann die folgende Meldung
{“reqId”:“LZnysALkgKmT5qiP2Aww”,
“level”:3,
“time”:“2021-11-11T14:55:29+00:00”,
“remoteAddr”:“192.168.2.23”,
“user”:“chris”,
“app”:“index”,
“method”:“GET”
“url”:"/index.php/settings/user",
“message”:“An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘data’ in ‘field list’”,
“userAgent”:“Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.71 Safari/537.36”,
“version”:“22.2.0.2”,
“exception”:{
“Exception”:“OC\DB\Exceptions\DbalException”,
“Message”:“An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘data’ in ‘field list’”,
“Code”:1054
“Trace”:[{“file”:"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php"
“line”:302,
“function”:“wrap”
“class”:“OC\DB\Exceptions\DbalException”
“type”:"::"},
{“file”:"/var/www/nextcloud/lib/private/Accounts/AccountManager.php",
“line”:323,
“function”:“executeQuery”,
“class”:“OC\DB\QueryBuilder\QueryBuilder”
“type”:"->"},
{“file”:"/var/www/nextcloud/lib/private/Accounts/AccountManager.php"
“line”:716,
“function”:“getUser”
“class”:“OC\Accounts\AccountManager”,
“type”:"->"},
{“file”:"/var/www/nextcloud/apps/settings/lib/Settings/Personal/PersonalInfo.php",
“line”:105
“function”:“getAccount”,
“class”:“OC\Accounts\AccountManager”
“type”:"->"},
{“file”:"/var/www/nextcloud/apps/settings/lib/Controller/CommonSettingsTrait.php",
“line”:137
“function”:“getForm”
“class”:“OCA\Settings\Settings\Personal\PersonalInfo”,
“type”:"->"},{“file”:"/var/www/nextcloud/apps/settings/lib/Controller/PersonalSettingsController.php",
“line”:76
“function”:“formatSettings”,
“class”:“OCA\Settings\Controller\PersonalSettingsController”
“type”:"->"},
{“file”:"/var/www/nextcloud/apps/settings/lib/Controller/CommonSettingsTrait.php",
“line”:148,
“function”:“getSettings”
“class”:“OCA\Settings\Controller\PersonalSettingsController”
“type”:"->"},
{“file”:"/var/www/nextcloud/apps/settings/lib/Controller/PersonalSettingsController.php",
“line”:67
“function”:“getIndexResponse”,
“class”:“OCA\Settings\Controller\PersonalSettingsController”,
“type”:"->"},
{“file”:"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
“line”:217
“function”:“index”
“class”:“OCA\Settings\Controller\PersonalSettingsController”,
“type”:"->"},
{“file”:"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
“line”:126
“function”:“executeController”,
“class”:“OC\AppFramework\Http\Dispatcher”,
“type”:"->"},
{“file”:"/var/www/nextcloud/lib/private/AppFramework/App.php",
“line”:156,
“function”:“dispatch”,
“class”:“OC\AppFramework\Http\Dispatcher”,
“type”:"->"},
{“file”:"/var/www/nextcloud/lib/private/Route/Router.php",
“line”:301
“function”:“main”,
“class”:“OC\AppFramework\App”
“type”:"::"},
{“file”:"/var/www/nextcloud/lib/base.php",
“line”:1000
“function”:“match”,
“class”:“OC\Route\Router”,
“type”:"->"},
{“file”:"/var/www/nextcloud/index.php",
“line”:36
“function”:“handleRequest”,
“class”:“OC”
“type”:"::"}],
“File”:"/var/www/nextcloud/lib/private/DB/Exceptions/DbalException.php",
“Line”:71,
“Previous”:{“Exception”:“Doctrine\DBAL\Exception\InvalidFieldNameException”
“Message”:“An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘data’ in ‘field list’”
“Code”:1054
“Trace”:[
{“file”:"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
“line”:1728
“function”:“convert”,
“class”:“Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter”
“type”:"->"},
{“file”:"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
“line”:1667,
“function”:“handleDriverException”,
“class”:“Doctrine\DBAL\Connection”,
“type”:"->"},
{“file”:"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
“line”:1040,
“function”:“convertExceptionDuringQuery”,
“class”:“Doctrine\DBAL\Connection”,
“type”:"->"},
{“file”:"/var/www/nextcloud/lib/private/DB/Connection.php",
“line”:231
“function”:“executeQuery”,
“class”:“Doctrine\DBAL\Connection”,
“type”:"->"},
{“file”:"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
“line”:210,
“function”:“executeQuery”,
“class”:“OC\DB\Connection”,
“type”:"->"},
{“file”:"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
“line”:287,
“function”:“execute”,
“class”:“Doctrine\DBAL\Query\QueryBuilder”,
“type”:"->"},
{“file”:"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
“line”:300
“function”:“execute”,
“class”:“OC\DB\QueryBuilder\QueryBuilder”,
“type”:"->"},
{“file”:"/var/www/nextcloud/lib/private/Accounts/AccountManager.php",
“line”:323
“function”:“executeQuery”,
“class”:“OC\DB\QueryBuilder\QueryBuilder”,
“type”:"->"},
{“file”:"/var/www/nextcloud/lib/private/Accounts/AccountManager.php",
“line”:716,
“function”:“getUser”,
“class”:“OC\Accounts\AccountManager”,
“type”:"->"},
{“file”:"/var/www/nextcloud/apps/settings/lib/Settings/Personal/PersonalInfo.php",
“line”:105,
“function”:“getAccount”,
“class”:“OC\Accounts\AccountManager”,
“type”:"->"},
{“file”:"/var/www/nextcloud/apps/settings/lib/Controller/CommonSettingsTrait.php",
“line”:137
“function”:“getForm”,
“class”:“OCA\Settings\Settings\Personal\PersonalInfo”,
“type”:"->"},{“file”:"/var/www/nextcloud/apps/settings/lib/Controller/PersonalSettingsController.php",
“line”:76
“function”:“formatSettings”,
“class”:“OCA\Settings\Controller\PersonalSettingsController”,
“type”:"->"},
{“file”:"/var/www/nextcloud/apps/settings/lib/Controller/CommonSettingsTrait.php",
“line”:148
“function”:“getSettings”,
“class”:“OCA\Settings\Controller\PersonalSettingsController”
“type”:"->"},{“file”:"/var/www/nextcloud/apps/settings/lib/Controller/PersonalSettingsController.php"
“line”:67
“function”:“getIndexResponse”
“class”:“OCA\Settings\Controller\PersonalSettingsController”
“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php"
“line”:217
“function”:“index”
“class”:“OCA\Settings\Controller\PersonalSettingsController”
“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php"
“line”:126
“function”:“executeController”
“class”:“OC\AppFramework\Http\Dispatcher”
“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/AppFramework/App.php"
“line”:156
“function”:“dispatch”
“class”:“OC\AppFramework\Http\Dispatcher”
“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/Route/Router.php"
“line”:301
“function”:“main”
“class”:“OC\AppFramework\App”
“type”:"::"},{“file”:"/var/www/nextcloud/lib/base.php"
“line”:1000
“function”:“match”
“class”:“OC\Route\Router”
“type”:"->"},{“file”:"/var/www/nextcloud/index.php"
“line”:36
“function”:“handleRequest”
“class”:“OC”
“type”:"::"}]
“File”:"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php"
“Line”:65
“Previous”:{“Exception”:“Doctrine\DBAL\Driver\PDO\Exception”
“Message”:“SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘data’ in ‘field list’”
“Code”:1054
“Trace”:[{“file”:"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php"
“line”:84
“function”:“new”
“class”:“Doctrine\DBAL\Driver\PDO\Exception”
“type”:"::"},{“file”:"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php"
“line”:1032
“function”:“execute”
“class”:“Doctrine\DBAL\Driver\PDO\Statement”
“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/DB/Connection.php"
“line”:231
“function”:“executeQuery”
“class”:“Doctrine\DBAL\Connection”
“type”:"->"},{“file”:"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php"
“line”:210
“function”:“executeQuery”
“class”:“OC\DB\Connection”
“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php"
“line”:287
“function”:“execute”
“class”:“Doctrine\DBAL\Query\QueryBuilder”
“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php"
“line”:300
“function”:“execute”
“class”:“OC\DB\QueryBuilder\QueryBuilder”
“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/Accounts/AccountManager.php"
“line”:323
“function”:“executeQuery”
“class”:“OC\DB\QueryBuilder\QueryBuilder”
“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/Accounts/AccountManager.php"
“line”:716
“function”:“getUser”
“class”:“OC\Accounts\AccountManager”
“type”:"->"},{“file”:"/var/www/nextcloud/apps/settings/lib/Settings/Personal/PersonalInfo.php"
“line”:105
“function”:“getAccount”
“class”:“OC\Accounts\AccountManager”
“type”:"->"},{“file”:"/var/www/nextcloud/apps/settings/lib/Controller/CommonSettingsTrait.php"
“line”:137
“function”:“getForm”
“class”:“OCA\Settings\Settings\Personal\PersonalInfo”
“type”:"->"},{“file”:"/var/www/nextcloud/apps/settings/lib/Controller/PersonalSettingsController.php"
“line”:76
“function”:“formatSettings”
“class”:“OCA\Settings\Controller\PersonalSettingsController”
“type”:"->"},{“file”:"/var/www/nextcloud/apps/settings/lib/Controller/CommonSettingsTrait.php"
“line”:148
“function”:“getSettings”
“class”:“OCA\Settings\Controller\PersonalSettingsController”
“type”:"->"},{“file”:"/var/www/nextcloud/apps/settings/lib/Controller/PersonalSettingsController.php"
“line”:67
“function”:“getIndexResponse”
“class”:“OCA\Settings\Controller\PersonalSettingsController”
“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php"
“line”:217
“function”:“index”
“class”:“OCA\Settings\Controller\PersonalSettingsController”
“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php"
“line”:126
“function”:“executeController”
“class”:“OC\AppFramework\Http\Dispatcher”
“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/AppFramework/App.php"
“line”:156
“function”:“dispatch”
“class”:“OC\AppFramework\Http\Dispatcher”
“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/Route/Router.php"
“line”:301
“function”:“main”
“class”:“OC\AppFramework\App”
“type”:"::"},{“file”:"/var/www/nextcloud/lib/base.php"
“line”:1000
“function”:“match”
“class”:“OC\Route\Router”
“type”:"->"},{“file”:"/var/www/nextcloud/index.php"
“line”:36
“function”:“handleRequest”
“class”:“OC”
“type”:"::"}]
“File”:"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php"
“Line”:26
“Previous”:{“Exception”:“PDOException”
“Message”:“SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘data’ in ‘field list’”
“Code”:“42S22”
“Trace”:[{“file”:"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php"
“line”:82
“function”:“execute”
“class”:“PDOStatement”
“type”:"->"},{“file”:"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php"
“line”:1032
“function”:“execute”
“class”:“Doctrine\DBAL\Driver\PDO\Statement”
“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/DB/Connection.php"
“line”:231
“function”:“executeQuery”
“class”:“Doctrine\DBAL\Connection”
“type”:"->"},{“file”:"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php"
“line”:210
“function”:“executeQuery”
“class”:“OC\DB\Connection”
“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php"
“line”:287
“function”:“execute”
“class”:“Doctrine\DBAL\Query\QueryBuilder”
“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php"
“line”:300
“function”:“execute”
“class”:“OC\DB\QueryBuilder\QueryBuilder”
“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/Accounts/AccountManager.php"
“line”:323
“function”:“executeQuery”
“class”:“OC\DB\QueryBuilder\QueryBuilder”
“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/Accounts/AccountManager.php"
“line”:716
“function”:“getUser”
“class”:“OC\Accounts\AccountManager”
“type”:"->"},{“file”:"/var/www/nextcloud/apps/settings/lib/Settings/Personal/PersonalInfo.php"
“line”:105
“function”:“getAccount”
“class”:“OC\Accounts\AccountManager”
“type”:"->"},{“file”:"/var/www/nextcloud/apps/settings/lib/Controller/CommonSettingsTrait.php"
“line”:137
“function”:“getForm”
“class”:“OCA\Settings\Settings\Personal\PersonalInfo”
“type”:"->"},{“file”:"/var/www/nextcloud/apps/settings/lib/Controller/PersonalSettingsController.php"
“line”:76
“function”:“formatSettings”
“class”:“OCA\Settings\Controller\PersonalSettingsController”
“type”:"->"},{“file”:"/var/www/nextcloud/apps/settings/lib/Controller/CommonSettingsTrait.php"
“line”:148
“function”:“getSettings”
“class”:“OCA\Settings\Controller\PersonalSettingsController”
“type”:"->"},{“file”:"/var/www/nextcloud/apps/settings/lib/Controller/PersonalSettingsController.php"
“line”:67
“function”:“getIndexResponse”
“class”:“OCA\Settings\Controller\PersonalSettingsController”
“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php"
“line”:217
“function”:“index”
“class”:“OCA\Settings\Controller\PersonalSettingsController”
“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php"
“line”:126
“function”:“executeController”
“class”:“OC\AppFramework\Http\Dispatcher”
“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/AppFramework/App.php"
“line”:156
“function”:“dispatch”
“class”:“OC\AppFramework\Http\Dispatcher”
“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/Route/Router.php"
“line”:301
“function”:“main”
“class”:“OC\AppFramework\App”
“type”:"::"},{“file”:"/var/www/nextcloud/lib/base.php"
“line”:1000
“function”:“match”
“class”:“OC\Route\Router”
“type”:"->"},{“file”:"/var/www/nextcloud/index.php"
“line”:36
“function”:“handleRequest”
“class”:“OC”
“type”:"::"}]
“File”:"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php"
“Line”:82}}}
“CustomMessage”:"–"}}
rufe ich allerdings
https://ownlcoud.TLD.ICU//index.php/settings/admin auf kann ich die Einstellungen ganz normal verwalten.
Meine Systemeinstellungen sind Ubuntu 20.04
php --version
PHP 8.0.12 (cli) (built: Oct 22 2021 12:35:27) ( NTS )
Copyright (c) The PHP Group
Zend Engine v4.0.12, Copyright (c) Zend Technologies
with Zend OPcache v8.0.12, Copyright (c), by Zend Technologies
läuft auf einem apache2 und MySQL/MariaDB Server.
Hat vielleicht jemand ein Idee?
Vielen lieben Dank schon im voraus
ChristophR