Free text searching working?

[Si Burgess]

Hi all,

As I understand, enabling the free text search should allow for searching of the product description by using a MSSQL free text catalog, right? help.ablecommerce.com doesn't seem have a page on this, only mentions it in the bug/fixes release pages. Some info in the manual on this would help understanding.

I have enabled free text searching, no errors were shown in the UI nor the error log so I presume the free text catalog has been created and populated. I have then gone to the store and searched on one of the words in a product description. In the results no results are found. The word was "competition" so shouldn't be in the standard ignore words list.

Searching on a word in product name works OK.

How can I see if free text searching has been correctly set-up?

Also, what is the name of the free text catalog the system creates? I need to supply that to my hosting company.

Many thanks,
Si

[AbleMods]

Try testing for a few words found only in the description field of a few products. AC7 search wouldn't find those by default. If that works, you're fine.

The SQL FTS files are called sysft_<dbname>Catalog and sysft_ac_SearchCatalog

Make sure you've installed the FTS search patch for 7.0.3 - there's a bug when more than one keyword in the search criteria is used.

[Si Burgess]

Thanks for the reply.

Updating to the latest CommerceBuilder.dll and a reset of the App Pool got it working. Thought asp.net was supposed to monitor file changes in the /bin folder and perform it's own restart when a file changes, it needed a clout in my case.

Si

[bkort@web2market.com]

Hi:

Any idea why the Full Text / Free Text search isn't enabled by default? Why anybody wouldn't want it enabled?

[jmestep]

I think it has something to do with the hosting- some hosters wouldn't allow it.
It isn't working well now, but is going to be working better in 7.0.4

http://bugs.ablecommerce.com/show_bug.cgi?id=8361

[AbleMods]

FTS must also be installed and enabled on the SQL server. Not all ISPs will have it enabled thus Able cannot assume it will always be available for a particular store deployment.