{"reqId":"yt4Jd46UXnrCNikmD9LP","level":3,"time":"2026-03-30T06:19:09+00:00","remoteAddr":"192.168.62.1","user":"pixi","app":"deck","method":"POST","url":"/apps/deck/cards/550/assign","scriptName":"/index.php","message":"An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR: column \"type\" of relation \"oc_deck_assigned_users\" does not exist\nLINE 1: ...c_deck_assigned_users\" (\"card_id\", \"participant\", \"type\") VA...\n ^","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36 Edg/146.0.0.0","version":"32.0.7.1","exception":{"Exception":"OC\\DB\\Exceptions\\DbalException","Message":"An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR: column \"type\" of relation \"oc_deck_assigned_users\" does not exist\nLINE 1: ...c_deck_assigned_users\" (\"card_id\", \"participant\", \"type\") VA...\n ^","Code":7,"Trace":[{"file":"/data/www/nextcloud/lib/private/DB/ConnectionAdapter.php","line":69,"function":"wrap","class":"OC\\DB\\Exceptions\\DbalException","type":"::"},{"file":"/data/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":313,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/data/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":116,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/data/www/nextcloud/apps/deck/lib/Db/AssignmentMapper.php","line":117,"function":"insert","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/data/www/nextcloud/apps/deck/lib/Service/AssignmentService.php","line":137,"function":"insert","class":"OCA\\Deck\\Db\\AssignmentMapper","type":"->"},{"file":"/data/www/nextcloud/apps/deck/lib/Controller/CardController.php","line":179,"function":"assignUser","class":"OCA\\Deck\\Service\\AssignmentService","type":"->"},{"file":"/data/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":204,"function":"assignUser","class":"OCA\\Deck\\Controller\\CardController","type":"->"},{"file":"/data/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":118,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/data/www/nextcloud/lib/private/AppFramework/App.php","line":153,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/data/www/nextcloud/lib/private/Route/Router.php","line":321,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/data/www/nextcloud/lib/base.php","line":1091,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/data/www/nextcloud/index.php","line":25,"function":"handleRequest","class":"OC","type":"::"}],"File":"/data/www/nextcloud/lib/private/DB/Exceptions/DbalException.php","Line":56,"Previous":{"Exception":"Doctrine\\DBAL\\Exception\\InvalidFieldNameException","Message":"An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR: column \"type\" of relation \"oc_deck_assigned_users\" does not exist\nLINE 1: ...c_deck_assigned_users\" (\"card_id\", \"participant\", \"type\") VA...\n ^","Code":7,"Trace":[{"file":"/data/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1976,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\PostgreSQL\\ExceptionConverter","type":"->"},{"file":"/data/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1918,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/data/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1218,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/data/www/nextcloud/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/data/www/nextcloud/lib/private/DB/Connection.php","line":467,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->"},{"file":"/data/www/nextcloud/lib/private/DB/ConnectionAdapter.php","line":67,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/data/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":313,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/data/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":116,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/data/www/nextcloud/apps/deck/lib/Db/AssignmentMapper.php","line":117,"function":"insert","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/data/www/nextcloud/apps/deck/lib/Service/AssignmentService.php","line":137,"function":"insert","class":"OCA\\Deck\\Db\\AssignmentMapper","type":"->"},{"file":"/data/www/nextcloud/apps/deck/lib/Controller/CardController.php","line":179,"function":"assignUser","class":"OCA\\Deck\\Service\\AssignmentService","type":"->"},{"file":"/data/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":204,"function":"assignUser","class":"OCA\\Deck\\Controller\\CardController","type":"->"},{"file":"/data/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":118,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/data/www/nextcloud/lib/private/AppFramework/App.php","line":153,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/data/www/nextcloud/lib/private/Route/Router.php","line":321,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/data/www/nextcloud/lib/base.php","line":1091,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/data/www/nextcloud/index.php","line":25,"function":"handleRequest","class":"OC","type":"::"}],"File":"/data/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php","Line":68,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[42703]: Undefined column: 7 ERROR: column \"type\" of relation \"oc_deck_assigned_users\" does not exist\nLINE 1: ...c_deck_assigned_users\" (\"card_id\", \"participant\", \"type\") VA...\n ^","Code":7,"Trace":[{"file":"/data/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":132,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::"},{"file":"/data/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1212,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/data/www/nextcloud/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/data/www/nextcloud/lib/private/DB/Connection.php","line":467,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->"},{"file":"/data/www/nextcloud/lib/private/DB/ConnectionAdapter.php","line":67,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/data/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":313,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/data/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":116,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/data/www/nextcloud/apps/deck/lib/Db/AssignmentMapper.php","line":117,"function":"insert","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/data/www/nextcloud/apps/deck/lib/Service/AssignmentService.php","line":137,"function":"insert","class":"OCA\\Deck\\Db\\AssignmentMapper","type":"->"},{"file":"/data/www/nextcloud/apps/deck/lib/Controller/CardController.php","line":179,"function":"assignUser","class":"OCA\\Deck\\Service\\AssignmentService","type":"->"},{"file":"/data/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":204,"function":"assignUser","class":"OCA\\Deck\\Controller\\CardController","type":"->"},{"file":"/data/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":118,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/data/www/nextcloud/lib/private/AppFramework/App.php","line":153,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/data/www/nextcloud/lib/private/Route/Router.php","line":321,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/data/www/nextcloud/lib/base.php","line":1091,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/data/www/nextcloud/index.php","line":25,"function":"handleRequest","class":"OC","type":"::"}],"File":"/data/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":24,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[42703]: Undefined column: 7 ERROR: column \"type\" of relation \"oc_deck_assigned_users\" does not exist\nLINE 1: ...c_deck_assigned_users\" (\"card_id\", \"participant\", \"type\") VA...\n ^","Code":"42703","Trace":[{"file":"/data/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":130,"function":"execute","class":"PDOStatement","type":"->"},{"file":"/data/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1212,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/data/www/nextcloud/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/data/www/nextcloud/lib/private/DB/Connection.php","line":467,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->"},{"file":"/data/www/nextcloud/lib/private/DB/ConnectionAdapter.php","line":67,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/data/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":313,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/data/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":116,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/data/www/nextcloud/apps/deck/lib/Db/AssignmentMapper.php","line":117,"function":"insert","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/data/www/nextcloud/apps/deck/lib/Service/AssignmentService.php","line":137,"function":"insert","class":"OCA\\Deck\\Db\\AssignmentMapper","type":"->"},{"file":"/data/www/nextcloud/apps/deck/lib/Controller/CardController.php","line":179,"function":"assignUser","class":"OCA\\Deck\\Service\\AssignmentService","type":"->"},{"file":"/data/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":204,"function":"assignUser","class":"OCA\\Deck\\Controller\\CardController","type":"->"},{"file":"/data/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":118,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/data/www/nextcloud/lib/private/AppFramework/App.php","line":153,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/data/www/nextcloud/lib/private/Route/Router.php","line":321,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/data/www/nextcloud/lib/base.php","line":1091,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/data/www/nextcloud/index.php","line":25,"function":"handleRequest","class":"OC","type":"::"}],"File":"/data/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":130}}},"message":"An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR: column \"type\" of relation \"oc_deck_assigned_users\" does not exist\nLINE 1: ...c_deck_assigned_users\" (\"card_id\", \"participant\", \"type\") VA...\n ^","exception":{"query":"INSERT INTO `*PREFIX*deck_assigned_users` (`card_id`, `participant`, `type`) VALUES(:dcValue1, :dcValue2, :dcValue3)"},"CustomMessage":"An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR: column \"type\" of relation \"oc_deck_assigned_users\" does not exist\nLINE 1: ...c_deck_assigned_users\" (\"card_id\", \"participant\", \"type\") VA...\n ^"},"id":"69ca1b1b954b1"}
How to use GitHub
Bug description
It is not possible to assign a card to a user. The UI allows selecting a user, but the assignment is not persisted. After closing and reopening the card, the assignee is no longer set. The same happens when using the "Assign to me" action.
The log shows the following error message:
DbalException An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR: column "type" of relation "oc_deck_assigned_users" does not exist LINE 1: ...c_deck_assigned_users" ("card_id", "participant", "type") VA... ^To Reproduce
Steps to reproduce the behavior:
Expected behavior
The selected assignment should be saved and still be present after reopening the card.
Client details:
Server details
Operating system: Linux 5.15.0-171-generic x86_64
Web server: nginx
Database: PostgreSQL 12.18
PHP version: 8.1.2
Nextcloud version: 32.0.7
Where did you install Nextcloud from: Update via stable channel
Signing status:
List of activated apps:
Nextcloud configuration:
Are you using an external user-backend, if yes which one: No
Logs
Nextcloud log (data/nextcloud.log)
Browser log