AbleCommerce Shopping Cart Software

I am getting the following error in my AC error log, and search does not work from the front end.

Exception of type 'System.Web.HttpUnhandledException' was thrown.; Syntax error near 'honda' in the full-text search condition '2003 honda element'.

I am still testing, but my environment looks like this:
1. DB has a fully populated FTC
2. Store configuration has FTC checkbox enabled.
3. Product has all of these words in the search keywords field.

Thanks for your help!
Sean

Ok, I feel smart. This was handled in the latest hotfix. Applied fix, and works fine.

On the product details page is a field called "Search Keywords:", but neither the product finder, nor the advance search seem to find products with keywords in this field. Is this working?

Just test it on my local install of 7.0.3 and it seems to work great. I entered a word in keywords section of product and then tested both simple and advance search page.

seanhoward wrote:On the product details page is a field called "Search Keywords:", but neither the product finder, nor the advance search seem to find products with keywords in this field. Is this working?

Keyword search works very well. Keywords should be separated with commas like "Stainless, Steel, Skillet".

Keep in mind with FTS enabled, the Products Keyword field is mostly a mute point. FTS will return noteably different result sets for keyword searches because it's now hitting the ModelNumber, SKU, Description and Summary fields etc instead of just the contents of the product keywords field.

Also, keyword searches are "static". Putting "Stainless Steel" in the search box will NOT find a product with the keywords "Stainless, Steel, SKillet" nor will FTS return a hit on a description of "Steel skillet made of stainless material". It would only find a product with the specific words "Stainless Steel" immediately next to each other.

AC7 search is best suited for single-word or connected-word searches only. I believe improvements to this are slated in the next Able release but don't quote me on that.

I have full text search enabled, but it doenst seem to work when I serach the catalog. Am I missing something?

igavemybest wrote:I have full text search enabled, but it doenst seem to work when I serach the catalog. Am I missing something?

Did you install the FTS patch ?

Is there a patch for 7.0.3? My FTS works, just not when I am in teh admin searching in the catalog. It works on the store side and in the main upper right search box on the admin.

There is a patch.

FTS isn't implemented on the admin side.

In the interest of community knowledge, I offer this follow-up. My problem was ultimately caused by two things: 1.) I needed to install the 7.0.3 FTS patch, and 2.) I think that AC7 looks at the primary catalog, and it might be best if it remained named "ac_SearchCatalog".

Also, as a clarification of what AbleMods explained, i.e. "FTS isn't implemented on the admin side.", the search box in the header, the advanced search, and the admin search are three separate functions that appear to have different algorithms.

This may or may not be an appropriate place for this question, but I would like the SimpleSearch.ascx to look at ONLY the "search keywords" field without disabling the FTS catalog for the advanced search. Is there an easy way to do this, or do I have to refactor the ASCX to use the Admin search logic vis-a-vis "search areas"? Related to that, is there a parameter or an overload that gets the method "ProductDataSource.NarrowSearch" to return results for "all" keywords instead of "any"? I'm getting results from my data that are irrelevant to my search keywords.

Thanks everyone!

Sean