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

/lib/questionlib.php:get_categories_for_contexts sql error

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.9
    • 1.9.3
    • Database SQL/XMLDB
    • None
    • Oracle
    • Oracle
    • MOODLE_19_STABLE
    • MOODLE_19_STABLE

    Description

      ora 923
      SELECT *, (SELECT count(1) FROM m_question q WHERE c.id = q.category AND q.hidden='0' AND q.parent='0') as questioncount FROM m_question_categories c WHERE c.contextid IN (861, 721, 642, 41, 1) ORDER BY parent, sortorder, name ASC

      • line 686 of lib/dmllib.php: call to debugging()
      • line 949 of lib/dmllib.php: call to get_recordset_sql()
      • line 1731 of lib/questionlib.php: call to get_records_sql()
      • line 1745 of lib/questionlib.php: call to get_categories_for_contexts()
      • line 101 of question/editlib.php: call to question_category_options()
      • line 572 of question/editlib.php: call to question_category_form()
      • line 349 of mod/quiz/edit.php: call to question_showbank()

      has to be
      SELECT C.*
      for oracle...

      Attachments

        Issue Links

          Activity

            People

              timhunt Tim Hunt
              protzek D P
              Petr Skoda Petr Skoda
              Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                15/Oct/08