Monday, April 2, 2012

Webcal timezone fix

When using web cal 1.2.x, events were all showing in Eastern time. Events previously scheduled at 9am PT were now showing up as 12n ET. Even when you change the timezone in the WebUI settings page, web cal always shows the current GMT offset as -4. 

The problem is that there are two variables 'TIMEZONE' and 'SERVER_TIMEZONE'.Only one is changed using the WebUI. So you need to login the database manually using phomyadmin and set the timezone correctly on both variables.


mysql> update webcal_config set cal_value="America/Los_Angeles" where cal_setting="TIMEZONE";
mysql> update webcal_config set cal_value="America/Los_Angeles" where cal_setting="SERVER_TIMEZONE";