#102069Constants not present on root page in workspace / translation overlay
Description
It seems as if the usage of a constants within a “marker” (e.g. ###PAGE_TSCONFIG_IDLIST###) is not working when the root page of a site is being workspaced.
TCA:
$GLOBALS['TCA']['pages']['columns']['fe_group']['config']['foreign_table_where'] = 'AND fe_groups.pid IN (###CURRENT_PID###,###PAGE_TSCONFIG_IDLIST###)';
PageTS:
TCEFORM.pages.fe_group.PAGE_TSCONFIG_IDLIST = {$pid.userSource}
Site config:
settings:
pid:
userSource: 123
Here’s the SQL error you get after saving the workspace change.
SELECT `fe_groups`.`uid`, `fe_groups`.`pid`, `fe_groups`.`title`, `fe_groups`.`hidden` FROM `fe_groups`, `pages` WHERE (fe_groups.pid IN (321,)) ...
As you can see CURRENT_PID is being processed correctly, but PAGE_TSCONFIG_IDLIST is just empty, hence the SQL error.
This is generally working. But not for a workspace’d root page! I think it’s due to the fact that this page has now a different ID for which no site config exists. When adding a dummy site config with that ID as a rootPageId, then the constants are present!
Hint: the workaround from #93746 doesn’t work here.
Reviews 3
History 59
-
Garvin Hicking changed category <span data-processor="relativetime" data-value="2024-07-31T10:27:55+00:00" > 07/31/24, 10:27 </span>
-
Philipp Kitzberger commented and changed subject
Constants not present on root page in workspaceConstants not present on root page in workspace / translation overlay <span data-processor="relativetime" data-value="2025-03-18T10:01:05+00:00" > 03/18/25, 10:01 </span> -
Philipp Kitzberger changed description <span data-processor="relativetime" data-value="2025-03-21T10:38:40+00:00" > 03/21/25, 10:38 </span>
-
Gerrit Code Review pushed patch set 1 for main to change 89051 status
NewUnder Review <span data-processor="relativetime" data-value="2025-04-11T08:36:20+00:00" > 04/11/25, 08:36 </span> -
Gerrit Code Review pushed patch set 2 for main to change 89051 <span data-processor="relativetime" data-value="2025-04-11T08:55:49+00:00" > 04/11/25, 08:55 </span>
-
Gerrit Code Review pushed patch set 1 for 13.4 to change 89075 <span data-processor="relativetime" data-value="2025-04-11T21:27:38+00:00" > 04/11/25, 21:27 </span>
-
Gerrit Code Review pushed patch set 1 for 12.4 to change 89076 <span data-processor="relativetime" data-value="2025-04-11T21:27:52+00:00" > 04/11/25, 21:27 </span>
-
Benni Mack commented and changed status
Under ReviewResolved done0 %100 % <span data-processor="relativetime" data-value="2025-04-11T21:45:09+00:00" > 04/11/25, 21:45 </span>Applied in changeset commit:7054716b19843d2cbb11e9b717cd710e6c83c513.
-
Benni Mack changed status
ResolvedClosed <span data-processor="relativetime" data-value="2025-12-02T14:37:04+00:00" > 12/02/25, 14:37 </span>
The same behaviour can be reproduced for translated versions of root pages.