[MDL-47052] Participation report fails when filtering by the first letter - Moodle Tracker

XML

Word

Printable

Affected Branches:
MOODLE_27_STABLE
Fixed Branches:
MOODLE_27_STABLE
Pull from Repository:
git://github.com/marinaglancy/moodle.git
Pull Master Branch:
wip-~~MDL-47052~~-master
Pull Master Diff URL:
https://github.com/marinaglancy/moodle/compare/master...wip-MDL-47052-master
Testing Instructions:
Hide

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
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

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

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()

is a regression caused by

MDL-41283 Convert Course participation report to new logging API

Participants:: CiBoT, Damyon Wiese, Eloy Lafuente (stronk7), Gisele Brugger, Marina Glancy, Rajesh Taneja