From f9c92efef365b5a3d2e68775196fac022814e15a Mon Sep 17 00:00:00 2001
From: tjhunt <tjhunt>
Date: Tue, 14 Nov 2006 15:41:20 +0000
Subject: [PATCH] MDL-7531 Fix SQL that does not work in Oracle. Thanks to Mark
 Hetherington for the fix. Merged from MOODLE_17_STABLE.

---
 lib/questionlib.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/lib/questionlib.php b/lib/questionlib.php
index f0c727af9e..8b2e5961ce 100644
--- a/lib/questionlib.php
+++ b/lib/questionlib.php
@@ -1480,7 +1480,7 @@ function question_category_select_menu($courseid, $published = false, $only_edit
             SELECT cat.*, c.shortname AS coursename 
             FROM {$CFG->prefix}question_categories cat, {$CFG->prefix}course c
             WHERE c.id = cat.course AND (cat.course = $courseid $publishsql)
-            ORDER BY parent, sortorder, name ASC");
+            ORDER BY cat.parent, cat.sortorder, cat.name ASC");
 
     $categories = add_indented_names($categories);
 
-- 
2.39.5