search

nextcloud / richdocuments

📑 Collabora Online for Nextcloud
https://nextcloud.com/collaboraonline
355 stars 116 forks source link

Fail to edit files, having a 500 http error and "Failed to generate token for file" error message #3742

Closed CVZ-es closed 5 months ago

CVZ-es commented 5 months ago

Hi everybody,

Sorry I'm trying to setup my own Collabora Online Development Edition server with nextcloud (29.0.2) on ubuntu 22.04, but i'm having an issue related with the database.

Thanks in advance for you help Best Dami

Describe the bug I setup richdocument extension (8.4.2) with my own CODE server, but when I try to edit a file, I get a 500 error in my Apache logs "POST /cloud/index.php/apps/richdocuments/token HTTP/1.1" 500 871

When I go to nextcloud log, I find this error: DbalException An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'template_destination' in 'field list' Failed to generate token for file

Client details: Tried Firefox and Chrome, same issue

Server details

Operating system: ubuntu 22.04

Web server: 2.4.52-1ubuntu4.9

Database: mysql 5.8+1.0.8

PHP version: 8.1.2-1ubuntu2.17

Nextcloud version: 29.0.2

Version of the richdocuments app 8.4.2

Version of Collabora Online 24.04.4.1 9091043

Configuration of the richdocuments app { "apps": { "richdocuments": { "disable_certificate_verification": "", "doc_format": "", "edit_groups": "", "enabled": "yes", "external_apps": "", "installed_version": "8.4.2", "public_wopi_url": "https:\/\/collaboraonline.mydomain.org", "signed": "true", "types": "prevent_group_restriction", "use_groups": "", "wopi_allowlist": "xxx.xxx.xxx.xxx", "wopi_url": "https:\/\/collaboraonline.mydomain.org" } } }

Nextcloud log (data/nextcloud.log)

DbalException An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'template_destination' in 'field list' Failed to generate token for file

Browser log

Failed to load resource: the server responded with a status of 500 (Internal Server Error)

joshtrichards commented 5 months ago

We need the entire raw log entry so that we can isolate where this is coming from via the stack trace.

CVZ-es commented 5 months ago

Hi Joshtrichards,

Thanks fo your reply.

It is fine with this log debug (see below)? Let me know Thanks in advance Best Dami

