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

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


    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • 3.2.6, 3.3.3
    • 3.2.4, 3.3, 3.3.1, 3.3.2
    • Backup: IMS-CC
    • MDL-60615-master
    • 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.


      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.  

      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.

            damyon Damyon Wiese
            wuzi1999 Karen Holland
            Adrian Greeve Adrian Greeve
            David Monllaó David Monllaó
            David Monllaó David Monllaó
            0 Vote for this issue
            2 Start watching this issue


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