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

New Olson timezone files require dst_time and std_time fields of size 6 instead of 5

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 1.8.3, 1.9, 2.0
    • 1.8.4, 1.9, 2.0
    • Database SQL/XMLDB
    • None
    • Linux 2.6.22, Ubuntu 7.10, Postgres 8.1
    • PostgreSQL
    • MOODLE_18_STABLE, MOODLE_19_STABLE, MOODLE_20_STABLE
    • MOODLE_18_STABLE, MOODLE_19_STABLE, MOODLE_20_STABLE

    Description

      These patches upgrade dst_time and std_time fields in timezone to varchar(6)

      These fields were varchar(5) and that's too small to upgrade using the latest Olson data (which contains the new daylight saving rules for New Zealand for example).

      The patches apply cleanly against:

      • MOODLE_18_STABLE
      • MOODLE_19_STABLE
      • CVSHEAD

      Francois

      Attachments

        Issue Links

          has been marked as being related by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-12699 META: Curl, download and componentlib issues

          • Critical - Crashes server, loss of data, severe memory leak
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-11127 timezone olson.txt import throws DB errors due to incorrect field sizes

          • Minor - Minor loss of function where workaround is possible
          • Closed

          Activity

            People

              stronk7 Eloy Lafuente (stronk7)
              francois Francois Marier
              Nobody Nobody
              David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                11/Jan/08