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

Hotpot 2.0 course reset gives error

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.2.5
    • Fix Version/s: 2.1.6, 2.2.3, 2.3, 2.4
    • Component/s: Module: HotPot
    • Labels:
      None
    • Affected Branches:
      MOODLE_22_STABLE
    • Fixed Branches:
      MOODLE_21_STABLE, MOODLE_22_STABLE, MOODLE_23_STABLE, MOODLE_24_STABLE

      Description

      When I select course reset and then Hotpots - Delete all attempts I get the following error

      Reset course
      Error reading from database

      More information about this error

      Debug info: Ambiguous column name 'id'.
      SELECT id, id FROM mdl_hotpot WHERE course = ? ORDER BY id
      [array (
      0 => 773,
      )]
      Stack trace:
      line 394 of \lib\dml\moodle_database.php: dml_read_exception thrown
      line 255 of \lib\dml\mssql_native_moodle_database.php: call to moodle_database->query_end()
      line 711 of \lib\dml\mssql_native_moodle_database.php: call to mssql_native_moodle_database->query_end()
      line 740 of \lib\dml\mssql_native_moodle_database.php: call to mssql_native_moodle_database->get_recordset_sql()
      line 1129 of \lib\dml\moodle_database.php: call to mssql_native_moodle_database->get_records_sql()
      line 1078 of \lib\dml\moodle_database.php: call to moodle_database->get_records_select()
      line 1527 of \mod\hotpot\lib.php: call to moodle_database->get_records()
      line 4903 of \lib\moodlelib.php: call to hotpot_reset_userdata()
      line 73 of \course\reset.php: call to reset_course_userdata()

        Attachments

          Activity

            People

            • Assignee:
              xxxxxxx Gordon Bateson
              Reporter:
              fweiss Fred Weiss
              Participants:
              Component watchers:
              Gordon Bateson
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                14/May/12