[rt-users] Help! I enabled Full Text search and now Simple search won't look at Subjects !!

[ktm at rice.edu]

On Wed, Oct 07, 2015 at 02:51:16PM -0400, Al Joslin wrote:
> I am running 4.2.11
> 
> I have install mariadb 10.0 
> 
> I have enabled native mySQL full text search
> 
> It works fine - EXCEPT: it seems that I can have Full Text -or- Subject from the Simple Search box, but not both?
> 
> If I disable the full text from the RT_Site_config then the simple search box searches subjects but not attachments
> 
> If I enable the full text from the RT_Site_config then the simple search box searches attachments but not subjects
> 
> I don’t know how to proceed, this is not going to go over well…
> 
> I also have a custom field my users insisted on that will carry text — can I index and search more than one table (attachments) ?
> 
> thanks
> al;
> 

Hi Al,

It definitely looks like a bug to me. Have you reported it? It also looks like
it will only handle a single table search so you will need to write code to add
support for your other custom field. I had something similar in my PostgreSQL
patch for older systems, but I have not looked recently.

Regards,
Ken