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: [email protected] [mailto:[email protected]] On Behalf Of Ruslan Zakirov Sent: Friday, December 23, 2011 11:27 AM To: Poulter, Dale Cc: [email protected] 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 <[email protected]> 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: [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. > -- Best regards, Ruslan. -------- RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
