Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-3499

hotpot view responses page issues

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 2.2
    • Fix Version/s: None
    • Component/s: Module: HotPot
    • Labels:
      None
    • Affected Branches:
      MOODLE_22_STABLE

      Description

      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

        Attachments

          Activity

            People

            • Assignee:
              aborrow Anthony Borrow
              Reporter:
              danmarsden Dan Marsden
              Participants:
              Component watchers:
              Gordon Bateson
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated: