Hallo Leute,
wenn ich versuche ein Dokument in der Nextcloud zu öffnen bekomme ich diesen Fehler
Collabora Online Development Edition konnte nicht geladen werden â Bitte versuchen Sie es spĂ€ter noch einmal
Das hier finde ich im Log:
{âreqIdâ:âAA9wUipUVF4wWu7oCWXlâ,âlevelâ:3,âtimeâ:â2020-04-28T09:57:51+00:00â,âremoteAddrâ:â172.18.18.9â,âuserâ:âadminâ,âappâ:ârichdocumentsâ,âmethodâ:âGETâ,âurlâ:"/index.php/apps/richdocuments/index?fileId=5804100&requesttoken=w5j9ntZoX7%2BA23GZp%2B66g2soOpMIgSQbOCPYexLWcLc%3D%3Al8ur%2FZUOHtPzixqy8Z7VsVwRbOVg2G9dfkuUN1SHH4E%3D",âmessageâ:{âExceptionâ:âDoctrine\DBAL\Exception\InvalidFieldNameExceptionâ,âMessageâ:âAn exception occurred while executing âINSERT INTO ârichdocuments_wopiâ(âfileidâ,âowner_uidâ,âeditor_uidâ,âversionâ,âcanwriteâ,âserver_hostâ,âtokenâ,âexpiryâ,âtemplate_destinationâ,âhide_downloadâ,âdirectâ,âis_remote_tokenâ,âtemplate_idâ) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?)â with params [5804100, âadminâ, âadminâ, 0, true, âhttps:\/\/nextcloudmeinedomain.tld\/â, âjtjbwvZLMa8nr8IiI78Eb4W2ycXDvmcpâ, 1588069671, 0, false, false, false, 0]:\n\nSQLSTATE[42703]: Undefined column: 7 ERROR: column âtemplate_idâ of relation ârichdocuments_wopiâ does not exist\nLINE 1: âŠationâ,âhide_downloadâ,âdirectâ,âis_remote_tokenâ,âtemplate_âŠ\n ^â,âCodeâ:0,âTraceâ:[{âfileâ:"/usr/lib/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php",âlineâ:169,âfunctionâ:âconvertExceptionâ,âclassâ:âDoctrine\DBAL\Driver\AbstractPostgreSQLDriverâ,âtypeâ:"->",âargsâ:[âAn exception occurred while executing âINSERT INTO ârichdocuments_wopiâ(âfileidâ,âowner_uidâ,âeditor_uidâ,âversionâ,âcanwriteâ,âserver_hostâ,âtokenâ,âexpiryâ,âtemplate_destinationâ,âhide_downloadâ,âdirectâ,âis_remote_tokenâ,âtemplate_idâ) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?)â with params [5804100, âadminâ, âadminâ, 0, true, âhttps:\/\/nextcloudmeinedomain.tld\/â, âjtjbwvZLMa8nr8IiI78Eb4W2ycXDvmcpâ, 1588069671, 0, false, false, false, 0]:\n\nSQLSTATE[42703]: Undefined column: 7 ERROR: column âtemplate_idâ of relation ârichdocuments_wopiâ does not exist\nLINE 1: âŠationâ,âhide_downloadâ,âdirectâ,âis_remote_tokenâ,âtemplate_âŠ\n ^â,{âerrorInfoâ:[â42703â,7,âERROR: column âtemplate_idâ of relation ârichdocuments_wopiâ does not exist\nLINE 1: âŠationâ,âhide_downloadâ,âdirectâ,âis_remote_tokenâ,âtemplate_âŠ\n ^â],âclassâ:âDoctrine\DBAL\Driver\PDOExceptionâ}]},{âfileâ:"/usr/lib/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php",âlineâ:145,âfunctionâ:âwrapExceptionâ,âclassâ:âDoctrine\DBAL\DBALExceptionâ,âtypeâ:"::",âargsâ:[{âclassâ:âDoctrine\DBAL\Driver\PDOPgSql\Driverâ},{âerrorInfoâ:[â42703â,7,âERROR: column âtemplate_idâ of relation ârichdocuments_wopiâ does not exist\nLINE 1: âŠationâ,âhide_downloadâ,âdirectâ,âis_remote_tokenâ,âtemplate_âŠ\n ^â],âclassâ:âDoctrine\DBAL\Driver\PDOExceptionâ},âAn exception occurred while executing âINSERT INTO ârichdocuments_wopiâ(âfileidâ,âowner_uidâ,âeditor_uidâ,âversionâ,âcanwriteâ,âserver_hostâ,âtokenâ,âexpiryâ,âtemplate_destinationâ,âhide_downloadâ,âdirectâ,âis_remote_tokenâ,âtemplate_idâ) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?)â with params [5804100, âadminâ, âadminâ, 0, true, âhttps:\/\/nextcloudmeinedomain.tld\/â, âjtjbwvZLMa8nr8IiI78Eb4W2ycXDvmcpâ, 1588069671, 0, false, false, false, 0]:\n\nSQLSTATE[42703]: Undefined column: 7 ERROR: column âtemplate_idâ of relation ârichdocuments_wopiâ does not exist\nLINE 1: âŠationâ,âhide_downloadâ,âdirectâ,âis_remote_tokenâ,âtemplate_âŠ\n ^â]},{âfileâ:"/usr/lib/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Statement.php",âlineâ:162,âfunctionâ:âdriverExceptionDuringQueryâ,âclassâ:âDoctrine\DBAL\DBALExceptionâ,âtypeâ:"::",âargsâ:[{âclassâ:âDoctrine\DBAL\Driver\PDOPgSql\Driverâ},{âerrorInfoâ:[â42703â,7,âERROR: column âtemplate_idâ of relation ârichdocuments_wopiâ does not exist\nLINE 1: âŠationâ,âhide_downloadâ,âdirectâ,âis_remote_tokenâ,âtemplate_âŠ\n ^â],âclassâ:âDoctrine\DBAL\Driver\PDOExceptionâ},âINSERT INTO ârichdocuments_wopiâ(âfileidâ,âowner_uidâ,âeditor_uidâ,âversionâ,âcanwriteâ,âserver_hostâ,âtokenâ,âexpiryâ,âtemplate_destinationâ,âhide_downloadâ,âdirectâ,âis_remote_tokenâ,âtemplate_idâ) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?)â,{â1â:5804100,â2â:âadminâ,â3â:âadminâ,â4â:0,â5â:true,â6â:âhttps://nextcloudmeinedomain.tld/",â7â:âjtjbwvZLMa8nr8IiI78Eb4W2ycXDvmcpâ,â8â:1588069671,â9â:0,â10â:false,â11â:false,â12â:false,â13â:0}]},{âfileâ:"/usr/lib/nextcloud/lib/public/AppFramework/Db/Mapper.php",âlineâ:255,âfunctionâ:âexecuteâ,âclassâ:âDoctrine\DBAL\Statementâ,âtypeâ:"->â,âargsâ:[]},{âfileâ:"/usr/lib/nextcloud/lib/public/AppFramework/Db/Mapper.php",âlineâ:129,âfunctionâ:âexecuteâ,âclassâ:âOCP\AppFramework\Db\Mapperâ,âtypeâ:"->",âargsâ:[âINSERT INTO *PREFIX*richdocuments_wopi
(fileid
,owner_uid
,editor_uid
,version
,canwrite
,server_host
,token
,expiry
,template_destination
,hide_download
,direct
,is_remote_token
,template_id
) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?)â,[5804100,âadminâ,âadminâ,0,true,âhttps://nextcloudmeinedomain.tld/",âjtjbwvZLMa8nr8IiI78Eb4W2ycXDvmcpâ,1588069671,0,false,false,false,0]]},{âfileâ:"/usr/lib/nextcloud/apps/richdocuments/lib/Db/WopiMapper.php",âlineâ:89,âfunctionâ:âinsertâ,âclassâ:âOCP\AppFramework\Db\Mapperâ,âtypeâ:"->â,âargsâ:[{âidâ:null,âclassâ:âOCA\Richdocuments\Db\Wopiâ}]},{âfileâ:"/usr/lib/nextcloud/apps/richdocuments/lib/TokenManager.php",âlineâ:205,âfunctionâ:âgenerateFileTokenâ,âclassâ:âOCA\Richdocuments\Db\WopiMapperâ,âtypeâ:"->",âargsâ:["*** sensitive parameter replaced ",âadminâ,âadminâ,â0â,1,âhttps://nextcloudmeinedomain.tld/",null,0,false,false,false,0,null]},{âfileâ:"/usr/lib/nextcloud/apps/richdocuments/lib/Controller/DocumentController.php",âlineâ:238,âfunctionâ:âgetTokenâ,âclassâ:âOCA\Richdocuments\TokenManagerâ,âtypeâ:"->â,âargsâ:[" sensitive parameters replaced "]},{âfileâ:"/usr/lib/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",âlineâ:170,âfunctionâ:âindexâ,âclassâ:âOCA\Richdocuments\Controller\DocumentControllerâ,âtypeâ:"->",âargsâ:[" sensitive parameter replaced "]},{âfileâ:"/usr/lib/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",âlineâ:99,âfunctionâ:âexecuteControllerâ,âclassâ:âOC\AppFramework\Http\Dispatcherâ,âtypeâ:"->",âargsâ:[{âclassâ:âOCA\Richdocuments\Controller\DocumentControllerâ},âindexâ]},{âfileâ:"/usr/lib/nextcloud/lib/private/AppFramework/App.php",âlineâ:125,âfunctionâ:âdispatchâ,âclassâ:âOC\AppFramework\Http\Dispatcherâ,âtypeâ:"->",âargsâ:[{âclassâ:âOCA\Richdocuments\Controller\DocumentControllerâ},âindexâ]},{âfileâ:"/usr/lib/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php",âlineâ:47,âfunctionâ:âmainâ,âclassâ:âOC\AppFramework\Appâ,âtypeâ:"::",âargsâ:[âOCA\Richdocuments\Controller\DocumentControllerâ,âindexâ,{âclassâ:âOC\AppFramework\DependencyInjection\DIContainerâ},{"_route":ârichdocuments.document.indexâ}]},{âfunctionâ:"__invoke",âclassâ:âOC\AppFramework\Routing\RouteActionHandlerâ,âtypeâ:"->",âargsâ:[{"_route":ârichdocuments.document.indexâ}]},{âfileâ:"/usr/lib/nextcloud/lib/private/Route/Router.php",âlineâ:299,âfunctionâ:âcall_user_funcâ,âargsâ:[{âclassâ:âOC\AppFramework\Routing\RouteActionHandlerâ},{âroute":ârichdocuments.document.indexâ}]},{âfileâ:"/usr/lib/nextcloud/lib/base.php",âlineâ:1008,âfunctionâ:âmatchâ,âclassâ:âOC\Route\Routerâ,âtypeâ:"->",âargsâ:["/apps/richdocuments/index"]},{âfileâ:"/usr/lib/nextcloud/index.php",âlineâ:38,âfunctionâ:âhandleRequestâ,âclassâ:âOCâ,âtypeâ:"::",âargsâ:[]}],âFileâ:"/usr/lib/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php",âLineâ:60,âPreviousâ:{âExceptionâ:âDoctrine\DBAL\Driver\PDOExceptionâ,âMessageâ:âSQLSTATE[42703]: Undefined column: 7 ERROR: column âtemplate_idâ of relation ârichdocuments_wopiâ does not exist\nLINE 1: âŠationâ,âhide_downloadâ,âdirectâ,âis_remote_tokenâ,"templateâŠ\n ^â,âCodeâ:â42703â,âTraceâ:[{âfileâ:"/usr/lib/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Statement.php",âlineâ:153,âfunctionâ:âexecuteâ,âclassâ:âDoctrine\DBAL\Driver\PDOStatementâ,âtypeâ:"->",âargsâ:[null]},{âfileâ:"/usr/lib/nextcloud/lib/public/AppFramework/Db/Mapper.php",âlineâ:255,âfunctionâ:âexecuteâ,âclassâ:âDoctrine\DBAL\Statementâ,âtypeâ:"->",âargsâ:[]},{âfileâ:"/usr/lib/nextcloud/lib/public/AppFramework/Db/Mapper.php",âlineâ:129,âfunctionâ:âexecuteâ,âclassâ:âOCP\AppFramework\Db\Mapperâ,âtypeâ:"->",âargsâ:[âINSERT INTO *PREFIX*richdocuments_wopi
(fileid
,owner_uid
,editor_uid
,version
,canwrite
,server_host
,token
,expiry
,template_destination
,hide_download
,direct
,is_remote_token
,template_id
) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?)â,[5804100,âadminâ,âadminâ,0,true,âhttps://nextcloudmeinedomain.tld/",âjtjbwvZLMa8nr8IiI78Eb4W2ycXDvmcpâ,1588069671,0,false,false,false,0]]},{âfileâ:"/usr/lib/nextcloud/apps/richdocuments/lib/Db/WopiMapper.php",âlineâ:89,âfunctionâ:âinsertâ,âclassâ:âOCP\AppFramework\Db\Mapperâ,âtypeâ:"->â,âargsâ:[{âidâ:null,âclassâ:âOCA\Richdocuments\Db\Wopiâ}]},{âfileâ:"/usr/lib/nextcloud/apps/richdocuments/lib/TokenManager.php",âlineâ:205,âfunctionâ:âgenerateFileTokenâ,âclassâ:âOCA\Richdocuments\Db\WopiMapperâ,âtypeâ:"->",âargsâ:[" sensitive parameter replaced ",âadminâ,âadminâ,â0â,1,âhttps://nextcloudmeinedomain.tld/",null,0,false,false,false,0,null]},{âfileâ:"/usr/lib/nextcloud/apps/richdocuments/lib/Controller/DocumentController.php",âlineâ:238,âfunctionâ:âgetTokenâ,âclassâ:âOCA\Richdocuments\TokenManagerâ,âtypeâ:"->â,âargsâ:[" sensitive parameters replaced "]},{âfileâ:"/usr/lib/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",âlineâ:170,âfunctionâ:âindexâ,âclassâ:âOCA\Richdocuments\Controller\DocumentControllerâ,âtypeâ:"->",âargsâ:[" sensitive parameter replaced "]},{âfileâ:"/usr/lib/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",âlineâ:99,âfunctionâ:âexecuteControllerâ,âclassâ:âOC\AppFramework\Http\Dispatcherâ,âtypeâ:"->",âargsâ:[{âclassâ:âOCA\Richdocuments\Controller\DocumentControllerâ},âindexâ]},{âfileâ:"/usr/lib/nextcloud/lib/private/AppFramework/App.php",âlineâ:125,âfunctionâ:âdispatchâ,âclassâ:âOC\AppFramework\Http\Dispatcherâ,âtypeâ:"->",âargsâ:[{âclassâ:âOCA\Richdocuments\Controller\DocumentControllerâ},âindexâ]},{âfileâ:"/usr/lib/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php",âlineâ:47,âfunctionâ:âmainâ,âclassâ:âOC\AppFramework\Appâ,âtypeâ:"::",âargsâ:[âOCA\Richdocuments\Controller\DocumentControllerâ,âindexâ,{âclassâ:âOC\AppFramework\DependencyInjection\DIContainerâ},{"_route":ârichdocuments.document.indexâ}]},{âfunctionâ:"__invoke",âclassâ:âOC\AppFramework\Routing\RouteActionHandlerâ,âtypeâ:"->",âargsâ:[{"_route":ârichdocuments.document.indexâ}]},{âfileâ:"/usr/lib/nextcloud/lib/private/Route/Router.php",âlineâ:299,âfunctionâ:âcall_user_funcâ,âargsâ:[{âclassâ:âOC\AppFramework\Routing\RouteActionHandlerâ},{âroute":ârichdocuments.document.indexâ}]},{âfileâ:"/usr/lib/nextcloud/lib/base.php",âlineâ:1008,âfunctionâ:âmatchâ,âclassâ:âOC\Route\Routerâ,âtypeâ:"->",âargsâ:["/apps/richdocuments/index"]},{âfileâ:"/usr/lib/nextcloud/index.php",âlineâ:38,âfunctionâ:âhandleRequestâ,âclassâ:âOCâ,âtypeâ:"::",âargsâ:[]}],âFileâ:"/usr/lib/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php",âLineâ:119,âPreviousâ:{âExceptionâ:âPDOExceptionâ,âMessageâ:âSQLSTATE[42703]: Undefined column: 7 ERROR: column âtemplate_idâ of relation ârichdocuments_wopiâ does not exist\nLINE 1: âŠationâ,âhide_downloadâ,âdirectâ,âis_remote_tokenâ,"templateâŠ\n ^â,âCodeâ:â42703â,âTraceâ:[{âfileâ:"/usr/lib/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php",âlineâ:117,âfunctionâ:âexecuteâ,âclassâ:âPDOStatementâ,âtypeâ:"->",âargsâ:[null]},{âfileâ:"/usr/lib/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Statement.php",âlineâ:153,âfunctionâ:âexecuteâ,âclassâ:âDoctrine\DBAL\Driver\PDOStatementâ,âtypeâ:"->",âargsâ:[null]},{âfileâ:"/usr/lib/nextcloud/lib/public/AppFramework/Db/Mapper.php",âlineâ:255,âfunctionâ:âexecuteâ,âclassâ:âDoctrine\DBAL\Statementâ,âtypeâ:"->",âargsâ:[]},{âfileâ:"/usr/lib/nextcloud/lib/public/AppFramework/Db/Mapper.php",âlineâ:129,âfunctionâ:âexecuteâ,âclassâ:âOCP\AppFramework\Db\Mapperâ,âtypeâ:"->",âargsâ:[âINSERT INTO *PREFIX*richdocuments_wopi
(fileid
,owner_uid
,editor_uid
,version
,canwrite
,server_host
,token
,expiry
,template_destination
,hide_download
,direct
,is_remote_token
,template_id
) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?)â,[5804100,âadminâ,âadminâ,0,true,âhttps://nextcloudmeinedomain.tld/",âjtjbwvZLMa8nr8IiI78Eb4W2ycXDvmcpâ,1588069671,0,false,false,false,0]]},{âfileâ:"/usr/lib/nextcloud/apps/richdocuments/lib/Db/WopiMapper.php",âlineâ:89,âfunctionâ:âinsertâ,âclassâ:âOCP\AppFramework\Db\Mapperâ,âtypeâ:"->â,âargsâ:[{âidâ:null,âclassâ:âOCA\Richdocuments\Db\Wopiâ}]},{âfileâ:"/usr/lib/nextcloud/apps/richdocuments/lib/TokenManager.php",âlineâ:205,âfunctionâ:âgenerateFileTokenâ,âclassâ:âOCA\Richdocuments\Db\WopiMapperâ,âtypeâ:"->",âargsâ:[" sensitive parameter replaced ",âadminâ,âadminâ,â0â,1,âhttps://nextcloudmeinedomain.tld/",null,0,false,false,false,0,null]},{âfileâ:"/usr/lib/nextcloud/apps/richdocuments/lib/Controller/DocumentController.php",âlineâ:238,âfunctionâ:âgetTokenâ,âclassâ:âOCA\Richdocuments\TokenManagerâ,âtypeâ:"->â,âargsâ:[" sensitive parameters replaced "]},{âfileâ:"/usr/lib/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",âlineâ:170,âfunctionâ:âindexâ,âclassâ:âOCA\Richdocuments\Controller\DocumentControllerâ,âtypeâ:"->",âargsâ:[" sensitive parameter replaced ***"]},{âfileâ:"/usr/lib/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",âlineâ:99,âfunctionâ:âexecuteControllerâ,âclassâ:âOC\AppFramework\Http\Dispatcherâ,âtypeâ:"->",âargsâ:[{âclassâ:âOCA\Richdocuments\Controller\DocumentControllerâ},âindexâ]},{âfileâ:"/usr/lib/nextcloud/lib/private/AppFramework/App.php",âlineâ:125,âfunctionâ:âdispatchâ,âclassâ:âOC\AppFramework\Http\Dispatcherâ,âtypeâ:"->",âargsâ:[{âclassâ:âOCA\Richdocuments\Controller\DocumentControllerâ},âindexâ]},{âfileâ:"/usr/lib/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php",âlineâ:47,âfunctionâ:âmainâ,âclassâ:âOC\AppFramework\Appâ,âtypeâ:"::",âargsâ:[âOCA\Richdocuments\Controller\DocumentControllerâ,âindexâ,{âclassâ:âOC\AppFramework\DependencyInjection\DIContainerâ},{"_route":ârichdocuments.document.indexâ}]},{âfunctionâ:"__invoke",âclassâ:âOC\AppFramework\Routing\RouteActionHandlerâ,âtypeâ:"->",âargsâ:[{"_route":ârichdocuments.document.indexâ}]},{âfileâ:"/usr/lib/nextcloud/lib/private/Route/Router.php",âlineâ:299,âfunctionâ:âcall_user_funcâ,âargsâ:[{âclassâ:âOC\AppFramework\Routing\RouteActionHandlerâ},{"_route":ârichdocuments.document.indexâ}]},{âfileâ:"/usr/lib/nextcloud/lib/base.php",âlineâ:1008,âfunctionâ:âmatchâ,âclassâ:âOC\Route\Routerâ,âtypeâ:"->",âargsâ:["/apps/richdocuments/index"]},{âfileâ:"/usr/lib/nextcloud/index.php",âlineâ:38,âfunctionâ:âhandleRequestâ,âclassâ:âOCâ,âtypeâ:"::",âargsâ:[]}],âFileâ:"/usr/lib/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php",âLineâ:117}},âCustomMessageâ:"â"},âuserAgentâ:âMozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.102 Safari/537.36 Edge/18.18362â,âversionâ:â18.0.4.2â,âidâ:â5ea7ff2b89cabâ}
Zu Beginn hatte ich noch 18.03. drauf habe aber auf 18.0.4 upgedatet fehlerfrei, leider ist das Problem damit immer noch nicht behoben. Habe ebenso die Cloud in Wartungsmodes versetzt und habe ein maintenence:repair versucht, aber auch das brachte kein Erfolg.
Alles andere schein zu funktionieren.
Ich wĂ€re fĂŒr jedne Tipp dankbar. Vielen dank im voraus
LG Eddie
PS das ist mein System:
Nextcloud version (eg, 12.0.2) : 18.0.4.2
Operating system and version (eg, Ubuntu 17.04) : Ubuntu 16.0.4.6 LTS
Apache or nginx version (eg, Apache 2.4.25) : 2.4.18
PHP version (eg, 7.1) : 7.3.16