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

Error in Outcomes report in Grade administration with ORACLE

    XMLWordPrintable

Details

    • 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";

    Description

      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";

      Attachments

        Issue Links

          Activity

            People

              moodle.com Moodle HQ
              sara.cenni Sara Cenni
              Zachary Durber Zachary Durber
              David Monllaó David Monllaó
              Rajesh Taneja Rajesh Taneja
              Adrian Greeve, Ilya Tregubov, Kevin Percy, Mathew May, Mihail Geshoski, Shamim Rezaie
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                9/Mar/15