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

Course restore failure on calendar events

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 2.5.2, 2.6
    • 2.5.4
    • Backup
    • MOODLE_25_STABLE, MOODLE_26_STABLE
    • MOODLE_25_STABLE
    • MDL-42768-master
    • Hide

      To test, at the very least, on MSSQL and Oracle.

      1. Create a course
      2. Create a calendar event of course type in the course
      3. Backup the course including the calendar events
      4. Restore the course as a merge into the original course
      5. Make sure the restore worked and the event has not been duplicated
      Show
      To test, at the very least, on MSSQL and Oracle . Create a course Create a calendar event of course type in the course Backup the course including the calendar events Restore the course as a merge into the original course Make sure the restore worked and the event has not been duplicated

    Description

      Restore course to a new course.

      Conversions of name and modulename seem to be required.

      Type - Course
      Format - Moodle 2
      Mode - General
      Date taken - Tuesday, 5 November 2013, 1:08 PM

      Moodle version - 2.5.2+ (Build: 20131101)[2013051402.11]

      Backup version - 2.5[2013051400]

      Debug info: The data types ntext and nvarchar are incompatible in the equal to operator.
      SELECT TOP 1 id FROM mdl_event WHERE name = ? AND courseid = ? AND
      repeatid = ? AND modulename = ? AND timestart = ? AND timeduration =?
      AND CONVERT(varchar(255), description) = CONVERT(varchar(255), ?)

      Error code: dmlreadexception

      Stack trace: •line 423 of \lib\dml\moodle_database.php: dml_read_exception thrown
      •line 256 of \lib\dml\mssql_native_moodle_database.php: call to moodle_database->query_end()
      •line 723 of \lib\dml\mssql_native_moodle_database.php: call to mssql_native_moodle_database->query_end()
      •line 1689 of \lib\dml\moodle_database.php: call to mssql_native_moodle_database->get_recordset_sql()
      •line 2204 of \backup\moodle2\restore_stepslib.php: call to moodle_database->record_exists_sql()
      •line 131 of \backup\util\plan\restore_structure_step.class.php: call to restore_calendarevents_structure_step->process_calendarevents()
      •line 103 of \backup\util\helper\restore_structure_parser_processor.class.php: call to restore_structure_step->process()
      •line 151 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 192 of \backup\moodle2\restore_activity_task.class.php: call to base_task->execute()
      •line 167 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 315 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()

      Attachments

        Issue Links

          Activity

            People

              fred Frédéric Massart
              matmie Matthew Mierzejewski
              Ankit Agarwal Ankit Agarwal
              Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
              Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
              Adrian Greeve, David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                13/Jan/14