[rt-users] Sphinx full-text search engine in RT

Wed Jan 12 03:44:05 EST 2011

Hi Cristiano.

Thanks for your reply.
It seems like your attached zip file was removed somewhere on the way, probably in your end, since it is missing both in your mail to me and in the one to rt-users. It has been replaced by a text file containing "This attachment was removed by Edge3 Transport Agent". Is it a lot of code, or could you add it to the wiki as well?

/Johan

From: Guadagnino Cristiano [mailto:guadagnino.cristiano at creval.it]
Sent: den 11 januari 2011 12:22
To: Johan Sjöberg
Cc: rt-users at lists.bestpractical.com
Subject: R: Sphinx full-text search engine in RT

Hi Johan,
I am attaching the missing files to this message.

You'll also find "sorttable-RT.js", which we implemented after I wrote the article: with this you can sort the results table by clicking on the field names in the table header (like other tables in RT). It still lacks feedback when you hover the table headers, but it works very well otherwise.

To enable table sorting you have to modify sphinx.php and insert the following code in the <head> section (obviosuly you'll have to adapt the path):

<script src='JavaScript/sorttable-RT.js' type='text/javascript'></script>

Before doing this, please reget the sphinx.php script from the wiki because I'm going to add a few lines of necessary code there.

Hope this helps!

Bye
Cristiano

Da: Johan Sjöberg [mailto:johan.sjoberg at deltamanagement.se]
Inviato: Tuesday, January 11, 2011 10:39 AM
A: Guadagnino Cristiano; rt-users at lists.bestpractical.com
Oggetto: RE: Sphinx full-text search engine in RT

Hi.

Thanks for your great work. I am currently trying to follow your documentation to integrate sphinx in our RT setup, and I have run into some problems.

In sphinx.php, you include MySql.class.php and Timer.class.php. What are these? Have you written them yourself, or are they available for download somewhere?

Best Regards,
Johan

From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Guadagnino Cristiano
Sent: den 13 september 2010 15:22
To: rt-users at lists.bestpractical.com
Subject: [rt-users] Sphinx full-text search engine in RT

Hi all,
I just wanted to let everyone know that I have finished integrating the Sphinx search engine in our RT.

It is simply great: full-text searches on the whole RT db in just fractions of a second!

I am slowly documenting the whole thing on the RT wiki. You can find it by looking for "IntegratingSphinx". It is not yet complete though.

I hope it will be useful to somebody else.

Bye
Cris

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110112/0a94f92c/attachment.htm>