#109112pages.SYS_LASTCHANGED gets updated only after visiting a page
Description
I stumbled on this issue while investigating how the fluid “Menu of recent pages” works: I tried several time to change both the page properties and the content of several pages but failing to see them appear on the menu.
It seems that the menu uses in its query the field pages.SYS_LAST_CHANGED but as far as I can see that field is updated only after you visit the page in the frontend (for a newly created, not visited page it’s 0)
Moreover, the documentation seems wrong as on https://docs.typo3.org/c/typo3/cms-fluid-styled-content/main/en-us/ContentElements/Menu/Index.html I read
> *Recently updated pages*
> Shows a list of pages which are updated in the last 7 days. Updated only means a change in the page properties, not the content on the page.
But as far as I can see, SYS_LASTCHANGED refreshes both changing the page properties, and changing one of the content elements (always after visiting the page)
The actual query performed by the menu is:
SELECT * FROM `pages` WHERE (`uid` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (`sys_language_uid` = ?) AND (((`pages`.`deleted` = 0) AND (((`pages`.`t3ver_state` <= 0) AND (`pages`.`t3ver_wsid` = 0))) AND (((`pages`.`t3ver_oid` = 0) OR (`pages`.`t3ver_state` = 4))) AND (`pages`.`hidden` = 0) AND (`pages`.`starttime` <= 1772114160) AND (((`pages`.`endtime` = 0) OR (`pages`.`endtime` > 1772114160))))) AND ((((`pages`.`fe_group` = '') OR (`pages`.`fe_group` IS NULL) OR (`pages`.`fe_group` = '0') OR (FIND_IN_SET('0', `pages`.`fe_group`)) OR (FIND_IN_SET('-1', `pages`.`fe_group`))))) AND (`SYS_LASTCHANGED`>='0' AND pages.nav_hide=0 AND pages.doktype NOT IN (6,254) AND `pages`.`no_search`='0' AND `SYS_LASTCHANGED`>'1771509360') AND (((`pages`.`t3ver_wsid` = 0) AND (((`pages`.`t3ver_oid` = 0) OR (`pages`.`t3ver_state` = 4))))) ORDER BY `SYS_LASTCHANGED` DESC
Thanks to Soren Malling and Mathias Brodala for their help and pointing me to the right direction.
Reviews 2
Related issues 1
History 46
-
Garvin Hicking commented <span data-processor="relativetime" data-value="2026-02-26T20:11:57+00:00" > 02/26/26, 20:11 </span>
-
Georg Ringer changed Related to #63810 <span data-processor="relativetime" data-value="2026-02-26T20:13:49+00:00" > 02/26/26, 20:13 </span>
-
Simon Schaufelberger commented <span data-processor="relativetime" data-value="2026-02-26T22:07:44+00:00" > 02/26/26, 22:07 </span>
> The fact that its frontend based is intentional.
But is that really helpful then? This is not intuitive at all in my opinion.
-
Gerrit Code Review pushed patch set 1 for main to change 97224 status
NewUnder Review <span data-processor="relativetime" data-value="2026-10-30T06:17:04+00:00" > 10/30/26, 06:17 </span> -
Gerrit Code Review pushed patch set 1 for 14.3 to change 97231 <span data-processor="relativetime" data-value="2026-10-30T10:13:23+00:00" > 10/30/26, 10:13 </span>
-
Oliver Bartsch commented and changed status
Under ReviewResolved done0 %100 % <span data-processor="relativetime" data-value="2026-10-30T10:15:16+00:00" > 10/30/26, 10:15 </span>Applied in changeset commit:5489c49d2bd57cc2d166f465fe6523cccb3edb2b.
Lolli touched/refactored this. The fact that its frontend based is intentional.
It really only works after frontend cache warming.