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

Differences between upgraded and installed sites detected on blocks subsystem

    XMLWordPrintable

    Details

    • Difficulty:
      Moderate
    • Affected Branches:
      MOODLE_20_STABLE
    • Fixed Branches:
      MOODLE_20_STABLE

      Description

      Was playing with moodle.org (upgraded from 1.9 recently as you know), and detected this differences from clean install:

      • missing index: CREATE INDEX blocinst_par_ix ON block_instances (parentcontextid);
      • differences in columns:
        • blockinstances->defaultweight size = 3 @ moodle.org (should be 10)
        • block_positions->blockinstanceid missing unsigned property

      Surely minor details to be fixed on upgrade to make no differences between upgraded/installed sites. Note the index can have impact in performance and the size could (in theory) lead to storage problems too.

      Triaging to STABLE, would be great to have this fixed in next iteration. Ciao

        Attachments

          Activity

            People

            • Assignee:
              samhemelryk Sam Hemelryk
              Reporter:
              stronk7 Eloy Lafuente (stronk7)
              Participants:
              Component watchers:
              Adrian Greeve, Mihail Geshoski, Peter Dias, Matteo Scaramuccia, Andrew Nicols, Mathew May, Michael Hawkins, Shamim Rezaie, Simey Lameze, Matteo Scaramuccia, Jake Dallimore, Jun Pataleta, Ryan Wyllie
            • Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                21/Feb/11