aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB
diff options
context:
space:
mode:
authorMeik Sievertsen <acydburn@phpbb.com>2008-09-18 14:32:51 +0000
committerMeik Sievertsen <acydburn@phpbb.com>2008-09-18 14:32:51 +0000
commit958d077faa647f0123d5b711c9c6ed6d56b4a6c7 (patch)
treecb93d600a38c220512762e97b1391c9191321910 /phpBB
parent4649b93e0d41cf1133ac4850c52d524227420c80 (diff)
downloadforums-958d077faa647f0123d5b711c9c6ed6d56b4a6c7.tar
forums-958d077faa647f0123d5b711c9c6ed6d56b4a6c7.tar.gz
forums-958d077faa647f0123d5b711c9c6ed6d56b4a6c7.tar.bz2
forums-958d077faa647f0123d5b711c9c6ed6d56b4a6c7.tar.xz
forums-958d077faa647f0123d5b711c9c6ed6d56b4a6c7.zip
Fix native full text search on postgresql while using excluding keyword matches. (Bug #19195)
git-svn-id: file:///svn/phpbb/trunk@8880 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB')
-rw-r--r--phpBB/includes/search/fulltext_native.php7
1 files changed, 4 insertions, 3 deletions
diff --git a/phpBB/includes/search/fulltext_native.php b/phpBB/includes/search/fulltext_native.php
index 5d17ca4fdc..5ec2a9657d 100644
--- a/phpBB/includes/search/fulltext_native.php
+++ b/phpBB/includes/search/fulltext_native.php
@@ -447,11 +447,12 @@ class fulltext_native extends search_backend
'FROM' => array(
SEARCH_WORDMATCH_TABLE => array(),
SEARCH_WORDLIST_TABLE => array(),
- POSTS_TABLE => 'p'
),
- 'LEFT_JOIN' => array()
+ 'LEFT_JOIN' => array(array(
+ 'FROM' => array(POSTS_TABLE => 'p'),
+ 'ON' => 'm0.post_id = p.post_id',
+ )),
);
- $sql_where[] = 'm0.post_id = p.post_id';
$title_match = '';
$group_by = true;