Full Text Search not working on new install

[Mike718NY]

I have a new install (VERSION: 7.0.3 BUILD: 12458) and Full Text seach isnt' working.

I checked off "Enable Full Text Searching" and have [[ConLib:SimpleSearch]] in default header.

I was looking in SQL Server and noticed this:
Catalog Size : 0 MB
Default Catalog : False

Am I missing anything?

[tomo218]

I have the same problem, did a new install and having this issue..
using sql server 2005.

An error has occured at http://www.itdirec.com/Search.aspx?k=hp, ssd Exception of type 'System.Web.HttpUnhandledException' was thrown.; Syntax error near ',' in the full-text search condition 'hp, ssd'.

[tomo218]

updated to the commercebuilder build patch 12912

Exception of type 'System.Web.HttpUnhandledException' was thrown.; Object reference not set to an instance of an object.

[Mike718NY]

My full text search is still not working.
I don't get any errors. When I type in a search word, it just displays all products.

[Chris Hadden]

Do you have "category search" enabled in the side bar? This needed to be on for my text search to work. Otherwise it returned all products.

[Mike718NY]

thanks Chris, . . I remember doing this on my last website but I'm not sure what I did. I had:

Do I put that parameter here:

[[ConLib:Custom/SimpleCategoryList CategoryId="0"]]

[Mike718NY]

How do I find the parameters for the side bar, especially the "category search" enabled one?

[Mike718NY]

Still can't get this to work.

[Logan Rhodehamel]

When you are on the Configure -> Store screen, can you describe what it says under the Full Text Search section?

[Mike718NY]

Enabling full text search can improve the response times for searches performed on your product catalog.

[Checked] Enable Full Text Searching

[Logan Rhodehamel]

What happens when you search on the retail side?

[jmestep]

If it is enabled, there should be an ac_SearchCatalog in your database-->Storage-->Full Text Catalog. One of the sites I work in is on a HyperV at Drundo and Drundo had it disabled to save resources, but they turned it on when i asked.

[Logan Rhodehamel]

If it is enabled, there should be an ac_SearchCatalog in your database-->Storage-->Full Text Catalog. One of the sites I work in is on a HyperV at Drundo and Drundo had it disabled to save resources, but they turned it on when i asked.

When it was disabled, were we able to detect it successfully from the configuration screen though? If not, it might indicate some other way we should be checking for FTS capability.

[sdlong02]

If it is enabled, there should be an ac_SearchCatalog in your database-->Storage-->Full Text Catalog. One of the sites I work in is on a HyperV at Drundo and Drundo had it disabled to save resources, but they turned it on when i asked.

When it was disabled, were we able to detect it successfully from the configuration screen though? If not, it might indicate some other way we should be checking for FTS capability.

I'm pretty sure there is no indication if it is working or not in the configuration screen. It's just a checkbox to mark whether you want FTS enabled or not. Unless of course mine is setup incorrectly and I'm just figuring that out.

[tomo218]

New Setup...
PLATFORM: ASP.NET
VERSION: 7.0.3
BUILD: 12458
MSSQL v2008
AC SCHEMA v2005

In my 2008 SQL Database i do have the Full Text Catalog and it is populated with something... (says 4389 Unique Key Count, 157 Item Count)
The check box is checked in the admin back end for full text search.

commercebuilder build patch 12912
Multiple Key Word Search Just Breaks.... get errors as follows
Exception of type 'System.Web.HttpUnhandledException' was thrown.; Object reference not set to an instance of an object.

commercebuilder build patch 12624
Multiple Key Word Search passes.. but results arent Full Text Searches... No Results are ever returned when you have more then one word.

I've compared my version vs a freinds and he had version 12624 commerce build patch... tried it and atleast i dont get errors.. is there something im missing.

[Logan Rhodehamel]

commercebuilder build patch 12912
Multiple Key Word Search Just Breaks.... get errors as follows
Exception of type 'System.Web.HttpUnhandledException' was thrown.; Object reference not set to an instance of an object.

