<html>
<head>
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<font size="-1"><font face="DejaVu Sans Mono">After successfull<font
size="-1">y setting up RT with sphinx</font> I'm trying to
search for a string<br>
<font size="-1">in a ticket's 'content<font size="-1">'</font></font>.
When <font size="-1">I enter t<font size="-1">he str<font
size="-1">ing into 'Search' box of RT it <br>
<font size="-1">returns no result even when I'm using
fulltext<font size="-1">:<search-string> format of
search.<br>
<font size="-1">Whe<font size="-1">n the same is
searched with Sphinx's 'search' <font size="-1">binary,
the results are coming<br>
<font size="-1">up fine. Is RT not communicating
with Sphinx over here?<br>
<br>
<font size="-1">A section of my
RT_SiteConfig.pm:<br>
<br>
<font size="-1">Set( %FullTextSearch,<br>
Enable => 1,<br>
Indexed => 1,<br>
Table => 'AttachmentsIndex',<br>
MaxMatches => '10000',<br>
);<br>
<br>
<br>
<font size="-1"><br>
<font size="-1">mysql> show create
table AttachmentsIndex \G</font><br>
<br>
<font size="-1"> Table:
AttachmentsIndex<br>
Create Table: CREATE TABLE
`AttachmentsIndex` (<br>
`id` int(10) unsigned NOT NULL,<br>
`weight` int(11) NOT NULL,<br>
`query` varchar(3072) NOT NULL,<br>
KEY `query` (`query`(1024))<br>
) ENGINE=SPHINX DEFAULT CHARSET=utf8
CONNECTION='sphinx://localhost:3312/rt,rt_delta'<br>
</font><br>
NB:<br>
<font size="-1">1. I have <font
size="-1">stopped,started Apache
after all the sphinx integrati<font
size="-1">on was done. <br>
<font size="-1"> </font>A<font
size="-1">lso did it <font
size="-1">again </font>when
search results</font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font><font
face="DejaVu Sans Mono">
<small> were not returned</small></font> <font size="-1">from
web-interface <font size="-1">search.<br>
<font size="-1"><br>
2. <font size="-1">'searchd' is <font size="-1">listening at
127.0.0.1:3312</font></font></font><br>
</font></font>
</body>
</html>