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

Participation report fails when filtering by the first letter

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Critical Critical
    • 2.7.2
    • 2.7.1
    • Reports
    • MOODLE_27_STABLE
    • MOODLE_27_STABLE
    • wip-MDL-47052-master
    • 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

      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

            marina Marina Glancy
            marina Marina Glancy
            Rajesh Taneja Rajesh Taneja
            Damyon Wiese Damyon Wiese
            Zachary Durber Zachary Durber
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.