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

Reuse of sql param ID causes error with blind marking

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 3.2.2
    • 3.2.3
    • Assignment
    • MOODLE_32_STABLE
    • MOODLE_32_STABLE
    • MDL-58262-master
    • 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.

    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

              emerrill Eric Merrill
              emerrill Eric Merrill
              Juan Leyva Juan Leyva
              Dan Poltawski Dan Poltawski
              Simey Lameze Simey Lameze
              Adrian Greeve, Ilya Tregubov, Kevin Percy, Mathew May, Mihail Geshoski, Shamim Rezaie
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                8/May/17