Searching Error

Posted By UKcentric Wed 11 Jul 2012
Add to Favorites1
Author Message
UKcentric
 Posted Wed 11 Jul 2012
Supreme Being

Supreme Being - (29,775 reputation)Supreme Being - (29,775 reputation)Supreme Being - (29,775 reputation)Supreme Being - (29,775 reputation)Supreme Being - (29,775 reputation)Supreme Being - (29,775 reputation)Supreme Being - (29,775 reputation)Supreme Being - (29,775 reputation)Supreme Being - (29,775 reputation)

Group: Forum Members
Last Active: Mon 13 Apr 2015
Posts: 43, Visits: 2,159
On our art supplies site we have lots of products with the word "watercolour" in the title and description.

Doing a normal keyword search returns 0 products but it should return about 100.

To get all these products you have to do an advanced search using the "one or more words" or "exact wording or phrase".

On advanced search using "all words" it returns 0.

I'm guessing this is a problem with the default search but what can we do to resolve it?
Neil
 Posted Fri 13 Jul 2012
Supreme Being

Supreme Being - (126,937 reputation)Supreme Being - (126,937 reputation)Supreme Being - (126,937 reputation)Supreme Being - (126,937 reputation)Supreme Being - (126,937 reputation)Supreme Being - (126,937 reputation)Supreme Being - (126,937 reputation)Supreme Being - (126,937 reputation)Supreme Being - (126,937 reputation)

Group: Forum Members
Last Active: Sat 3 Nov 2018
Posts: 192, Visits: 5,220
Pretty sure the max search string is 10 characters - we see the same thing on our site. Would also be interested if this could be increased.
UKcentric
 Posted Tue 17 Jul 2012
Supreme Being

Supreme Being - (29,775 reputation)Supreme Being - (29,775 reputation)Supreme Being - (29,775 reputation)Supreme Being - (29,775 reputation)Supreme Being - (29,775 reputation)Supreme Being - (29,775 reputation)Supreme Being - (29,775 reputation)Supreme Being - (29,775 reputation)Supreme Being - (29,775 reputation)

Group: Forum Members
Last Active: Mon 13 Apr 2015
Posts: 43, Visits: 2,159
Having looked at the code, I see the max length of a search query is 40 characters not 10.

The problem is that the default search option for a basic search is "all words" which for some reason contains a bug that fails to bring back important search results.

So I am now going to attempt to force the default search to be "one or more words" and I hope that will solve the problem.
Neil
 Posted Thu 26 Jul 2012
Supreme Being

Supreme Being - (126,937 reputation)Supreme Being - (126,937 reputation)Supreme Being - (126,937 reputation)Supreme Being - (126,937 reputation)Supreme Being - (126,937 reputation)Supreme Being - (126,937 reputation)Supreme Being - (126,937 reputation)Supreme Being - (126,937 reputation)Supreme Being - (126,937 reputation)

Group: Forum Members
Last Active: Sat 3 Nov 2018
Posts: 192, Visits: 5,220
Yes I can see what you mean, did you get this working? Can you share the changes?
dwavell
 Posted Fri 2 Nov 2012
Supreme Being

Supreme Being - (4,603 reputation)Supreme Being - (4,603 reputation)Supreme Being - (4,603 reputation)Supreme Being - (4,603 reputation)Supreme Being - (4,603 reputation)Supreme Being - (4,603 reputation)Supreme Being - (4,603 reputation)Supreme Being - (4,603 reputation)Supreme Being - (4,603 reputation)

Group: Forum Members
Last Active: Thu 30 Apr 2015
Posts: 8, Visits: 17
Hi - did anyone solve this?

We're seeing something similar - except it doesn't match results for any of the search types.

The website is http://hurst-iw.co.uk - which has many thousands of products, but the exmaple I've been looking at is their "Nespresso" coffee range.  I can search "Nespresso" and they come up, but I'd also like users to be able to search "Nespre" or something, and looking at the stored procedure I'd expect the code to work. I can search "nes coffee" and will get all products mentioning coffee, but the "nes" is ignored.

Any ideas?

Cheers,

Dan
dwavell
 Posted Fri 2 Nov 2012
Supreme Being

Supreme Being - (4,603 reputation)Supreme Being - (4,603 reputation)Supreme Being - (4,603 reputation)Supreme Being - (4,603 reputation)Supreme Being - (4,603 reputation)Supreme Being - (4,603 reputation)Supreme Being - (4,603 reputation)Supreme Being - (4,603 reputation)Supreme Being - (4,603 reputation)

Group: Forum Members
Last Active: Thu 30 Apr 2015
Posts: 8, Visits: 17
Also, to add to this, the same problem exists on the Kartris demo site so don't think it's been fixed in the latest release and wouldn't seem to be a config issue.

Searches of this type from the backend work fine.
Neil
 Posted Fri 2 Nov 2012
Supreme Being

Supreme Being - (126,937 reputation)Supreme Being - (126,937 reputation)Supreme Being - (126,937 reputation)Supreme Being - (126,937 reputation)Supreme Being - (126,937 reputation)Supreme Being - (126,937 reputation)Supreme Being - (126,937 reputation)Supreme Being - (126,937 reputation)Supreme Being - (126,937 reputation)

Group: Forum Members
Last Active: Sat 3 Nov 2018
Posts: 192, Visits: 5,220
Pretty sure this is resolved now in 1.4004.
dwavell
 Posted Sun 4 Nov 2012
Supreme Being

Supreme Being - (4,603 reputation)Supreme Being - (4,603 reputation)Supreme Being - (4,603 reputation)Supreme Being - (4,603 reputation)Supreme Being - (4,603 reputation)Supreme Being - (4,603 reputation)Supreme Being - (4,603 reputation)Supreme Being - (4,603 reputation)Supreme Being - (4,603 reputation)

Group: Forum Members
Last Active: Thu 30 Apr 2015
Posts: 8, Visits: 17
Thanks for the info Neil - version upgrades are a complete pain in the behind tho as have modified my site beyond the use of the skin files.   Several things also changed in various user controls - and sadly I didn't keep very good documentation of what files I modified Crazy

Also - the demo site search has the same flaw - so unless they've not update their own demo it would seem it's not fixed.

I guess if the fix for this was only in the stored proc and / or in the way it's called, I could download the latest version, instal it seperately and just transfer the relevant bits?!

Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Back To Top