[rt-users] Full text search don't work

[Matt Zagrabelny]

On Tue, Dec 16, 2014 at 8:34 AM, Arkady Glazov <uglobster at 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 .

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