From 808fae8f0507a0a773859ab5f4a9c18035056194 Mon Sep 17 00:00:00 2001 From: mjollnir_ Date: Sat, 14 Jul 2007 19:36:59 +0000 Subject: [PATCH] fixing a small syntax oddity that breaks get_my_courses in postgres. quoting " means escape table, not string --- lib/datalib.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib/datalib.php b/lib/datalib.php index 8fdd0dc0b8..5d0f936928 100644 --- a/lib/datalib.php +++ b/lib/datalib.php @@ -760,7 +760,7 @@ SELECT FROM {$CFG->prefix}role_assignments ra INNER JOIN {$CFG->prefix}context x ON x.id=ra.contextid - INNER JOIN {$CFG->prefix}course_categories a ON (a.path LIKE ".sql_concat('"%/"', 'x.instanceid', '"/%"')." OR a.id=x.instanceid) AND x.contextlevel=40 + INNER JOIN {$CFG->prefix}course_categories a ON (a.path LIKE ".sql_concat("'%/'", 'x.instanceid', "'/%'")." OR a.id=x.instanceid) AND x.contextlevel=40 INNER JOIN {$CFG->prefix}course c ON c.category=a.id WHERE ra.userid=$userid -- 2.39.5