Possible inconsistency with Mexico City timezone in /timesheet

[jbarbadillo]

Describe the issue

I am not sure this is a bug, but I have been checking for the right configuration and I think there is a little inconsistency with Mexico City. I will try to explain it right.

I have to say that we already seen a wrong UTC time for Mexico City in Kimai 1.30.2, so we upgraded to 2.16.1 to check if libraries used had something to do.

Pleas let me know if this is not a bug and it is a configuration or system context issue regarding our setup. I will be glad to try or check other things.

environment

• docker image: FROM kimai/kimai2:apache-2.16.1-prod. We also include a modified file (PunchInOutMode.php) to be able to create punches via API return true in canUpdateTimesWithAPI().
• Using AWS cluster runnin in amazon/amzn2-ami-ecs-hvm-2.0.20240424-x86_64-ebs instance.
• we override some settings with local.yaml, but nothing special.

Some context

As far as I know, Mexico City stopped changing time in 2022, and tzdata lib in unix system shows that. I have checked that our instance has an up to date library.

If I try what I have described below with Spain/Madrid timezone, I don't see this inconsistency.

How to reproduce

1. log in as user (ROLE_USER), and go to Preferences and set timezone to America/Mexico City.
2. go to /timesheet, and clieck create. You will see Mexico local time. UTC -6 9:00

3. click save.

expected

See in the time sheet the UTC-6 that you were seeing in the creation form: 9:00

actual behavior

You see in the time sheet UTC-5 10:00

Moreover, if I edit the time, I see again the correct and expected Mexico Citi UTC -6.

I already tried

• I've read and searched the documentation.
• I've searched for similar issues in this repository.
• I've searched for similar issues in the discussions.

Kimai version

2.16.1

How do you run Kimai?

Docker

Which PHP version are you using?

8.2

Logfile

