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

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

XMLWordPrintable

    • MOODLE_25_STABLE
    • MOODLE_24_STABLE, MOODLE_25_STABLE

      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

        1. ddmatch.png
          11 kB
          Martin O'Mahony
        2. ddmatch-answers.png
          45 kB
          Martin O'Mahony

            jmvedrine Jean-Michel Vedrine
            ruiruas rui ruas
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.