Jun 12 21:40:14 server-name Nextcloud[23276]{"reqId":"QcxJ53WfqgpcTMpxgl5h","level":0,"time":"2024-06-12T19:40:14+00:00","remoteAddr":"x.x.x.x","user":"admin-nextcloud","app":"no app in context","method":"GET","url":"/cloud/apps/files/api/v1/views","message":"{\"Exception\":\"RuntimeException\",\"Message\":\"ignorable exception\",\"Code\":0,\"Trace\":[{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppConfig.php\",\"line\":1206,\"function\":\"loadConfig\",\"class\":\"OC\\\\AppConfig\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppConfig.php\",\"line\":127,\"function\":\"loadConfigAll\",\"class\":\"OC\\\\AppConfig\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AllConfig.php\",\"line\":196,\"function\":\"getKeys\",\"class\":\"OC\\\\AppConfig\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/user_ldap/lib/Helper.php\",\"line\":133,\"function\":\"getAppKeys\",\"class\":\"OC\\\\AllConfig\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/user_ldap/lib/Helper.php\",\"line\":74,\"function\":\"getServersConfig\",\"class\":\"OCA\\\\User_LDAP\\\\Helper\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/user_ldap/lib/AppInfo/Application.php\",\"line\":133,\"function\":\"getServerConfigurationPrefixes\",\"class\":\"OCA\\\\User_LDAP\\\\Helper\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppFramework/Bootstrap/FunctionInjector.php\",\"line\":66,\"function\":\"OCA\\\\User_LDAP\\\\AppInfo\\\\{closure}\",\"class\":\"OCA\\\\User_LDAP\\\\AppInfo\\\\Application\",\"type\":\"->\",\"args\":[\"*** sensitive parameters replaced ***\"]},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppFramework/Bootstrap/BootContext.php\",\"line\":50,\"function\":\"injectFn\",\"class\":\"OC\\\\AppFramework\\\\Bootstrap\\\\FunctionInjector\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/user_ldap/lib/AppInfo/Application.php\",\"line\":147,\"function\":\"injectFn\",\"class\":\"OC\\\\AppFramework\\\\Bootstrap\\\\BootContext\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppFramework/Bootstrap/Coordinator.php\",\"line\":200,\"function\":\"boot\",\"class\":\"OCA\\\\User_LDAP\\\\AppInfo\\\\Application\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/App/AppManager.php\",\"line\":437,\"function\":\"bootApp\",\"class\":\"OC\\\\AppFramework\\\\Bootstrap\\\\Coordinator\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/App/AppManager.php\",\"line\":216,\"function\":\"loadApp\",\"class\":\"OC\\\\App\\\\AppManager\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/legacy/OC_App.php\",\"line\":128,\"function\":\"loadApps\",\"class\":\"OC\\\\App\\\\AppManager\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/base.php\",\"line\":1022,\"function\":\"loadApps\",\"class\":\"OC_App\",\"type\":\"::\"},{\"file\":\"/var/www/nextcloud/cloud/index.php\",\"line\":49,\"function\":\"handleRequest\",\"class\":\"OC\",\"type\":\"::\"}],\"File\":\"/var/www/nextcloud/cloud/lib/private/AppConfig.php\",\"Line\":1220,\"message\":\"The loading of lazy AppConfig values have been requested\",\"exception\":{},\"CustomMessage\":\"The loading of lazy AppConfig values have been requested\"}","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/115.0","version":"29.0.2.2"}
Jun 12 21:40:14 server-name Nextcloud[23276]: {"reqId":"595VAEBnEm27LdKanEee","level":0,"time":"2024-06-12T19:40:14+00:00","remoteAddr":"x.x.x.x","user":"admin-nextcloud","app":"no app in context","method":"PROPFIND","url":"/cloud/remote.php/dav/files/admin-nextcloud/Nouveau%20document.odt","message":"{\"Exception\":\"RuntimeException\",\"Message\":\"ignorable exception\",\"Code\":0,\"Trace\":[{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppConfig.php\",\"line\":1206,\"function\":\"loadConfig\",\"class\":\"OC\\\\AppConfig\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppConfig.php\",\"line\":127,\"function\":\"loadConfigAll\",\"class\":\"OC\\\\AppConfig\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AllConfig.php\",\"line\":196,\"function\":\"getKeys\",\"class\":\"OC\\\\AppConfig\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/user_ldap/lib/Helper.php\",\"line\":133,\"function\":\"getAppKeys\",\"class\":\"OC\\\\AllConfig\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/user_ldap/lib/Helper.php\",\"line\":74,\"function\":\"getServersConfig\",\"class\":\"OCA\\\\User_LDAP\\\\Helper\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/user_ldap/lib/AppInfo/Application.php\",\"line\":133,\"function\":\"getServerConfigurationPrefixes\",\"class\":\"OCA\\\\User_LDAP\\\\Helper\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppFramework/Bootstrap/FunctionInjector.php\",\"line\":66,\"function\":\"OCA\\\\User_LDAP\\\\AppInfo\\\\{closure}\",\"class\":\"OCA\\\\User_LDAP\\\\AppInfo\\\\Application\",\"type\":\"->\",\"args\":[\"*** sensitive parameters replaced ***\"]},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppFramework/Bootstrap/BootContext.php\",\"line\":50,\"function\":\"injectFn\",\"class\":\"OC\\\\AppFramework\\\\Bootstrap\\\\FunctionInjector\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/user_ldap/lib/AppInfo/Application.php\",\"line\":147,\"function\":\"injectFn\",\"class\":\"OC\\\\AppFramework\\\\Bootstrap\\\\BootContext\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppFramework/Bootstrap/Coordinator.php\",\"line\":200,\"function\":\"boot\",\"class\":\"OCA\\\\User_LDAP\\\\AppInfo\\\\Application\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/App/AppManager.php\",\"line\":437,\"function\":\"bootApp\",\"class\":\"OC\\\\AppFramework\\\\Bootstrap\\\\Coordinator\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/App/AppManager.php\",\"line\":216,\"function\":\"loadApp\",\"class\":\"OC\\\\App\\\\AppManager\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/legacy/OC_App.php\",\"line\":128,\"function\":\"loadApps\",\"class\":\"OC\\\\App\\\\AppManager\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/remote.php\",\"line\":155,\"function\":\"loadApps\",\"class\":\"OC_App\",\"type\":\"::\"}],\"File\":\"/var/www/nextcloud/cloud/lib/private/AppConfig.php\",\"Line\":1220,\"message\":\"The loading of lazy AppConfig values have been requested\",\"exception\":{},\"CustomMessage\":\"The loading of lazy AppConfig values have been requested\"}","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/115.0","version":"29.0.2.2"}
Jun 12 21:40:14 server-name Nextcloud[23276]: {"reqId":"H75HUcd2fm6OYLqjStHe","level":0,"time":"2024-06-12T19:40:14+00:00","remoteAddr":"x.x.x.x","user":"admin-nextcloud","app":"no app in context","method":"PROPFIND","url":"/cloud/remote.php/dav/files/admin-nextcloud//Nouveau%20document.odt/","message":"{\"Exception\":\"RuntimeException\",\"Message\":\"ignorable exception\",\"Code\":0,\"Trace\":[{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppConfig.php\",\"line\":1206,\"function\":\"loadConfig\",\"class\":\"OC\\\\AppConfig\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppConfig.php\",\"line\":127,\"function\":\"loadConfigAll\",\"class\":\"OC\\\\AppConfig\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AllConfig.php\",\"line\":196,\"function\":\"getKeys\",\"class\":\"OC\\\\AppConfig\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/user_ldap/lib/Helper.php\",\"line\":133,\"function\":\"getAppKeys\",\"class\":\"OC\\\\AllConfig\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/user_ldap/lib/Helper.php\",\"line\":74,\"function\":\"getServersConfig\",\"class\":\"OCA\\\\User_LDAP\\\\Helper\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/user_ldap/lib/AppInfo/Application.php\",\"line\":133,\"function\":\"getServerConfigurationPrefixes\",\"class\":\"OCA\\\\User_LDAP\\\\Helper\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppFramework/Bootstrap/FunctionInjector.php\",\"line\":66,\"function\":\"OCA\\\\User_LDAP\\\\AppInfo\\\\{closure}\",\"class\":\"OCA\\\\User_LDAP\\\\AppInfo\\\\Application\",\"type\":\"->\",\"args\":[\"*** sensitive parameters replaced ***\"]},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppFramework/Bootstrap/BootContext.php\",\"line\":50,\"function\":\"injectFn\",\"class\":\"OC\\\\AppFramework\\\\Bootstrap\\\\FunctionInjector\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/user_ldap/lib/AppInfo/Application.php\",\"line\":147,\"function\":\"injectFn\",\"class\":\"OC\\\\AppFramework\\\\Bootstrap\\\\BootContext\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppFramework/Bootstrap/Coordinator.php\",\"line\":200,\"function\":\"boot\",\"class\":\"OCA\\\\User_LDAP\\\\AppInfo\\\\Application\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/App/AppManager.php\",\"line\":437,\"function\":\"bootApp\",\"class\":\"OC\\\\AppFramework\\\\Bootstrap\\\\Coordinator\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/App/AppManager.php\",\"line\":216,\"function\":\"loadApp\",\"class\":\"OC\\\\App\\\\AppManager\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/legacy/OC_App.php\",\"line\":128,\"function\":\"loadApps\",\"class\":\"OC\\\\App\\\\AppManager\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/remote.php\",\"line\":155,\"function\":\"loadApps\",\"class\":\"OC_App\",\"type\":\"::\"}],\"File\":\"/var/www/nextcloud/cloud/lib/private/AppConfig.php\",\"Line\":1220,\"message\":\"The loading of lazy AppConfig values have been requested\",\"exception\":{},\"CustomMessage\":\"The loading of lazy AppConfig values have been requested\"}","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/115.0","version":"29.0.2.2"}
Jun 12 21:40:14 server-name Nextcloud[23277]: {"reqId":"LGmUuYnkAxHKR35Nvm1l","level":0,"time":"2024-06-12T19:40:14+00:00","remoteAddr":"x.x.x.x","user":"admin-nextcloud","app":"no app in context","method":"POST","url":"/cloud/index.php/apps/richdocuments/token","message":"{\"Exception\":\"RuntimeException\",\"Message\":\"ignorable exception\",\"Code\":0,\"Trace\":[{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppConfig.php\",\"line\":1206,\"function\":\"loadConfig\",\"class\":\"OC\\\\AppConfig\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppConfig.php\",\"line\":127,\"function\":\"loadConfigAll\",\"class\":\"OC\\\\AppConfig\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AllConfig.php\",\"line\":196,\"function\":\"getKeys\",\"class\":\"OC\\\\AppConfig\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/user_ldap/lib/Helper.php\",\"line\":133,\"function\":\"getAppKeys\",\"class\":\"OC\\\\AllConfig\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/user_ldap/lib/Helper.php\",\"line\":74,\"function\":\"getServersConfig\",\"class\":\"OCA\\\\User_LDAP\\\\Helper\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/user_ldap/lib/AppInfo/Application.php\",\"line\":133,\"function\":\"getServerConfigurationPrefixes\",\"class\":\"OCA\\\\User_LDAP\\\\Helper\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppFramework/Bootstrap/FunctionInjector.php\",\"line\":66,\"function\":\"OCA\\\\User_LDAP\\\\AppInfo\\\\{closure}\",\"class\":\"OCA\\\\User_LDAP\\\\AppInfo\\\\Application\",\"type\":\"->\",\"args\":[\"*** sensitive parameters replaced ***\"]},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppFramework/Bootstrap/BootContext.php\",\"line\":50,\"function\":\"injectFn\",\"class\":\"OC\\\\AppFramework\\\\Bootstrap\\\\FunctionInjector\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/user_ldap/lib/AppInfo/Application.php\",\"line\":147,\"function\":\"injectFn\",\"class\":\"OC\\\\AppFramework\\\\Bootstrap\\\\BootContext\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppFramework/Bootstrap/Coordinator.php\",\"line\":200,\"function\":\"boot\",\"class\":\"OCA\\\\User_LDAP\\\\AppInfo\\\\Application\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/App/AppManager.php\",\"line\":437,\"function\":\"bootApp\",\"class\":\"OC\\\\AppFramework\\\\Bootstrap\\\\Coordinator\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/App/AppManager.php\",\"line\":216,\"function\":\"loadApp\",\"class\":\"OC\\\\App\\\\AppManager\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/legacy/OC_App.php\",\"line\":128,\"function\":\"loadApps\",\"class\":\"OC\\\\App\\\\AppManager\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/base.php\",\"line\":1022,\"function\":\"loadApps\",\"class\":\"OC_App\",\"type\":\"::\"},{\"file\":\"/var/www/nextcloud/cloud/index.php\",\"line\":49,\"function\":\"handleRequest\",\"class\":\"OC\",\"type\":\"::\"}],\"File\":\"/var/www/nextcloud/cloud/lib/private/AppConfig.php\",\"Line\":1220,\"message\":\"The loading of lazy AppConfig values have been requested\",\"exception\":{},\"CustomMessage\":\"The loading of lazy AppConfig values have been requested\"}","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/115.0","version":"29.0.2.2"}
Jun 12 21:40:14 server-name Nextcloud[23277]: {"reqId":"LGmUuYnkAxHKR35Nvm1l","level":3,"time":"2024-06-12T19:40:14+00:00","remoteAddr":"x.x.x.x","user":"admin-nextcloud","app":"richdocuments","method":"POST","url":"/cloud/index.php/apps/richdocuments/token","message":"{\"Exception\":\"OC\\\\DB\\\\Exceptions\\\\DbalException\",\"Message\":\"An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'template_destination' in 'field list'\",\"Code\":1054,\"Trace\":[{\"file\":\"/var/www/nextcloud/cloud/lib/private/DB/QueryBuilder/QueryBuilder.php\",\"line\":328,\"function\":\"wrap\",\"class\":\"OC\\\\DB\\\\Exceptions\\\\DbalException\",\"type\":\"::\"},{\"file\":\"/var/www/nextcloud/cloud/lib/public/AppFramework/Db/QBMapper.php\",\"line\":137,\"function\":\"executeStatement\",\"class\":\"OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/richdocuments/lib/Db/WopiMapper.php\",\"line\":97,\"function\":\"insert\",\"class\":\"OCP\\\\AppFramework\\\\Db\\\\QBMapper\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/richdocuments/lib/TokenManager.php\",\"line\":203,\"function\":\"generateFileToken\",\"class\":\"OCA\\\\Richdocuments\\\\Db\\\\WopiMapper\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/richdocuments/lib/Controller/DocumentController.php\",\"line\":476,\"function\":\"generateWopiToken\",\"class\":\"OCA\\\\Richdocuments\\\\TokenManager\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/richdocuments/lib/Controller/DocumentController.php\",\"line\":384,\"function\":\"getToken\",\"class\":\"OCA\\\\Richdocuments\\\\Controller\\\\DocumentController\",\"type\":\"->\",\"args\":[\"*** sensitive parameters replaced ***\"]},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppFramework/Http/Dispatcher.php\",\"line\":232,\"function\":\"token\",\"class\":\"OCA\\\\Richdocuments\\\\Controller\\\\DocumentController\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppFramework/Http/Dispatcher.php\",\"line\":138,\"function\":\"executeController\",\"class\":\"OC\\\\AppFramework\\\\Http\\\\Dispatcher\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppFramework/App.php\",\"line\":184,\"function\":\"dispatch\",\"class\":\"OC\\\\AppFramework\\\\Http\\\\Dispatcher\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/Route/Router.php\",\"line\":338,\"function\":\"main\",\"class\":\"OC\\\\AppFramework\\\\App\",\"type\":\"::\"},{\"file\":\"/var/www/nextcloud/cloud/lib/base.php\",\"line\":1050,\"function\":\"match\",\"class\":\"OC\\\\Route\\\\Router\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/index.php\",\"line\":49,\"function\":\"handleRequest\",\"class\":\"OC\",\"type\":\"::\"}],\"File\":\"/var/www/nextcloud/cloud/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 'template_destination' in 'field list'\",\"Code\":1054,\"Trace\":[{\"file\":\"/var/www/nextcloud/cloud/3rdparty/doctrine/dbal/src/Connection.php\",\"line\":1943,\"function\":\"convert\",\"class\":\"Doctrine\\\\DBAL\\\\Driver\\\\API\\\\MySQL\\\\ExceptionConverter\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/3rdparty/doctrine/dbal/src/Connection.php\",\"line\":1885,\"function\":\"handleDriverException\",\"class\":\"Doctrine\\\\DBAL\\\\Connection\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/3rdparty/doctrine/dbal/src/Connection.php\",\"line\":1213,\"function\":\"convertExceptionDuringQuery\",\"class\":\"Doctrine\\\\DBAL\\\\Connection\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php\",\"line\":292,\"function\":\"executeStatement\",\"class\":\"Doctrine\\\\DBAL\\\\Connection\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/DB/Connection.php\",\"line\":373,\"function\":\"executeStatement\",\"class\":\"Doctrine\\\\DBAL\\\\Connections\\\\PrimaryReadReplicaConnection\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php\",\"line\":393,\"function\":\"executeStatement\",\"class\":\"OC\\\\DB\\\\Connection\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/DB/QueryBuilder/QueryBuilder.php\",\"line\":280,\"function\":\"execute\",\"class\":\"Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/DB/QueryBuilder/QueryBuilder.php\",\"line\":326,\"function\":\"execute\",\"class\":\"OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/public/AppFramework/Db/QBMapper.php\",\"line\":137,\"function\":\"executeStatement\",\"class\":\"OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/richdocuments/lib/Db/WopiMapper.php\",\"line\":97,\"function\":\"insert\",\"class\":\"OCP\\\\AppFramework\\\\Db\\\\QBMapper\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/richdocuments/lib/TokenManager.php\",\"line\":203,\"function\":\"generateFileToken\",\"class\":\"OCA\\\\Richdocuments\\\\Db\\\\WopiMapper\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/richdocuments/lib/Controller/DocumentController.php\",\"line\":476,\"function\":\"generateWopiToken\",\"class\":\"OCA\\\\Richdocuments\\\\TokenManager\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/richdocuments/lib/Controller/DocumentController.php\",\"line\":384,\"function\":\"getToken\",\"class\":\"OCA\\\\Richdocuments\\\\Controller\\\\DocumentController\",\"type\":\"->\",\"args\":[\"*** sensitive parameters replaced ***\"]},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppFramework/Http/Dispatcher.php\",\"line\":232,\"function\":\"token\",\"class\":\"OCA\\\\Richdocuments\\\\Controller\\\\DocumentController\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppFramework/Http/Dispatcher.php\",\"line\":138,\"function\":\"executeController\",\"class\":\"OC\\\\AppFramework\\\\Http\\\\Dispatcher\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppFramework/App.php\",\"line\":184,\"function\":\"dispatch\",\"class\":\"OC\\\\AppFramework\\\\Http\\\\Dispatcher\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/Route/Router.php\",\"line\":338,\"function\":\"main\",\"class\":\"OC\\\\AppFramework\\\\App\",\"type\":\"::\"},{\"file\":\"/var/www/nextcloud/cloud/lib/base.php\",\"line\":1050,\"function\":\"match\",\"class\":\"OC\\\\Route\\\\Router\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/index.php\",\"line\":49,\"function\":\"handleRequest\",\"class\":\"OC\",\"type\":\"::\"}],\"File\":\"/var/www/nextcloud/cloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php\",\"Line\":67,\"Previous\":{\"Exception\":\"Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\Exception\",\"Message\":\"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'template_destination' in 'field list'\",\"Code\":1054,\"Trace\":[{\"file\":\"/var/www/nextcloud/cloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php\",\"line\":132,\"function\":\"new\",\"class\":\"Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\Exception\",\"type\":\"::\"},{\"file\":\"/var/www/nextcloud/cloud/3rdparty/doctrine/dbal/src/Connection.php\",\"line\":1207,\"function\":\"execute\",\"class\":\"Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\Statement\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php\",\"line\":292,\"function\":\"executeStatement\",\"class\":\"Doctrine\\\\DBAL\\\\Connection\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/DB/Connection.php\",\"line\":373,\"function\":\"executeStatement\",\"class\":\"Doctrine\\\\DBAL\\\\Connections\\\\PrimaryReadReplicaConnection\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/3rdparty/doctrine/d
Jun 12 21:40:14 server-name Nextcloud[23278]: {"reqId":"yniFZI0J6mZCvMLjCvjP","level":0,"time":"2024-06-12T19:40:14+00:00","remoteAddr":"x.x.x.x","user":"admin-nextcloud","app":"no app in context","method":"GET","url":"/cloud/apps/files/api/v1/views","message":"{\"Exception\":\"RuntimeException\",\"Message\":\"ignorable exception\",\"Code\":0,\"Trace\":[{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppConfig.php\",\"line\":1206,\"function\":\"loadConfig\",\"class\":\"OC\\\\AppConfig\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppConfig.php\",\"line\":127,\"function\":\"loadConfigAll\",\"class\":\"OC\\\\AppConfig\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AllConfig.php\",\"line\":196,\"function\":\"getKeys\",\"class\":\"OC\\\\AppConfig\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/user_ldap/lib/Helper.php\",\"line\":133,\"function\":\"getAppKeys\",\"class\":\"OC\\\\AllConfig\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/user_ldap/lib/Helper.php\",\"line\":74,\"function\":\"getServersConfig\",\"class\":\"OCA\\\\User_LDAP\\\\Helper\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/user_ldap/lib/AppInfo/Application.php\",\"line\":133,\"function\":\"getServerConfigurationPrefixes\",\"class\":\"OCA\\\\User_LDAP\\\\Helper\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppFramework/Bootstrap/FunctionInjector.php\",\"line\":66,\"function\":\"OCA\\\\User_LDAP\\\\AppInfo\\\\{closure}\",\"class\":\"OCA\\\\User_LDAP\\\\AppInfo\\\\Application\",\"type\":\"->\",\"args\":[\"*** sensitive parameters replaced ***\"]},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppFramework/Bootstrap/BootContext.php\",\"line\":50,\"function\":\"injectFn\",\"class\":\"OC\\\\AppFramework\\\\Bootstrap\\\\FunctionInjector\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/user_ldap/lib/AppInfo/Application.php\",\"line\":147,\"function\":\"injectFn\",\"class\":\"OC\\\\AppFramework\\\\Bootstrap\\\\BootContext\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppFramework/Bootstrap/Coordinator.php\",\"line\":200,\"function\":\"boot\",\"class\":\"OCA\\\\User_LDAP\\\\AppInfo\\\\Application\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/App/AppManager.php\",\"line\":437,\"function\":\"bootApp\",\"class\":\"OC\\\\AppFramework\\\\Bootstrap\\\\Coordinator\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/App/AppManager.php\",\"line\":216,\"function\":\"loadApp\",\"class\":\"OC\\\\App\\\\AppManager\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/legacy/OC_App.php\",\"line\":128,\"function\":\"loadApps\",\"class\":\"OC\\\\App\\\\AppManager\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/base.php\",\"line\":1022,\"function\":\"loadApps\",\"class\":\"OC_App\",\"type\":\"::\"},{\"file\":\"/var/www/nextcloud/cloud/index.php\",\"line\":49,\"function\":\"handleRequest\",\"class\":\"OC\",\"type\":\"::\"}],\"File\":\"/var/www/nextcloud/cloud/lib/private/AppConfig.php\",\"Line\":1220,\"message\":\"The loading of lazy AppConfig values have been requested\",\"exception\":{},\"CustomMessage\":\"The loading of lazy AppConfig values have been requested\"}","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/115.0","version":"29.0.2.2"}
Jun 12 21:40:15 server-name Nextcloud[23278]: {"reqId":"ViC0sTPRddsuZhBt9OET","level":0,"time":"2024-06-12T19:40:15+00:00","remoteAddr":"x.x.x.x","user":"admin-nextcloud","app":"no app in context","method":"GET","url":"/cloud/index.php/apps/files/preview-service-worker.js","message":"{\"Exception\":\"RuntimeException\",\"Message\":\"ignorable exception\",\"Code\":0,\"Trace\":[{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppConfig.php\",\"line\":1206,\"function\":\"loadConfig\",\"class\":\"OC\\\\AppConfig\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppConfig.php\",\"line\":127,\"function\":\"loadConfigAll\",\"class\":\"OC\\\\AppConfig\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AllConfig.php\",\"line\":196,\"function\":\"getKeys\",\"class\":\"OC\\\\AppConfig\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/user_ldap/lib/Helper.php\",\"line\":133,\"function\":\"getAppKeys\",\"class\":\"OC\\\\AllConfig\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/user_ldap/lib/Helper.php\",\"line\":74,\"function\":\"getServersConfig\",\"class\":\"OCA\\\\User_LDAP\\\\Helper\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/user_ldap/lib/AppInfo/Application.php\",\"line\":133,\"function\":\"getServerConfigurationPrefixes\",\"class\":\"OCA\\\\User_LDAP\\\\Helper\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppFramework/Bootstrap/FunctionInjector.php\",\"line\":66,\"function\":\"OCA\\\\User_LDAP\\\\AppInfo\\\\{closure}\",\"class\":\"OCA\\\\User_LDAP\\\\AppInfo\\\\Application\",\"type\":\"->\",\"args\":[\"*** sensitive parameters replaced ***\"]},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppFramework/Bootstrap/BootContext.php\",\"line\":50,\"function\":\"injectFn\",\"class\":\"OC\\\\AppFramework\\\\Bootstrap\\\\FunctionInjector\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/apps/user_ldap/lib/AppInfo/Application.php\",\"line\":147,\"function\":\"injectFn\",\"class\":\"OC\\\\AppFramework\\\\Bootstrap\\\\BootContext\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/AppFramework/Bootstrap/Coordinator.php\",\"line\":200,\"function\":\"boot\",\"class\":\"OCA\\\\User_LDAP\\\\AppInfo\\\\Application\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/App/AppManager.php\",\"line\":437,\"function\":\"bootApp\",\"class\":\"OC\\\\AppFramework\\\\Bootstrap\\\\Coordinator\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/App/AppManager.php\",\"line\":216,\"function\":\"loadApp\",\"class\":\"OC\\\\App\\\\AppManager\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/private/legacy/OC_App.php\",\"line\":128,\"function\":\"loadApps\",\"class\":\"OC\\\\App\\\\AppManager\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/cloud/lib/base.php\",\"line\":1022,\"function\":\"loadApps\",\"class\":\"OC_App\",\"type\":\"::\"},{\"file\":\"/var/www/nextcloud/cloud/index.php\",\"line\":49,\"function\":\"handleRequest\",\"class\":\"OC\",\"type\":\"::\"}],\"File\":\"/var/www/nextcloud/cloud/lib/private/AppConfig.php\",\"Line\":1220,\"message\":\"The loading of lazy AppConfig values have been requested\",\"exception\":{},\"CustomMessage\":\"The loading of lazy AppConfig values have been requested\"}","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/115.0","version":"29.0.2.2"}
joshtrichards commented 5 months ago

Any chance the database was restored at some point to an older snapshot or something?

Your database tables do not match up with the current app version from the sounds of it.

You can try running NC_debug=1 ./occ migrations:status richdocuments to see what the state of the db migrations are, but my guess is it'll say everything is up-to-date.

Do you have your Nextcloud log from when you first installed the richdocuments app?

What's the history of this installation? How did you install the richdocuments app?

CVZ-es commented 5 months ago

Hi Joshtrichards,

Thanks fo your reply.

Any chance the database was restored at some point to an older snapshot or something? No but it was migrated from owncloud few years ago, and probably had in that time richdocuments

You can try running NC_debug=1 ./occ migrations:status richdocuments to see what the state of the db migrations are, but my guess is it'll say everything is up-to-date. I have this message: There are no commands defined in the "migrations" namespace.

Do you have your Nextcloud log from when you first installed the richdocuments app? No sorry

What's the history of this installation? How did you install the richdocuments app? I installed from web administration console, but I was probably installed in a past life.

I guess, it would be a better idea to resintall the app. I have found this in a 2020 post, is it still valid?

disable app
remove app folder
run the following sql statements:
drop table oc_richdocuments_direct;
drop table oc_richdocuments_wopi;
drop table oc_richdocuments_assets;
delete from oc_migrations where app='richdocuments';
reinstall the app

Thanks for your reply

Best Dami

CVZ-es commented 5 months ago

Hi Joshtrichards,

I have finally reinstalled the app, and droped all the old tables, I have reinstalled from command line, and everything is working fine now :-)

Here is the process (there was an extra oc_richdocuments_template table)

disable app remove app folder run the following sql statements: drop table oc_richdocuments_direct; drop table oc_richdocuments_wopi; drop table oc_richdocuments_assets; drop table oc_richdocuments_template delete from oc_migrations where app='richdocuments'; reinstall the app

Thank you so much for your help;-) Best Dami