Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now

Time displaying 3 hours more from the current time on tickets ( New & Old tickets)

Hi Team,

I have installed Osticket v1.10 freshly on my Ubuntu 14.04 server, now the tickets are fetching very slow, ( need to refresh every time or i have to logout and login again)

And in Osticket v1.10 time also displaying 3 hr more than the current time. 

My time zone is IST  . and in osticket also i have set it to Asia/Kolkata as its IST timezone.

Osticket version - v 1.10
Web server - Apache 2.4.7 (Ubuntu)
Mysql version - 5.7.19
PHP version - 5.5.9-1ubuntu4.22
OS - Ubuntu 14.04 server os

Please help me to fix this issue.

Thanks and regards


  • Please ensure that your datetime/timezone is the same in the following:
    osTicket Admin panel
    osTicket Agent panel -> Profile
    Server OS
  • All my date and timezone are same in in the following:

    osTicket Admin panel
    osTicket Agent panel -> Profile
    Server OS

    Still i am getting 3 hr difference .

  • Can you provide the results of:
    USE mysql;
    SELECT * FROM `time_zone_name`;
  • I fixed this issue .... anyways thanks for the responces.
  • What was the fix?  In case someone else runs into this.
  • edited September 2017
    To remove timezone issue with osticket DB timezone as : IST (Interpreted as Asia/Jerusalem)

    we have done fix in include/class.config.php

    Search for line having

    function getDbTimezone()

    in this function you would last line as

    return $this->get('db_timezone');

    Comment this line , and add below two line

    $dvd_db_timezone='Asia/Kolkata'; return $dvd_db_timezone;

    The function would like below.

    function getDbTimezone() { if (!$this->exists('db_timezone')) {
    require_once INCLUDE_DIR . 'class.timezone.php';
    $this->persist('db_timezone', DbTimezone::determine()); }
    $dvd_db_timezone='Asia/Kolkata'; return $dvd_db_timezone; // return
    $this->get('db_timezone'); }


    This is how i fixed my Issue


  • edited September 2017
    You never posted your database timezone...

    Run the following in MySQL and post the results:
    mysql> SELECT @@global.time_zone, @@session.time_zone;

    By the way, that's not a permanent "fix"...when you upgrade osTicket the changes will be lost.
Sign In or Register to comment.