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

Reuse of sql param ID causes error with blind marking

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.2.2
    • Fix Version/s: 3.2.3
    • Component/s: Assignment
    • Labels:
    • Testing Instructions:
      Hide
      1. Setup a course with students and an assigment
      2. Turn on Blind Marking for the assignment
      3. Enter a user override for a student in the course
      4. Attempt to view the View all submissions table
      5. Confirm there is no error and that it looks correct.
      Show
      Setup a course with students and an assigment Turn on Blind Marking for the assignment Enter a user override for a student in the course Attempt to view the View all submissions table Confirm there is no error and that it looks correct.
    • Affected Branches:
      MOODLE_32_STABLE
    • Fixed Branches:
      MOODLE_32_STABLE
    • Pull Master Branch:
      MDL-58262-master

      Description

      In assign, with blink marking on, and if there are overrides, it reuses the named parameter assignmentid5, which results in a param mismatch error, making the View all submissions page inaccessible.

      Default exception handler: ERROR: Incorrect number of query parameters. Expected 47, got 46. Debug:
      Error code: invalidqueryparam
      * line 908 of /lib/dml/moodle_database.php: dml_exception thrown
      * line 773 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->fix_sql_params()
      * line 1553 of /lib/dml/moodle_database.php: call to pgsql_native_moodle_database->get_records_sql()
      * line 1626 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()
      * line 1836 of /lib/dml/moodle_database.php: call to moodle_database->get_field_sql()
      * line 1560 of /lib/tablelib.php: call to moodle_database->count_records_sql()
      * line 1614 of /lib/tablelib.php: call to table_sql->query_db()
      * line 1439 of /mod/assign/renderer.php: call to table_sql->out()
      * line 1235 of /mod/assign/renderer.php: call to mod_assign_renderer->flexible_table()
      * line 381 of /lib/outputrenderers.php: call to mod_assign_renderer->render_assign_grading_table()
      * line 4062 of /mod/assign/locallib.php: call to plugin_renderer_base->render()
      * line 4149 of /mod/assign/locallib.php: call to assign->view_grading_table()
      * line 575 of /mod/assign/locallib.php: call to assign->view_grading_page()
      * line 55 of /mod/assign/view.php: call to assign->view()

       

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  8/May/17