Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-50006

Est timezones are stored/updated with wrong information

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.8.5
    • Fix Version/s: None
    • Component/s: Calendar
    • Labels:
    • Affected Branches:
      MOODLE_28_STABLE

      Description

      In the database EST timezones (eg. Etc/GMT+5) is stored with the hour offset and not the minute offset in the database.

      That means when the get_user_timezone_offset function gets the record and divides with minutes per hour the offset is completely off.

      8:30 CET becomes 6:25 Etc/GMT+5 because the offset is calculated to -0.083333333333333

      Solution:

      Update the timezone information in the database to minutes,

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              jethac Jetha Chan
              Reporter:
              ecomerc Peter Obel
              Participants:
              Component watchers:
              Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated: