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

Error in Outcomes report in Grade administration with ORACLE

XMLWordPrintable

    • Oracle
    • MOODLE_25_STABLE, MOODLE_26_STABLE, MOODLE_27_STABLE, MOODLE_28_STABLE
    • MOODLE_27_STABLE, MOODLE_28_STABLE
    • MDL-40776_master
    • Hide

      Just add a space in line 77 (file: grade/report/outcomes/index.php) before GROUP

      Show
      Just add a space in line 77 (file: grade/report/outcomes/index.php) before GROUP
    • Easy
    • Hide

      Test in all DBs:

      1) enable Outcomes
      2) create a course
      3) create an Outcome
      4) create an Assignment and flag the outcome
      5) click on "Grades";
      6) click on "Outcomes report" in "Grade administration";

      Show
      Test in all DBs: 1) enable Outcomes 2) create a course 3) create an Outcome 4) create an Assignment and flag the outcome 5) click on "Grades"; 6) click on "Outcomes report" in "Grade administration";

      When I try to see Outcomes report in Grade administration I get this error.
      Using ORACLE DB the step are the following:
      1) enable Outcomes
      2) create a course
      3) create an Outcome
      4) create an Assignment and flag the outcome
      5) click on "Grades";
      6) click on "Outcomes report" in "Grade administration";

      Then I get this error:
      Debug info: ORA-00933: SQL command not properly ended

      SELECT itemid, AVG(finalgrade) AS avg, COUNT(finalgrade) AS count
      FROM d_grade_grades
      WHERE itemid = :o_param1GROUP BY itemid
      [array (
      'o_param1' => 439,
      )]

      I fixed the error adding a space in line 77 (file: grade/report/outcomes/index.php) before GROUP

      73 $sql = "SELECT itemid, AVG(finalgrade) AS avg, COUNT(finalgrade) AS count
      74 FROM

      {grade_grades}

      75 WHERE itemid = ?".
      76 $hidesuspendedsql.
      77 "GROUP BY itemid";

      modifying the line in " GROUP BY itemid";

            moodle.com Moodle HQ
            sara.cenni Sara Cenni
            Zachary Durber Zachary Durber
            David Monllaó David Monllaó
            Rajesh Taneja Rajesh Taneja
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved:

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