#104732altLabelField in lowlevel not exploded
Description
https://github.com/TYPO3/typo3/blob/v13.2.1/typo3/sysext/lowlevel/Classes/Controller/DatabaseIntegrityController.php#L1112
https://github.com/TYPO3/typo3/blob/v13.2.1/typo3/sysext/frontend/Configuration/TCA/tt_content.php#L6
TCA config ‘label_alt’ can be comma separated values
in lowlevel DatabaseIntegrityController the value is not exploded
Leads to Undefined array key “subheader,bodytext”
Problem exists in V11 too
Reviews 2
History 617
-
Garvin Hicking commented and changed category status
NewNeeds Feedback <span data-processor="relativetime" data-value="2024-08-26T17:09:11+00:00" > 08/26/24, 17:09 </span> -
Philipp Parzer commented <span data-processor="relativetime" data-value="2024-08-27T05:07:32+00:00" > 08/27/24, 05:07 </span>
- go to DB Check
- Full Search
- Advanced Query
- select Page Content (tt_content)
- select uid,header,l18n_parent
- where l18n_parent = <uid></uid>
page doesn’t refresh
error in the log moduleI think there must be content elements without a header
tested with TYPO3 11 and PHP 8.2 -
Gerrit Code Review pushed patch set 1 for main to change 86193 status
Needs FeedbackUnder Review <span data-processor="relativetime" data-value="2024-09-19T06:58:59+00:00" > 09/19/24, 06:58 </span> -
Gerrit Code Review pushed patch set 2 for main to change 86193 <span data-processor="relativetime" data-value="2024-09-19T07:05:43+00:00" > 09/19/24, 07:05 </span>
-
Garvin Hicking commented and changed status
Under ReviewNeeds Feedback <span data-processor="relativetime" data-value="2024-09-19T07:08:15+00:00" > 09/19/24, 07:08 </span>I created a patch for it, could you have a look at it if it works for you:
-
Gerrit Code Review pushed patch set 3 for main to change 86193 status
Needs FeedbackUnder Review <span data-processor="relativetime" data-value="2024-09-20T12:38:18+00:00" > 09/20/24, 12:38 </span> -
Gerrit Code Review pushed patch set 4 for main to change 86193 <span data-processor="relativetime" data-value="2024-09-20T12:52:10+00:00" > 09/20/24, 12:52 </span>
-
Gerrit Code Review pushed patch set 5 for main to change 86193 <span data-processor="relativetime" data-value="2024-10-18T14:01:42+00:00" > 10/18/24, 14:01 </span>
-
Gerrit Code Review pushed patch set 6 for main to change 86193 <span data-processor="relativetime" data-value="2024-11-15T09:13:43+00:00" > 11/15/24, 09:13 </span>
-
Gerrit Code Review pushed patch set 7 for main to change 86193 <span data-processor="relativetime" data-value="2024-12-04T11:46:34+00:00" > 12/04/24, 11:46 </span>
-
Gerrit Code Review pushed patch set 8 for main to change 86193 <span data-processor="relativetime" data-value="2025-03-20T20:08:50+00:00" > 03/20/25, 20:08 </span>
-
Gerrit Code Review pushed patch set 9 for main to change 86193 <span data-processor="relativetime" data-value="2025-03-26T12:29:34+00:00" > 03/26/25, 12:29 </span>
-
Garvin Hicking commented <span data-processor="relativetime" data-value="2025-03-26T12:30:09+00:00" > 03/26/25, 12:30 </span>
Updated steps to reproduce for this patch:
Steps to reproduce:
1. Check label_alt with at least ONE select relation:
- have a tt_content entry <uid> with an empty “header” column (i.e. UID=42) and a CType like “text”</uid>
- have a tt_content.php override (or edit sysext/frontend/Configuration/TCA/tt_content.php) with ‘label_alt’ => ‘subheader,bodytext,CType’
- have caches flushed ;)
- go to DB Check
- select Full Search
- select Advanced Query
- select Page Content (tt_content)
- select uid,header,l18n_parent
- Add condition WHERE (Transl.Org) l18n_parent = <uid></uid>
Check for the “Query” where part, the dropdown for selecting the uid, for your empty UID=42. It should show the “CType” (=value “Regular Text Element”) for entry [42] (due to the empty header).
2. Check label_alt WITHOUT a select relation
- Same as above, but with “subheader,bodytext” only
Now entries should show a fallback of “[]” for any field where neither header, subheader nor bodytext was filled!
3. Check label_alt on relations of the RESULT
Now do the same again, with the option “Use formatted strings, labels and dates instead of original values for results” in “Query options”.
This then modifies the RESULT listing (not the filter dropdowns). It should yield a result list with table keys: uid, header, l18n_parent.
Instead of “4” for “l18n_parent” it should show the resolved label_alt values. Check this with both label_alt=“subheader,bodytext,CType” and label_alt=“subheader,bodytext”.
-
Gerrit Code Review pushed patch set 10 for main to change 86193 <span data-processor="relativetime" data-value="2025-03-26T12:54:58+00:00" > 03/26/25, 12:54 </span>
-
Gerrit Code Review pushed patch set 1 for 13.4 to change 88783 <span data-processor="relativetime" data-value="2025-03-27T05:12:42+00:00" > 03/27/25, 05:12 </span>
-
Garvin Hicking commented and changed status
Under ReviewResolved done0 %100 % <span data-processor="relativetime" data-value="2025-03-27T05:15:09+00:00" > 03/27/25, 05:15 </span>Applied in changeset commit:3a5eb7b495ff872260a349c8bd7342aef661aabe.
-
Benni Mack changed status
ResolvedClosed <span data-processor="relativetime" data-value="2025-12-02T14:33:27+00:00" > 12/02/25, 14:33 </span>
Could you list more details on how to reproduce, error stacktrace? Or is this a tocket you’re preparing a patch for?