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

\\moodledev\mod\quiz\report\reportlib.php where the tables have been hardcoded with a prefix of "mdl" - causing an error.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 1.9.1
    • 1.9.2
    • Quiz
    • None
    • Oracle
    • MOODLE_19_STABLE
    • MOODLE_19_STABLE

    Description

      The following error appeared in our logs last Friday.
      [Fri May 23 07:05:30 2008] [error] SQL ORA-00942: table or view does not exist in /var/www/html/moodle/lib/dmllib.php on line 1078. STATEMENT: SELECT\n FLOOR(qg.grade*10/q.grade) AS band,\n COUNT(1) AS num\n FROM\n mdl_quiz_grades qg, \n mdl_quiz q\n WHERE qg.quiz = q.id AND qg.quiz = 4723 AND qg.userid IN (11223)\n GROUP BY band\n ORDER BY band with limits (, ), referer: http://usqstudydesk.usq.edu.au/mod/quiz/report.php?q=4723

      Bug found in \mod\quiz\report\reportlib.php in the following function:
      function quiz_report_grade_bands($bandwidth, $bands, $quizid, $useridlist){
      $sql = "SELECT
      FLOOR(qg.grade/$bandwidth) AS band,
      COUNT(1) AS num
      FROM
      mdl_quiz_grades qg,
      mdl_quiz q
      WHERE qg.quiz = q.id AND qg.quiz = $quizid AND qg.userid IN ($useridlist)
      GROUP BY band
      ORDER BY band";

      Attachments

        Activity

          People

            jamiesensei Jamie Pratt
            ayong Andrew Yong
            Jérôme Mouneyrac Jérôme Mouneyrac
            Tim Hunt, Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              11/Jul/08