From 672bbc791de7e9b753040a10e836ad7211b05663 Mon Sep 17 00:00:00 2001
From: David Mudrak <david.mudrak@gmail.com>
Date: Thu, 7 Oct 2010 16:11:42 +0000
Subject: [PATCH] MDL-24425 mnet: fixed SQL DISTINCT from a table containing
 text field

---
 auth/mnet/auth.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/auth/mnet/auth.php b/auth/mnet/auth.php
index 2faf62d6262..ef5d6362c8b 100644
--- a/auth/mnet/auth.php
+++ b/auth/mnet/auth.php
@@ -1241,7 +1241,7 @@ class auth_plugin_mnet extends auth_plugin_base {
         global $DB, $CFG;
         // strip off wwwroot, since the remote site will prefix it's return url with this
         $wantsurl = preg_replace('/(' . preg_quote($CFG->wwwroot, '/') . '|' . preg_quote($CFG->httpswwwroot, '/') . ')/', '', $wantsurl);
-        if (!$hosts = $DB->get_records_sql('SELECT DISTINCT h.*, a.sso_jump_url,a.name as application
+        if (!$hosts = $DB->get_records_sql('SELECT DISTINCT h.id, h.wwwroot, h.name, a.sso_jump_url,a.name as application
                 FROM {mnet_host} h
                 JOIN {mnet_host2service} m ON h.id=m.hostid
                 JOIN {mnet_service} s ON s.id=m.serviceid
-- 
2.36.1