Same issue shows Timezone as " IST (interpreted as Asia/Jerusalem)",# mysql -e "SELECT @@global.time_zone;"+--------------------+| @@global.time_zone |+--------------------+| Asia/Kolkata |+--------------------+# dateMon Aug 21 11 IST 2017

Can you provide the results of:USE mysql;SELECT * FROM `time_zone_name`;

It will show a lot if lines (more 1700).# mysql -D mysql -e "select * from time_zone_name" | wc -l1781# 

Good that means your time zones are properly populated in MySQL.Now this please:SELECT @@global.time_zone, @@session.time_zone;

HI GrizlyI made all the changes from that above link , but still unable to resolved the issue. And even i installed freshly on my VM with the same version v 1.10 , still same issue i am getting the same time zone (Jerusalem) instead of Kolkata in database.Can you please help me out how to change the date or timezone in osticket data base.Thanks & RegardsRajendra

See below please:# mysql -e "SELECT @@global.time_zone, @@session.time_zone;"+--------------------+---------------------+| @@global.time_zone | @@session.time_zone |+--------------------+---------------------+| Asia/Kolkata | Asia/Kolkata |+--------------------+---------------------+# 

I checked mine, it's MariaDb, has zero entries in any of the time_zone fields, and the @@globàl was set to SYSTEM. But I'm not in Kolkata.. hmm

Was meaning to spin up a server and check, but got busy at work. If you've a spare VM with it, try not setting it at all in MySQL, just the server.

I've asked a dev to take a look at this thread.

Okay so the system is still interpreting your timezone as 'Asia/Jerusalem' which is a two and a half hour difference from 'Asia/Kolkata'.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');After you do this save the file, refresh the Dashboard > System Information page and see if the timezone is now correct. If so, then retest creating a ticket to see if the times are correct.

done, still the sameActual time : 23 but Ticket creation time & Dashboard > System Information is still the same.---- Create Date:24/08/2017 2 AM

My apologies as I seem to have drank a whole cup of stupid this morning. That wouldn't have worked because it only affects the Information page...doh. Upon ticket creation we use the SQL NOW() function.So run the following command in MySQL...:mysql> SELECT NOW();...then log out of MySQL and run this in the command line:$ datePost both results for me please.

  • jase replied to this.

    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.