From 630a3dc3841eeb05424c3bd6a89b6736f15f03f9 Mon Sep 17 00:00:00 2001
From: tjhunt <tjhunt>
Date: Tue, 2 Sep 2008 06:55:32 +0000
Subject: [PATCH] MDL-14160 SQL in get_categories_for_contexts does not work on
 Oracle. Thanks to Adrian Smith and Francois Marier for the fix.

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

diff --git a/lib/questionlib.php b/lib/questionlib.php
index d157c36eb8..35d1a30cfc 100644
--- a/lib/questionlib.php
+++ b/lib/questionlib.php
@@ -2132,7 +2132,7 @@ function question_make_default_categories($contexts) {
 function get_categories_for_contexts($contexts, $sortorder = 'parent, sortorder, name ASC') {
     global $DB;
     return $DB->get_records_sql("
-            SELECT *, (SELECT count(1) FROM {question} q
+            SELECT c.*, (SELECT count(1) FROM {question} q
                         WHERE c.id = q.category AND q.hidden='0' AND q.parent='0') AS questioncount
               FROM {question_categories} c
              WHERE c.contextid IN ($contexts)
-- 
2.39.5