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

Course Restore from 2.3.4+ to 2.5.1+ fails with dmlreadexception (MSSQL) and existing temptables found

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: 2.5.1
    • Fix Version/s: None
    • Component/s: Backup
    • Labels:
      None
    • Affected Branches:
      MOODLE_25_STABLE

      Description

      Environment (2.5.1+ TEST server):
      -CentOS 6.4
      -Lighttpd
      -PHP 5.4.17, FastCGI, APC
      -Moodle 2.5.1+ (Build: 20130726)
      -MSSQL 2008 R2
      -FreeTDS driver

      Environment (2.3.4+ server):
      -Win Server 2008 R2
      -IIS 7
      -PHP 5.3.13
      -Moodle 2.3.4+ (Build: 20130222)
      -MSSQL 2008 R2
      -FreeTDS driver

      Steps:
      1) (On 2.3.4+ server) Browsed to the course then clicked Backup
      2) Selected all but 'IMS Common Cartridge 1.1' and 'Anonymize user information'
      3) Selected all schema settings
      4) Took rest of Defaults for backing up the course
      5) (On 2.5.1+ server) Created a new test course
      6) In the new course, clicked on Restore
      7) Added backup file then clicked Restore
      8) Tried restoring as a new course OR deleting the contents of the test course and restoring to it (took defaults for restoring in both cases)
      9) After clicking 'Perform Restore' you receive the error:

      2013-07-29 09:28:48: (mod_fastcgi.c.2676) FastCGI-stderr: Enrol plugin 'selta can not be restored because it is not enabled, use migration to manual eents
      Default exception handler: Error reading from database Debug: The data typext 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 timedon =?
      AND CONVERT(varchar, description, 255) = CONVERT(varchar,55)
      [array (
      0 => 'Outside reading report',
      1 => 830,
      2 => '0',
      3 => 'assign',
      4 => 1354060800,
      5 => '0',
      6 => '<div class="no-overflow">see file posted in eLearn for instructionsad and report on one of the following:<br />
      <br />
      Tubes: a journey to the center of the internet Blum, Andrew<br />
      The HP Way Packard, David<br />
      In the Plex: How Google thinks, works & shapes our lives Levy, Steve/>
      </div>',
      )]
      Error code: dmlreadexception

      • 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_dat->query_end()
      • line 722 of /lib/dml/mssql_native_moodle_database.php: call to mssql_natiodle_database->query_end()
      • line 1689 of /lib/dml/moodle_database.php: call to mssql_native_moodle_dae->get_recordset_sql()
      • line 2204 of /backup/moodle2/restore_stepslib.php: call to moodle_databascord_exists_sql()
      • line 131 of /backup/util/plan/restore_structure_step.class.php: call to re_calendarevents_structure_step->process_calendarevents()
      • line 103 of /backup/util/helper/restore_structure_parser_processor.class.call to restore_structure_step->process()
      • line 151 of /backup/util/xml/parser/processors/grouped_parser_processor.cphp: call to restore_structure_parser_processor->dispatch_chunk()
      • line 91 of /backup/util/helper/restore_structure_parser_processor.class.pall to grouped_parser_processor->postprocess_chunk()
      • line 148 of /backup/util/xml/parser/processors/simplified_parser_processoss.php: call to restore_structure_parser_processor->postprocess_chunk()
      • line 92 of /backup/util/xml/parser/processors/progressive_parser_processoss.php: call to simplified_parser_processor->process_chunk()
      • line 169 of /backup/util/xml/parser/progressive_parser.class.php: call toressive_parser_processor->receive_chunk()
      • line 253 of /backup/util/xml/parser/progressive_parser.class.php: call toressive_parser->publish()
      • line ? of unknownfile: call to progressive_parser->end_tag()
      • line 158 of /backup/util/xml/parser/progressive_parser.class.php: call toparse()
      • line 137 of /backup/util/xml/parser/progressive_parser.class.php: call toressive_parser->parse()
      • line 105 of /backup/util/plan/restore_structure_step.class.php: call to pssive_parser->process()
      • line 153 of /backup/util/plan/base_task.class.php: call to restore_structtep->execute()
      • line 192 of /backup/moodle2/restore_activity_task.class.php: call to base->execute()
      • line 163 of /backup/util/plan/base_plan.class.php: call to restore_activisk->execute()
      • line 157 of /backup/util/plan/restore_plan.class.php: call to base_plan->te()
      • line 315 of /backup/controller/restore_controller.class.php: call to restlan->execute()
      • line 147 of /backup/util/ui/restore_ui.class.php: call to restore_controlexecute_plan()
      • line 46 of /backup/restore.php: call to restore_ui->execute()

      2013-07-29 09:28:49: (mod_fastcgi.c.2676) FastCGI-stderr: Potential coding - existing temptables found when disposing database. Must be dropped!

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              kickehy Brad Meyer
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: