joomla-cms
joomla-cms copied to clipboard
Calendar type custom field value is changed when switching article category with time zone other than UTC
Steps to reproduce the issue
- Make sure Joomla! has set timezone other than UTC - for this example i used Europe/Warsaw (+2h it's important )
- Create custom field with type calendar with time
- Make sure the field is displayed on article details - i added it after title
- Create article and set custom field for desired date and time - for this example let's assume it's 20:00
- Save & close the article
- Check value of custom field added in Database - should be set to 18:00
- Check date displayed on article on details view - it should display time we set while creating article
- Edit this article again and change only category
- 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.
#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.
This is indeed still an issue....in 4.2.2. Running into it today.