Issue Bug Closed

#104396DataHandler::inlineLocalizeSynchronize fails for tables without versioning

Hannes Lau 07/15/24, 17:12 updated 10/15/24, 09:13

Description

In https://github.com/TYPO3/typo3/blob/12.4/typo3/sysext/core/Classes/DataHandling/DataHandler.php#L5031 the andWhere Clause `‘AND t3ver_oid=0’` is always appended, even for tables without versioning. This leads to an invalid field exception `unknown column t3ver_oid`.

Original:

$parentRecordLocalization = BackendUtility::getRecordLocalization($table, $id, $command['language'], 'AND t3ver_oid=0');

Quick patch was:

-            $parentRecordLocalization = BackendUtility::getRecordLocalization($table, $id, $command['language'], 'AND t3ver_oid=0');
+            $useVersioning = (bool) ($GLOBALS['TCA'][$table]['ctrl']['versioningWS'] ?? false);
+            $versioningWhereClause = $useVersioning ? 'AND t3ver_oid=0' : '';
+            $parentRecordLocalization = BackendUtility::getRecordLocalization($table, $id, $command['language'], $versioningWhereClause);

Reviews 2