deck icon indicating copy to clipboard operation
deck copied to clipboard

Published 20 hours ago • verified publisher icon nextcloud

Can't remove user from board

Open hadealahmad opened this issue 5 months ago • 0 comments
trafficstars

Bug description

Once you add a user to a NC Deck Board you cannot remove the user, this error will appear in the logs: Error deck

DbalException An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1093 You can't specify target table 'oc_deck_assigned_users' for update in FROM clause

Steps To Reproduce

  1. Create a board.
  2. Add a user.
  3. Try to remove the added user from the board.
  4. The error will be logged.

Expected behavior The user should be removed.

Screenshots

Image

Client details:

  • OS: Web Client
  • Browser Chrome (vivaldi) / Firefox (waterfox)
  • Version Latest Version
  • Device: PC
Server details Operating System: Linux 5.15.0-141-generic x86_64 CPU: AMD EPYC Processor (with IBPB) (8 threads) Memory: 29.37 GB Server time: Mon Jun 16 18:45:41 CEST 2025 Uptime: 8 days, 3 hours, 42 minutes, 54 seconds

List of activated apps: Enabled:

  • activity: 4.0.0
  • admin_audit: 1.21.0
  • announcementcenter: 7.1.3
  • app_api: 5.0.2
  • bruteforcesettings: 4.0.0
  • circles: 31.0.0
  • cloud_federation_api: 1.14.0
  • comments: 1.21.0
  • contacts: 7.1.3
  • contactsinteraction: 1.12.0
  • dashboard: 7.11.0
  • dav: 1.33.0
  • deck: 1.15.1
  • federatedfilesharing: 1.21.0
  • files: 2.3.1
  • files_accesscontrol: 2.0.0
  • files_pdfviewer: 4.0.0
  • files_sharing: 1.23.1
  • files_trashbin: 1.21.0
  • files_versions: 1.24.0
  • firstrunwizard: 4.0.0
  • forms: 5.1.0
  • impersonate: 2.0.0
  • issuetemplate: 0.7.0
  • logreader: 4.0.0
  • lookup_server_connector: 1.19.0
  • notes: 4.12.1
  • notifications: 4.0.0
  • oauth2: 1.19.1
  • password_policy: 3.0.0
  • privacy: 3.0.0
  • profile: 1.0.0
  • provisioning_api: 1.21.0
  • related_resources: 2.0.0
  • serverinfo: 3.0.0
  • settings: 1.14.0
  • systemtags: 1.21.1
  • theming: 2.6.1
  • twofactor_backupcodes: 1.20.0
  • updatenotification: 1.21.0
  • user_status: 1.11.0
  • viewer: 4.0.0
  • weather_status: 1.11.0
  • webhook_listeners: 1.2.0
  • workflowengine: 2.13.0 Disabled:
  • appointments: 2.4.5 (installed 2.4.5)
  • calendar: 5.3.2 (installed 5.3.2)
  • encryption: 2.19.0
  • federation: 1.21.0 (installed 1.21.0)
  • files_downloadlimit: 4.0.0 (installed 4.0.0)
  • files_external: 1.23.0
  • files_reminders: 1.4.0 (installed 1.4.0)
  • nextcloud_announcements: 3.0.0 (installed 3.0.0)
  • photos: 4.0.0-dev.1 (installed 4.0.0-dev.1)
  • recommendations: 4.0.0 (installed 4.0.0)
  • sharebymail: 1.21.0 (installed 1.21.0)
  • support: 3.0.0 (installed 3.0.0)
  • survey_client: 3.0.0 (installed 3.0.0)
  • suspicious_login: 9.0.1
  • text: 5.0.0 (installed 5.0.0)
  • twofactor_nextcloud_notification: 5.0.0
  • twofactor_totp: 13.0.0-dev.0
  • user_ldap: 1.22.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", "dbtype": "mysql", "version": "31.0.6.2", "overwrite.cli.url": "https://DOMAIN", "dbname": "REMOVED SENSITIVE VALUE", "dbhost": "REMOVED SENSITIVE VALUE", "dbport": "", "dbtableprefix": "oc_", "mysql.utf8mb4": true, "dbuser": "REMOVED SENSITIVE VALUE", "dbpassword": "REMOVED SENSITIVE VALUE", "installed": true, "mail_from_address": "REMOVED SENSITIVE VALUE", "mail_smtpmode": "smtp", "mail_sendmailmode": "smtp", "mail_domain": "REMOVED SENSITIVE VALUE", "mail_smtpsecure": "ssl", "mail_smtpauth": true, "mail_smtpname": "REMOVED SENSITIVE VALUE", "mail_smtppassword": "REMOVED SENSITIVE VALUE", "mail_smtphost": "REMOVED SENSITIVE VALUE", "mail_smtpport": "465", "defaultapp": "deck,notes", "skeletondiretory": "", "maintenance": false, "theme": "", "loglevel": 2, "forbidden_filename_basenames": [ "con", "prn", "aux", "nul", "com0", "com1", "com2", "com3", "com4", "com5", "com6", "com7", "com8", "com9", "com\u00b9", "com\u00b2", "com\u00b3", "lpt0", "lpt1", "lpt2", "lpt3", "lpt4", "lpt5", "lpt6", "lpt7", "lpt8", "lpt9", "lpt\u00b9", "lpt\u00b2", "lpt\u00b3" ], "forbidden_filename_characters": [ "<", ">", ":", """, "|", "?", "*", "\", "/" ], "forbidden_filename_extensions": [ " ", ".", ".filepart", ".part" ], "app_install_overwrite": [ "issuetemplate" ] } }

