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

Errors in SQL in file browser file_info_context_coursecat.php on postgresql 8.3

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Minor
    • 2.3.4, 2.4.1
    • 2.3.3, 2.4
    • Filepicker

    Description

      Two lines in file_info_context_coursecat.php are missing "AS" in the SQL command causing an error when attempting to view the server files in tree mode.

      207 $rs = $DB->get_recordset_sql('SELECT ctx.id contextid, c.visible -> $rs = $DB>get_recordset_sql('SELECT ctx.id AS contextid, c.visible

      229 $rs = $DB->get_recordset_sql('SELECT ctx.id contextid, c.visible -> $rs = $DB>get_recordset_sql('SELECT ctx.id AS contextid, c.visible

      The error was discovered on v. 2.3.3 but appears not to have been fixed on 2.4 either.

      Attachments

        Issue Links

          Activity

            People

              skodak Petr Skoda (Inactive)
              trobb Thomas Robb
              Dan Poltawski Dan Poltawski
              Mark Nelson Mark Nelson
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Clockify

                  Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.