User:Hef/rt search: Difference between revisions
From Pumping Station One
| (3 intermediate revisions by the same user not shown) | |||
| Line 18: | Line 18: | ||
I added The following to RT_SiteConfig.pm | I added The following to RT_SiteConfig.pm | ||
<pre> | |||
Set( %FullTextSearch, | Set( %FullTextSearch, | ||
Enable => 1, | Enable => 1, | ||
| Line 24: | Line 25: | ||
Table => 'AttachmentsIndex', | Table => 'AttachmentsIndex', | ||
); | ); | ||
</pre> | |||
Below is a simple Sphinx configuration which can be used to index all | Below is a simple Sphinx configuration which can be used to index all | ||
| Line 29: | Line 31: | ||
ideal; you should read the Sphinx documentation to understand how to | ideal; you should read the Sphinx documentation to understand how to | ||
configure it to better suit your needs. | configure it to better suit your needs. | ||
<pre> | |||
source rt { | source rt { | ||
| Line 47: | Line 50: | ||
sql_query_info = SELECT * FROM Attachments WHERE id=$id | sql_query_info = SELECT * FROM Attachments WHERE id=$id | ||
} | } | ||
index rt { | index rt { | ||