#79014DataHandler not deleting inline and MM references if base table does not have a "delete"-field leads to DatabaseRecordException
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
- 13.4 89617[BUGFIX] Correctly hard-delete inline foreign field children
- main 89614[BUGFIX] Correctly hard-delete inline foreign field children
- 13.4 89585[BUGFIX] Delete relations of tables without delete-field
- main 50987[BUGFIX] Delete relations of tables without delete-field
- 13.4 89520[BUGFIX] Improve recycler hard delete DB consistency
- main 89497[BUGFIX] Improve recycler hard delete DB consistency
Related issues 4
- Bug #76138Inline Relations - Delete Behaviour with mixed Usage of the Deleted Flag
- Bug #81549Deleting categories in trash bin does not delete mm records
- Bug #95541Strange behavior of DataHandler regarding hard- and flag-delete with enableCascadingDelete
- Bug #106815Correctly hard-delete inline foreign field children