[Bug]: DECK on DELETE user SHARED

[stachmx]

⚠️ This issue respects the following points: ⚠️

• This is a bug, not a question or a configuration/webserver/proxy issue.
• This issue is not already reported on Github OR Nextcloud Community Forum (I've searched it).
• Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
• I agree to follow Nextcloud's Code of Conduct.

Bug description

My english is not good but here we go.

When I create a board and then configure it with the people I want to access it, with the people I'll share it with, everything works perfectly, but when I makes a mistake and wants to delete someone they don't need on the board, or if time passes and you want to delete a member who's being shared with you, you can't; you have to delete the entire board and recreate it, cause the delete shared item dont works

All of this happens in Deck.

Steps to reproduce

1. i go to a board in the three pints "..."
2. clic on details of board
3. in SHARE, i try to delete a user and there is...

notting happens

Expected behavior

i expected to get it a user deleted from the list of shared from my board created

Nextcloud Server version

31

Operating system

Debian/Ubuntu

PHP engine version

PHP 8.2

Web server

Apache (supported)

Database engine version

MySQL

Is this bug present after an update or on a fresh install?

None

Are you using the Nextcloud Server Encryption module?

Encryption is Disabled

What user-backends are you using?

• Default user-backend (database)
• LDAP/ Active Directory
• SSO - SAML
• Other

Configuration report

{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "default_language": "es",
        "collabora_online_verify_cert": false,
        "trusted_domains": [
            "***REMOVED SENSITIVE VALUE***",
            "***REMOVED SENSITIVE VALUE***"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "31.0.9.1",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "nsff_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "mail_smtpmode": "smtp",
        "mail_smtpsecure": "ssl",
        "mail_sendmailmode": "smtp",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "465",
        "mail_smtpauth": true,
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "maintenance": false,
        "theme": "",
        "loglevel": 2,
        "config_is_read_only": false,
        "app_install_overwrite": [],
        "overwriteprotocol": "https",
        "overwrite.cli.url": "***REMOVED SENSITIVE VALUE***",
        "trusted_proxies": "***REMOVED SENSITIVE VALUE***"
    }
}

List of activated Apps

Enabled:
  - activity: 4.0.0
  - admin_audit: 1.21.0
  - app_api: 5.0.2
  - bruteforcesettings: 4.0.0
  - calendar: 5.5.7
  - calendar_resource_management: 0.10.0
  - circles: 31.0.0
  - cloud_federation_api: 1.14.0
  - comments: 1.21.0
  - contactsinteraction: 1.12.0
  - dashboard: 7.11.0
  - dav: 1.33.0
  - deck: 1.15.3
  - federatedfilesharing: 1.21.0
  - federation: 1.21.0
  - files: 2.3.1
  - files_accesscontrol: 2.0.2
  - files_downloadlimit: 4.0.0
  - files_pdfviewer: 4.0.0
  - files_reminders: 1.4.0
  - files_sharing: 1.23.1
  - files_trashbin: 1.21.0
  - files_versions: 1.24.0
  - firstrunwizard: 4.0.0
  - logreader: 4.0.0
  - lookup_server_connector: 1.19.0
  - nextcloud_announcements: 3.0.0
  - notifications: 4.0.0
  - oauth2: 1.19.1
  - password_policy: 3.0.0
  - photos: 4.0.0
  - privacy: 3.0.0
  - profile: 1.0.0
  - provisioning_api: 1.21.0
  - recommendations: 4.0.0
  - related_resources: 2.0.0
  - richdocuments: 8.7.6
  - richdocumentscode: 25.4.504
  - serverinfo: 3.0.0
  - settings: 1.14.0
  - sharebymail: 1.21.0
  - side_menu: 5.1.3
  - survey_client: 3.0.0
  - systemtags: 1.21.1
  - text: 5.0.0
  - 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:
  - certificate24: 0.3.7 (installed 0.3.7)
  - contacts: 7.3.3 (installed 7.3.3)
  - encryption: 2.19.0 (installed 2.19.0)
  - files_external: 1.23.0
  - spreed: 21.1.5 (installed 21.1.5)
  - support: 3.0.0 (installed 3.0.0)
  - suspicious_login: 9.0.1
  - twofactor_nextcloud_notification: 5.0.0
  - twofactor_totp: 13.0.0-dev.0
  - user_ldap: 1.22.0

Nextcloud Signing status

No errors have been found.

Nextcloud Logs

Saltar al contenido principal
Saltar a la navegación de la aplicación
Configuración de administración: Registro
Lector del registro

Configuraciones del lector del registro

Nivel

Aplicación
Mensaje


Hora
Acciones de entradas del registro
Error
richdocuments
ConnectException
cURL error 28: Operation timed out after 5000 milliseconds with 0 bytes received (see https://curl.haxx.se/libcurl/c/libcurl-errors.html) for ***REMOVED SENSITIVE VALUE***

14 oct 2025, 10:55:40 a.m.

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

14 oct 2025, 10:55:04 a.m.

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

14 oct 2025, 10:45:42 a.m.

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

14 oct 2025, 10:45:41 a.m.

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

14 oct 2025, 10:45:40 a.m.

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

14 oct 2025, 10:45:21 a.m.

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

14 oct 2025, 10:45:20 a.m.

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

14 oct 2025, 10:39:01 a.m.

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

14 oct 2025, 10:39:01 a.m.

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

14 oct 2025, 10:38:23 a.m.

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

14 oct 2025, 10:38:23 a.m.

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

14 oct 2025, 10:38:22 a.m.

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

14 oct 2025, 10:38:22 a.m.

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

14 oct 2025, 10:38:21 a.m.

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

14 oct 2025, 10:38:17 a.m.

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

14 oct 2025, 10:38:16 a.m.

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

14 oct 2025, 10:38:16 a.m.

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

14 oct 2025, 10:38:16 a.m.

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

14 oct 2025, 10:38:15 a.m.

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

14 oct 2025, 10:38:14 a.m.

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

14 oct 2025, 10:38:14 a.m.

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

14 oct 2025, 10:38:14 a.m.

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

14 oct 2025, 10:38:13 a.m.

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

14 oct 2025, 10:38:12 a.m.

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

14 oct 2025, 10:38:11 a.m.

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

14 oct 2025, 10:38:11 a.m.

Additional info

i have total control of the server dedicated

[osm-frasch]

I have the same problem. I think this corresponds to the bug report: #7226

[luka-nextcloud]

@stachmx @osm-frasch I am not able to reproduce this issue. Please enable debug flag on your server and then reproduce issue and share the related log entries if possible. thanks!

[outnsp]

#7320

[osm-frasch]

This bug is still not solved in Nextcloud Hub 25 Autumn, 32.0.5 Enterprise
Deck Version: Version 1.16.3,
MySQL: 8.0.36, PHP: 8.2.28

I cannot undo the release of a board.
User access cannot be revoked reliably; assignments/participants may remain referenced in DB; this can lead to unintended access to board content (confidential information).

Here's the Nextcloud system-protocol:

[deck] Fehler: 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
DELETE /index.php/apps/deck/boards/3/acl/30
von xxx.xx.xx.xx von MaxMuster um 02.03.2026, 09:42:38

    /home/www/nextcloud/lib/private/DB/ConnectionAdapter.phpZeile 69

OC\DB\Exceptions\DbalException::wrap(
  {
    "__class__": "Doctrine\\DBAL\\Exception\\DriverException"
  },
  "",
  "DELETE FROM `*PREFIX*deck_assigned_users` WHERE `card_id` IN (SELECT `a`.`card_id` FROM `*PREFIX*deck_assigned_users` `a` INNER JOIN `*PREFIX*deck_cards` `c` ON c.id = a.card_id INNER JOIN `*PREFIX*deck_stacks` `s` ON s.id = c.stack_id WHERE (`a`.`participant` = :dcValue1) AND (`s`.`board_id` = :dcValue2) AND (`a`.`type` = :dcValue3))"
)

/home/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.phpZeile 308

OC\DB\ConnectionAdapter->executeStatement(
  "DELETE FROM `*PREFIX*deck_assigned_users` WHERE `card_id` IN (SELECT `a`.`card_id` FROM `*PREFIX*deck_assigned_users` `a` INNER JOIN `*PREFIX*deck_cards` `c` ON c.id = a.card_id INNER JOIN `*PREFIX*deck_stacks` `s` ON s.id = c.stack_id WHERE (`a`.`participant` = :dcValue1) AND (`s`.`board_id` = :dcValue2) AND (`a`.`type` = :dcValue3))",
  {
    "dcValue1": "Tina Test",
    "dcValue2": 3,
    "dcValue3": 0
  },
  {
    "dcValue1": 2,
    "dcValue2": 1,
    "dcValue3": 1
  }
)

/home/www/nextcloud/apps/deck/lib/Db/AssignmentMapper.phpZeile 91

OC\DB\QueryBuilder\QueryBuilder->executeStatement()

/home/www/nextcloud/apps/deck/lib/Service/BoardService.phpZeile 447

OCA\Deck\Db\AssignmentMapper->deleteByParticipantOnBoard(
  "Tina Test",
  3
)

/home/www/nextcloud/apps/deck/lib/Controller/BoardController.phpZeile 147

OCA\Deck\Service\BoardService->deleteAcl(
  30
)

/home/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.phpZeile 204

OCA\Deck\Controller\BoardController->deleteAcl(
  "30"
)

/home/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.phpZeile 118

OC\AppFramework\Http\Dispatcher->executeController(
  {
    "__class__": "OCA\\Deck\\Controller\\BoardController"
  },
  "deleteAcl"
)

/home/www/nextcloud/lib/private/AppFramework/App.phpZeile 153

OC\AppFramework\Http\Dispatcher->dispatch(
  {
    "__class__": "OCA\\Deck\\Controller\\BoardController"
  },
  "deleteAcl"
)

/home/www/nextcloud/lib/private/Route/Router.phpZeile 321

OC\AppFramework\App::main(
  "OCA\\Deck\\Controller\\BoardController",
  "deleteAcl",
  {
    "__class__": "OC\\AppFramework\\DependencyInjection\\DIContainer"
  },
  {
    "_route": "deck.board.deleteacl",
    "boardId": "3",
    "aclId": "30"
  }
)

/home/www/nextcloud/lib/base.phpZeile 1061

OC\Route\Router->match(
  "/apps/deck/boards/3/acl/30"
)

/home/www/nextcloud/index.phpZeile 25

OC::handleRequest()

Verursacht von DriverException 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

---

Here is the browser console output:

`ncaught (in promise)
Object { message: "Request failed with status code 500", name: "AxiosError", code: "ERR_BAD_RESPONSE", config: {…}, request: XMLHttpRequest, response: {…}, status: 500, stack: "", … }
​
code: "ERR_BAD_RESPONSE"
​
config: Object { timeout: 0, xsrfCookieName: "XSRF-TOKEN", xsrfHeaderName: "X-XSRF-TOKEN", … }
​
message: "Request failed with status code 500"
​
name: "AxiosError"
​
request: XMLHttpRequest { readyState: 4, timeout: 0, withCredentials: false, … }
​
response: Object { data: {…}, status: 500, statusText: "Internal Server Error", … }
​
stack: "Ye@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2102360\ng@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2106654\nEventHandlerNonNull*66802/We</<@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2106913\n66802/We<@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2106242\nmt@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2113778\n_request@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2116949\nrequest@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2115242\n66802/</At.prototype[e]@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2117264\n66802/i/<@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2084986\ndeleteAcl@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:4802985\ndeleteAclFromCurrentBoard@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:5075988\nk/</<@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:3340289\nv.prototype.dispatch@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:3342033\nv/this.dispatch@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:3337508\nclickDeleteAcl@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:5038840\nclick@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:5042926\npn@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:1976771\nn@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:1969461\npn@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:1976771\n85471/e.prototype.$emit@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:1998715\nonClick@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:3237957\nhandleClick@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2636427\npn@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:1976771\nn@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:1969461\n85471/qr/i._wrapper@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2009760\nEventListener.handleEvent*qr@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2009786\nEt@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:1969748\nUr@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2010167\n_@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2019040\nm@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2018346\np@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2018797\nm@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2018331\n85471/Ni@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2022340\n85471/e.prototype._update@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:1998867\na@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2029848\n85471/e.prototype.get@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:1980387\ne@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:1980300\n85471/qa.prototype.$mount/<@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2029872\n85471/qa.prototype.$mount@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2030090\ninit@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:1985178\n85471/m/<@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2017940\nm@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2018217\np@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2018797\nm@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2018331\np@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2018797\nm@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2018331\np@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2018797\nm@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2018331\n85471/w/<@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2021068\nw@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2021252\n85471/w/<@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2020777\nw@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2021252\n85471/w/<@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2020777\nw@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2021252\n85471/Ni@https://xx.xxx.de/apps/deck/js/deck-main.js?v=f0165283-28:2:2022388\n"
​
status: 500
: Object { constructor: K(e, t, n, a, r), toJSON: toJSON(), stack: "", … }
constructor: function K(e, t, n, a, r)
ECONNABORTED: "ECONNABORTED"
ERR_BAD_OPTION: "ERR_BAD_OPTION"
ERR_BAD_OPTION_VALUE: "ERR_BAD_OPTION_VALUE"
ERR_BAD_REQUEST: "ERR_BAD_REQUEST"
ERR_BAD_RESPONSE: "ERR_BAD_RESPONSE"
ERR_CANCELED: "ERR_CANCELED"
ERR_DEPRECATED: "ERR_DEPRECATED"
ERR_FR_TOO_MANY_REDIRECTS: "ERR_FR_TOO_MANY_REDIRECTS"
ERR_INVALID_URL: "ERR_INVALID_URL"
ERR_NETWORK: "ERR_NETWORK"
ERR_NOT_SUPPORT: "ERR_NOT_SUPPORT"
ETIMEDOUT: "ETIMEDOUT"
from: function from(e, t, n, a, r, i)
length: 5
name: "K"
super: Error.prototype { stack: "", … }
: function ()
isAxiosError: true
stack: ""
toJSON: function toJSON()
: Error.prototype { stack: "", … }
constructor: function Error()
message: ""
name: "Error"
stack: ""
toString: function toString()
<get stack()>: function stack()
<set stack()>: function stack()
: O

Short Technical Hint for a Possible Fix

Note:
The following suggestion is a quickly generated AI-based technical hint. It may help identify the root cause or point toward a potential solution, but it has not been tested in a production environment.
prototype: Object { constructor: K(e, t, n, a, r), toJSON: toJSON(), stack: "", … }

Root Cause
The DELETE query in AssignmentMapper::deleteByParticipantOnBoard() deletes from deck_assigned_users while simultaneously selecting from the same table in a subquery.
This triggers MySQL/MariaDB error 1093:
“You can't specify target table for update in FROM clause”
This is a known MySQL/MariaDB limitation when a table is modified and read from within the same query using a subquery.

Required Fix
The DELETE statement should be rewritten to avoid selecting from the same target table directly.
Two common and safe approaches are:
Using a derived table (nested SELECT)
Using a JOIN-based DELETE

Example Solution – Derived Table Pattern

DELETE FROM oc_deck_assigned_users WHERE card_id IN ( SELECT card_id FROM ( SELECT a.card_id FROM oc_deck_assigned_users a INNER JOIN oc_deck_cards c ON c.id = a.card_id INNER JOIN oc_deck_stacks s ON s.id = c.stack_id WHERE a.participant = :participant AND s.board_id = :boardId AND a.type = :type ) tmp );

Alternative (Cleaner and Usually More Efficient) – JOIN-Based DELETE

DELETE a FROM oc_deck_assigned_users a INNER JOIN oc_deck_cards c ON c.id = a.card_id INNER JOIN oc_deck_stacks s ON s.id = c.stack_id WHERE a.participant = :participant AND s.board_id = :boardId AND a.type = :type;

[grnd-alt]

this has been resolved but not backported. It is already in nc33, I now backported it to nextcloud 32 so 1.16.5 will be fixed:
#7700