Search not working

Reply

Wyatt Preul replied on Thu, Apr 5 2007 2:50 PM

rated by 0 users

I will look further into your issue and let you know.

Thanks,

Reply

Mark Monica replied on Thu, Apr 5 2007 3:16 PM

rated by 0 users

Wyatt,

Just tossing an idea out there.  When I installed Beta 1, I started off with SQL 2005 SP1.  Before installing your Beta 2 I installed SQL 2005 SP2.  Then a few days later I installed Beta 2. 

Is your test data store SQL 2005 SP2?

Thanks,

Mark

Reply

Wyatt Preul replied on Thu, Apr 5 2007 3:46 PM

rated by 0 users

I am running SP1, I will upgrade to SP2 and let you know if there are any changes.

Thanks,

Reply

worldview replied on Fri, Apr 6 2007 11:38 AM

rated by 0 users

I am having the exact same problem.

Clean install of CS beta 2 MSI with SQL-Express --> Search not working.

Tried running this query --> Search still not working
Truncate table dbo.cs_SearchIgnoreWords
Truncate table dbo.cs_SearchBarrel
Update dbo.cs_Posts set isIndexed = 0

Reply

Wyatt Preul replied on Mon, Apr 9 2007 9:33 AM

rated by 0 users

I have a question for everyone with this problem... Are you using the MSI installer?  If not, what installer are you using?

Also, are you all running the SP2 for SQL Server 2005 ?

Thanks,

Reply

heilmanj replied on Mon, Apr 9 2007 10:31 AM

rated by 0 users

Unfortunately I don't maintain the server it is installed on so I don't know if it is running SP2 (We are running SQL Server 2005 and I would imagine that IT has installed this update).  CS 2007 Beta 1 was installed using the MSI installer, whoever we upgraded to Beta 2 using the web install.

Again, thank you Wyatt for looking in to this.

Julius

