issue in Database Time zone

apyash

issue in Database Time zone

Server Information
Ticket Version v1.12.5 (933bb1f) — Up to date
Web Server Software Apache
MySQL Version 5.6.41
PHP Version 7.0.29

It supposed to be IST, but showing American Time. I have checked php.ini and it is showing correct as Asia / Kolkata.

Refer below Screenshot for the same.

RBGE

apyash You can log into MySQL and use an account with SUPER privileges to type

SET time_zone = timezone;

Ideally timezone would be SYSTEM and take the same value as your server (which is the default setting), but if for some reason this doesn't work you can always specify a UTC offset, such as +10:00 or -6:00 etc...

ntozier

As a side note, I believe that you have restart the MySQL service after this change.

apyash

I am using shared server, so is there any other way as I don't have access of root for the above suggested changes.

ntozier

Or you can upgrade to 1.14.1.

which added these PRs
https://github.com/osTicket/osTicket/pull/5163
https://github.com/osTicket/osTicket/pull/5164