Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-3683

Error: Comparisons of text column conditions are not allowed. Please use sql_compare_text() in your query. when running Import XML Folder Now for coursesection.xml

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • None
    • 2.1
    • Enrol: Banner/LMB
    • MOODLE_21_STABLE

      When processing the LMB integration it fails when trying to create the Course.
      Steps to reproduce.

      1. Upload the attached coursesection.xml to site/xml/
      2. Login into the site
      3. Go to /enrol/lmb/tools/extractprocess.php
      4. Select Import XML Folder Now link

      Result: /srv/clientdata/na13/mwsudev/xml/coursesection.xml
      Comparisons of text column conditions are not allowed. Please use sql_compare_text() in your query.

      More information about this error

      Stack trace:
      line 517 of /lib/dml/moodle_database.php: dml_exception thrown
      line 1241 of /lib/dml/moodle_database.php: call to moodle_database->where_clause()
      line 1324 of /enrol/lmb/lib.php: call to moodle_database->get_record()
      line 963 of /enrol/lmb/lib.php: call to enrol_lmb_plugin->get_category_id()
      line 873 of /enrol/lmb/lib.php: call to enrol_lmb_plugin->process_course_section_tag()
      line 680 of /enrol/lmb/lib.php: call to enrol_lmb_plugin->process_group_tag()
      line 795 of /enrol/lmb/lib.php: call to enrol_lmb_plugin->process_file()
      line 34 of /enrol/lmb/tools/extractprocess.php: call to enrol_lmb_plugin->process_folder()

            emerrill Eric Merrill
            dmercer@moodlerooms.com David Mercer
            Votes:
            1 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

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