Logs

Nextcloud log (data/nextcloud.log)

Error
	deck
	
DbalException An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1093 You can't specify target table 'oc_deck_assigned_users' for update in FROM clause

Browser log

Failed to get subsystem status for purpose 
Object { rejected: true, message: Error }
[content-script.js:104:25](moz-extension://c08fb9a3-6d43-49c2-a24c-1ec62461fb30/content-script.js)

Object { app: "viewer", uid: "USERNAME", level: 2, ignoredMimes: (4) […] }
[index.mjs:51:16](https://DOMAIN/apps/viewer/node_modules/@nextcloud/logger/dist/index.mjs)
OCA.Files.Sidebar initialized [Sidebar.js:19:10](webpack:///nextcloud/apps/files/src/services/Sidebar.js)
OCA.Comments.View initialized [comments-app.js:15:8](webpack:///nextcloud/apps/comments/src/comments-app.js)
OCA.Sharing.ShareSearch initialized [ShareSearch.js:16:10](webpack:///nextcloud/apps/files_sharing/src/services/ShareSearch.js)
OCA.Sharing.ExternalLinkActions initialized [ExternalLinkActions.js:16:10](webpack:///nextcloud/apps/files_sharing/src/services/ExternalLinkActions.js)
OCA.Sharing.ExternalShareActions initialized [ExternalShareActions.js:16:10](webpack:///nextcloud/apps/files_sharing/src/services/ExternalShareActions.js)
session heartbeat polling started [session-heartbeat.js:83:9](webpack:///nextcloud/core/src/session-heartbeat.js)
Notifications permissions denied [NotificationsApp.vue:423](https://DOMAIN/apps/notifications/src/NotificationsApp.vue)
Polling interval updated to 30000 [NotificationsApp.vue:380](https://DOMAIN/apps/notifications/src/NotificationsApp.vue)
Started background fetcher as session_keepalive is enabled [NotificationsApp.vue:251](https://DOMAIN/apps/notifications/src/NotificationsApp.vue)
Got notification data, restoring default polling interval. [NotificationsApp.vue:336](https://DOMAIN/apps/notifications/src/NotificationsApp.vue)
Failed to get subsystem status for purpose 
Object { rejected: true, message: Error }
[content-script.js:104:25](moz-extension://c08fb9a3-6d43-49c2-a24c-1ec62461fb30/content-script.js)
XHRDELETE
https://DOMAIN/index.php/apps/deck/boards/32/acl/49
[HTTP/2 500  181ms]

Uncaught (in promise) 
Object { stack: "X@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2070898\nje@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2082319\ng@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2086995\nEventHandlerNonNull*70715/$e</<@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2087254\n70715/$e<@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2086583\nht@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2093700\n_request@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2096527\nrequest@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2095054\n70715/</vt.prototype[e]@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2096822\n70715/r/<@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2065196\ndeleteAcl@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:4868271\ndeleteAclFromCurrentBoard@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:4901909\ny/</<@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:4720573\ng.prototype.dispatch@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:4722337\ng/this.dispatch@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:4717794\nclickDeleteAcl@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:5118237\nclick@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:5122328\nfn@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:1959453\nn@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:1952143\nfn@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:1959453\n85471/e.prototype.$emit@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:1981314\nonClick@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:3636100\nhandleClick@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2614709\nfn@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:1959453\nn@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:1952143\n85471/zr/i._wrapper@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:1992359\nEventListener.handleEvent*zr@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:1992385\nEt@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:1952430\nqr@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:1992766\n_@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2001639\nm@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2000945\nf@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2001396\nm@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2000930\n85471/Mi@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2004939\n85471/e.prototype._update@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:1981466\na@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2012447\n85471/e.prototype.get@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:1962986\ne@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:1962899\n85471/za.prototype.$mount/<@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2012471\n85471/za.prototype.$mount@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2012689\ninit@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:1967777\n85471/m/<@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2000539\nm@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2000816\nf@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2001396\nm@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2000930\nf@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2001396\nm@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2000930\nf@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2001396\nm@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2000930\n85471/w/<@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2003667\nw@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2003851\n85471/w/<@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2003376\nw@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2003851\n85471/w/<@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2003376\nw@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2003851\n85471/Mi@https://DOMAIN/apps/deck/js/deck-main.js?v=2f6dff83-13:2:2004987\n", message: "Request failed with status code 500", name: "AxiosError", code: "ERR_BAD_RESPONSE", config: {…}, request: XMLHttpRequest, response: {…}, status: 500 }

hadealahmad avatar Jun 16 '25 16:06 hadealahmad