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

Tue Jan 11 06:22:15 EST 2011

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/20110111/ae4d4b99/attachment.htm>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: more_code.zip.txt
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110111/ae4d4b99/attachment.txt>