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

Gradebook: Overview report tripping on bad order clause

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 1.9
    • Fix Version/s: 1.9
    • Component/s: Gradebook
    • Labels:
      None
    • Database:
      MySQL
    • URL:
      /grade/report/overview/index.php?id=2
    • Affected Branches:
      MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE

      Description

      When I go to view the I get:

      Overview report - Anthony Borrow
      Unknown column 'c.c.sortorder' in 'order clause'

      SELECT c.id,c.sortorder,c.shortname,c.idnumber,c.category,c.fullname,c.teacher,c.teachers,c.student,c.students,c.guest,c.startdate,c.visible,c.newsitems,c.cost,c.enrol,c.groupmode,c.groupmodeforce, ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, cc.path AS categorypath FROM mdl_course c JOIN mdl_course_categories cc ON c.category=cc.id JOIN mdl_context ctx ON (c.id=ctx.instanceid AND ctx.contextlevel=50) LEFT OUTER JOIN mdl_role_assignments ra ON (ra.contextid=ctx.id AND ra.userid=2) LEFT OUTER JOIN mdl_role_capabilities rc ON (rc.contextid=ctx.id AND (rc.capability='moodle/course:view' )) WHERE ra.id IS NOT NULL OR rc.id IS NOT NULL ORDER BY c.c.sortorder ASC

      • line 686 of lib/dmllib.php: call to debugging()
      • line 1022 of lib/accesslib.php: call to get_recordset_sql()
      • line 923 of lib/datalib.php: call to get_user_courses_bycap()
      • line 116 of grade/report/overview/lib.php: call to get_my_courses()
      • line 94 of grade/report/overview/index.php: call to grade_report_overview->fill_table()

      Fatal error: Call to a member function FetchRow() on a non-object in /home/arborrow/Moodle/code/19stable/lib/dmllib.php on line 814

      Peace - Anthony

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              skodak Petr Skoda
              Reporter:
              aborrow Anthony Borrow
              Tester:
              Anthony Borrow Anthony Borrow
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                3/Mar/08