From e1266eaf4bdad8c9eac68ca2751d2316025752cd Mon Sep 17 00:00:00 2001 From: David Monllao Date: Mon, 12 Nov 2018 16:26:14 +0100 Subject: [PATCH] MDL-63724 messaging: Prefix field with the table alias --- lib/classes/message/manager.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib/classes/message/manager.php b/lib/classes/message/manager.php index 5630ac4bce0..4ffc62ece5e 100644 --- a/lib/classes/message/manager.php +++ b/lib/classes/message/manager.php @@ -86,7 +86,7 @@ class manager { FROM {message_conversation_members} mcm JOIN {user} u ON (mcm.conversationid = :convid AND u.id = mcm.userid) - ORDER BY id desc"; + ORDER BY u.id desc"; $members = $DB->get_records_sql($sql, ['convid' => $eventdata->convid]); if (empty($members)) { throw new \moodle_exception("Conversation has no members or does not exist."); -- 2.43.0