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

Course restore fails with missing default value for new text field: participants

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • None
    • 2.8.1
    • None
    • 2014101003
    • MOODLE_28_STABLE

      Part of the tests we do for our clients is course backup and restore. The course restore failed with the following error:

      Error writing to database
       
      More information about this error
      Debug info: Field 'participants' doesn't have a default value
      INSERT INTO mdl_bigbluebuttonbn (name,moderatorpass,viewerpass,wait,newwindow,record,description,welcome,voicebridge,timedue,timeavailable,timeduration,meetingid,timemodified,course) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
      [array (
      0 => 'bigbluebuttonbn',
      1 => '08ff3c83e7c3acfa2a899730c11717ac',
      2 => 'd017d10a7fb9c8084d7981ac55c8ddf9',
      3 => '1',
      4 => '0',
      5 => '0',
      6 => '',
      7 => '',
      8 => '0',
      9 => '0',
      10 => '0',
      11 => '14400',
      12 => '56d2b7e1b4a74730300e879e7518f908',
      13 => '0',
      14 => 5,
      )]
      Error code: dmlwriteexception
      Stack trace:
       
          line 446 of /lib/dml/moodle_database.php: dml_write_exception thrown
          line 1164 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
          line 1210 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
          line 51 of /mod/bigbluebuttonbn/backup/moodle2/restore_bigbluebuttonbn_stepslib.php: call to mysqli_native_moodle_database->insert_record()
          line 137 of /backup/util/plan/restore_structure_step.class.php: call to restore_bigbluebuttonbn_activity_structure_step->process_bigbluebuttonbn()
          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 190 of /backup/util/xml/parser/progressive_parser.class.php: call to progressive_parser_processor->receive_chunk()
          line 278 of /backup/util/xml/parser/progressive_parser.class.php: call to progressive_parser->publish()
          line ? of unknownfile: call to progressive_parser->end_tag()
          line 179 of /backup/util/xml/parser/progressive_parser.class.php: call to xml_parse()
          line 158 of /backup/util/xml/parser/progressive_parser.class.php: call to progressive_parser->parse()
          line 110 of /backup/util/plan/restore_structure_step.class.php: call to progressive_parser->process()
          line 181 of /backup/util/plan/base_task.class.php: call to restore_structure_step->execute()
          line 195 of /backup/moodle2/restore_activity_task.class.php: call to base_task->execute()
          line 177 of /backup/util/plan/base_plan.class.php: call to restore_activity_task->execute()
          line 167 of /backup/util/plan/restore_plan.class.php: call to base_plan->execute()
          line 333 of /backup/controller/restore_controller.class.php: call to restore_plan->execute()
          line 184 of /backup/util/ui/restore_ui.class.php: call to restore_controller->execute_plan()
          line 107 of /backup/restore.php: call to restore_ui->execute()
      

      BTW, I also noticed that where the upgrade.php file adds the new participants field and the bigbluebuttonbn_participant table, the install file only adds the participants field

            jfederico Jesus Federico
            linda.vanderbaan Linda Vanderbaan
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

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