inflectional causing "query contained only ignored words" error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tony Vargas - 21 Jan 2005 16:29 GMT

Hi

I am receiving the error "query contained only ignored words" from the word
"best" that is not in the ignored words list. While researching the problem
online I found the following link:
http://www.dbforums.com/archive/index.php/t-965368.html

In the post the poster states this is a known bug in full-text indexing and
has been written up as a "DOC bug" (not sure what that means) by MS. I am
hoping there is an update and/or fix for this problem.

Any help would be appreciated.

Thanks

Tony

Reply to this Message

Hilary Cotter - 21 Jan 2005 17:58 GMT

remove the word well from your noise word list. Stop MSSearch before making
this change and restart it after. Then rebuild your index.

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

> Hi
>
[quoted text clipped - 12 lines]
>
> Tony

Reply to this Message

Tony Vargas - 21 Jan 2005 18:21 GMT

Well there-in lies the problem. It does not exist in the noise word list.
"best" is not a noise word. It is a bug with full-text indexing when using
inflectional with certain words.

This works:
Contains(my_field, 'best')

This doesn't Work:
Contains(my_field, 'formsof(INFLECTIONAL, "best")')

In my original post I stated that in another forum someone said MS had this
listed as a bug, but I was hoping there may be a fix for this already.

> remove the word well from your noise word list. Stop MSSearch before making
> this change and restart it after. Then rebuild your index.
[quoted text clipped - 18 lines]
> >
> > Tony

Reply to this Message

Hilary Cotter - 21 Jan 2005 18:35 GMT

I'm curious as to why it works on my machine.

If you don't mind me asking - which word breaker are you using? Which OS?
Which noise file did you edit?

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

> Well there-in lies the problem. It does not exist in the noise word list.
> "best" is not a noise word. It is a bug with full-text indexing when using
[quoted text clipped - 31 lines]
> > >
> > > Tony

Reply to this Message

John Kane - 22 Jan 2005 03:42 GMT

Tony,
A "DOC bug" is a documentation bug, i.e., a "by design" feature that is not
documented in Books Online (BOL) or in a KB article.
I'll confirm that the DOC bug, however, and to the best of my knowledge, no
KB article for this has been written or made public, I'm sad to say. The
workaround at this time, is not to use the 'FORMSOF(INFLECTIONAL) parameter.

Regards,
John

Signature

SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/

> Hi
>
[quoted text clipped - 12 lines]
>
> Tony

Reply to this Message