Time Zome / time Issue: Page 2

Time Zome / time Issue

rsclmumbai

indranilkamulkar try to set the timezone based on the difference in time you are seeing.

hemanthnalluri

Facing the same issue.. In the DB,time is proper.. Issue is only with the displaying in the OSTICKET Frontend.

ntozier

Is your Agent Profile timezone incorrect?

hemanthnalluri

ntozier Yes, my agent profile is also set to IST ( Indian standard time).

KevinTheJedi

@rsclmumbai @hemanthnalluri

The problem is actually with PHP's native timezone_name_from_abbr() method. When passing 'IST' to this method it returns 'Asia/Jerusalem' like we see in all these cases. Seems like this needs to be addressed on their level. I can create a patch to temporarily return 'Asia/Kolkata' instead but this is only a bandaid instead of a permanent fix.

Cheers.

rsclmumbai

KevinTheJedi The problem is actually with PHP's native timezone_name_from_abbr() method. When passing 'IST' to this method it returns 'Asia/Jerusalem' like we see in all these cases. Seems like this needs to be addressed on their level. I can create a patch to temporarily return 'Asia/Kolkata' instead but this is only a bandaid instead of a permanent fix.

@KevinTheJedi
If you modify the code to:
timezone_name_from_abbr($xxxx,$offset);
It will work fine. I have tested this.

KevinTheJedi

@rsclmumbai

We don’t have an $offset variable and how would we know what each offset will be for each timezone?

Cheers.

rsclmumbai

KevinTheJedi
Either the user will have to set the offset.

Where is OST getting abbreviated timezone from?
Can OST rely on full timezone instead of abbreviated tz?

KevinTheJedi

@rsclmumbai

The abbreviated time zone is coming from MySQL (@@GLOBAL.system_time_zone).

I will get back to you on the exact reason why we translate the abbreviations to full names.

Cheers.

rsclmumbai

For me, SELECT @@global.time_zone shows "SYSTEM" & not IST
This brings me to the command echo date_default_timezone_get(); and it shows "Asia/Kolkata"

I'm following this thread on stackoverflow:
https://stackoverflow.com/questions/2934258/how-do-i-get-the-current-time-zone-of-mysql

Would it be better to use the timezone selection by the user so get past this issue in the simplest possible way, without having to rely on external parties like MySQL or PHP etc?

kalepranali044

rsclmumbai Did you find the solution. I am facing exactly the same problem. If you fond any solution please let me know.

rsclmumbai

kalepranali044 I had to tweak the time zone to match the timezone of my users.
My users are in IST time zone (+5.30) but I had to select ""Athens"" at the timezone for the time to match accurately.
HTH

« Previous Page