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

Problem filtering HotPot reports

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.2.3
    • Fix Version/s: 2.0.10
    • Component/s: Module: HotPot
    • Labels:
      None
    • Affected Branches:
      MOODLE_22_STABLE
    • Fixed Branches:
      MOODLE_20_STABLE

      Description

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

        Attachments

          Activity

            People

            Assignee:
            xxxxxxx Gordon Bateson
            Reporter:
            pferre22 Pau Ferrer
            Participants:
            Component watchers:
            Gordon Bateson
            Votes:
            2 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Fix Release Date:
              9/Jul/12