[edit] I just ran a search on this site using the word "mixed" (found in mmonica's post form 04/02/07 on this thread).  When searching the entire site it comes up with 107 items (none of them this thread) and when I searched this forum no results were returned.  On my site search barrel returnes enough posts for someone new to the site to look through, however I can definatly notice posts that are not comming up when searched for.

Reply

Mark Monica replied on Mon, Apr 9 2007 11:05 AM

rated by 0 users

Wyatt,

I am using the MSI installer and SQL 2005 SP2.

Mark

Reply

Edoardo replied on Mon, Apr 9 2007 11:08 AM

rated by 0 users

I'm hitting the issue running SQL 2005 SP2 with a scratch install of Beta 2 using the web installer.

Reply

Mark Monica replied on Mon, Apr 9 2007 11:10 AM

rated by 0 users

Julius,

You should be able to run the following query against your database to determine the version. 

SELECT 'SQL Server ' 
+ CAST(SERVERPROPERTY('productversion') AS VARCHAR) + ' - ' 
+ CAST(SERVERPROPERTY('productlevel') AS VARCHAR) + ' (' 
+ CAST(SERVERPROPERTY('edition') AS VARCHAR) + ')'

 Mark

heilmanj:

Unfortunately I don't maintain the server it is installed on so I don't know if it is running SP2 (We are running SQL Server 2005 and I would imagine that IT has installed this update).  CS 2007 Beta 1 was installed using the MSI installer, whoever we upgraded to Beta 2 using the web install.

Again, thank you Wyatt for looking in to this.

Julius

[edit] I just ran a search on this site using the word "mixed" (found in mmonica's post form 04/02/07 on this thread).  When searching the entire site it comes up with 107 items (none of them this thread) and when I searched this forum no results were returned.  On my site search barrel returnes enough posts for someone new to the site to look through, however I can definatly notice posts that are not comming up when searched for.

Reply

Wyatt Preul replied on Tue, Apr 10 2007 10:14 AM

rated by 0 users

I just tested out a database that I received that was reported to have indexing issues.  Whenever I restored it and added a couple of test posts from Community Server 2007 Beta 2 the posts were indexed correctly.

It raised a couple of ideas, firstly, is anyone who is reporting the indexing issues also running custom modules or is this indeed a clean install?  Secondly, are you absolutely positive that posts are not getting indexed.  Perhaps you can try running the following query, then make a post and after the indexing job has run on it, rerun the query to see if the number has increased.  This query indicates how many search words are available.

SELECT count([Word]) FROM [cs_SearchBarrel]

One thing that you can try is to hit your database from a fresh install of 2007 Beta 2.  I would try downloading the web installer and unpacking it.  Then simply change the connection string to connect to the database that you are experiencing these issues with.  Make a couple of posts and see if they get indexed.  Make sure to remove the connection string from your test web install shortly after you perform this test though so that things don't get messy.  Or you could backup your existing database and restore it to a new server, such as your development box, then connect to this development server from a fresh unpackage of the web installer.

Let me know your thoughts.

Thanks,

Reply

heilmanj replied on Tue, Apr 10 2007 12:43 PM

rated by 0 users

I don't think that my issue is a matter of the post's not being indexed, but how thoroughly they are being indexed.  When I search for 'Wyatt AND sectionid:254' on this site I receive 31 items the first being:

Re: Reproduced: Search not working properly on CS.org

Does this mean that there was a Beta 2 bug then ifthe "indexing" had to be updated? quote user='Wyatt Preul' Yes we recently fixed the indexing on this site. It will take a little while for the post to become indexed because the indexing service has to catch up. Thanks,

Reply

Mark Monica replied on Tue, Apr 10 2007 2:36 PM

rated by 0 users

Wyatt,

1. I agree with heilmanj that the indexing service appears to be running and even sometimes indexing words (not many in my case and mostly on older posts).  What it is not doing is indexing all the words even on this site.  As an additional note I'm not sure that I have been clear but I am performing my searches against blogs, not forums.
2. If I run the select statement you gave it does not return the words that can not be found with search.  Just as heilmanj said, searching for your name does not give results for your previous post in this thread, but does from his post.  It seems to be very inconsistent what words the search barrel is indexing.
3. If you search this forum for cs_SearchBarrel you will get a three hits for this thread but not the other four messages in this thread that has the cs_SearchBarrel text in it.

Mark

Reply

Wyatt Preul replied on Tue, Apr 10 2007 5:17 PM

rated by 0 users

mmonica:

What it is not doing is indexing all the words even on this site

Thank you for finding and pointing this out.  I have investigated this and the display name inside of a quote block that is more than one word appears to not have all of the words indexed with enterprise search.  This issue has been reported and will be resolved.  However, you should be happy to know that this is not an issue with the Search Barrel, which is what you are running.  Therefore, if you try this locally with a display name of 'Wyatt Preul' both 'Wyatt' and 'Preul' are searchable.

mmonica:

It seems to be very inconsistent what words the search barrel is indexing

If a word is greater than or equal to 3 characters long it will be indexed.  Is there an example that you can provide specific to the Search Barrel that demonstrates this inconsistenty?

Reply

Mark Monica replied on Tue, Apr 10 2007 5:59 PM

rated by 0 users

First off all my searches I'm doing locally that are bombing are to blogs.

Wyatt Preul:

If a word is greater than or equal to 3 characters long it will be indexed.  Is there an example that you can provide specific to the Search Barrel that demonstrates this inconsistenty?

Secondly here are a few things to try as you suggest above.

1. cs_SearchBarrel should be found 7 times (posts) in this thread.  Only four search results show.
2. I have a post in this thread at 2:36 that has the word "four" in it that does not show when searched, yet the word "inconsistent" in the same post does show in searches.  In the same post "three" does not get indexed.
3. The word "mixed" originally appeard in this thread in my 04-03-2007 2:24 AM post and does not show up (maybe because it is in quotes?) when searched.  The text also appears in my 04-09-2007 11:10 AM post and heilmanj's 04-09-2007 10:31 AM  post (also quoted). Further review of this is that mixed* does find it.  Shouldn't words be wildcarded by default (If I search for Live I get LiveWriter)?

I could probably search for more words but I need to go home.  Maybe I'll try more research there.

I've also tried a couple of your other suggestions with only more frustration.

Tried web installer to same DB.  No luck.  Same search problems

Tried clean install locally with data to new db on same SQL Server as problemed install.  Even more search woes.  It did not appear to index properly so I removed all the terms from the search barrel so it could rebuild, it never repopulated this time!  Does the job operate needing some permissions that I might be missing?  There are no errors in jobs and it shows success.  The frustration grows...

Mark

Reply

Wyatt Preul replied on Wed, Apr 11 2007 10:35 AM

rated by 0 users

You covered a lot of information in this post, let me see if I can break it down and answer most of your questions individually.

mmonica:

...I removed all the terms from the search barrel so it could rebuild...

This would mean that search barrel was indexing search terms.  If the cs_SearchBarrel table is getting populated then you are getting items that you can search on.  Also, clearing this table alone will not force the site to reindex your posts.  You will need to set your cs_Posts IsIndexed column to all '0' this informs Community Server that there are posts need to be indexed.

mmonica:

Shouldn't words be wildcarded by default

On Google I tried your search for live and even Google does not assume that you are wildcarding the word.  If you would like to include wildcard results simply add an * so search for live*.  In the book Professional Community Server there is a good discussion on the possible ways to perform a search.  My point is that it is not assumed that you are wanting to find livewriter by searching for live.  If you want livewriter you can search for live* or livewriter.

mmonica:

Tried web installer to same DB.  No luck.  Same search problems

What again are the search problems?  Does search not work at all or is it for certain words that it doesn't work?  If you want to backup your db I can take a look at it and see if we can help resolve your searching woes.

mmonica:

cs_SearchBarrel should be found 7 times

I will investigate this further and fine why there is a post that was not included in the search results.  Thanks for finding this.

Please let me know if you have any questions.

Wyatt