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

Export Grades, Preview has the message 'Error reading from database' - rainnner

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.0.2
    • Fix Version/s: None
    • Component/s: Gradebook
    • Labels:
      None
    • Environment:
      NA
    • Database:
      Any
    • Difficulty:
      Easy
    • Affected Branches:
      MOODLE_20_STABLE

      Description

      line 161 in grade/lib.php

      "rainnner ON rainner.userid = u.id"

      rainnner should be spelt rainner

      To reproduce:

      Go to a course, export grades as a plain text file. On the preview page, the error appears.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

              Hide
              andyjdavis Andrew Davis added a comment -

              2.0 version

              repo: git://github.com/andyjdavis/moodle.git
              branch: MDL-27153_grade_export_preview_sql
              diff: https://github.com/andyjdavis/moodle/compare/MOODLE_20_STABLE...MDL-27153_grade_export_preview_sql

              Show
              andyjdavis Andrew Davis added a comment - 2.0 version repo: git://github.com/andyjdavis/moodle.git branch: MDL-27153 _grade_export_preview_sql diff: https://github.com/andyjdavis/moodle/compare/MOODLE_20_STABLE...MDL-27153_grade_export_preview_sql
              Hide
              andyjdavis Andrew Davis added a comment -

              2.1 version

              repo: git://github.com/andyjdavis/moodle.git
              branch: MDL-27153_grade_export_preview_sql_MASTER
              diff: https://github.com/andyjdavis/moodle/compare/master...MDL-27153_grade_export_preview_sql_MASTER

              Show
              andyjdavis Andrew Davis added a comment - 2.1 version repo: git://github.com/andyjdavis/moodle.git branch: MDL-27153 _grade_export_preview_sql_MASTER diff: https://github.com/andyjdavis/moodle/compare/master...MDL-27153_grade_export_preview_sql_MASTER
              Hide
              andyjdavis Andrew Davis added a comment -

              Thankyou for the report bunwich

              Ive create pull requests for consideration by the integrators.
              PULL-653 PULL-654

              Show
              andyjdavis Andrew Davis added a comment - Thankyou for the report bunwich Ive create pull requests for consideration by the integrators. PULL-653 PULL-654
              Hide
              negations Paul Taylor added a comment -

              Hi:

              Looks like there is an issue related to this. I am getting the error and no export as are some other users in this forum:

              http://moodle.org/mod/forum/discuss.php?d=173281&parent=759396

              Error message is:

              Debug info: Unknown column 'rainner.userid' in 'on clause'
              SELECT g.* , u.lastname AS usrt1, u.firstname AS usrt2, u.id AS usrt
              FROM mdl_grade_grades g
              JOIN mdl_user u ON g.userid = u.id
              JOIN (SELECT DISTINCT eu1_u.id
              FROM mdl_user eu1_u
              JOIN mdl_user_enrolments eu1_ue ON eu1_ue.userid = eu1_u.id
              JOIN mdl_enrol eu1_e ON (eu1_e.id = eu1_ue.enrolid AND eu1_e.courseid = ?)
              WHERE eu1_u.deleted = 0 AND eu1_u.id <> ?) je ON je.id = u.id

              JOIN (
              SELECT DISTINCT ra.userid
              FROM mdl_role_assignments ra
              WHERE ra.roleid = ?
              AND ra.contextid IN (16,3,1)
              ) rainnner ON rainner.userid = u.id
              WHERE u.deleted = 0
              AND g.itemid IN (?,?,?)

              ORDER BY usrt1 ASC, usrt2 ASC, usrt ASC, g.itemid ASC
              [array (
              0 => '2',
              1 => '1',
              2 => '5',
              3 => 26,
              4 => 27,
              5 => 25,
              )]
              Stack trace:

              line 391 of /lib/dml/moodle_database.php: dml_read_exception thrown
              line 749 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
              line 166 of /grade/lib.php: call to mysqli_native_moodle_database->get_recordset_sql()
              line 225 of /grade/export/lib.php: call to graded_users_iterator->init()
              line 59 of /grade/export/xls/index.php: call to grade_export->display_preview()

              Show
              negations Paul Taylor added a comment - Hi: Looks like there is an issue related to this. I am getting the error and no export as are some other users in this forum: http://moodle.org/mod/forum/discuss.php?d=173281&parent=759396 Error message is: Debug info: Unknown column 'rainner.userid' in 'on clause' SELECT g.* , u.lastname AS usrt1, u.firstname AS usrt2, u.id AS usrt FROM mdl_grade_grades g JOIN mdl_user u ON g.userid = u.id JOIN (SELECT DISTINCT eu1_u.id FROM mdl_user eu1_u JOIN mdl_user_enrolments eu1_ue ON eu1_ue.userid = eu1_u.id JOIN mdl_enrol eu1_e ON (eu1_e.id = eu1_ue.enrolid AND eu1_e.courseid = ?) WHERE eu1_u.deleted = 0 AND eu1_u.id <> ?) je ON je.id = u.id JOIN ( SELECT DISTINCT ra.userid FROM mdl_role_assignments ra WHERE ra.roleid = ? AND ra.contextid IN (16,3,1) ) rainnner ON rainner.userid = u.id WHERE u.deleted = 0 AND g.itemid IN (?,?,?) ORDER BY usrt1 ASC, usrt2 ASC, usrt ASC, g.itemid ASC [array ( 0 => '2', 1 => '1', 2 => '5', 3 => 26, 4 => 27, 5 => 25, )] Stack trace: line 391 of /lib/dml/moodle_database.php: dml_read_exception thrown line 749 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end() line 166 of /grade/lib.php: call to mysqli_native_moodle_database->get_recordset_sql() line 225 of /grade/export/lib.php: call to graded_users_iterator->init() line 59 of /grade/export/xls/index.php: call to grade_export->display_preview()
              Hide
              negations Paul Taylor added a comment -

              Sorry, upgrade to 20/04 codebase fixed the problem.

              Show
              negations Paul Taylor added a comment - Sorry, upgrade to 20/04 codebase fixed the problem.

                People

                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: