-
Bug
-
Resolution: Fixed
-
Minor
-
2.2.3
-
None
-
MOODLE_22_STABLE
-
MOODLE_20_STABLE
When viewing the scores and filtering them, it occurs this error:
Debug info: ERROR: column "lastname" does not exist
LINE 1: ...FROM mdl_hotpot_attempts ha WHERE hotpotid=$1 AND lastname I...
^
SELECT COUNT(1) FROM mdl_hotpot_attempts ha WHERE hotpotid=$1 AND lastname ILIKE $2 ESCAPE '
'
[array (
0 => '19',
1 => 'C%',
)]
Stack trace:
line 394 of /lib/dml/moodle_database.php: dml_read_exception thrown
line 232 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
line 678 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
line 1297 of /lib/dml/moodle_database.php: call to pgsql_native_moodle_database->get_records_sql()
line 1372 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()
line 1543 of /lib/dml/moodle_database.php: call to moodle_database->get_field_sql()
line 1364 of /lib/tablelib.php: call to moodle_database->count_records_sql()
line 152 of /mod/hotpot/report/renderer.php: call to table_sql->query_db()
line 88 of /mod/hotpot/report/renderer.php: call to mod_hotpot_report_renderer->reportcontent()
line 93 of /mod/hotpot/report.php: call to mod_hotpot_report_renderer->render_report()