Card assignment fails due to missing "type" column in oc_deck_assigned_users

[pixi-p]

How to use GitHub

• Please use the 👍 reaction to show that you are affected by the same issue.
• Please don't comment if you have no relevant information to add. It's just extra noise for everyone subscribed to this issue.
• Subscribe to receive notifications on status change and new comments.

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:

1. Select any card
2. Assign the card to any user
3. Close the card
4. Reopen the card

Expected behavior
The selected assignment should be saved and still be present after reopening the card.

Client details:

• OS: Windows 11
• Browser Microsoft Edge
• Version 146.0.3856.84
• Device: desktop

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:

No errors have been found.

List of activated apps:

Enabled:
  - activity: 5.0.0
  - app_api: 32.0.0
  - audioplayer: 3.8.0
  - bookmarks: 16.1.3
  - bruteforcesettings: 5.0.0
  - calendar: 6.2.1
  - circles: 32.0.0
  - cloud_federation_api: 1.16.0
  - comments: 1.22.0
  - contacts: 8.3.6
  - contactsinteraction: 1.13.1
  - cookbook: 0.11.6
  - dashboard: 7.12.0
  - dav: 1.34.2
  - deck: 1.16.3
  - dicomviewer: 2.3.2
  - drawio: 4.1.4
  - federatedfilesharing: 1.22.0
  - federation: 1.22.0
  - files: 2.4.0
  - files_accesscontrol: 3.0.2
  - files_downloadlimit: 5.0.0-dev.0
  - files_external: 1.24.1
  - files_fulltextsearch: 32.0.2
  - files_pdfviewer: 5.0.0
  - files_reminders: 1.5.0
  - files_sharing: 1.24.1
  - files_trashbin: 1.22.0
  - files_versions: 1.25.0
  - firstrunwizard: 5.0.0
  - forms: 5.2.5
  - fulltextsearch: 32.0.0
  - fulltextsearch_elasticsearch: 32.0.2
  - gpxpod: 7.2.4
  - logreader: 5.0.0
  - lookup_server_connector: 1.20.0
  - metadata: 0.23.0
  - notes: 4.13.1
  - notifications: 5.0.0
  - oauth2: 1.20.0
  - password_policy: 4.0.0
  - passwords: 2026.3.10
  - photos: 5.0.0
  - previewgenerator: 5.13.0
  - privacy: 4.0.0
  - profile: 1.1.0
  - provisioning_api: 1.22.0
  - recommendations: 5.0.0
  - related_resources: 3.0.0
  - richdocuments: 9.0.5
  - serverinfo: 4.0.0
  - settings: 1.15.1
  - sharebymail: 1.22.0
  - support: 4.0.0
  - survey_client: 4.0.0
  - systemtags: 1.22.0
  - tasks: 0.17.1
  - text: 6.0.1
  - theming: 2.7.0
  - twofactor_backupcodes: 1.21.0
  - twofactor_email: 2.8.5
  - twofactor_nextcloud_notification: 6.0.0
  - twofactor_totp: 14.0.0
  - updatenotification: 1.22.0
  - user_status: 1.12.0
  - viewer: 5.0.0
  - weather_status: 1.12.0
  - webhook_listeners: 1.3.0
  - workflowengine: 2.14.0
Disabled:
  - admin_audit: 1.22.0
  - afterlogic: 2.0.13 (installed 2.0.13)
  - duplicatefinder: 1.7.3 (installed 1.7.3)
  - encryption: 2.20.0
  - files_downloadactivity: 1.18.1 (installed 1.18.1)
  - files_markdown: 2.4.1 (installed 2.4.1)
  - files_texteditor: 2.15.1 (installed 2.15.1)
  - files_trackdownloads: 1.11.0 (installed 1.11.0)
  - groupfolders: 20.1.12 (installed 20.1.12)
  - impersonate: 3.0.1 (installed 3.0.1)
  - maps: 1.6.0 (installed 1.6.0)
  - nextcloud_announcements: 4.0.0 (installed 1.4.0)
  - quota_warning: 1.23.0 (installed 1.23.0)
  - spreed: 22.0.10 (installed 22.0.10)
  - suspicious_login: 10.0.0
  - user_ldap: 1.23.0

Nextcloud configuration:

