diff options
| author | rxu <rxu@mail.ru> | 2017-10-24 20:35:25 +0700 |
|---|---|---|
| committer | rxu <rxu@mail.ru> | 2017-10-24 20:35:25 +0700 |
| commit | 4f0b736f14e6d51dcf19e93897fe5386023369e7 (patch) | |
| tree | 70be67ddcfd1c66dd54a4dc0110dea7339848415 /phpBB/phpbb/search/fulltext_sphinx.php | |
| parent | 3b5c624c03351b4e4acbfc1d1818576e04faea69 (diff) | |
| download | forums-4f0b736f14e6d51dcf19e93897fe5386023369e7.tar forums-4f0b736f14e6d51dcf19e93897fe5386023369e7.tar.gz forums-4f0b736f14e6d51dcf19e93897fe5386023369e7.tar.bz2 forums-4f0b736f14e6d51dcf19e93897fe5386023369e7.tar.xz forums-4f0b736f14e6d51dcf19e93897fe5386023369e7.zip | |
[ticket/15419] Fix Sphinx UTF8 search in delta index
PHPBB3-15419
Diffstat (limited to 'phpBB/phpbb/search/fulltext_sphinx.php')
| -rw-r--r-- | phpBB/phpbb/search/fulltext_sphinx.php | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/phpBB/phpbb/search/fulltext_sphinx.php b/phpBB/phpbb/search/fulltext_sphinx.php index 59c3d55076..a20e3ad4b5 100644 --- a/phpBB/phpbb/search/fulltext_sphinx.php +++ b/phpBB/phpbb/search/fulltext_sphinx.php @@ -304,7 +304,7 @@ class fulltext_sphinx array('sql_attr_string', 'post_subject'), ), 'source source_phpbb_' . $this->id . '_delta : source_phpbb_' . $this->id . '_main' => array( - array('sql_query_pre', ''), + array('sql_query_pre', 'SET NAMES \'utf8\''), array('sql_query_range', ''), array('sql_range_step', ''), array('sql_query', 'SELECT @@ -324,6 +324,7 @@ class fulltext_sphinx WHERE p.topic_id = t.topic_id AND p.post_id >= ( SELECT max_doc_id FROM ' . SPHINX_TABLE . ' WHERE counter_id=1 )'), + array('sql_query_post_index', ''), ), 'index index_phpbb_' . $this->id . '_main' => array( array('path', $this->config['fulltext_sphinx_data_path'] . 'index_phpbb_' . $this->id . '_main'), |