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
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                9/Mar/15