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

Differences between upgraded and installed sites detected on blocks subsystem

    XMLWordPrintable

Details

    • MOODLE_20_STABLE
    • MOODLE_20_STABLE
    • Moderate

    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

            samhemelryk Sam Hemelryk
            stronk7 Eloy Lafuente (stronk7)
            Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan, Matteo Scaramuccia, Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Matteo Scaramuccia, Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              21/Feb/11