Hi Gordon, hope you're doing well!

getting an sql error on responses page with latest 2.x version of hotpot from new plugins db
Debug info: ERROR: column "u.id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT COUNT(1), u.id AS userid, u.firstname, u.lastname, u....
^
SELECT COUNT(1), u.id AS userid, u.firstname, u.lastname, u.picture, u.imagealt, u.email FROM mdl_hotpot_attempts ha, mdl_user u WHERE hotpotid=$1 AND ha.userid=u.id
[array (
0 => '1',
)]
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 1351 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()

Also - there doesn't appear to be a link to view reports page anymore so that a teacher can view the report.

I'll provide patches for both these issues and provide them here