an ASP.NET Open Source CMS & eCommerce platform
Search:
Skip Navigation LinksHome > DotShoppingCart Forums > Support > Using DotShoppingCart > Search Problem and bug - It fails when searchin...
Search Problem and bug - It fails when searching phrases containing one numeric character
Last Post 8/23/2010 12:37:35 PM By Bahram. 25 replies.
Page 1 of 3 (26 posts) << First < Prev 1 2 3 Next > Last >> 
8/17/2010 9:46:21 AM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Search Problem and bug - It fails when searching phrases containing one numeric character
 It seems V4 has some search problems as V3, When I search for :
smartreader 32 KB it has result set
but when using
smartreader 7 it fails.
 
Seems that it can not handle one character searchs
 
smartreader plus 10 works
smartreader plus 4 fails
 
you can test at : http:\\store.acrsystems.com
8/17/2010 12:14:53 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Search Problem and bug - It fails when searching phrases containing one numeric character
It's possible that they are considered noise words. You can configure noise word yourself. Please take a look at this.
DotShoppingCart Staff
8/17/2010 12:33:25 PM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Re: Search Problem and bug - It fails when searching phrases containing one numeric character
 It is a bug as it was in V3.1 since it shows Default.aspx page contents, I do not know and think about noise word.
 
putting the phrase in quote also does not works, I do not have any setting or set any Stoplist for full text since SQL 2008 handles full test internally.
 
Also you did not paid attention to my post : 
 
Search result for smartreader 7 produce error in result while smartreader 10 won't
if smartreader is in noise list, niether of them should work.
 
 
8/17/2010 1:37:56 PM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Re: Search Problem and bug - It fails when searching phrases containing one numeric character
I also tested on another DSC shop : http://www.sd9000.com
 
search for Marquee and
 
marquee 6 (no result)
8/17/2010 2:22:44 PM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Re: Search Problem and bug - It fails when searching phrases containing one numeric character
 I checked and there is no stop or noise list.
8/17/2010 4:14:42 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Search Problem and bug - It fails when searching phrases containing one numeric character
If you don't have stoplist and stop words defined for your database, SQL server will use the system default list. Run this query and you will see 0 to 9 are included in the list.
 
select * from sys.fulltext_system_stopwords where language_id = 1033
 
What you can do is to create a customized stoplist with empty stopwords and set the dotshoppingcart database to use that empty stoplist. Then 0 to 9 will not be ignored anymore.
DotShoppingCart Staff
8/17/2010 4:43:25 PM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Re: Search Problem and bug - It fails when searching phrases containing one numeric character
What if I remove 0-9 values or edit them in the table?
8/17/2010 5:04:35 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Search Problem and bug - It fails when searching phrases containing one numeric character
That will work as well. You should notice that If you change to the system stopwords, it will affect all the databases on the server.
DotShoppingCart Staff
8/18/2010 9:35:30 AM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Re: Search Problem and bug - It fails when searching phrases containing one numeric character
There is two questions :
 
1- Why DCS code can not return no result and returns dump code of HTML blocks, How can I get the error code and display the message
 
2- 
What is the alternate way? since there is reason of the initial stopwords, if I enclose my phrase in qoutes : then the search works but interprets each token separately i.e.
"smartreader 7" does not returns all entries of the phrase "smartreader 7" but anything that has smartreader and 7 
8/18/2010 9:41:50 AM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Re: Search Problem and bug - It fails when searching phrases containing one numeric character
continies
Also when i use quotes in my search phrase the Default.aspx and Page/AboutUs.aspx apear in the end. The Default page contains an HTML code with some texts like the search phrase, it should not appear or need to br filtered.
 
Thanks,
8/18/2010 10:05:49 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Search Problem and bug - It fails when searching phrases containing one numeric character
When you do search DSC does two parts. Search in products and search in html text. If you don't want it to display html search result. Please change web\controls\core\search.ascx to remove the html search content.
 
Internally DSC is using SQL fulltext search. You can read SQL fulltext search whitepaper on how it works. Basically it uses the word break to seperate the search phrases into individual words and then runs through the fulltext index.  
DotShoppingCart Staff
Page 1 of 3 (26 posts) << First < Prev 1 2 3 Next > Last >> 
Project hosted at CodePlex.com
Copyright © 2013 DotShoppingCart. All rights reserved.