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

fresh installation: time zone error

I have change all the timezone to asia/shanghai, but the system time is still a day before. I see in the system info the database timezone is "Timezone CST (Interpreted as America/Chicago)"

is there sth wrong?

Server Information
osTicket Version v1.10.1 (9ae093d) —  Up to date
Web Server Software nginx/1.12.2
MySQL Version 5.5.57
PHP Version 5.6.30

PHP Settings
cgi.fix_pathinfo "1" is recommended if AJAX is not working
date.timezone PRC
Database Information and Usage
Schema osticket (localhost)
Schema Signature 98ad7d550c26ac44340350912296e673
Space Used 2.43 MiB
Space for Attachments 0.01 MiB
Timezone CST (Interpreted as America/Chicago)

Comments

  • "I have change all the timezone to asia/shanghai,"
    ^ this statement is obviously not true.

    Server OS times zone?
    Database timezone?
    PHP timezone?
    osTicket Default Timezone?
    osTicket Agent profile timezone?
  • edited January 13
    thanks.

    Server OS times zone?: PRC
    Database timezone?: asia/shanghai in my.cnf
    PHP timezone? PRC in php.in
    osTicket Default Timezone? asia/shanghai in admin setting
    osTicket Agent profile timezone? asia/shanghai in agent setting

    I think this might be a bug, I find a solution to this, and change the code, it works: https://github.com/liangxinhui/osTicket-Chinese

    it suggest two change:

    1. add  following code in my.cnf

    [msyqld]
    default-time_zone='+8:00'

    2. change return db_get_variable('system_time_zone', 'global'); in include/mysqli.php to return db_get_variable('time_zone', 'global');

Sign In or Register to comment.