I just upgraded to v1.2.1 to fix the problem of not being able to add dates after December 2010. That problem is fixed, but now all the existing events in my calendar now show the wrong times. Our calendar events take place in America/New York -4 GMT. When I upgraded our settings showed -4GMT in both our preferences and our system settings. I realize now that our server is really located in American/Vancourver -7 GMT, but I didn't have that set properly originally.
Anyway, when I upgraded, suddenly all of our events were listed as 7 hours later than they should be. For example an event at 8:30am on 5/29/10 shows up as 3:30pm. I have fixed this for the time being by switching our preferences time zone to -11GMT Pacific/Midway, but this is not a good solution. When users try to sync with other icalendars the event times will be off schedule. For example when I view the events on my blackberry or in google calendar.
What can I do? Is there something I can go into the code to adjust? I need for already entered events to show the correct time in the correct time zone and I need events added in the future to be entered in the correct time zone.
Should I go back an install v 1.2.0? Then try to reinstall v 1.2.1 later?
Should I just manually go in and change all the events' times for existing events?
Thanks!
System Settings
PROGRAM_NAME: WebCalendar v1.2.1 (09 Apr 2010)
SERVER_SOFTWARE: Apache/2.2.3 (CentOS)
Web Browser: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.2.3) Gecko/20100401 Firefox/3.6.3 GTB7.0 ( .NET CLR 3.5.30729)
PHP Version: 5.1.6
Default Encoding:
db_type: mysql
readonly: N
single_user: N
single_user_login:
use_http_auth: N
user_inc: user.php
ADD_LINK_IN_VIEWS: N
ADMIN_OVERRIDE_UAC: Y
ALLOW_ATTACH: N
ALLOW_ATTACH_ANY: N
ALLOW_ATTACH_PART: N
ALLOW_COLOR_CUSTOMIZATION: Y
ALLOW_COMMENTS: N
ALLOW_COMMENTS_ANY: N
ALLOW_COMMENTS_PART: N
ALLOW_CONFLICTS: Y
ALLOW_CONFLICT_OVERRIDE: Y
ALLOW_EXTERNAL_HEADER: N
ALLOW_EXTERNAL_USERS: Y
ALLOW_HTML_DESCRIPTION: Y
ALLOW_SELF_REGISTRATION: N
ALLOW_USER_HEADER: N
ALLOW_USER_THEMES: Y
ALLOW_VIEW_OTHER: Y
APPLICATION_NAME: HPS Source Book Online
APPROVE_ASSISTANT_EVENT: Y
AUTO_REFRESH: N
AUTO_REFRESH_TIME: 0
BGCOLOR: #FFFFFF
BGREPEAT: repeat fixed center
BOLD_DAYS_IN_YEAR: Y
CAPTIONS: #B04040
CATEGORIES_ENABLED: Y
CELLBG: #C0C0C0
CONFLICT_REPEAT_MONTHS: 6
CUSTOM_HEADER: Y
CUSTOM_SCRIPT: N
CUSTOM_TRAILER: Y
DATE_FORMAT: LANGUAGE_DEFINED
DATE_FORMAT_MD: LANGUAGE_DEFINED
DATE_FORMAT_MY: LANGUAGE_DEFINED
DATE_FORMAT_TASK: LANGUAGE_DEFINED
DEMO_MODE: N
DISABLE_ACCESS_FIELD: N
DISABLE_CROSSDAY_EVENTS: N
DISABLE_LOCATION_FIELD: N
DISABLE_PARTICIPANTS_FIELD: N
DISABLE_POPUPS: N
DISABLE_PRIORITY_FIELD: N
DISABLE_REMINDER_FIELD: N
DISABLE_REPEATING_FIELD: N
DISABLE_URL_FIELD: N
DISPLAY_ALL_DAYS_IN_MONTH: N
DISPLAY_CREATED_BYPROXY: Y
DISPLAY_DESC_PRINT_DAY: Y
DISPLAY_END_TIMES: N
DISPLAY_LOCATION: N
DISPLAY_LONG_DAYS: N
DISPLAY_MINUTES: N
DISPLAY_MOON_PHASES: N
DISPLAY_SM_MONTH: Y
DISPLAY_TASKS: N
DISPLAY_TASKS_IN_GRID: N
DISPLAY_UNAPPROVED: Y
DISPLAY_WEEKENDS: Y
DISPLAY_WEEKNUMBER: Y
EMAIL_ASSISTANT_EVENTS: Y
EMAIL_EVENT_ADDED: Y
EMAIL_EVENT_CREATE: N
EMAIL_EVENT_DELETED: Y
EMAIL_EVENT_REJECTED: Y
EMAIL_EVENT_UPDATED: Y
EMAIL_FALLBACK_FROM: youremailhere
EMAIL_HTML: N
EMAIL_MAILER: mail
EMAIL_REMINDER: Y
ENABLE_CAPTCHA: N
ENABLE_GRADIENTS: N
ENABLE_ICON_UPLOADS: N
ENTRY_SLOTS: 144
EXTERNAL_NOTIFICATIONS: N
EXTERNAL_REMINDERS: N
FONTS: Arial, Helvetica, sans-serif
FREEBUSY_ENABLED: N
GENERAL_USE_GMT: N
GROUPS_ENABLED: N
H2COLOR: #000000
HASEVENTSBG: #FFFF33
HOME_LINK: http://www.hptaonline.com/
IMPORT_CATEGORIES: Y
LANGUAGE: none
LIMIT_APPTS: N
LIMIT_APPTS_NUMBER: 6
LIMIT_DESCRIPTION_SIZE: N
MENU_DATE_TOP: Y
MENU_ENABLED: Y
MENU_THEME: default
MYEVENTS: #006000
NONUSER_AT_TOP: Y
NONUSER_ENABLED: Y
OTHERMONTHBG: #D0D0D0
OVERRIDE_PUBLIC: N
OVERRIDE_PUBLIC_TEXT: Not available
PARTICIPANTS_IN_POPUP: N
PLUGINS_ENABLED: N
POPUP_BG: #FFFFFF
POPUP_FG: #000000
PUBLIC_ACCESS: Y
PUBLIC_ACCESS_ADD_NEEDS_APPROVAL: N
PUBLIC_ACCESS_CAN_ADD: N
PUBLIC_ACCESS_DEFAULT_SELECTED: N
PUBLIC_ACCESS_DEFAULT_VISIBLE: Y
PUBLIC_ACCESS_OTHERS: Y
PUBLIC_ACCESS_VIEW_PART: N
PUBLISH_ENABLED: Y
PULLDOWN_WEEKNUMBER: N
REMEMBER_LAST_LOGIN: N
REMINDER_DEFAULT: N
REMINDER_OFFSET: 240
REMINDER_WITH_DATE: N
REMOTES_ENABLED: Y
REPORTS_ENABLED: Y
REQUIRE_APPROVALS: N
RSS_ENABLED: Y
SELF_REGISTRATION_BLACKLIST: N
SELF_REGISTRATION_FULL: Y
SEND_EMAIL: N
SERVER_TIMEZONE: America/Vancouver
SERVER_URL: http://www.hptaonline.com/webcalendar/
SITE_EXTRAS_IN_POPUP: N
SMTP_AUTH: N
SMTP_HOST: localhost
SMTP_PORT: 25
STARTVIEW: view_l.php?id=2
SUMMARY_LENGTH: 80
TABLEBG: #000000
TEXTCOLOR: #000000
THBG: #FFFFFF
THEME: none
THFG: #000000
TIMED_EVT_LEN: D
TIMEZONE: America/New_York
TIME_FORMAT: 12
TIME_SLOTS: 24
TIME_SPACER: »
TODAYCELLBG: #FFFF33
UAC_ENABLED: Y
UPCOMING_ALLOW_OVR: Y
UPCOMING_DISPLAY_CAT_ICONS: Y
UPCOMING_DISPLAY_LAYERS: Y
UPCOMING_DISPLAY_LINKS: Y
UPCOMING_DISPLAY_POPUPS: Y
UPCOMING_EVENTS: Y
USER_PUBLISH_ENABLED: Y
USER_PUBLISH_RW_ENABLED: Y
USER_RSS_ENABLED: N
USER_SEES_ONLY_HIS_GROUPS: Y
USER_SORT_ORDER: cal_firstname, cal_lastname
WEBCAL_PROGRAM_VERSION: v1.2.1
WEBCAL_TZ_CONVERSION: Y
WEEKENDBG: #D0D0D0
WEEKEND_START: 6
WEEKNUMBER: #FF6633
WEEK_START: 0
WORK_DAY_END_HOUR: 17
WORK_DAY_START_HOUR: 8
Rerun install/index.php but first checkout the comments in the head of that file...see below.
* Input Parameters:
* OPTIONAL tzoffset If after logging in, adding tzoffset to
* the URL ( http://yourserver/install/index.php?tzoffset=2 )
* will adjust all existing events in the database +2 hours.
* OPTIONAL cutoffdate (YYYYMMDD) When adjusting the tzoffset
* the URL ( http://yourserver/install/index.php?tzoffset=2&cutoffdate=20070110 )
* will adjust all events <= 20070110 in the database +2 hours.
* This is very handy if your server changes timezones after installation.
Ray
This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).