Full text search don't work

RT Users
1

Hi,
Please help me understand where is my full text search?

i have Debian Linux machine with Pg, Apache 2 and installed RT 4.2.9 .

I run rt-setup-fulltext-index successfully, also run rt-fulltext-indexer
–all and change my RT_SiteConfig.pm:

Set( %FullTextSearch,
Enable => 1,
Indexed => 1,
Column => ‘ContentIndex’,
Table => ‘Attachments’,
);
Restart Apache and nothing. RT don’t search any words in content of tickets.

Best regards,
Arkady Glazov
http://globster.ru

2

I had to use the fulltext: prefix in order to get fulltext search working,
e.g.:

fulltext:"my fulltext here"On Tue, Dec 16, 2014 at 8:34 AM, Arkady Glazov uglobster@gmail.com wrote:

Hi,
Please help me understand where is my full text search?

i have Debian Linux machine with Pg, Apache 2 and installed RT 4.2.9 .

I run rt-setup-fulltext-index successfully, also run rt-fulltext-indexer
–all and change my RT_SiteConfig.pm:

Set( %FullTextSearch,
Enable => 1,
Indexed => 1,
Column => ‘ContentIndex’,
Table => ‘Attachments’,
);
Restart Apache and nothing. RT don’t search any words in content of
tickets.

–
Best regards,
Arkady Glazov
http://globster.ru

3

Hi,
Please help me understand where is my full text search?

i have Debian Linux machine with Pg, Apache 2 and installed RT 4.2.9 .

Ditto.

I run rt-setup-fulltext-index successfully, also run rt-fulltext-indexer
–all and change my RT_SiteConfig.pm:

Set( %FullTextSearch,
Enable => 1,
Indexed => 1,
Column => ‘ContentIndex’,
Table => ‘Attachments’,
);
Restart Apache and nothing. RT don’t search any words in content of tickets.

How are you executing a search?

Just out of curiosity what do the following yield:

SELECT count(*) from attachments where contentindex != ‘’;

SELECT count(*) from attachments where contentindex = ‘’;

Cheers,

-m