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

Course restore failes with SQL Server for SCORM, Folder and IMS resources

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Deferred
    • Affects Version/s: 2.4.2, 2.6
    • Fix Version/s: None
    • Component/s: Backup, Database SQL/XMLDB
    • Labels:
    • Affected Branches:
      MOODLE_24_STABLE, MOODLE_26_STABLE

      Description

      This seems to only occur when using Microsoft OS, MSSQL Server & IIS7.

      Backup a course on a server and then restore this on a copy of the setup. The restore fails and you get a http 500 error, no log file entries or php error entries regardles of the level of debugging set.
      Similar to MDL-40168 & MDL-34744 with no progress or resolution.

      The work around of editing one of the core files is not acceptable as this occurs on a production server.
      The backup files can come from any version from 1.9 onwards and they will fail with the issue reported above.

      Moodle 2.4.3+ (Build: 20130418)
      Windows NT MOODLE-WEB04 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586
      CGI/FastCGI
      PHP API 20090626
      PHP Extension 20090626
      Zend Extension 220090626
      PHP Version 5.3.13
      sqlsrv

      sqlsrv support
      enabled
      Directive
      Local Value
      Master Value

      sqlsrv.ClientBufferMaxKBSize 10240 10240
      sqlsrv.LogSeverity 0 0
      sqlsrv.LogSubsystems 0 0
      sqlsrv.WarningsReturnAsErrors On On

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              barry.matthias@remote-learner.net barry matthias
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Jake Dallimore, Jun Pataleta
              Votes:
              7 Vote for this issue
              Watchers:
              12 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: