Moodle

timezone olson.txt import throws DB errors due to incorrect field sizes

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Minor Minor
  • Resolution: Duplicate
  • Affects Version/s: 1.5, 1.5.1, 1.5.2, 1.5.3, 1.5.4, 1.6, 1.6.1, 1.6.2, 1.6.3, 1.6.4, 1.6.5, 1.7, 1.7.1, 1.7.2, 1.8, 1.8.1, 1.8.2
  • Fix Version/s: 1.8.4, 1.9, 2.0
  • Component/s: General
  • Labels:
    None
  • Database:
    PostgreSQL
  • Affected Branches:
    MOODLE_15_STABLE, MOODLE_16_STABLE, MOODLE_17_STABLE, MOODLE_18_STABLE
  • Fixed Branches:
    MOODLE_18_STABLE, MOODLE_19_STABLE, MOODLE_20_STABLE

Description

mdl_timezone.dst_time and mdl_timezone.std_time are varchar(5) which is too small to store a negative time these fields need to be changed to varchar(6).

Negative times in lib/timezones.txt have been truncated from -11:00 to -11:0 so importing this file files does not throw an error.

Issue Links

Activity

Hide
Eloy Lafuente (stronk7) added a comment -

Closed as duplicate of MDL-12024

Ciao

Show
Eloy Lafuente (stronk7) added a comment - Closed as duplicate of MDL-12024 Ciao

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: