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: [email protected] [mailto:[email protected]] On Behalf Of
Ruslan Zakirov
Sent: Friday, December 23, 2011 8:56 AM
To: Poulter, Dale
Cc: [email protected]
Subject: Re: [rt-users] Sphinx fulltext index v4.0.4
On Fri, Dec 23, 2011 at 18:47, Poulter, Dale
<[email protected]> 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" <[email protected]> wrote:
>
>> On Fri, Dec 23, 2011 at 18:22, Poulter, Dale
>> <[email protected]> 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" <[email protected]>
>>> wrote:
>>>
>>>> On Thu, Dec 15, 2011 at 17:32, Poulter, Dale
>>>> <[email protected]> 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.
--------
RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston March 5 & 6, 2012
