[rt-users] Sphinx fulltext index v4.0.4

[Ruslan Zakirov]

On Fri, Dec 23, 2011 at 18:47, Poulter,   Dale
<dale.poulter at vanderbilt.edu> wrote:
> Correct.  The index and table seems to have been created.  One strange item is that the attatchmentindex table in MySQL is empty. Thanks for your help.

It's sort of empty as it's dynamic. It's a special table that connects
mysql to sphinx. Run 'show create table AttachmentsIndex' and send us
output.

>
>
> Sent from iphone
>
>
> On Dec 23, 2011, at 8:29 AM, "Ruslan Zakirov" <ruz at bestpractical.com> wrote:
>
>> On Fri, Dec 23, 2011 at 18:22, Poulter,   Dale
>> <dale.poulter at vanderbilt.edu> wrote:
>>> I actually tried with and without the fulltext without any success.
>>
>> It's hard to say what went wrong. Just for clarification, you've
>> created required tables with a script, configured RT's config,
>> configured sphinx, setup indexer that puts data into sphinx index.
>> Right?
>>
>> To diagnose this start with RT's debug log. Enable logging of SQL
>> statements in RT. Use command line sphinx client to make sure data is
>> in the index. At this moment we don't have any info to help you.
>>
>>> Sent from iphone
>>>
>>>
>>> On Dec 23, 2011, at 3:09 AM, "Ruslan Zakirov" <ruz at bestpractical.com> wrote:
>>>
>>>> On Thu, Dec 15, 2011 at 17:32, Poulter,   Dale
>>>> <dale.poulter at vanderbilt.edu> wrote:
>>>>> However,  Request Tracker does not seem to be searching the index.  If we
>>>>> search for any term that is only in the contents of the ticket and not the
>>>>> header we do not get any hits.  We do get hits for terms in the ticket
>>>>> header though.  If I search sphinx directly for a term everything works
>>>>> correctly.  It seems as if RT is not searching Sphinx.  Have I missed a step
>>>>> in the setup process?  Any assistance will be appreciated.  Thanks.
>>>>
>>>> How do you search? It's still required to use fulltext:x in simple
>>>> search and Content in the query builder.
>>>>
>>>> --
>>>> Best regards, Ruslan.
>>>>
>>>
>>
>>
>>
>> --
>> Best regards, Ruslan.
>>
>
> --------
> RT Training Sessions (http://bestpractical.com/services/training.html)
> * Boston  March 5 & 6, 2012



-- 
Best regards, Ruslan.