Bug #20274
open
Story #63815: Reduce communication between server and client
SYS_LASTCHANGED should not change when only page permissions are changed (but it does)
Added by Yannick Pavard over 15 years ago.
Updated over 1 year ago.
Description
There is a problem with the behavior of TYPO3 and the "access module". When admin user changes permissions for a backend group, SYS_LASTCHANGED is changed too.
So, when I use TypoScript to show last updated in frontend page, the date is updated but no content has changed.
My TS code :
lib.objPiedPage.5.30 = TEXT
lib.objPiedPage.5.30.data = page:lastUpdated
lib.objPiedPage.5.30.if.isTrue.Data = page:lastUpdated
lib.objPiedPage.5.30.strftime = %e %B %Y
lib.objPiedPage.5.30.wrap= <p> Last update: |</p>
lib.objPiedPage.5.30.data = register : SYS_LASTCHANGED
lib.objPiedPage.5.30.if >
(issue imported from #M10841)
Files
- Target version deleted (
0)
generally it would be great to be able to define what action causes an update of SYS_LASTCHANGED. For example if a new comment is posted (via frontend) I'd prefere to remain SYS_LASTCHANGED unchanged, since the article itself did not change.
Also related #34219 where SYS_LASTCHANGE is updated whe changing records in the workspace
Thomas,
No, it should change. The value is used to generate the 'Last Modified' header. If you do not change that when the content changes . . . A user with a cached version (in the browser) will check with the server when that page expires. The server will then however tell the user that the page has 'not' changed. The user will then NEVER see the new comment, perpetually serving up the content from his own cache.
- Description updated (diff)
- Parent task set to #63815
- Is Regression set to No
I used the typoscript included to test on both 6.2.14 and 7 (latest master):
page.40 = TEXT
page.40.data = page:lastUpdated
page.40.if.isTrue.Data = page:lastUpdated
page.40.strftime = %e %B %Y %H:%M:%S
page.40.wrap= <p> Last update: |</p>
page.40.data = register : SYS_LASTCHANGED
page.40.if >
then I changed the permissions of one page (changed the group, or the owner, or the permissions)
my results:
TYPO3 6.2.14 > bug still present
TYPO3 7 (latest master) > bug NOT present
Not sure if it's related. I am using TYPO3 7.4.0 with the Introduction Package on a local installation with XAMPP (Windows 7 Enterprise, 64 bits):
SYS_LASTCHANGED seems to be updated only when the page (properties) itself is modified. Changing a content element does not affect the field value.
The cache of that page has to be rewritten for SYS_LASTCHANGED to be updated.
It's not updated even after clearing all caches and temp files... See screenshot of the two database tables.
- Category set to Caching
- Target version set to Candidate for Major Version
My previous test was wrongly performed, I should have used config.no_cache=1
This is the short test I performed on a new 9.5.4:
1) I used the following TypoScript:
config.no_cache=1
page=PAGE
page.40 = TEXT
page.40.data = page:lastUpdated
page.40.if.isTrue.Data = page:lastUpdated
page.40.strftime = %e %B %Y %H:%M:%S
page.40.wrap= <p> Last update: |</p>
page.40.data = register : SYS_LASTCHANGED
page.40.if >
page.100 =< styles.content.get
Results:
1) Change the permissions of the page >> the SYS_LASTCHANGED field is updated
2) Change one of the content elements on the page >> the SYS_LASTCHANGED field is not updated
Hi Riccardo, SYS_LASTCHANGED is updated when the frontend is actually called!
- TYPO3 Version changed from 4.2 to 11
- PHP Version changed from 4.3 to 8.1
Hi Benni and sorry for the late reply
IIRC I actually visited the frontend to see the change on the SYS_LASTCHANGED field printed via TypoScript on the page itself.
I repeated the test on comment 10 on TYPO3 11.x and 13.0.0-dev
Here the results:
1) Change the permissions of the page >> the SYS_LASTCHANGED field is updated
2) Change one of the content elements on the page >> the SYS_LASTCHANGED field is not updated
3) Change a property of the page (e.g. the "alternative navigation title" field) >> the SYS_LASTCHANGED field is updated
I raise the TYPO3 version to 11
Also available in: Atom
PDF
Updated by 
Updated by 
Updated by 
Updated by 
Updated by 
Updated by 
Updated by 
Updated by 