joomla-cms icon indicating copy to clipboard operation
joomla-cms copied to clipboard

Calendar type custom field value is changed when switching article category with time zone other than UTC

Open TheSpiritCode opened this issue 5 years ago • 2 comments
trafficstars

Steps to reproduce the issue

  1. Make sure Joomla! has set timezone other than UTC - for this example i used Europe/Warsaw (+2h it's important )
  2. Create custom field with type calendar with time
  3. Make sure the field is displayed on article details - i added it after title
  4. Create article and set custom field for desired date and time - for this example let's assume it's 20:00
  5. Save & close the article
  6. Check value of custom field added in Database - should be set to 18:00
  7. Check date displayed on article on details view - it should display time we set while creating article
  8. Edit this article again and change only category
  9. Save & close

Expected result

Database value of custom field should still show time 18:00 and for sure it should still display as select time while creating article.

Actual result

Database value of custom field increase by 2h everytime category is changed which also changes displayed data of this field

System information (as much as possible)

Tested on Joomla! 3.9.19. Server and database time zones are Europe/Warsaw

Additional comments

Sorry for bad English. it's not my native language. Looks to me as if custom field always retrieves correct data from database but when category change is taking place something adds to the value 2h (probably time zones difference, I did not check that). You can clearly see that between steps 8 and 9.

TheSpiritCode avatar Aug 11 '20 20:08 TheSpiritCode

#36327 is a temporary fix for this. PLEASE BE AWARE THAT THIS RIGHT NOW IS NOT A FINAL FIX AND THAT THIS ISSUE MOST LIKELY STILL EXISTS IN 4.0 AND THUS NEEDS TO BE FIXED THERE AS WELL! Do not close this issue.

Hackwar avatar Dec 16 '21 11:12 Hackwar

This is indeed still an issue....in 4.2.2. Running into it today.

crystalenka avatar Sep 13 '22 08:09 crystalenka