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
Rajendra

Comments

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

    MySQL
    PHP
    osTicket Admin panel
    osTicket Agent panel -> Profile
    Server OS

    Still i am getting 3 hr difference .

    imageimageimage
    Capture1.JPG
    652 x 212 - 37K
    Capture2.JPG
    694 x 153 - 22K
    Capture3.JPG
    269 x 36 - 11K
  • 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 25
    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'); }

    <br>

    This is how i fixed my Issue

    <br>

    image
    Capture.JPG
    701 x 253 - 31K
  • edited September 26
    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.