From 80f24e8bcb9e7f280a1c831f4134dd0cc6862c86 Mon Sep 17 00:00:00 2001 From: Bharat Mediratta Date: Wed, 26 Oct 2011 12:49:45 -0700 Subject: Follow on to 7f62f09cf377b92b615e456ec4539300b331fd4b for #1663 to fix bad query syntax, pointed out by Singularis in http://gallery.menalto.com/gallery_3.0.2_feedback#comment-383135 --- modules/search/helpers/search.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'modules') diff --git a/modules/search/helpers/search.php b/modules/search/helpers/search.php index a77a2433..d6d67c29 100644 --- a/modules/search/helpers/search.php +++ b/modules/search/helpers/search.php @@ -53,7 +53,7 @@ class search_Core { foreach (identity::group_ids_for_active_user() as $id) { $fields[] = "`view_$id` = TRUE"; // access::ALLOW } - $access_sql = "AND (" . join(" OR ", $fields) . ")"; + $access_sql = " AND (" . join(" OR ", $fields) . ")"; } else { $access_sql = ""; } @@ -122,7 +122,7 @@ class search_Core { $score = $db->query($query)->current()->score; $score = substr($score, 0, strlen($score) - 2); - $data = $db->query(self::_build_query_base($q) . "having `score` >= " . $score); + $data = $db->query(self::_build_query_base($q) . " HAVING `score` >= " . $score); $data->seek($data->count() - 1); -- cgit v1.2.3