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

Course restore failure on calendar events

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.5.2, 2.6
    • Fix Version/s: 2.5.4
    • Component/s: Backup
    • Labels:
    • Testing Instructions:
      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
    • Affected Branches:
      MOODLE_25_STABLE, MOODLE_26_STABLE
    • Fixed Branches:
      MOODLE_25_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      MDL-42768-master

      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

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

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  13/Jan/14