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

Error reading from database when attempting Hangman

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.4.4
    • Fix Version/s: None
    • Component/s: Module: Game
    • Labels:
      None
    • Affected Branches:
      MOODLE_24_STABLE

      Description

      Game module 2013050305 in Moodle 2.4.4 (build 20130606), running on Oracle 11.2.0.3.

      When attempting Hangman, we receive the following error: "Error reading from database".

      Debug information:

      Debug info: ORA-00918: column ambiguously defined
      SELECT oracle_o.*
      FROM (SELECT oracle_i.*, rownum AS oracle_rownum
      FROM (SELECT ge.id,ge.id FROM m_glossary_entries ge WHERE glossaryid=4 AND concept NOT LIKE '% %' ) oracle_i
      WHERE rownum <= :o_oracle_num_rows
      ) oracle_o
      WHERE oracle_rownum > :o_oracle_skip_rows
      [array (
      'o_oracle_num_rows' => 3,
      'o_oracle_skip_rows' => 2,
      )]
      Error code: dmlreadexception
      Stack trace:

      line 426 of /lib/dml/moodle_database.php: dml_read_exception thrown
      line 274 of /lib/dml/oci_native_moodle_database.php: call to moodle_database->query_end()
      line 1101 of /lib/dml/oci_native_moodle_database.php: call to oci_native_moodle_database->query_end()
      line 228 of /mod/game/locallib.php: call to oci_native_moodle_database->get_records_sql()
      line 121 of /mod/game/locallib.php: call to game_question_selectrandom()
      line 91 of /mod/game/locallib.php: call to game_question_shortanswer_glossary()
      line 32 of /mod/game/hangman/play.php: call to game_question_shortanswer()
      line 197 of /mod/game/attempt.php: call to game_hangman_continue()
      line 175 of /mod/game/attempt.php: call to game_create()
      line 25 of /mod/game/attempt.php: call to game_do_attempt()

        Attachments

          Activity

            People

            Assignee:
            bdaloukas Vasilis Daloukas
            Reporter:
            cnobis Chris Nobis
            Participants:
            Component watchers:
            Vasilis Daloukas
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: