Issue Bug Resolved

#109112pages.SYS_LASTCHANGED gets updated only after visiting a page

Riccardo De Contardi 02/26/26, 14:06 updated 10/30/26, 10:15

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

History 46

  1. Garvin Hicking commented <span data-processor="relativetime" data-value="2026-02-26T20:11:57+00:00" > 02/26/26, 20:11 </span>

    Lolli touched/refactored this. The fact that its frontend based is intentional.

    It really only works after frontend cache warming.

  2. 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.

  3. Oliver Bartsch commented and changed status Under Review Resolved done 0 % 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.