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

Ensure user->idnumber has no NULL values before altering it in upgrade (64cc=>255cc)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.9.1
    • Fix Version/s: 1.9.2
    • Labels:
      None
    • Environment:
      Upgrading to Moodle 1.9.1
    • Affected Branches:
      MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE

      Description

      It seems that some old servers have their user->idnumber declared as nullable (with some nulls within it).

      In the 1.9 => 1.9.1 upgrade we changed that field from char(64) to char(255). When such change is performed, the missing NOT NULL clause is detected and enforced.

      And that crashes in the old servers commented above.

      Solution: Enforce not nulls are there by updating them to '' value before altering the table.

        Attachments

          Activity

            People

            • Assignee:
              stronk7 Eloy Lafuente (stronk7)
              Reporter:
              stronk7 Eloy Lafuente (stronk7)
              Tester:
              Dongsheng Cai
              Participants:
              Component watchers:
              Jake Dallimore, Jun Pataleta, Matteo Scaramuccia, Andrew Nicols, Mathew May, Michael Hawkins, Shamim Rezaie, Simey Lameze
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                11/Jul/08