[2024-05-14T15:00:38.616247+00:00] deprecation.INFO: User Deprecated: Nesting transactions without enabling savepoints is deprecated. Call Doctrine\DBAL\Connection::setNestTransactionsWithSavepoints(true) to enable savepoints. (Connection.php:1376 called by UnitOfWork.php:428, https://github.com/doctrine/dbal/pull/5383, package doctrine/dbal) {"exception":"[object] (ErrorException(code: 0): User Deprecated: Nesting transactions without enabling savepoints is deprecated.\nCall Doctrine\\DBAL\\Connection::setNestTransactionsWithSavepoints(true) to enable savepoints. (Connection.php:1376 called by UnitOfWork.php:428, https://github.com/doctrine/dbal/pull/5383, package doctrine/dbal) at /opt/kimai/vendor/doctrine/deprecations/lib/Doctrine/Deprecations/Deprecation.php:210)"} {"channel":"deprecation"}
[2024-05-14T15:00:38.622287+00:00] deprecation.INFO: User Deprecated: PARTIAL syntax in DQL is deprecated. (Parser.php:1847 called by Parser.php:2281, https://github.com/doctrine/orm/issues/8471, package doctrine/orm) {"exception":"[object] (ErrorException(code: 0): User Deprecated: PARTIAL syntax in DQL is deprecated. (Parser.php:1847 called by Parser.php:2281, https://github.com/doctrine/orm/issues/8471, package doctrine/orm) at /opt/kimai/vendor/doctrine/deprecations/lib/Doctrine/Deprecations/Deprecation.php:210)"} {"channel":"deprecation"}
localhost:8001 172.21.12.61 - - [14/May/2024:16:00:38 +0100] "POST /es/timesheet/create HTTP/1.1" 302 591 "https://corporate-val.time.ci-srv.das-gate.com/es/timesheet/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36"
[2024-05-14T15:00:38.864301+00:00] deprecation.INFO: User Deprecated: PARTIAL syntax in DQL is deprecated. (Parser.php:1847 called by Parser.php:2281, https://github.com/doctrine/orm/issues/8471, package doctrine/orm) {"exception":"[object] (ErrorException(code: 0): User Deprecated: PARTIAL syntax in DQL is deprecated. (Parser.php:1847 called by Parser.php:2281, https://github.com/doctrine/orm/issues/8471, package doctrine/orm) at /opt/kimai/vendor/doctrine/deprecations/lib/Doctrine/Deprecations/Deprecation.php:210)"} {"channel":"deprecation"}
localhost:8001 172.21.12.61 - - [14/May/2024:16:00:38 +0100] "GET /es/timesheet/ HTTP/1.1" 200 9724 "https://corporate-val.time.ci-srv.das-gate.com/es/timesheet/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36"
[2024-05-14T15:00:39.057366+00:00] deprecation.INFO: User Deprecated: Since zircote/swagger-php 4.9: Context detecting is deprecated {"exception":"[object] (ErrorException(code: 0): User Deprecated: Since zircote/swagger-php 4.9: Context detecting is deprecated at /opt/kimai/vendor/zircote/swagger-php/src/Context.php:197)"} {"channel":"deprecation"}
[2024-05-14T15:00:39.058370+00:00] deprecation.INFO: User Deprecated: Since zircote/swagger-php 4.9: Context detecting is deprecated {"exception":"[object] (ErrorException(code: 0): User Deprecated: Since zircote/swagger-php 4.9: Context detecting is deprecated at /opt/kimai/vendor/zircote/swagger-php/src/Context.php:197)"} {"channel":"deprecation"}
[2024-05-14T15:00:39.058720+00:00] deprecation.INFO: User Deprecated: Since zircote/swagger-php 4.9: Context detecting is deprecated {"exception":"[object] (ErrorException(code: 0): User Deprecated: Since zircote/swagger-php 4.9: Context detecting is deprecated at /opt/kimai/vendor/zircote/swagger-php/src/Context.php:197)"} {"channel":"deprecation"}
[2024-05-14T15:00:39.059293+00:00] deprecation.INFO: User Deprecated: Since zircote/swagger-php 4.9: Context detecting is deprecated {"exception":"[object] (ErrorException(code: 0): User Deprecated: Since zircote/swagger-php 4.9: Context detecting is deprecated at /opt/kimai/vendor/zircote/swagger-php/src/Context.php:197)"} {"channel":"deprecation"}
localhost:8001 172.21.12.61 - - [14/May/2024:16:00:39 +0100] "GET /favicon.ico HTTP/1.1" 200 15333 "https://corporate-val.time.ci-srv.das-gate.com/es/timesheet/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36"
localhost:8001 172.21.12.61 - - [14/May/2024:16:00:39 +0100] "GET /api/timesheets/active HTTP/1.1" 200 1240 "https://corporate-val.time.ci-srv.das-gate.com/es/timesheet/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36"
localhost:8001 172.21.12.61 - - [14/May/2024:16:00:39 +0100] "GET /favicon.ico HTTP/1.1" 200 15333 "https://corporate-val.time.ci-srv.das-gate.com/es/timesheet/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36"
localhost:8001 172.21.12.61 - - [14/May/2024:16:00:39 +0100] "GET /es/timesheet/?state=1&billable=0&exported=1&pageSize=50&page=1&orderBy=begin&order=DESC&_token=a419179c.Zzt10mD7cO5M9VgJkEJtdypJ8FeLhpLuTAgl1GM7EC4.X3BDjQWNNK00vAhC4wkODWkguzjc6eqGfD9RhgtyQEIUZA-QJLkAvS-SLw&performSearch=performSearch HTTP/1.1" 200 9574 "https://corporate-val.time.ci-srv.das-gate.com/es/timesheet/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36"
localhost:8001 172.21.12.61 - - [14/May/2024:16:00:39 +0100] "GET /favicon.ico HTTP/1.1" 200 15333 "https://corporate-val.time.ci-srv.das-gate.com/es/timesheet/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36"

Screenshots

No response