On 13/03/2014 14:32, Kevin Falcone wrote:
On Thu, Mar 13, 2014 at 02:06:40PM +0000, Mark Goodge wrote:
On 13/03/2014 14:00, Cena, Stephen (ext. 300) wrote:
We currently run two RT 4.0.19 systems on Ubuntu 12.04LTS and MySQL
5.5.35. Management is now asking me to enable full text searching on the
sites so we can search inside the body of the tickets. From what I've
read, our current configuration won't support it due to MySQL 5.5.x not
supporting it natively.
MySQL has supported fulltext indexes since version 5.0. What makes you
think otherwise?
It supported InnoDB Full Text indexing in 5.0?
No; you need to use MyISAM until 5.6.
But that should not be an issue here; I know that RT uses InnoDB by
default but there should be no reason why the table you want to search
can't be converted to MyISAM.
Mark
--
My blog: http://mark.goodge.co.uk
--
RT Training London, March 19-20 and Dallas May 20-21
http://bestpractical.com/training
