Issue Bug Closed

#79014DataHandler not deleting inline and MM references if base table does not have a "delete"-field leads to DatabaseRecordException⁠⁠⁠⁠

Stephan Großberndt 12/16/16, 12:00 updated 12/02/25, 14:36

Description

DataHandler calls deleteRecord_procFields() to check and delete inline and MM references only if the base table has a “delete”-field:

        if ($deleteField && !$forceHardDelete) {
            ...

            // before (un-)deleting this record, check for child records or references
            $this->deleteRecord_procFields($table, $uid, $undeleteRecord);
            $this->databaseConnection->exec_UPDATEquery($table, 'uid=' . (int)$uid, $updateFields);
            // Delete all l10n records as well, impossible during undelete because it might bring too many records back to life
            if (!$undeleteRecord) {
                $this->deleteL10nOverlayRecords($table, $uid);
            }
        } else {
            ...

            // Delete the hard way...:
            $this->databaseConnection->exec_DELETEquery($table, 'uid=' . (int)$uid);
            $this->deleteL10nOverlayRecords($table, $uid);
        }

This is wrong. If a table does not contain a defined “delete”-field in TCA and has inline or MM-relations and a record from this table is deleted, the related and mm records stay in the database.

If you try to open the record on the other side of the mm-relation you get a ⁠⁠⁠⁠@DatabaseRecordException⁠⁠⁠⁠@ with ⁠⁠⁠⁠@#1437656081: Record with uid XXX from table tx_extension_mytable@ not found⁠⁠⁠⁠ because the relation in the mm table is still there but the record is not.

Reviews 6