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

cleanup_contexts() broken SQL - breaks upgrades

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.9
    • 1.9
    • Roles / Access
    • None
    • Oracle
    • MOODLE_19_STABLE
    • MOODLE_19_STABLE

    Description

      accesslib:cleanup_contexts() - Fix invalid SQL syntax and reserved keywords

      cleanup_contexts() was not working on Oracle - mostly due to 2 SQL
      syntax problems. So probably marginally working elsewhere.

      • We should not use AS when naming table/subselect aliases - only
        when referring to column aliases in the resultset
      • level is a reserved word - oops! - so back to contextlevel

      This was breaking upgrades to 1.9 on Oracle.

      Attachments

        Activity

          People

            martinlanghoff Martín Langhoff
            martinlanghoff Martín Langhoff
            Nobody Nobody
            Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Ilya Tregubov, Sara Arjona (@sarjona)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              3/Mar/08