inflectional causing "query contained only ignored words" error

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.webservertalk.com/archive.../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
remove the word well from your noise word list. Stop MSSearch before making
this change and restart it after. Then rebuild your index.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Tony Vargas" <Tony Vargas@.discussions.microsoft.com> wrote in message
news:8CA64E3E-2645-476C-859B-776BA62108CD@.microsoft.com...
> 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.webservertalk.com/archive.../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
|||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
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Tony Vargas" <Tony Vargas@.discussions.microsoft.com> wrote in message
news:8CA64E3E-2645-476C-859B-776BA62108CD@.microsoft.com...
> 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.webservertalk.com/archive.../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

Inflectional and/or not returning the correct results

When doing the following search (SearchAllProducts, keyword, 'FORMSOF (INFLECTIONAL, pens) and FORMSOF (INFLECTIONAL, pads)'), we get 170 records returned. But if we switch the and and replace it with an OR we get 1294 records returned. Whats the part w
e don't understand is that the OR is not pulling back any of the 170 records where both words are in the keyword field. Even though we do a pens search and we get 748 records and for pads we get 716 records. We would expect to get back 1464 records. I
s this a bug or we not doing something right? We are using Enterprise Edition running SP3a on Windows 2000 running SP4.
Any ideas?
Kris
Kris,
Could you post some of the actual data in the FT-enable column(s) from your
FT-enabled table(s) along with the actual FTS query and table structure?
Also, do you have multiple FT-enabled tables in one FT Catalogs or do you
use one FT Catalog for each FT-enabled table?
Thanks,
John
"Kris" <kmccarty@.distributorcentral.com> wrote in message
news:81F1AFB5-679F-4963-B8B9-77A0FAFB6A7E@.microsoft.com...
> When doing the following search (SearchAllProducts, keyword, 'FORMSOF
(INFLECTIONAL, pens) and FORMSOF (INFLECTIONAL, pads)'), we get 170 records
returned. But if we switch the and and replace it with an OR we get 1294
records returned. Whats the part we don't understand is that the OR is not
pulling back any of the 170 records where both words are in the keyword
field. Even though we do a pens search and we get 748 records and for pads
we get 716 records. We would expect to get back 1464 records. Is this a
bug or we not doing something right? We are using Enterprise Edition
running SP3a on Windows 2000 running SP4.
> Any ideas?
> Kris

Inflectional ?

Hi,
Ok, say I want to pull back all '"picture ~ frame"' and '"pictures ~
frames"' so I do the following; FormsOf(Inflectional, "picture ~ frame")
this results in syntax error. I thought inflectional would automatically do
it if I put " around the near words. The first ones I listed do not pull
back the plurals, if I use the wildcard I get what I need but wonder if this
is the way it should work say I also want framing so I do fram* but this
would also give me frampton which I do not want. Do I need to use the
thesuraus or is there some way of forming the inflectional that I am not
getting?
Thanks,
jc
Sorry forgot, sql 2k5 sp2a
jc
|||A freetext query will do an implicit near and the stemming you are looking
for.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"John Cantley" <johnca@.magenic.com> wrote in message
news:OoTJLiBcHHA.208@.TK2MSFTNGP05.phx.gbl...
> Hi,
> Ok, say I want to pull back all '"picture ~ frame"' and '"pictures ~
> frames"' so I do the following; FormsOf(Inflectional, "picture ~ frame")
> this results in syntax error. I thought inflectional would automatically
> do it if I put " around the near words. The first ones I listed do not
> pull back the plurals, if I use the wildcard I get what I need but wonder
> if this is the way it should work say I also want framing so I do fram*
> but this would also give me frampton which I do not want. Do I need to use
> the thesuraus or is there some way of forming the inflectional that I am
> not getting?
> Thanks,
> jc
>
sql