Hi,
we had to change the timezone on all our servers and little by little we discover some problems.
After changing the time to GMT+1 all real-time summarys added 60min on pause/talk times. For example in AST_timeonVDADall.php around line 600 the sql-query uses UNIX_TIMESTAMP(last_call) which produces the difference if you are not in the UTC(GMT) timezone. To solve the problem quickly I hardcoded additional 3600sec in the calculation.
Maybe somebody has a more elegant way to deal with GMT offset...
Thanks
heinz
Timechange problems
Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
2 posts
• Page 1 of 1
Timechange problems
by heinz » Thu Nov 01, 2007 4:06 am
- heinz
- Posts: 106
- Joined: Mon Oct 08, 2007 1:30 am
- Location: South Africa
by mflorell » Thu Nov 01, 2007 12:51 pm
The best thing to do is make sure that all of your servers table gmt_offset settings are synchronized to the actual timezone settings for your machine(NOT ADJUSTED FOR GMT). And you should update your OS to use the proper timezone scheme(NOT MANUALLY CHANGING THE TIME AT DST START AND END).
- mflorell
- Site Admin
- Posts: 18387
- Joined: Wed Jun 07, 2006 2:45 pm
- Location: Florida
2 posts
• Page 1 of 1
Who is online
Users browsing this forum: Google [Bot] and 153 guests