[rt-users] Sphinx fulltext index v4.0.4

Thu Dec 29 08:26:25 EST 2011

Here is the output from the debug log.  The mysql log did not have any errors.

[Thu Dec 29 13:01:54 2011] [error]: Found more than one occurrence of the /Callbacks/AssetTracker/autohandler/Default callback.  This may cause only one of the callbacks to run.  Look for the duplicate Callback in your /apps/rt385/local/html /apps/rt385/local/plugins/RT-Authen-ExternalAuth/html /apps/rt385/local/plugins/RT-Extension-MergeUsers/html /apps/rt385/local/plugins/RT-Extension-MergeUsersHistory/html /apps/rt385/local/plugins/RT-Extension-MandatorySubject/html /apps/rt385/local/plugins/RT-Extension-SummaryByUser/html /apps/rt385/local/plugins/RT-Extension-MobileUI/html /apps/rt385/share/html (/apps/rt385/sbin/../lib/RT/Interface/Web/Request.pm:133)
[Thu Dec 29 13:02:21 2011] [warning]: RT::ActiveStatus undefined, falling back to deprecated defaults (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:202)
[Thu Dec 29 13:02:21 2011] [warning]: RT::InactiveStatus undefined, falling back to deprecated defaults (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:222)
[Thu Dec 29 13:02:21 2011] [warning]: RT::ActiveStatus undefined, falling back to deprecated defaults (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:202)
[Thu Dec 29 13:02:21 2011] [warning]: RT::InactiveStatus undefined, falling back to deprecated defaults (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:222)
[Thu Dec 29 13:02:21 2011] [warning]: RT::ActiveStatus undefined, falling back to deprecated defaults (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:202)
[Thu Dec 29 13:02:21 2011] [warning]: RT::InactiveStatus undefined, falling back to deprecated defaults (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:222)
[Thu Dec 29 13:02:21 2011] [warning]: RT::ActiveStatus undefined, falling back to deprecated defaults (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:202)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine IsGroup redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 76. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:76)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine IsUser redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 96. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:96)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine Object redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 116. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:116)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine GrantRight redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 153. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:153)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine RevokeRight redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 190. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:190)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine HasRight redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 282. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:282)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine _HasRight redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 372. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:372)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine _HasGroupRight redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 390. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:390)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine _HasRoleRight redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 444. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:444)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine InvalidateACLCache redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 526. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:526)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine _GetPrincipalTypeForACL redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 547. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:547)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine _ReferenceId redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 573. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:573)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine _InitSQL redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 64. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:64)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine _SQLLimit redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 77. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:77)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine _SQLJoin redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 96. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:96)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine _OpenParen redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 106. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:106)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine _CloseParen redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 109. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:109)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine _close_bundle redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 140. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:140)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine _parser redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 171. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:171)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine ClausesToSQL redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 247. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:247)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine FromSQL redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 282. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:282)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine Query redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 348. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:348)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine ClassifySQLOperation redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 365. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:365)
[Thu Dec 29 13:03:56 2011] [warning]:   (in cleanup) Error while loading /apps/rt385/sbin/rt-server: Can't locate RT/Authen/ExternalAuth.pm in @INC (@INC contains: /apps/rt385/sbin/../local/lib /apps/rt385/sbin/../lib /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 . /opt/pkgs/apache-2.2.15) at /apps/rt385/sbin/../lib/RT.pm line 659. (/apps/rt385/sbin/../lib/RT.pm:343)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine IsGroup redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 76. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:76)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine IsUser redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 96. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:96)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine Object redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 116. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:116)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine GrantRight redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 153. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:153)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine RevokeRight redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 190. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:190)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine HasRight redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 282. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:282)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine _HasRight redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 372. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:372)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine _HasGroupRight redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 390. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:390)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine _HasRoleRight redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 444. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:444)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine InvalidateACLCache redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 526. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:526)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine _GetPrincipalTypeForACL redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 547. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:547)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine _ReferenceId redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 573. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:573)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine _InitSQL redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 64. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:64)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine _SQLLimit redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 77. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:77)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine _SQLJoin redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 96. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:96)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine _OpenParen redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 106. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:106)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine _CloseParen redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 109. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:109)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine _close_bundle redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 140. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:140)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine _parser redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 171. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:171)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine ClausesToSQL redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 247. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:247)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine FromSQL redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 282. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:282)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine Query redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 348. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:348)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine ClassifySQLOperation redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 365. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:365)
[Thu Dec 29 13:04:02 2011] [warning]:   (in cleanup) Error while loading /apps/rt385/sbin/rt-server: Can't locate RT/Authen/ExternalAuth.pm in @INC (@INC contains: /apps/rt385/sbin/../local/lib /apps/rt385/sbin/../lib /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 . /opt/pkgs/apache-2.2.15) at /apps/rt385/sbin/../lib/RT.pm line 659. (/apps/rt385/sbin/../lib/RT.pm:343)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine IsGroup redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 76. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:76)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine IsUser redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 96. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:96)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine Object redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 116. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:116)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine GrantRight redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 153. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:153)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine RevokeRight redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 190. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:190)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine HasRight redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 282. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:282)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _HasRight redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 372. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:372)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _HasGroupRight redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 390. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:390)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _HasRoleRight redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 444. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:444)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine InvalidateACLCache redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 526. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:526)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _GetPrincipalTypeForACL redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 547. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:547)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _ReferenceId redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 573. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:573)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _InitSQL redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 64. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:64)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _SQLLimit redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 77. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:77)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _SQLJoin redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 96. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:96)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _OpenParen redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 106. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:106)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _CloseParen redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 109. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:109)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _close_bundle redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 140. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:140)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _parser redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 171. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:171)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine ClausesToSQL redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 247. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:247)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine FromSQL redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 282. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:282)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine Query redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 348. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:348)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine ClassifySQLOperation redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 365. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:365)
[Thu Dec 29 13:04:07 2011] [warning]:   (in cleanup) Error while loading /apps/rt385/sbin/rt-server: Can't locate RT/Authen/ExternalAuth.pm in @INC (@INC contains: /apps/rt385/sbin/../local/lib /apps/rt385/sbin/../lib /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 . /opt/pkgs/apache-2.2.15) at /apps/rt385/sbin/../lib/RT.pm line 659. (/apps/rt385/sbin/../lib/RT.pm:343)

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

Hi,

Looks good. Move on to SQL log and debug log.

On Fri, Dec 23, 2011 at 21:13, Poulter,   Dale
<dale.poulter at vanderbilt.edu> wrote:
> 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.
>

--
Best regards, Ruslan.