{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            ***REMOVED SENSITIVE VALUE***
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "overwrite.cli.url": ***REMOVED SENSITIVE VALUE***,
        "dbtype": "pgsql",
        "version": "32.0.7.1",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "logtimezone": "UTC",
        "installed": true,
        "theme": "",
        "maintenance": false,
        "loglevel": 2,
        "enable_previews": true,
        "default_phone_region": "PL",
        "preview_libreoffice_path": "\/usr\/bin\/libreoffice",
        "trashbin_retention_obligation": "auto",
        "mail_smtpmode": "sendmail",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpauth": true,
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "587",
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "memcache.local": "\\OC\\Memcache\\Redis",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "filelocking.enabled": "true",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 0,
            "timeout": 0
        },
        "cache_path": "\/var\/cache\/nextcloud",
        "mysql.utf8mb4": true,
        "updater.release.channel": "stable",
        "auth.bruteforce.protection.enabled": false,
        "preview_max_x": "2048",
        "preview_max_y": "2048",
        "jpeg_quality": "60",
        "mail_sendmailmode": "smtp",
        "app_install_overwrite": [
            "dicomviewer",
            "previewgenerator",
            "ransomware_detection",
            "files_texteditor",
            "fulltextsearch_elasticsearch",
            "fulltextsearch",
            "files_fulltextsearch",
            "files_markdown",
            "files_trackdownloads",
            "duplicatefinder"
        ],
        "maintenance_window_start": 1,
        "twofactor_enforced": "true",
        "twofactor_enforced_groups": [],
        "twofactor_enforced_excluded_groups": []
    }
}

Are you using an external user-backend, if yes which one: No

Logs

Nextcloud log (data/nextcloud.log)

{"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"}

Browser log

images.js:55 [WARN] viewer: Some mimes were ignored because they are not enabled in the server previews config {app: 'viewer', uid: '****', level: 2, ignoredMimes: Array(3)}
log @ index.mjs:44
warn @ index.mjs:62
(anonymous) @ images.js:55

CardApi.js:109  POST https://**********/apps/deck/cards/550/assign 500 (Internal Server Error)
(anonymous) @ xhr.js:198
xhr @ xhr.js:15
mt @ dispatchRequest.js:51
_request @ Axios.js:185
request @ Axios.js:40
(anonymous) @ Axios.js:224
(anonymous) @ bind.js:5
assignUser @ CardApi.js:109
assignCardToUser @ card.js:344
(anonymous) @ vuex.esm.js:851
v.dispatch @ vuex.esm.js:516
dispatch @ vuex.esm.js:406
assignUserToCard @ CardSidebarTabDetails.vue:124
pn @ vue.runtime.esm.js:3033
n @ vue.runtime.esm.js:1832
pn @ vue.runtime.esm.js:3033
e.$emit @ vue.runtime.esm.js:3732
onSelect @ AssignmentSelector.vue:126
pn @ vue.runtime.esm.js:3033
n @ vue.runtime.esm.js:1832
pn @ vue.runtime.esm.js:3033
e.$emit @ vue.runtime.esm.js:3732
select @ vue-select.js:1
click @ vue-select.js:1
pn @ vue.runtime.esm.js:3033
n @ vue.runtime.esm.js:1832
i._wrapper @ vue.runtime.esm.js:7500
settle.js:19 Uncaught (in promise) K {message: 'Request failed with status code 500', name: 'AxiosError', code: 'ERR_BAD_RESPONSE', config: {…}, request: XMLHttpRequest, …}
Ye @ settle.js:19
g @ xhr.js:59
XMLHttpRequest.send
(anonymous) @ xhr.js:198
xhr @ xhr.js:15
mt @ dispatchRequest.js:51
_request @ Axios.js:185
request @ Axios.js:40
(anonymous) @ Axios.js:224
(anonymous) @ bind.js:5
assignUser @ CardApi.js:109
assignCardToUser @ card.js:344
(anonymous) @ vuex.esm.js:851
v.dispatch @ vuex.esm.js:516
dispatch @ vuex.esm.js:406
assignUserToCard @ CardSidebarTabDetails.vue:124
pn @ vue.runtime.esm.js:3033
n @ vue.runtime.esm.js:1832
pn @ vue.runtime.esm.js:3033
e.$emit @ vue.runtime.esm.js:3732
onSelect @ AssignmentSelector.vue:126
pn @ vue.runtime.esm.js:3033
n @ vue.runtime.esm.js:1832
pn @ vue.runtime.esm.js:3033
e.$emit @ vue.runtime.esm.js:3732
select @ vue-select.js:1
click @ vue-select.js:1
pn @ vue.runtime.esm.js:3033
n @ vue.runtime.esm.js:1832
i._wrapper @ vue.runtime.esm.js:7500

[pixi-p]

I resolved the issue by applying the missing schema changes manually.

The migration 1000Date20200308073933 is present in the oc_migrations table, so it is marked as executed. However, the expected changes (the type column and corresponding index on deck_assigned_users) were not actually applied to the database.

Manually executing:

ALTER TABLE oc_deck_assigned_users
ADD COLUMN type integer NOT NULL DEFAULT 0;

CREATE INDEX deck_assigned_users_idx_ty
ON oc_deck_assigned_users (type);

resolved the problem.

This indicates that the migration was recorded as executed without the schema changes being applied, resulting in an inconsistent database state.