From: David Mudrak <david.mudrak@gmail.com>
Date: Thu, 7 Oct 2010 16:11:42 +0000 (+0000)
Subject: MDL-24425 mnet: fixed SQL DISTINCT from a table containing text field
X-Git-Tag: v2.0.0-rc2~643
X-Git-Url: http://git.moodle.org/gw?p=moodle.git;a=commitdiff_plain;h=672bbc791de7e9b753040a10e836ad7211b05663

MDL-24425 mnet: fixed SQL DISTINCT from a table containing text field
---

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