Re: [rt-users] Sphinx fulltext index v4.0.4

2011-12-30 Thread Luciano Ernesto da Silva
Thanks for you help! Luciano -Original Message- From: Poulter, Dale [mailto:dale.poul...@vanderbilt.edu] Sent: Thu 12/29/2011 4:42 PM To: Luciano Ernesto da Silva Cc: rt-users@lists.bestpractical.com Subject: RE: [rt-users] Sphinx fulltext index v4.0.4 Here is the process I used

Re: [rt-users] Sphinx fulltext index v4.0.4

2011-12-29 Thread Poulter, Dale
. -Original Message- From: Luciano Ernesto da Silva [mailto:luci...@cpd.ufrgs.br] Sent: Thursday, December 29, 2011 12:27 PM To: Poulter, Dale Cc: rt-users@lists.bestpractical.com Subject: RE: [rt-users] Sphinx fulltext index v4.0.4 Hello Dale, Can you point me how did you compiled sphinxSE

Re: [rt-users] Sphinx fulltext index v4.0.4

2011-12-29 Thread Poulter, Dale
...@gmail.com [mailto:ruslan.zaki...@gmail.com] On Behalf Of Ruslan Zakirov Sent: Thursday, December 29, 2011 9:14 AM To: Poulter, Dale Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Sphinx fulltext index v4.0.4 Hi, Looks like your RT 4 instance is installed incorrectly. Log says that RT

Re: [rt-users] Sphinx fulltext index v4.0.4

2011-12-29 Thread Poulter, Dale
/RT.pm:343) -Original Message- From: ruslan.zaki...@gmail.com [mailto:ruslan.zaki...@gmail.com] On Behalf Of Ruslan Zakirov Sent: Friday, December 23, 2011 11:27 AM To: Poulter, Dale Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Sphinx fulltext index v4.0.4 Hi, Looks good

Re: [rt-users] Sphinx fulltext index v4.0.4

2011-12-29 Thread Luciano Ernesto da Silva
of Poulter, Dale Sent: Thu 12/29/2011 1:15 PM To: Ruslan Zakirov Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Sphinx fulltext index v4.0.4 Thanks. I was just about to send out a note. It appears the v4 was installed on top of the v3.8.5 instance which caused many issues. I

Re: [rt-users] Sphinx fulltext index v4.0.4

2011-12-29 Thread Ruslan Zakirov
] On Behalf Of Ruslan Zakirov Sent: Friday, December 23, 2011 11:27 AM To: Poulter, Dale Cc: rt-users@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.poul

Re: [rt-users] Sphinx fulltext index v4.0.4

2011-12-23 Thread Ruslan Zakirov
On Thu, Dec 15, 2011 at 17:32, Poulter, Dale dale.poul...@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

Re: [rt-users] Sphinx fulltext index v4.0.4

2011-12-23 Thread Ruslan Zakirov
On Fri, Dec 23, 2011 at 18:22, Poulter, Dale dale.poul...@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,

Re: [rt-users] Sphinx fulltext index v4.0.4

2011-12-23 Thread Poulter, Dale
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. Sent from iphone On Dec 23, 2011, at 8:29 AM, Ruslan Zakirov r...@bestpractical.com wrote: On Fri, Dec 23, 2011 at 18:22, Poulter, Dale

Re: [rt-users] Sphinx fulltext index v4.0.4

2011-12-23 Thread Ruslan Zakirov
On Fri, Dec 23, 2011 at 18:47, Poulter, Dale dale.poul...@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

Re: [rt-users] Sphinx fulltext index v4.0.4

2011-12-23 Thread Ruslan Zakirov
] Sphinx fulltext index v4.0.4 On Fri, Dec 23, 2011 at 18:47, Poulter,   Dale dale.poul...@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

Re: [rt-users] Sphinx fulltext index v4.0.4

2011-12-23 Thread Poulter, Dale
] On Behalf Of Ruslan Zakirov Sent: Friday, December 23, 2011 8:56 AM To: Poulter, Dale Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Sphinx fulltext index v4.0.4 On Fri, Dec 23, 2011 at 18:47, Poulter, Dale dale.poul...@vanderbilt.edu wrote: Correct.  The index and table seems

[rt-users] Sphinx fulltext index v4.0.4

2011-12-15 Thread Poulter, Dale
Greetings, We are testing an upgrade to version 4.0.4 from 3.8.7. The upgrade went fine and we are able to view, submit, edit, etc. We also want to implement the fulltext index using sphinx. We have compiled sphinx, added it to mysql as a plugin and successfully ran the