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

ERROR: missing param "ej1_e1" in query on participants filtering

    XMLWordPrintable

    Details

    • Testing Instructions:
      Hide
      1. Create a course.
      2. Manually enrol one or more participants.
      3. Suspend one or more of the participants.
      4. Filter the participants by enrolment method and suspended enrolment status ("Status: Inactive")
        • Confirm that you don't see an error.
        • Confirm that you get the list of suspended participants.
      5. Do a number of combinations of filters and ensure that you don't get any errors.
      Show
      Create a course. Manually enrol one or more participants. Suspend one or more of the participants. Filter the participants by enrolment method and suspended enrolment status ("Status: Inactive") Confirm that you don't see an error. Confirm that you get the list of suspended participants. Do a number of combinations of filters and ensure that you don't get any errors.
    • Affected Branches:
      MOODLE_34_STABLE
    • Fixed Branches:
      MOODLE_34_STABLE
    • Pull Master Branch:
      MDL-59984-master

      Description

      While testing MDL-59828 I ran into this issue on the new Participants page.

      When I set the filter to

      • Enrolment methods: Manual enrolments
      • Role: Teacher
      • Status: Inactive

      I get ERROR: missing param "ej1_e1" in query

      Debug info: 
      Error code: missingkeyinsql
       
      Stack trace:
      line 948 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 1571 of /lib/dml/moodle_database.php: call to pgsql_native_moodle_database->get_records_sql()
      line 1644 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()
      line 1854 of /lib/dml/moodle_database.php: call to moodle_database->get_field_sql()
      line 1356 of /user/lib.php: call to moodle_database->count_records_sql()
      line 433 of /user/classes/participants_table.php: call to user_get_total_participants()
      line 1630 of /lib/tablelib.php: call to core_user\participants_table->query_db()
      line 251 of /user/classes/participants_table.php: call to table_sql->out()
      line 210 of /user/index.php: call to core_user\participants_table->out()
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                jpataleta Jun Pataleta
                Reporter:
                mudrd8mz David Mudrák (@mudrd8mz)
                Peer reviewer:
                Ankit Agarwal
                Integrator:
                Eloy Lafuente (stronk7)
                Tester:
                Mihail Geshoski
                Participants:
                Component watchers:
                Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona), Víctor Déniz Falcón, Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona), Víctor Déniz Falcón
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  13/Nov/17