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

3.4 QA IMS CC as course restore failing with sql query issue

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.2.4, 3.3, 3.3.1, 3.3.2
    • Fix Version/s: 3.2.6, 3.3.3
    • Component/s: Backup: IMS-CC
    • Labels:
    • Testing Instructions:
      Hide
      1. Import backup-moodle2-course-2-activity_examples-20171027-2219-nu.imscc, and py4e_export.imscc attached to MDLQA-11153.
      2. Verify they import (Course administration > Restore) without warnings or errors.

       

      Show
      Import backup-moodle2-course-2-activity_examples-20171027-2219-nu.imscc, and py4e_export.imscc attached to MDLQA-11153 . Verify they import (Course administration > Restore) without warnings or errors.  
    • Affected Branches:
      MOODLE_32_STABLE, MOODLE_33_STABLE
    • Fixed Branches:
      MOODLE_32_STABLE, MOODLE_33_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      MDL-60615-master

      Description

      I have set up a simple Moodle course, including forums, labels, resources, chats, LTI, quizzes, and created a IMSCC package via Moodle to test with.

      The 3.4 QA test is to use the course restore option and upload the IMS CC package as the course zip for a restore process.

      On https://qa.moodle.net/ it is failing with the following display error (and attaching the stack trace as well):

      Comparisons of text column conditions are not allowed. Please use sql_compare_text() in your query.

      This is also failing with the exact error on the exact same moodle-generated IMSCC package in a standard 3.3 and 3.2 site.

      However and kudos to the Moodlecloud team!!, it was able to restore onto a Moodlecloud site, with the supported activities active.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  13/Nov/17