bffa4d0925
Fixes #7125 and #7069 by implementing a two-step deletion process that avoids MySQL's restriction on deleting from a table while selecting from it in a subquery. The fix separates the SELECT and DELETE operations: 1. First query: Get card IDs for assignments to delete 2. Second query: Delete assignments using the collected IDs This approach works on all supported database systems (MySQL 5.7+, MySQL 8.0+, MariaDB 10.x+) and follows MySQL's official best practices for handling Error 1093: 'You can't specify target table for update in FROM clause'. The issue occurred because the original deleteByParticipantOnBoard method used a subquery that referenced the same table being deleted from, which MySQL prohibits but MariaDB allows (explaining why it worked in development but failed in production). Signed-off-by: Arne Bartelt <arne.bartelt@gmail.com> Signed-off-by: Arne Bartelt <Arne.Bartelt@gmail.com>
27 lines
960 B
Markdown
27 lines
960 B
Markdown
<!--
|
|
- SPDX-FileCopyrightText: 2024 Nextcloud GmbH and Nextcloud contributors
|
|
- SPDX-License-Identifier: AGPL-3.0-or-later
|
|
-->
|
|
# Authors
|
|
|
|
- Adrian Missy <adrian.missy@onewavestudios.com>
|
|
- Alexandru Puiu <alexpuiu20@yahoo.com>
|
|
- Arne Bartelt <arne.bartelt@gmail.com>
|
|
- Chandi Langecker <git@chandi.it>
|
|
- Christoph Wurst <christoph@winzerhof-wurst.at>
|
|
- Gary Kim <gary@garykim.dev>
|
|
- Georg Ehrke <oc.list@georgehrke.com>
|
|
- Jakob Röhrl <jakob.roehrl@web.de>
|
|
- Johannes Szeibert <johannes@szeibert.de>
|
|
- John Molakvoæ <skjnldsv@protonmail.com>
|
|
- Julien Veyssier <eneiluj@posteo.net>
|
|
- Julius Härtl <jus@bitgrid.net>
|
|
- Luka Trovic <luka.trovic@nextcloud.com>
|
|
- Maxence Lange <maxence@artificial-owl.com>
|
|
- Michael Weimann <mail@michael-weimann.eu>
|
|
- Raul Ferreira Fuentes <raul@nextcloud.com>
|
|
- Ryan Fletcher <ryan.fletcher@codepassion.ca>
|
|
- Steven R. Baker <steven@stevenrbaker.com>
|
|
- Thanos kamber <thanos.kamber@gmail.com>
|
|
- Vitor Mattos <vitor@php.rio>
|