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

restoring an mbz failing on oracle but restores fine on mssql

    Details

    • Affected Branches:
      MOODLE_23_STABLE

      Description

      i'm restoring a file on a fresh installation of moodle under oracle db.

      Debug info: ORA-01400: cannot insert NULL into ("MOODLEUSER"."M_LESSON_ATTEMPTS"."ANSWERID")
      INSERT INTO m_lesson_attempts (userid,retry,correct,useranswer,timeseen,lessonid,pageid,answerid) VALUES (:userid,:retry,:correct,:useranswer,:timeseen,:lessonid,:pageid,:answerid) RETURNING id INTO :oracle_id
      [array (
      'userid' => '5',
      'retry' => '0',
      'correct' => '1',
      'useranswer' => '<p>to be</p>',
      'timeseen' => 1280845409,
      'lessonid' => 2,
      'pageid' => 2,
      'answerid' => NULL,
      )]
      Stack trace:
      line 413 of \lib\dml\moodle_database.php: dml_write_exception thrown
      line 278 of \lib\dml\oci_native_moodle_database.php: call to moodle_database->query_end()
      line 1218 of \lib\dml\oci_native_moodle_database.php: call to oci_native_moodle_database->query_end()
      line 1261 of \lib\dml\oci_native_moodle_database.php: call to oci_native_moodle_database->insert_record_raw()
      line 122 of \mod\lesson\backup\moodle2\restore_lesson_stepslib.php: call to oci_native_moodle_database->insert_record()
      line 131 of \backup\util\plan\restore_structure_step.class.php: call to restore_lesson_activity_structure_step->process_lesson_attempt()
      line 103 of \backup\util\helper\restore_structure_parser_processor.class.php: call to restore_structure_step->process()
      line 125 of \backup\util\xml\parser\processors\grouped_parser_processor.class.php: call to restore_structure_parser_processor->dispatch_chunk()
      line 91 of \backup\util\helper\restore_structure_parser_processor.class.php: call to grouped_parser_processor->postprocess_chunk()
      line 148 of \backup\util\xml\parser\processors\simplified_parser_processor.class.php: call to restore_structure_parser_processor->postprocess_chunk()
      line 92 of \backup\util\xml\parser\processors\progressive_parser_processor.class.php: call to simplified_parser_processor->process_chunk()
      line 169 of \backup\util\xml\parser\progressive_parser.class.php: call to progressive_parser_processor->receive_chunk()
      line 253 of \backup\util\xml\parser\progressive_parser.class.php: call to progressive_parser->publish()
      line ? of unknownfile: call to progressive_parser->end_tag()
      line 158 of \backup\util\xml\parser\progressive_parser.class.php: call to xml_parse()
      line 137 of \backup\util\xml\parser\progressive_parser.class.php: call to progressive_parser->parse()
      line 105 of \backup\util\plan\restore_structure_step.class.php: call to progressive_parser->process()
      line 153 of \backup\util\plan\base_task.class.php: call to restore_structure_step->execute()
      line 187 of \backup\moodle2\restore_activity_task.class.php: call to base_task->execute()
      line 148 of \backup\util\plan\base_plan.class.php: call to restore_activity_task->execute()
      line 157 of \backup\util\plan\restore_plan.class.php: call to base_plan->execute()
      line 310 of \backup\controller\restore_controller.class.php: call to restore_plan->execute()
      line 147 of \backup\util\ui\restore_ui.class.php: call to restore_controller->execute_plan()
      line 46 of \backup\restore.php: call to restore_ui->execute()
      

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: