Indexed FTS with RT 4.0.1 and pgsql 8.3.9 doesn't work

Hi there,

After enabling indexed FTS and setting up the fulltext index I run
rt-fulltext-indexer and after few seconds it trew an error:
Can’t call method “id” without a package or object reference
at ./rt-fulltext-indexer line 399.

Fulltext searches return nothing, quering the database with:
select * from attachements where content like '%something%";
works fine.

Any suggestions?

Regards,
Robert Wysocki
CONTIUM S.A., http://www.contium.pl

[snip]

Since 4.0.1 isn’t released yet, I presume you mean 4.0.1rc1.

After enabling indexed FTS and setting up the fulltext index I run
rt-fulltext-indexer and after few seconds it threw an error:
Can’t call method “id” without a package or object reference
at ./rt-fulltext-indexer line 399.

Fulltext searches return nothing, quering the database with:
select * from attachements where content like '%something%";
works fine.

Any suggestions?

Try the following patch? You’ll need to re-run configure to have the
changes propagate from rt-fulltext-indexer.in to rt-fulltext-indexer
before re-running make install.

  • Alex

0001-Return-the-Attachment-object-not-its-id.patch (832 Bytes)

[snip]

Please keep all replies on the list.

Thanks for the patch, rt-fulltext-indexer now works fine (assuming that
not trowing an error any more means everything is fine), but searches
still return no tickets whereas the same phrases are found using
non-indexed searches.

Did you run rt-fulltext-indexer, or rt-fulltext-indexer --all? I
suspect you only indexed the first 100 attachments in your database.

  • Alex

Dnia 2011-05-26, czw o godzinie 10:57 -0400, Alex Vandiver pisze:> On Thu, 2011-05-26 at 08:36 +0200, Robert Wysocki wrote:

[snip]

Please keep all replies on the list.

Thanks for the patch, rt-fulltext-indexer now works fine (assuming that
not trowing an error any more means everything is fine), but searches
still return no tickets whereas the same phrases are found using
non-indexed searches.

Did you run rt-fulltext-indexer, or rt-fulltext-indexer --all? I
suspect you only indexed the first 100 attachments in your database.

Actually I did run “rt-fulltext-indexer --all” but what I was missing
was “resolved” keyword in the search.

Thanks for the help.

Regards,
Robert Wysocki
CONTIUM S.A., http://www.contium.pl