diff options
| author | Dhruv <dhruv.goel92@gmail.com> | 2012-07-12 17:22:03 +0530 |
|---|---|---|
| committer | Dhruv <dhruv.goel92@gmail.com> | 2012-07-19 23:01:49 +0530 |
| commit | 81959927e53ebc62765ff075d23feeaf9b40a95d (patch) | |
| tree | c02152cb40f888ace2dae608f1f371dbf721df53 /phpBB/docs | |
| parent | b81941a997760eca4f209cc100fe2baec3ef4468 (diff) | |
| download | forums-81959927e53ebc62765ff075d23feeaf9b40a95d.tar forums-81959927e53ebc62765ff075d23feeaf9b40a95d.tar.gz forums-81959927e53ebc62765ff075d23feeaf9b40a95d.tar.bz2 forums-81959927e53ebc62765ff075d23feeaf9b40a95d.tar.xz forums-81959927e53ebc62765ff075d23feeaf9b40a95d.zip | |
[feature/sphinx-fulltext-search] use Update in sphinx query
Instead of REPLACE use UPDATE since pgsql does not support REPLACE.
A row is inserted at time of creating table so REPLACE is no longer
needed.
PHPBB3-10946
Diffstat (limited to 'phpBB/docs')
| -rw-r--r-- | phpBB/docs/sphinx.sample.conf | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/phpBB/docs/sphinx.sample.conf b/phpBB/docs/sphinx.sample.conf index 3ab2552096..8ffd54a880 100644 --- a/phpBB/docs/sphinx.sample.conf +++ b/phpBB/docs/sphinx.sample.conf @@ -7,7 +7,7 @@ source source_phpbb_{SPHINX_ID}_main sql_db = db_name sql_port = 3306 #optional, default is 3306 sql_query_pre = SET NAMES 'utf8' - sql_query_pre = REPLACE INTO phpbb_sphinx SELECT 1, MAX(post_id) FROM phpbb_posts + sql_query_pre = UPDATE phpbb_sphinx SET max_doc_id = MAX(post_id) WHERE counter_id = 1 sql_query_range = SELECT MIN(post_id), MAX(post_id) FROM phpbb_posts sql_range_step = 5000 sql_query = SELECT
\ @@ -27,7 +27,7 @@ source source_phpbb_{SPHINX_ID}_main p.topic_id = t.topic_id
\ AND p.post_id >= $start AND p.post_id <= $end sql_query_post = - sql_query_post_index = REPLACE INTO phpbb_sphinx ( counter_id, max_doc_id ) VALUES ( 1, $maxid ) + sql_query_post_index = UPDATE phpbb_sphinx SET max_doc_id = $maxid WHERE counter_id = 1 sql_query_info = SELECT * FROM phpbb_posts WHERE post_id = $id sql_attr_uint = forum_id sql_attr_uint = topic_id |