| Index: trunk/extensions/SphinxSearch/sphinx.conf |
| — | — | @@ -1,5 +1,5 @@ |
| 2 | 2 | # |
| 3 | | -# Sphinx configuration for MediaWiki |
| | 3 | +# Sphinx configuration for MediaWiki |
| 4 | 4 | # |
| 5 | 5 | # Based on examples by Paul Grinberg at http://www.mediawiki.org/wiki/Extension:SphinxSearch |
| 6 | 6 | # and Hank at http://www.ralree.info/2007/9/15/fulltext-indexing-wikipedia-with-sphinx |
| — | — | @@ -27,10 +27,11 @@ |
| 28 | 28 | sql_query_pre = SET NAMES utf8 |
| 29 | 29 | |
| 30 | 30 | # main document fetch query - change the table names if you are using a prefix |
| 31 | | - sql_query = SELECT page_id, page_title, page_namespace, old_id, old_text FROM page, revision, text WHERE rev_id=page_latest AND old_id=rev_text_id |
| | 31 | + sql_query = SELECT page_id, page_title, page_namespace, page_is_redirect, old_id, old_text FROM page, revision, text WHERE rev_id=page_latest AND old_id=rev_text_id |
| 32 | 32 | |
| 33 | 33 | # attribute columns |
| 34 | 34 | sql_attr_uint = page_namespace |
| | 35 | + sql_attr_uint = page_is_redirect |
| 35 | 36 | sql_attr_uint = old_id |
| 36 | 37 | |
| 37 | 38 | # uncomment next line to collect all category ids for a category filter |
| — | — | @@ -40,12 +41,12 @@ |
| 41 | 42 | sql_query_info = SELECT page_title, page_namespace FROM page WHERE page_id=$id |
| 42 | 43 | } |
| 43 | 44 | |
| 44 | | -# data source definition for the incremental index |
| | 45 | +# data source definition for the incremental index |
| 45 | 46 | source src_wiki_incremental : src_wiki_main |
| 46 | 47 | { |
| 47 | 48 | # adjust this query based on the time you run the full index |
| 48 | 49 | # in this case, full index runs at 3 AM (server time) which translates to 7 AM UTC |
| 49 | | - sql_query = SELECT page_id, page_title, page_namespace, old_id, old_text FROM page, revision, text WHERE rev_id=page_latest AND old_id=rev_text_id AND page_touched>=DATE_FORMAT(CURDATE(), '%Y%m%d070000') |
| | 50 | + sql_query = SELECT page_id, page_title, page_namespace, page_is_redirect, old_id, old_text FROM page, revision, text WHERE rev_id=page_latest AND old_id=rev_text_id AND page_touched>=DATE_FORMAT(CURDATE(), '%Y%m%d070000') |
| 50 | 51 | |
| 51 | 52 | # all other parameters are copied from the parent source, |
| 52 | 53 | } |