FTS enabled in SiteConfig, but not being enabled

Hi all,
I’ve enabled FTS on the database, and restarted the server just to be sure.
I have this line in one of my config files:

Set( %FullTextSearch,
Enable => 1,
Indexed => 1,
Table => ‘AttachmentsIndex’);

And yet, in global > system config, I see that Enable is set to 0, not 1.
I’ve looked at the loaded config files, and they include the one where I
enabled this. After a lot of work yesterday, I did get the index program to
run without any warnings, so I know that worked. I see no errors in the log
when RT starts, at least not related to FTS.

I’m on RT 4.4.1, MySQL 5.7, Debian 8. What’s the trick to getting FTS to
work? Thanks!

Alex Hall
Automatic Distributors, IT department
ahall@autodist.com

Hi Alex,

Sounds like you may need to clear the mason cache.

Best Regards

MartinOn 2016-11-15 15:34, Alex Hall wrote:

Hi all,
I’ve enabled FTS on the database, and restarted the server just to be
sure. I have this line in one of my config files:

Set( %FullTextSearch,
Enable => 1,
Indexed => 1,
Table => ‘AttachmentsIndex’);

And yet, in global > system config, I see that Enable is set to 0, not

  1. I’ve looked at the loaded config files, and they include the one
    where I enabled this. After a lot of work yesterday, I did get the
    index program to run without any warnings, so I know that worked. I
    see no errors in the log when RT starts, at least not related to FTS.

I’m on RT 4.4.1, MySQL 5.7, Debian 8. What’s the trick to getting FTS
to work? Thanks!

Alex Hall
Automatic Distributors, IT department
ahall@autodist.com


RT 4.4 and RTIR training sessions, and a new workshop day!
https://bestpractical.com/training

  • Los Angeles - January 9-11 2017

Good thought, but that doesn’t seem to have helped. It still says that
Enable and Indexed are 0 in the system configuration page.On Tue, Nov 15, 2016 at 10:49 AM, Martin Wheldon < martin.wheldon@greenhills-it.co.uk> wrote:

Hi Alex,

Sounds like you may need to clear the mason cache.

Best Regards

Martin

On 2016-11-15 15:34, Alex Hall wrote:

Hi all,
I’ve enabled FTS on the database, and restarted the server just to be
sure. I have this line in one of my config files:

Set( %FullTextSearch,
Enable => 1,
Indexed => 1,
Table => ‘AttachmentsIndex’);

And yet, in global > system config, I see that Enable is set to 0, not

  1. I’ve looked at the loaded config files, and they include the one
    where I enabled this. After a lot of work yesterday, I did get the
    index program to run without any warnings, so I know that worked. I
    see no errors in the log when RT starts, at least not related to FTS.

I’m on RT 4.4.1, MySQL 5.7, Debian 8. What’s the trick to getting FTS
to work? Thanks!

Alex Hall
Automatic Distributors, IT department
ahall@autodist.com


RT 4.4 and RTIR training sessions, and a new workshop day!
https://bestpractical.com/training

  • Los Angeles - January 9-11 2017

RT 4.4 and RTIR training sessions, and a new workshop day!
https://bestpractical.com/training

  • Los Angeles - January 9-11 2017

Alex Hall
Automatic Distributors, IT department
ahall@autodist.com

Good thought, but that doesn’t seem to have helped. It still says that
Enable and Indexed are 0 in the system configuration page.

Hi Alex,

Sounds like you may need to clear the mason cache.

Clearing the mason cache only affects mason components that have been
updated on disk.

Changing configuration parameters wouldn’t effect any mason components.

-m

Hi all,
I found the problem. I’ve seen “Table” and “TableName” both used in sample
configurations, but apparently only one is correct. As soon as I switched
to “Table” in my config file, FTS enabled itself.On Tue, Nov 15, 2016 at 11:09 AM, Matt Zagrabelny mzagrabe@d.umn.edu wrote:

On Tue, Nov 15, 2016 at 9:56 AM, Alex Hall ahall@autodist.com wrote:

Good thought, but that doesn’t seem to have helped. It still says that
Enable and Indexed are 0 in the system configuration page.

On Tue, Nov 15, 2016 at 10:49 AM, Martin Wheldon martin.wheldon@greenhills-it.co.uk wrote:

Hi Alex,

Sounds like you may need to clear the mason cache.

Clearing the mason cache only affects mason components that have been
updated on disk.

Changing configuration parameters wouldn’t effect any mason components.

-m

Alex Hall
Automatic Distributors, IT department
ahall@autodist.com

I found the problem. I’ve seen “Table” and “TableName” both used in sample
configurations, but apparently only one is correct. As soon as I switched
to “Table” in my config file, FTS enabled itself.

If any of the configurations with “TableName” that you found were on
BPS’ site, please let them know where, so it can be fixed. If they
were on the wiki, please update them.

When I start RT 4.4.1 with “TableName” instead of “Table”, I see the
following in my error log:

[error]: No Table set for full-text index; disabling

It surprises me that you didn’t see such an error.

  • Alex