Build 12912 of the CommerceBuilder assembly was created to deal with multiple keyword searches. I'd have to know more about the error you received when you tried to apply the patch. For instance did it appear when you tried to visit a particular page? Was it only when you tried to search? And if it's only when you try to search, there could be some debug information collected to determine why.

[Mike718NY]

I think the problem with mine is that the search words are not getting into the Search page.

The " RESULTS FOR : " label is blank. It just returns all the products.

I put a Break point in ConLib\SimpleSearch.ascx

This gets hit:
protected void Page_Init()
{

But this never gets hit, even when I click the Search button:

protected void SearchButton_Click(object sender, EventArgs e)
{
string safeSearchPhrase = StringHelper.StripHtml(SearchPhrase.Text);
if (!string.IsNullOrEmpty(safeSearchPhrase))
Response.Redirect("~/Search.aspx?k=" + Server.UrlEncode(safeSearchPhrase));

So Search.aspx?k= is never getting the search terms into the Search page.

[jmestep]

When it was disabled, were we able to detect it successfully from the configuration screen though? If not, it might indicate some other way we should be checking for FTS capability.

I can't remember that far back (it was yesterday!) and I was working on several sites with FTS. I just checked another site on a HyperV at Drundo and the admin wasn't showing the check box for FTS. I have not asked Drundo to enable FTS on that site.

[AlexG]

The same problem:
I turn off it in AC on admin side and maid it manually in SQL
It's work for me.

[Logan Rhodehamel]

So Search.aspx?k= is never getting the search terms into the Search page.

Can you attach your SimpleSearch.aspx.cs file to this thread?

[Mike718NY]

Forget that last issue, I'm an idiot, . . "k= " is showing up in the URL :
localhost/DCPAC7/Search.aspx?k=printer, . . but the breakpoint wasn't going to that event.

I found another interesting clue. If I change the "_Keywords" in SearchPage.ascx.cs:

ProductList.DataSource = ProductDataSource.NarrowSearch(_Keywords, this.CategoryId, _ManufacturerId, ...
TO:
ProductList.DataSource = ProductDataSource.NarrowSearch(Request.QueryString["k"].ToString(), this.CategoryId, _ManufacturerId, ...

the Search works (but the paging and total count don't). So the database end is ok.

I also noticed this. In the Page_Load for SearchPage.aspx, the function RefreshCriteria()
calls a function FindSearchSidebarControl:
private void RefreshCriteria()
{
_SearchSidebar = (ISearchSidebar)PageHelper.FindSearchSidebarControl(this.Page);
............

public static Control FindSearchSidebarControl(Control parent)
{
Control match = null;
foreach (Control childControl in parent.Controls)
{
if (childControl is ISearchSidebar)
................

This function must have looped at least 150 times.
Is the problem related to the Sidebar?
I'm not using any Search features on my Sidebar, so can I just comment the RefreshCriteria() out?

[Logan Rhodehamel]

This function must have looped at least 150 times.
Is the problem related to the Sidebar?
I'm not using any Search features on my Sidebar, so can I just comment the RefreshCriteria() out?

It looped all the controls in the page collection to look for a search sidebar. If you comment this out, double check the product finder / advanced search page for functionality.

[Mike718NY]

The main problem I see is that "_Keywords" comes up an empty string:

ProductList.DataSource = ProductDataSource.NarrowSearch(_Keywords, ........

I noticed "_Keywords = _SearchSidebar.Keyword;" in RefreshCriteria() and figured that was the problem.

I added "_Keywords = Request.QueryString["k"];" in page load and it works now:

protected void Page_Load(object sender, System.EventArgs e)
{
...............
_Keywords = Request.QueryString["k"]; // added

//RefreshCriteria(); // took out
SetPagerIndex(); // this function was in RefreshCriteria(). Do I still need it?
BindSearchResultsPanel();
}

Even though it is working good, is this change ok?