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
