summaryrefslogtreecommitdiff
path: root/modules/search
diff options
context:
space:
mode:
authorBharat Mediratta <bharat@menalto.com>2011-10-26 12:49:45 -0700
committerBharat Mediratta <bharat@menalto.com>2011-10-26 12:49:45 -0700
commit80f24e8bcb9e7f280a1c831f4134dd0cc6862c86 (patch)
tree85462a81cbe226ccc4de081fd3683d10a76bfc31 /modules/search
parent2956d407279e9f2426d0328feb3276b9f9f26b09 (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.php4
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);