SQL 7 Full Text Search Failure - 7607

[nicfoster]

I have two tables each with one column full text indexed. I get the following error message when I try to query using contains verb:

Server: Msg 7607, Level 17, State 1, Line 1
Search on full-text catalog 'ProductName' for database ID 7, table ID 1342627826 with search condition 'FORMSOF(INFLECTIONAL,"glass&quot' failed with unknown result (319ef82c).

I have checked tosee that the catalogs are populated and that the tables are indeed full text enabled. Here is the query:

SELECT DISTINCT "Name"= Name , "Price"=min_price.minprice, "Supplier"=Products.Supplier,
"Sku"= SKU , "Image Name"= ImageName , "ProductId"=Products.Product_Id
FROM Products INNER JOIN FullProductDescr ON FullProductDescr.Prod_Id=Products.Product_Id
INNER JOIN min_price ON min_price.productid=Products.Product_Id
INNER JOIN ProductKeyWords ON ProductKeyWords.Prod_Id=Products.Product_Id
INNER JOIN WordList ON ProductKeyWords.KeywordNbr=WordList.WordValue
INNER JOIN EASearch ON EASearch.GroupWordValue=WordList.GroupWordValue
WHERE (Contains(products.Name ,'FORMSOF(INFLECTIONAL,"glass&quot')
or Contains(FullProductDescr.Descr,'FORMSOF(INFLECTIONAL,"glass&quot'))
and min_price.minprice<40 and EASearch.CategoryID in (100, 101, 102)
ORDER BY Products.Supplier, Products.Product_Id


Thanks for your help,
Nic

 

[nicfoster]

The solution to this problem was that the dll sqlftqry.dll was not updated when SP3 was installed. Installing the SP3 version of the dll solved the problem.