the commands output below at that time:# mysql -e 'SELECT NOW();'+---------------------+| NOW() |+---------------------+| 2017-08-25 00 |+---------------------+# dateFr aug 25 00 IST 2017# 

Asia/Kolkata (Interpreted as Asia/Jerusalem)PHP Settingscgi.fix_pathinfo "1" is recommended if AJAX is not workingdate.timezone Asia/KolkataDatabase Information and UsageSchemab**** (localhost)Schema Signature***********  Space Used214.58 MiBSpace for Attachments181.98 MiBTimezoneAsia/Kolkata (Interpreted as Asia/Jerusalem)

Edit include/mysqli.php and change line 118 from:return db_get_variable('system_time_zone', 'global');to:return db_get_variable('time_zone', 'global');This has resulted in Asia/Kolkata (Interpreted as Asia/Jerusalem)Pls let know from which file actual ticket created/ modified date is taken & lines to edit for displaying correct timezone. 

22 days later

Hello @[deleted],Okay, so I've been trying to figure out what's happening here on my free time and I have something for you to try. Please download the latest version 1.10.1 from http://osticket.com/download and upgrade your system. This update includes a fix for a MAJOR security issue, some other small bug fixes/additions, as well as some fixes for some time/timezone issues. I hope that once you upgrade your time issue will go away. So please test this and get back to me! (MAKE A BACKUP OF ALL FILES AND DB BEFORE UPGRADING JUST IN CASE)Cheers!

19 days later

@[deleted] AWESOME! I'm glad that worked for you! Cheers.

2 years later

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.

8 months later

I'm facing the same issue and alredy done the above solutions to fix the issue but no luck. Please help.

3 years later

@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.

    Fasal

    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.

      Fasal

      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

          Fasal

          You will need to set your system timezone and profile timezone and retest.

          Cheers.

            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?

                7 months later
                Write a Reply...