Time Zone Need to fix and Ticket system to match the current time

muhammadriyas

I changed the time zone settings to Asia/Dubai because the message timestamps should reflect our correct time zone. However, I’m investigating an issue where the time zone is still showing as Asia/Singapore. It appears this setting is coming from the Database Information and Usage configuration.

KevinTheJedi

muhammadriyas

Check server time zone, database time zone, web server time zone, PHP time zone, osTicket system time zone, and agent profile time zone.

Cheers.

muhammadriyas

KevinTheJedi Thanks,

I have checked all time zones all time zone is Asia/Dubai but in Database Information and Usage showing Asia/Singapore this time zone it's come there, Here, I can't change the time zone how to change it here?

KevinTheJedi

muhammadriyas

For this you would need to check the database timezone which is outside the scope of osTicket. There are many guides online that explain how to do this:

https://dev.mysql.com/doc/refman/8.4/en/time-zone-support.html

Cheers.

muhammadriyas

KevinTheJedi Thanks, In the OS Ticket dashboard, all settings are set to Asia/Dubai, but the message timestamps are not reflecting the correct time. How can we properly fix the time zone settings so that the timestamps accurately reflect Asia/Dubai?

KevinTheJedi

muhammadriyas

Times in osTicket simply depend on the server timezone, database timezone, PHP time zone, system timezone, and agent/user profile time zone. If times are not reflecting correctly then one of the timezones are off.

Typically you’d want database time zone to be UTC so dates can easily be converted to other timezones. However, if your database time zone was set to something else then leave it as changing it now would make the issue worse (unless you manually convert all timestamps in all tables).

Cheers.