search

nextcloud / tables

🍱 Nextcloud tables app
https://apps.nextcloud.com/apps/tables
GNU Affero General Public License v3.0
143 stars 24 forks source link

Vacation Request template broken #948

Closed enjeck closed 5 months ago

enjeck commented 6 months ago

Steps to reproduce

  1. Create a Table with the "Vacation Request" template
  2. Open the first view "Create Vacation Request"

Expected behavior

Rows should load properly

Actual behavior

Error thrown "Could not load rows. Unknown error."

Tables app version

No response

Browser

No response

Client operating system

No response

Operating system

No response

Web server

None

PHP engine version

None

Database

None

Additional info

Error Trace {"reqId":"FgQq7X01jP0JDzdoYu27","level":3,"time":"2024-03-22T12:11:09+00:00","remoteAddr":"192.168.21.5","user":"admin","app":"tables","method":"GET","url":"/index.php/apps/tables/table","message":"No column found to build filter with for id -2","userAgent":"Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36","version":"29.0.0.5","exception":{"Exception":"OCA\\Tables\\Errors\\InternalError","Message":"No column found to build filter with for id -2","Code":0,"Trace":[{"file":"/var/www/html/apps/tables/lib/Db/Row2Mapper.php","line":263,"function":"getFilter","class":"OCA\\Tables\\Db\\Row2Mapper","type":"->","args":[["OC\\DB\\QueryBuilder\\QueryBuilder"],[[-2,"is-equal","admin"],[20,"is-empty",""]]]},{"file":"/var/www/html/apps/tables/lib/Db/Row2Mapper.php","line":241,"function":"getFilterGroups","class":"OCA\\Tables\\Db\\Row2Mapper","type":"->","args":[["OC\\DB\\QueryBuilder\\QueryBuilder"],[[[-2,"is-equal","admin"],[20,"is-empty",""]]]]},{"file":"/var/www/html/apps/tables/lib/Db/Row2Mapper.php","line":143,"function":"addFilterToQuery","class":"OCA\\Tables\\Db\\Row2Mapper","type":"->","args":[["OC\\DB\\QueryBuilder\\QueryBuilder"],[[[-2,"is-equal","admin"],[20,"is-empty",""]]],"admin"]},{"file":"/var/www/html/apps/tables/lib/Db/Row2Mapper.php","line":827,"function":"getWantedRowIds","class":"OCA\\Tables\\Db\\Row2Mapper","type":"->","args":["admin",4,[[[-2,"is-equal","@my-name"],[20,"is-empty",""]]]]},{"file":"/var/www/html/apps/tables/lib/Service/RowService.php","line":516,"function":"countRowsForView","class":"OCA\\Tables\\Db\\Row2Mapper","type":"->","args":[["OCA\\Tables\\Db\\View",1],"admin",[["OCA\\Tables\\Db\\Column",15],["OCA\\Tables\\Db\\Column",16],["OCA\\Tables\\Db\\Column",17],["OCA\\Tables\\Db\\Column",18],["OCA\\Tables\\Db\\Column",19],"And 4 more entries, set log level to debug to see all entries"]]},{"file":"/var/www/html/apps/tables/lib/Service/ViewService.php","line":372,"function":"getViewRowsCount","class":"OCA\\Tables\\Service\\RowService","type":"->","args":[["OCA\\Tables\\Db\\View",1],"admin"]},{"file":"/var/www/html/apps/tables/lib/Service/ViewService.php","line":81,"function":"enhanceView","class":"OCA\\Tables\\Service\\ViewService","type":"->","args":[["OCA\\Tables\\Db\\View",1],"admin"]},{"file":"/var/www/html/apps/tables/lib/Service/TableService.php","line":203,"function":"findAll","class":"OCA\\Tables\\Service\\ViewService","type":"->","args":[["OCA\\Tables\\Db\\Table",4]]},{"file":"/var/www/html/apps/tables/lib/Service/TableService.php","line":130,"function":"enhanceTable","class":"OCA\\Tables\\Service\\TableService","type":"->","args":[["OCA\\Tables\\Db\\Table",4],"admin"]},{"file":"/var/www/html/apps/tables/lib/Controller/TableController.php","line":39,"function":"findAll","class":"OCA\\Tables\\Service\\TableService","type":"->","args":["admin"]},{"file":"/var/www/html/apps/tables/lib/Controller/Errors.php","line":16,"function":"OCA\\Tables\\Controller\\{closure}","class":"OCA\\Tables\\Controller\\TableController","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/tables/lib/Controller/TableController.php","line":40,"function":"handleError","class":"OCA\\Tables\\Controller\\TableController","type":"->","args":[["Closure"]]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"index","class":"OCA\\Tables\\Controller\\TableController","type":"->","args":[]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Tables\\Controller\\TableController"],"index"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Tables\\Controller\\TableController"],"index"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Tables\\Controller\\TableController","index",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["tables.table.index"]]},{"file":"/var/www/html/lib/base.php","line":1069,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/tables/table"]},{"file":"/var/www/html/index.php","line":39,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/apps/tables/lib/Db/Row2Mapper.php","Line":276,"message":"No column found to build filter with for id -2","exception":{"xdebug_message":null},"CustomMessage":"No column found to build filter with for id -2"}} master-nextcloud-1 | {"reqId":"FgQq7X01jP0JDzdoYu27","level":3,"time":"2024-03-22T12:11:09+00:00","remoteAddr":"192.168.21.5","user":"admin","app":"tables","method":"GET","url":"/index.php/apps/tables/table","message":"No column found to build filter with for id -2","userAgent":"Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36","version":"29.0.0.5","exception":{"Exception":"OCA\\Tables\\Errors\\InternalError","Message":"No column found to build filter with for id -2","Code":0,"Trace":[{"file":"/var/www/html/apps/tables/lib/Db/Row2Mapper.php","line":263,"function":"getFilter","class":"OCA\\Tables\\Db\\Row2Mapper","type":"->","args":[["OC\\DB\\QueryBuilder\\QueryBuilder"],[[-2,"is-equal","admin"]]]},{"file":"/var/www/html/apps/tables/lib/Db/Row2Mapper.php","line":241,"function":"getFilterGroups","class":"OCA\\Tables\\Db\\Row2Mapper","type":"->","args":[["OC\\DB\\QueryBuilder\\QueryBuilder"],[[[-2,"is-equal","admin"]]]]},{"file":"/var/www/html/apps/tables/lib/Db/Row2Mapper.php","line":143,"function":"addFilterToQuery","class":"OCA\\Tables\\Db\\Row2Mapper","type":"->","args":[["OC\\DB\\QueryBuilder\\QueryBuilder"],[[[-2,"is-equal","admin"]]],"admin"]},{"file":"/var/www/html/apps/tables/lib/Db/Row2Mapper.php","line":827,"function":"getWantedRowIds","class":"OCA\\Tables\\Db\\Row2Mapper","type":"->","args":["admin",4,[[[-2,"is-equal","@my-name"]]]]},{"file":"/var/www/html/apps/tables/lib/Service/RowService.php","line":516,"function":"countRowsForView","class":"OCA\\Tables\\Db\\Row2Mapper","type":"->","args":[["OCA\\Tables\\Db\\View",3],"admin",[["OCA\\Tables\\Db\\Column",15],["OCA\\Tables\\Db\\Column",16],["OCA\\Tables\\Db\\Column",17],["OCA\\Tables\\Db\\Column",18],["OCA\\Tables\\Db\\Column",19],"And 4 more entries, set log level to debug to see all entries"]]},{"file":"/var/www/html/apps/tables/lib/Service/ViewService.php","line":372,"function":"getViewRowsCount","class":"OCA\\Tables\\Service\\RowService","type":"->","args":[["OCA\\Tables\\Db\\View",3],"admin"]},{"file":"/var/www/html/apps/tables/lib/Service/ViewService.php","line":81,"function":"enhanceView","class":"OCA\\Tables\\Service\\ViewService","type":"->","args":[["OCA\\Tables\\Db\\View",3],"admin"]},{"file":"/var/www/html/apps/tables/lib/Service/TableService.php","line":203,"function":"findAll","class":"OCA\\Tables\\Service\\ViewService","type":"->","args":[["OCA\\Tables\\Db\\Table",4]]},{"file":"/var/www/html/apps/tables/lib/Service/TableService.php","line":130,"function":"enhanceTable","class":"OCA\\Tables\\Service\\TableService","type":"->","args":[["OCA\\Tables\\Db\\Table",4],"admin"]},{"file":"/var/www/html/apps/tables/lib/Controller/TableController.php","line":39,"function":"findAll","class":"OCA\\Tables\\Service\\TableService","type":"->","args":["admin"]},{"file":"/var/www/html/apps/tables/lib/Controller/Errors.php","line":16,"function":"OCA\\Tables\\Controller\\{closure}","class":"OCA\\Tables\\Controller\\TableController","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/tables/lib/Controller/TableController.php","line":40,"function":"handleError","class":"OCA\\Tables\\Controller\\TableController","type":"->","args":[["Closure"]]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"index","class":"OCA\\Tables\\Controller\\TableController","type":"->","args":[]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Tables\\Controller\\TableController"],"index"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Tables\\Controller\\TableController"],"index"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Tables\\Controller\\TableController","index",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["tables.table.index"]]},{"file":"/var/www/html/lib/base.php","line":1069,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/tables/table"]},{"file":"/var/www/html/index.php","line":39,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/apps/tables/lib/Db/Row2Mapper.php","Line":276,"message":"No column found to build filter with for id -2","exception":{"xdebug_message":null},"CustomMessage":"No column found to build filter with for id -2"}} master-nextcloud-1 | {"reqId":"FgQq7X01jP0JDzdoYu27","level":3,"time":"2024-03-22T12:11:09+00:00","remoteAddr":"192.168.21.5","user":"admin","app":"tables","method":"GET","url":"/index.php/apps/tables/table","message":"No column found to build filter with for id -2","userAgent":"Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36","version":"29.0.0.5","exception":{"Exception":"OCA\\Tables\\Errors\\InternalError","Message":"No column found to build filter with for id -2","Code":0,"Trace":[{"file":"/var/www/html/apps/tables/lib/Db/Row2Mapper.php","line":263,"function":"getFilter","class":"OCA\\Tables\\Db\\Row2Mapper","type":"->","args":[["OC\\DB\\QueryBuilder\\QueryBuilder"],[[-2,"is-equal","admin"],[29,"is-empty",""]]]},{"file":"/var/www/html/apps/tables/lib/Db/Row2Mapper.php","line":241,"function":"getFilterGroups","class":"OCA\\Tables\\Db\\Row2Mapper","type":"->","args":[["OC\\DB\\QueryBuilder\\QueryBuilder"],[[[-2,"is-equal","admin"],[29,"is-empty",""]]]]},{"file":"/var/www/html/apps/tables/lib/Db/Row2Mapper.php","line":143,"function":"addFilterToQuery","class":"OCA\\Tables\\Db\\Row2Mapper","type":"->","args":[["OC\\DB\\QueryBuilder\\QueryBuilder"],[[[-2,"is-equal","admin"],[29,"is-empty",""]]],"admin"]},{"file":"/var/www/html/apps/tables/lib/Db/Row2Mapper.php","line":827,"function":"getWantedRowIds","class":"OCA\\Tables\\Db\\Row2Mapper","type":"->","args":["admin",5,[[[-2,"is-equal","@my-name"],[29,"is-empty",""]]]]},{"file":"/var/www/html/apps/tables/lib/Service/RowService.php","line":516,"function":"countRowsForView","class":"OCA\\Tables\\Db\\Row2Mapper","type":"->","args":[["OCA\\Tables\\Db\\View",5],"admin",[["OCA\\Tables\\Db\\Column",24],["OCA\\Tables\\Db\\Column",25],["OCA\\Tables\\Db\\Column",26],["OCA\\Tables\\Db\\Column",27],["OCA\\Tables\\Db\\Column",28],"And 4 more entries, set log level to debug to see all entries"]]},{"file":"/var/www/html/apps/tables/lib/Service/ViewService.php","line":372,"function":"getViewRowsCount","class":"OCA\\Tables\\Service\\RowService","type":"->","args":[["OCA\\Tables\\Db\\View",5],"admin"]},{"file":"/var/www/html/apps/tables/lib/Service/ViewService.php","line":81,"function":"enhanceView","class":"OCA\\Tables\\Service\\ViewService","type":"->","args":[["OCA\\Tables\\Db\\View",5],"admin"]},{"file":"/var/www/html/apps/tables/lib/Service/TableService.php","line":203,"function":"findAll","class":"OCA\\Tables\\Service\\ViewService","type":"->","args":[["OCA\\Tables\\Db\\Table",5]]},{"file":"/var/www/html/apps/tables/lib/Service/TableService.php","line":130,"function":"enhanceTable","class":"OCA\\Tables\\Service\\TableService","type":"->","args":[["OCA\\Tables\\Db\\Table",5],"admin"]},{"file":"/var/www/html/apps/tables/lib/Controller/TableController.php","line":39,"function":"findAll","class":"OCA\\Tables\\Service\\TableService","type":"->","args":["admin"]},{"file":"/var/www/html/apps/tables/lib/Controller/Errors.php","line":16,"function":"OCA\\Tables\\Controller\\{closure}","class":"OCA\\Tables\\Controller\\TableController","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/tables/lib/Controller/TableController.php","line":40,"function":"handleError","class":"OCA\\Tables\\Controller\\TableController","type":"->","args":[["Closure"]]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"index","class":"OCA\\Tables\\Controller\\TableController","type":"->","args":[]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Tables\\Controller\\TableController"],"index"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Tables\\Controller\\TableController"],"index"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Tables\\Controller\\TableController","index",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["tables.table.index"]]},{"file":"/var/www/html/lib/base.php","line":1069,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/tables/table"]},{"file":"/var/www/html/index.php","line":39,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/apps/tables/lib/Db/Row2Mapper.php","Line":276,"message":"No column found to build filter with for id -2","exception":{"xdebug_message":null},"CustomMessage":"No column found to build filter with for id -2"}} master-nextcloud-1 | {"reqId":"FgQq7X01jP0JDzdoYu27","level":3,"time":"2024-03-22T12:11:09+00:00","remoteAddr":"192.168.21.5","user":"admin","app":"tables","method":"GET","url":"/index.php/apps/tables/table","message":"No column found to build filter with for id -2","userAgent":"Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36","version":"29.0.0.5","exception":{"Exception":"OCA\\Tables\\Errors\\InternalError","Message":"No column found to build filter with for id -2","Code":0,"Trace":[{"file":"/var/www/html/apps/tables/lib/Db/Row2Mapper.php","line":263,"function":"getFilter","class":"OCA\\Tables\\Db\\Row2Mapper","type":"->","args":[["OC\\DB\\QueryBuilder\\QueryBuilder"],[[-2,"is-equal","admin"]]]},{"file":"/var/www/html/apps/tables/lib/Db/Row2Mapper.php","line":241,"function":"getFilterGroups","class":"OCA\\Tables\\Db\\Row2Mapper","type":"->","args":[["OC\\DB\\QueryBuilder\\QueryBuilder"],[[[-2,"is-equal","admin"]]]]},{"file":"/var/www/html/apps/tables/lib/Db/Row2Mapper.php","line":143,"function":"addFilterToQuery","class":"OCA\\Tables\\Db\\Row2Mapper","type":"->","args":[["OC\\DB\\QueryBuilder\\QueryBuilder"],[[[-2,"is-equal","admin"]]],"admin"]},{"file":"/var/www/html/apps/tables/lib/Db/Row2Mapper.php","line":827,"function":"getWantedRowIds","class":"OCA\\Tables\\Db\\Row2Mapper","type":"->","args":["admin",5,[[[-2,"is-equal","@my-name"]]]]},{"file":"/var/www/html/apps/tables/lib/Service/RowService.php","line":516,"function":"countRowsForView","class":"OCA\\Tables\\Db\\Row2Mapper","type":"->","args":[["OCA\\Tables\\Db\\View",7],"admin",[["OCA\\Tables\\Db\\Column",24],["OCA\\Tables\\Db\\Column",25],["OCA\\Tables\\Db\\Column",26],["OCA\\Tables\\Db\\Column",27],["OCA\\Tables\\Db\\Column",28],"And 4 more entries, set log level to debug to see all entries"]]},{"file":"/var/www/html/apps/tables/lib/Service/ViewService.php","line":372,"function":"getViewRowsCount","class":"OCA\\Tables\\Service\\RowService","type":"->","args":[["OCA\\Tables\\Db\\View",7],"admin"]},{"file":"/var/www/html/apps/tables/lib/Service/ViewService.php","line":81,"function":"enhanceView","class":"OCA\\Tables\\Service\\ViewService","type":"->","args":[["OCA\\Tables\\Db\\View",7],"admin"]},{"file":"/var/www/html/apps/tables/lib/Service/TableService.php","line":203,"function":"findAll","class":"OCA\\Tables\\Service\\ViewService","type":"->","args":[["OCA\\Tables\\Db\\Table",5]]},{"file":"/var/www/html/apps/tables/lib/Service/TableService.php","line":130,"function":"enhanceTable","class":"OCA\\Tables\\Service\\TableService","type":"->","args":[["OCA\\Tables\\Db\\Table",5],"admin"]},{"file":"/var/www/html/apps/tables/lib/Controller/TableController.php","line":39,"function":"findAll","class":"OCA\\Tables\\Service\\TableService","type":"->","args":["admin"]},{"file":"/var/www/html/apps/tables/lib/Controller/Errors.php","line":16,"function":"OCA\\Tables\\Controller\\{closure}","class":"OCA\\Tables\\Controller\\TableController","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/tables/lib/Controller/TableController.php","line":40,"function":"handleError","class":"OCA\\Tables\\Controller\\TableController","type":"->","args":[["Closure"]]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"index","class":"OCA\\Tables\\Controller\\TableController","type":"->","args":[]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Tables\\Controller\\TableController"],"index"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Tables\\Controller\\TableController"],"index"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Tables\\Controller\\TableController","index",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["tables.table.index"]]},{"file":"/var/www/html/lib/base.php","line":1069,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/tables/table"]},{"file":"/var/www/html/index.php","line":39,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/apps/tables/lib/Db/Row2Mapper.php","Line":276,"message":"No column found to build filter with for id -2","exception":{"xdebug_message":null},"CustomMessage":"No column found to build filter with for id -2"}}
enjeck commented 5 months ago

There's a problem when updating too

1024-493