Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-28415

Quiz MULTICHOICE database insert error

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: 2.1
    • Fix Version/s: None
    • Component/s: Quiz
    • Labels:
      None
    • Environment:
      CENTOS5
      Mysql 5.0.77
      PHP
      5.3.6
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_21_STABLE

      Description

      Database insert error when adding a MULTICHOICE question using this format:* San Francisco:

      {1:MULTICHOICE:=California#OK~Arizona#Wrong}

      Debug info: Incorrect integer value: 'C' for column 'answerformat' at row 1
      UPDATE mdl_question_answers SET question = ?,answer = ?,feedback = ?,answerformat = ?,fraction = ?,feedbackformat = ? WHERE id=?
      [array (
      0 => 73,
      1 => 'C',
      2 => 'OK',
      3 => 'C',
      4 => '1',
      5 => '1',
      6 => 113,
      )]
      Stack trace:

      line 397 of /lib/dml/moodle_database.php: dml_write_exception thrown
      line 984 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      line 1016 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->update_record_raw()
      line 92 of /question/type/multichoice/questiontype.php: call to mysqli_native_moodle_database->update_record()
      line 424 of /question/type/questiontypebase.php: call to qtype_multichoice->save_question_options()
      line 139 of /question/type/multianswer/questiontype.php: call to question_type->save_question()
      line 424 of /question/type/questiontypebase.php: call to qtype_multianswer->save_question_options()
      line 181 of /question/type/multianswer/questiontype.php: call to question_type->save_question()
      line 264 of /question/question.php: call to qtype_multianswer->save_question()

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              timhunt Tim Hunt
              Reporter:
              loquelamoodle Simon Clegg
              Participants:
              Component watchers:
              Tim Hunt, Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: