I am using osticket 1.12v it shows Asia/Jerusalem .I have set mysql time zone to Asia/kolkata and php.ini to Asia/kolkata but doesnt effect.Need your help. I want change it to Asia.Kolkata.
Tickets time is not shown correctly
I'm facing the same issue and alredy done the above solutions to fix the issue but no luck. Please help.
@KevinTheJedi @ntozier I'm sorry to reopen this old thread, but I'm having the same issue with Asia/Kolkata in the latest version v1.16.3 here.
The timezone set correctly in the system, PHP , osTicket settings, and MariaDB is interpreting the timezone from the system to Asia/Kolkata and it all works just fine.
In PHP:
date.timezone Asia/Kolkata
In MariaDB:
MariaDB [(none)]> SELECT NOW();
+---------------------+
| NOW() |
+---------------------+
| 2022-11-04 21:09:03 |
+---------------------+
In the System:
/# date
Fri Nov 4 21:09:18 IST 2022
The osTicket shows:
PHP Settings
cgi.fix_pathinfo "1" is recommended if AJAX is not working
date.timezone Asia/Kolkata
Under "Database Information and Usage"
Timezone IST (Interpreted as Asia/Jerusalem)
The tickets creation date is wrong in my system, however, the rest of the websites hosted within the same server with same PHP showing the correct time. Any help on this would be appreciated.
You can set your timezone to a different timezone that's similar to Kolkata. Kolkata is a notoriously bad timezone with osTicket. We hope to improve timezone conversion and such in v2.0.
Cheers.
@KevinTheJedi To get correct Indian time, which timezone should we use instead of ours?
I'm unsure as I don't use that timezone. You can look online for timezones that are similar.
Cheers.
@KevinTheJedi I tried setting Asia/Colombo in the osTicket System Settings, but still the issue persists. Do I need to change it on all other places? If yes, this isn't possible since all other installations are working perfectly with our Asia/Kolkata timezone there so it won't be possible to change server wide.
Any other solutions we could apply?
Thanks
This hasn't fixed. I set it on my Profile and osTicket System Settings, but it still showing old one. I noticed the ticket interface is showing Japan time even if my timezone set to Kolkata everywhere except osTicket settings and profile where I set Colombo as per your suggestion.
I'm confused on from where the osTicket taking Japan time which isn't set anywhere on my server wide. @KevinTheJedi
@KevinTheJedi The ticket interface is showing a time equivalent to Japan time. I'm not sure from where it is taking that time zone. In my server, MariaDB, and PHP the timezone is set to Asia/Kolkata and osTicket settings and Profile has set to Asia/Colombo. Any idea?
Maybe Colombo is being interpreted differently as well?
You can look at the timezone class here:
Cheers.
KevinTheJedi This worked for me.