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

course restore fails - table "question_match" doesn't exist

    XMLWordPrintable

    Details

    • Affected Branches:
      MOODLE_25_STABLE
    • Fixed Branches:
      MOODLE_24_STABLE, MOODLE_25_STABLE

      Description

      when restoring a course from a backup file, it fails with the following error:

      the table "question_match" doesn't exist
      Debug info:
      Error code: ddltablenotexist
      Stack trace:
      line 554 of /lib/dml/moodle_database.php: dml_exception thrown
      line 1579 of /lib/dml/moodle_database.php: call to moodle_database->where_clause()
      line 197 of /question/type/ddmatch/backup/moodle2/restore_qtype_ddmatch_plugin.class.php: call to moodle_database->set_field()
      line 84 of /backup/moodle2/restore_plugin.class.php: call to restore_qtype_ddmatch_plugin->after_execute_question()
      line 362 of /backup/util/plan/restore_structure_step.class.php: call to restore_plugin->launch_after_execute_methods()
      line 108 of /backup/util/plan/restore_structure_step.class.php: call to restore_structure_step->launch_after_execute_methods()
      line 153 of /backup/util/plan/base_task.class.php: call to restore_structure_step->execute()
      line 163 of /backup/util/plan/base_plan.class.php: call to base_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()

      we recently upgraded from 2.3 to 2.5 (it was OK in 2.3) Apparently the restore script calls to the old mdl_question_match table, instead of mdl_qtype_match_options

      we have the following extra question types installed:
      qtype_conceptmap
      qtype_ddimageortext
      qtype_ddmarker
      qtype_ddmatch
      qtype_ddwtos
      qtype_gapselect
      qtype_order
      qtype_oumultiresponse
      qtype_pmatch

      Apart from this, all standard and extra questions are working correctly in 2.5

        Attachments

          Activity

            People

            Assignee:
            jmvedrine Jean-Michel Vedrine
            Reporter:
            ruiruas rui ruas
            Participants:
            Component watchers:
            Itamar Tzadok
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Fix Release Date:
              3/Dec/12