[rt-users] Sphinx fulltext index v4.0.4

[Poulter, Dale]

Here is the output.  Thanks.

mysql> show create table AttachmentsIndex;
+------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table            | Create Table                                                                                                                                                                                                                                  |
+------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| AttachmentsIndex | CREATE TABLE `AttachmentsIndex` (
  `id` int(10) unsigned NOT NULL,
  `weight` int(11) NOT NULL,
  `query` varchar(3072) NOT NULL,
  KEY `query` (`query`(1024))
) ENGINE=SPHINX DEFAULT CHARSET=utf8 CONNECTION='sphinx://localhost:9312/rt' |
+------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

-----Original Message-----
From: ruslan.zakirov at gmail.com [mailto:ruslan.zakirov at gmail.com] On Behalf Of Ruslan Zakirov
Sent: Friday, December 23, 2011 8:56 AM
To: Poulter, Dale
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Sphinx fulltext index v4.0.4

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.