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

Error in Outcomes report in Grade administration with ORACLE

    XMLWordPrintable

    Details

    • Database:
      Oracle
    • Testing Instructions:
      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";
    • Workaround:
      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
    • Difficulty:
      Easy
    • Affected Branches:
      MOODLE_25_STABLE, MOODLE_26_STABLE, MOODLE_27_STABLE, MOODLE_28_STABLE
    • Fixed Branches:
      MOODLE_27_STABLE, MOODLE_28_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      MDL-40776_master

      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

              Assignee:
              moodle.com moodle.com
              Reporter:
              sara.cenni Sara Cenni
              Peer reviewer:
              Zachary Durber
              Integrator:
              David Monllaó
              Tester:
              Rajesh Taneja
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                9/Mar/15