diff options
author | Bharat Mediratta <bharat@menalto.com> | 2011-10-26 12:49:45 -0700 |
---|---|---|
committer | Bharat Mediratta <bharat@menalto.com> | 2011-10-26 12:49:45 -0700 |
commit | 80f24e8bcb9e7f280a1c831f4134dd0cc6862c86 (patch) | |
tree | 85462a81cbe226ccc4de081fd3683d10a76bfc31 /modules/search | |
parent | 2956d407279e9f2426d0328feb3276b9f9f26b09 (diff) |
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
Diffstat (limited to 'modules/search')
-rw-r--r-- | modules/search/helpers/search.php | 4 |
1 files changed, 2 insertions, 2 deletions
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); |