Uploaded image for project: 'ZZZ: PUBLIC - Old Liferay Portal (Use Liferay Portal Standard Edition)'
  1. ZZZ: PUBLIC - Old Liferay Portal (Use Liferay Portal Standard Edition)
  2. LEP-5787

Change timezones to behave as expected for end users. Specfically PST, CST and EST

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 4.4.2, 5.0.1
    • Fix Version/s: 5.1.0
    • Component/s: None
    • Labels:
      None

      Description

      time.zones=Pacific/Midway,Pacific/Honolulu,America/Anchorage,America/Los_Angeles,America/Phoenix,America/Chicago,America/New_York,America/Puerto_Rico,America/St_Johns,
      America/Sao_Paulo,America/Noronha,Atlantic/Azores,GMT,Africa/Casablanca,Europe/Paris,Europe/Istanbul,Asia/Jerusalem,Asia/Baghdad,Iran,Asia/Dubai,Asia/Kabul,Asia/Karachi,Asia/Calcutta,
      Asia/Katmandu,Asia/Dhaka,Asia/Rangoon,Asia/Saigon,Asia/Shanghai,Asia/Tokyo,ROK,Australia/Darwin,Australia/Sydney,Pacific/Guadalcanal,Pacific/Auckland,Pacific/Enderbury,Pacific/Kiritimati

      (Added line breaks to make the post easier to read.)

      *ROK does not appear to be a valid time zone. See:
      http://cycleserv2.csail.mit.edu/Harpoon/srcdoc/java/util/TimeZone.html

      Upgrade script:
      update User_ set timeZoneId = America/Anchorage where timeZoneId = AST;
      update User_ set timeZoneId = America/Los_Angeles where timeZoneId = PST;
      update User_ set timeZoneId = America/Phoenix where timeZoneId = MST;
      update User_ set timeZoneId = America/Chicago where timeZoneId = CST;
      update User_ set timeZoneId = America/New_York where timeZoneId = EST;
      update User_ set timeZoneId = America/Puerto_Rico where timeZoneId = PRT;
      update User_ set timeZoneId = America/St_Johns where timeZoneId = CNT;
      update User_ set timeZoneId = America/Sao_Paulo where timeZoneId = BET;
      update User_ set timeZoneId = Africa/Casablanca where timeZoneId = WET;
      update User_ set timeZoneId = Europe/Paris where timeZoneId = CET;
      update User_ set timeZoneId = Europe/Istanbul where timeZoneId = EET;
      update User_ set timeZoneId = Asia/Calcutta where timeZoneId = IST;
      update User_ set timeZoneId = Asia/Saigon where timeZoneId = VST;
      update User_ set timeZoneId = Asia/Shanghai where timeZoneId = CTT;
      update User_ set timeZoneId = Asia/Tokyo where timeZoneId = JST;
      update User_ set timeZoneId = Australia/Darwin where timeZoneId = ACT;
      update User_ set timeZoneId = Australia/Sydney where timeZoneId = AET;
      update User_ set timeZoneId = Pacific/Guadalcanal where timeZoneId = SST;
      update User_ set timeZoneId = Pacific/Auckland where timeZoneId = NST;

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              edward.shin Edward Shin (Inactive)
              Reporter:
              edward.shin Edward Shin (Inactive)
              Participants of an Issue:
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Packages

                  Version Package
                  5.1.0