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

block->multiple disappeared in 1.9 => 2.0 (install still has it)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.0
    • Fix Version/s: 2.0
    • Component/s: Blocks, Installation
    • Labels:
      None
    • Database:
      MySQL
    • Difficulty:
      Moderate
    • Affected Branches:
      MOODLE_20_STABLE
    • Fixed Branches:
      MOODLE_20_STABLE

      Description

      Steps to reproduce (as tested on qa site and also local test site):

      1. Create a backup with no user data, including activities, blocks and filters.
      2. Attempt to restore (all restore destinations seem to give an error)
      3. Click the 'Perform restore' button

      The following error is obtained:

      Error reading from database

      Debug info: Unknown column 'b.multiple' in 'where clause'
      SELECT bi.id
      FROM mdl_block_instances bi
      JOIN mdl_block b ON b.name = bi.blockname
      WHERE bi.parentcontextid = ?
      AND bi.blockname = ?
      AND b.multiple = 0 LIMIT 0, 1
      [array (
      0 => '10',
      1 => 'calendar_upcoming',
      )]
      Stack trace:

      • line 391 of /lib/dml/moodle_database.php: dml_read_exception thrown
      • line 691 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      • line 1540 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_recordset_sql()
      • line 1615 of /backup/moodle2/restore_stepslib.php: call to moodle_database->record_exists_sql()
      • line 119 of /backup/util/plan/restore_structure_step.class.php: call to restore_block_instance_structure_step->process_block()
      • line 103 of /backup/util/helper/restore_structure_parser_processor.class.php: call to restore_structure_step->process()
      • line 83 of /backup/util/xml/parser/processors/grouped_parser_processor.class.php: call to restore_structure_parser_processor->dispatch_chunk()
      • line 175 of /backup/util/xml/parser/progressive_parser.class.php: call to grouped_parser_processor->after_path()
      • line 245 of /backup/util/xml/parser/progressive_parser.class.php: call to progressive_parser->inform_end()
      • line ? of unknownfile: call to progressive_parser->end_tag()
      • line 150 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 99 of /backup/util/plan/restore_structure_step.class.php: call to progressive_parser->process()
      • line 143 of /backup/util/plan/base_task.class.php: call to restore_structure_step->execute()
      • line 148 of /backup/util/plan/base_plan.class.php: call to base_task->execute()
      • line 144 of /backup/util/plan/restore_plan.class.php: call to base_plan->execute()
      • line 278 of /backup/controller/restore_controller.class.php: call to restore_plan->execute()
      • line 144 of /backup/util/ui/restore_ui.class.php: call to restore_controller->execute_plan()
      • line 39 of /backup/restore.php: call to restore_ui->execute()

      Skipping 'guest' enrolment plugin. Must be implemented

      • line 1086 of /backup/moodle2/restore_stepslib.php: call to debugging()
      • line 119 of /backup/util/plan/restore_structure_step.class.php: call to restore_enrolments_structure_step->process_enrol()
      • line 103 of /backup/util/helper/restore_structure_parser_processor.class.php: call to restore_structure_step->process()
      • line 106 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 127 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 161 of /backup/util/xml/parser/progressive_parser.class.php: call to progressive_parser_processor->receive_chunk()
      • line 235 of /backup/util/xml/parser/progressive_parser.class.php: call to progressive_parser->publish()
      • line ? of unknownfile: call to progressive_parser->end_tag()
      • line 150 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 99 of /backup/util/plan/restore_structure_step.class.php: call to progressive_parser->process()
      • line 143 of /backup/util/plan/base_task.class.php: call to restore_structure_step->execute()
      • line 148 of /backup/util/plan/base_plan.class.php: call to base_task->execute()
      • line 144 of /backup/util/plan/restore_plan.class.php: call to base_plan->execute()
      • line 278 of /backup/controller/restore_controller.class.php: call to restore_plan->execute()
      • line 144 of /backup/util/ui/restore_ui.class.php: call to restore_controller->execute_plan()
      • line 39 of /backup/restore.php: call to restore_ui->execute()

      Skipping 'self' enrolment plugin. Must be implemented

      • line 1086 of /backup/moodle2/restore_stepslib.php: call to debugging()
      • line 119 of /backup/util/plan/restore_structure_step.class.php: call to restore_enrolments_structure_step->process_enrol()
      • line 103 of /backup/util/helper/restore_structure_parser_processor.class.php: call to restore_structure_step->process()
      • line 106 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 127 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 161 of /backup/util/xml/parser/progressive_parser.class.php: call to progressive_parser_processor->receive_chunk()
      • line 235 of /backup/util/xml/parser/progressive_parser.class.php: call to progressive_parser->publish()
      • line ? of unknownfile: call to progressive_parser->end_tag()
      • line 150 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 99 of /backup/util/plan/restore_structure_step.class.php: call to progressive_parser->process()
      • line 143 of /backup/util/plan/base_task.class.php: call to restore_structure_step->execute()
      • line 148 of /backup/util/plan/base_plan.class.php: call to base_task->execute()
      • line 144 of /backup/util/plan/restore_plan.class.php: call to base_plan->execute()
      • line 278 of /backup/controller/restore_controller.class.php: call to restore_plan->execute()
      • line 144 of /backup/util/ui/restore_ui.class.php: call to restore_controller->execute_plan()
      • line 39 of /backup/restore.php: call to restore_ui->execute()

        Attachments

          Activity

            People

            • Assignee:
              stronk7 Eloy Lafuente (stronk7)
              Reporter:
              tsala Helen Foster
              Tester:
              Nobody
              Participants:
              Component watchers:
              Adrian Greeve, Mihail Geshoski, Peter Dias, Matteo Scaramuccia, Andrew Nicols, Mathew May, Michael Hawkins, Shamim Rezaie, Simey Lameze
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                24/Nov/10