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

Participation report fails when filtering by the first letter

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 2.7.1
    • Fix Version/s: 2.7.2
    • Component/s: Reports
    • Labels:
    • Testing Instructions:
      Hide
      1. Create a course with large number of participants (Make test course of size M will work)
      2. Go to the Participation report
      3. Click on any letter from the first name filter, last name filter, "All", etc
      4. Make sure there are no errors
      Show
      Create a course with large number of participants (Make test course of size M will work) Go to the Participation report Click on any letter from the first name filter, last name filter, "All", etc Make sure there are no errors
    • Affected Branches:
      MOODLE_27_STABLE
    • Fixed Branches:
      MOODLE_27_STABLE
    • Pull Master Branch:
      wip-MDL-47052-master

      Description

      1. Create a course with large number of participants (Make test course of size M will work)
      2. Go to the Participation report
      3. Click on any letter from the first name filter

      ERROR: missing param "ifirstc1" in query
       
      More information about this error
      Debug info:
      Error code: missingkeyinsql
      Stack trace:
       
          line 871 of /lib/dml/moodle_database.php: dml_exception thrown
          line 761 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->fix_sql_params()
          line 1476 of /lib/dml/moodle_database.php: call to pgsql_native_moodle_database->get_records_sql()
          line 1549 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()
          line 1759 of /lib/dml/moodle_database.php: call to moodle_database->get_field_sql()
          line 209 of /report/participation/index.php: call to moodle_database->count_records_sql()
      

      Originally mentioned here: https://tracker.moodle.org/browse/MDL-29812?focusedCommentId=307204&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-307204

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  8/Sep/14