Bug #20274

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 10 years ago. Updated 6 months ago.

Status:
New
Priority:
Should have
Assignee:
-
Category:
Caching
Start date:
2009-04-03
Due date:
% Done:

0%

TYPO3 Version:
4.2
PHP Version:
4.3
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

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)

t3tt_contentVSpages.PNG View (85.6 KB) Annina H, 2015-08-31 11:56

History

#1 Updated by Thomas Trethan over 8 years ago

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

#2 Updated by Ingo Pfennigstorf over 7 years ago

Also related #34219 where SYS_LASTCHANGE is updated whe changing records in the workspace

#3 Updated by Michiel Roos almost 5 years ago

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.

#4 Updated by Alexander Opitz almost 5 years ago

  • Description updated (diff)
  • Parent task set to #63815
  • Is Regression set to No

#5 Updated by Riccardo De Contardi about 4 years ago

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

#6 Updated by Annina H about 4 years ago

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.

#7 Updated by Florian Seirer about 4 years ago

The cache of that page has to be rewritten for SYS_LASTCHANGED to be updated.

#8 Updated by Annina H about 4 years ago

It's not updated even after clearing all caches and temp files... See screenshot of the two database tables.

#9 Updated by Riccardo De Contardi almost 4 years ago

  • Category set to Caching
  • Target version set to Candidate for Major Version

#10 Updated by Riccardo De Contardi 7 months ago

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

#11 Updated by Benni Mack 6 months ago

Hi Riccardo, SYS_LASTCHANGED is updated when the frontend is actually called!

Also available in: Atom PDF