From 3597b34382c0cfed4e8c33f99f7feebb3f339f20 Mon Sep 17 00:00:00 2001 From: acydburn Date: Thu, 18 Sep 2008 14:32:51 +0000 Subject: [PATCH] Fix native full text search on postgresql while using excluding keyword matches. (Bug #19195) git-svn-id: http://code.phpbb.com/svn/phpbb/trunk@8880 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/includes/search/fulltext_native.php | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/phpBB/includes/search/fulltext_native.php b/phpBB/includes/search/fulltext_native.php index 5d17ca4fd..5ec2a9657 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; -- 2.11.4.GIT