Timechange problems
Posted: Thu Nov 01, 2007 4:06 am
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
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