Menu

#298 Upgraded to 1.2.1 now all my events have the wrong time

closed
None
5
2011-05-26
2010-05-22
hptaonline
No

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

Discussion

  • Ray Jones

    Ray Jones - 2011-05-12

    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

     
  • Ray Jones

    Ray Jones - 2011-05-12
    • assigned_to: nobody --> rjones6061
    • status: open --> pending
     
  • SourceForge Robot

    • status: pending --> closed
     
  • SourceForge Robot

    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).

     

Log in to post a comment.