The ntext data type cannot be selected as DISTINCT because it is not comparable.

SELECT c.id, c.category, c.sortorder, c.shortname, c.fullname, c.idnumber, c.newsitems, c.teacher, c.teachers, c.student, c.students, c.guest, c.startdate, c.visible, c.cost, c.enrol, c.summary, c.groupmode, c.groupmodeforce FROM mdl_role_assignments ra INNER JOIN mdl_context x ON x.id=ra.contextid INNER JOIN mdl_course c ON x.instanceid=c.id AND x.contextlevel=50 WHERE ra.userid=9722 UNION SELECT c.id, c.category, c.sortorder, c.shortname, c.fullname, c.idnumber, c.newsitems, c.teacher, c.teachers, c.student, c.students, c.guest, c.startdate, c.visible, c.cost, c.enrol, c.summary, c.groupmode, c.groupmodeforce FROM mdl_role_assignments ra INNER JOIN mdl_context x ON x.id=ra.contextid INNER JOIN mdl_course_categories a ON x.instanceid=a.id AND x.contextlevel=40 INNER JOIN mdl_course c ON c.category=a.id WHERE ra.userid=9722 UNION SELECT c.id, c.category, c.sortorder, c.shortname, c.fullname, c.idnumber, c.newsitems, c.teacher, c.teachers, c.student, c.students, c.guest, c.startdate, c.visible, c.cost, c.enrol, c.summary, c.groupmode, c.groupmodeforce FROM mdl_role_capabilities ca INNER JOIN mdl_context x ON x.id=ca.contextid AND x.contextlevel=50 INNER JOIN mdl_course c ON c.id=x.instanceid WHERE ca.contextid 1 AND ca.capability='moodle/course:view' ORDER BY visible DESC,sortorder ASC

• line 677 of lib\dmllib.php: call to debugging()
• line 775 of lib\datalib.php: call to get_recordset_sql()
• line 41 of blocks\course_list\block_course_list.php: call to get_my_courses()
• line 671 of blocks\moodleblock.class.php: call to block_course_list->get_content()
• line 679 of blocks\moodleblock.class.php: call to block_list->is_empty()
• line 331 of lib\blocklib.php: call to block_list->_print_block()
• line 125 of index.php: call to blocks_print_group()

The ntext data type cannot be selected as DISTINCT because it is not comparable.

SELECT c.id, c.category, c.sortorder, c.shortname, c.fullname, c.idnumber, c.newsitems, c.teacher, c.teachers, c.student, c.students, c.guest, c.startdate, c.visible, c.cost, c.enrol, c.summary, c.groupmode, c.groupmodeforce FROM mdl_role_assignments ra INNER JOIN mdl_context x ON x.id=ra.contextid INNER JOIN mdl_course c ON x.instanceid=c.id AND x.contextlevel=50 WHERE ra.userid=9722 UNION SELECT c.id, c.category, c.sortorder, c.shortname, c.fullname, c.idnumber, c.newsitems, c.teacher, c.teachers, c.student, c.students, c.guest, c.startdate, c.visible, c.cost, c.enrol, c.summary, c.groupmode, c.groupmodeforce FROM mdl_role_assignments ra INNER JOIN mdl_context x ON x.id=ra.contextid INNER JOIN mdl_course_categories a ON x.instanceid=a.id AND x.contextlevel=40 INNER JOIN mdl_course c ON c.category=a.id WHERE ra.userid=9722 UNION SELECT c.id, c.category, c.sortorder, c.shortname, c.fullname, c.idnumber, c.newsitems, c.teacher, c.teachers, c.student, c.students, c.guest, c.startdate, c.visible, c.cost, c.enrol, c.summary, c.groupmode, c.groupmodeforce FROM mdl_role_capabilities ca INNER JOIN mdl_context x ON x.id=ca.contextid AND x.contextlevel=50 INNER JOIN mdl_course c ON c.id=x.instanceid WHERE ca.contextid 1 AND ca.capability='moodle/course:view' ORDER BY visible DESC

• line 677 of lib\dmllib.php: call to debugging()
• line 775 of lib\datalib.php: call to get_recordset_sql()
• line 1278 of calendar\lib.php: call to get_my_courses()
• line 1070 of calendar\lib.php: call to calendar_get_default_courses()
• line 24 of blocks\calendar_month\block_calendar_month.php: call to calendar_session_vars()
• line 202 of blocks\moodleblock.class.php: call to block_calendar_month->get_content()
• line 226 of blocks\moodleblock.class.php: call to block_base->is_empty()
• line 331 of lib\blocklib.php: call to block_base->_print_block()
• line 275 of index.php: call to blocks_print_group()