From d6f2c926fa6a88ec2c04cb8c798b0e13d6b915ad Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Sun, 6 Feb 2011 21:34:54 +0100 Subject: [PATCH] Fixes ambiguous order clause. MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Stéphane Jacob --- modules/search.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/modules/search.php b/modules/search.php index 64adb5f..8173c4a 100644 --- a/modules/search.php +++ b/modules/search.php @@ -417,8 +417,8 @@ class SearchModule extends PLModule INNER JOIN profile_mentor_term AS mt ON (mt.pid = mp.pid) INNER JOIN profile_job_term_relation AS jtr ON (jtr.jtid_2 = mt.jtid) WHERE jtr.jtid_1 = {?} - GROUP BY iso_3166_1_a2 - ORDER BY country", $jtid); + GROUP BY gc.iso_3166_1_a2 + ORDER BY gc.country", $jtid); $page->assign('list', $it); } } -- 2.1.4