Gossamer Forum
Home : Products : Gossamer Links : Discussions :

BUG: search substring

Quote Reply
BUG: search substring
I've just discovered on version 3.04 that it doesn't matter whether or not I have search substring set that GLinksSQL always searches for substrings.

http://mastersonsantafe.com/cgi-bin/jewelman/search.cgi?query=ring&bool=and&mh=25&substring=0
http://mastersonsantafe.com/cgi-bin/jewelman/search.cgi?query=ring&bool=and&mh=25&substring=1

Here's part of the stack query dump to prove what I'm talking about. It's the same for substring=0 and substring=1
my database is nonindexed.


SELECT ID FROM Links WHERE (((( Title LIKE '%ring%' OR Description LIKE '%ring%'))) AND (isValidated = 'Yes'))
thank you for posting a fix for this.

peace.
Quote Reply
Re: [klangan] BUG: search substring In reply to
Hi,

As fare as I know, the substring take affected when your keyword has more than one word.

Cheers,

Cheers,

Dat

Programming and creating plugins and templates
Blog
Quote Reply
Re: [klangan] BUG: search substring In reply to
Hi, I don't think this is a version 3 bug - I don't think that substring has ever worked on non-indexed tables.
Quote Reply
Re: [klangan] BUG: search substring In reply to
Hi,

aflnr is right. Substring support is not available when using NONINDEXED mode. See page 9 of the manual (or the screenshot below) for features depending on the search method used:



Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] BUG: search substring In reply to
Is there a fix for the internal search for the left substring?
Quote Reply
Re: [Robert] BUG: search substring In reply to
Hi,

No, it wouldn't be possible to use left substring and internal search mode (as the internal search splits things into words and uses mysql indexes on the words). If you want left substring searching (which most search engines don't support anyways), you should use non-indexed mode.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] BUG: search substring In reply to
So no method offers everything?
Ok. Bad news. ;-(

I just play around with the search; search in cat is ok; search for something* too,
but when i try +pets - dolls i got the same than "pets dolls" with bool=or;
For my opinion it should search for = 'pets' and !=dolls

?
Quote Reply
Re: [Alex] BUG: search substring In reply to
Can i change the score with a global value?
Looking for pets offers 1,19,7, but i want the links with a picture first;
so i should add to score a value in a field "searchvalue" for example; now i dont know if this field is counted while there isnīt the word pets inside.
Quote Reply
Re: [Robert] BUG: search substring In reply to
I'm not quite sure I understand what you are looking for. Few search engines do left-substring matching (i.e. if you search for 'car' in google, you don't get results for 'scar'). The reason it works in non-indexed mode is that you are just looking for any occurence of the word 'car' in the title/description. This is also useful in language which don't use space as a word seperator.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] BUG: search substring In reply to
Quote:
(i.e. if you search for 'car' in google, you don't get results for 'scar').
Note that however Google does (left & right) substring match in the URL...

Best regards,
Webmaster33


Paid Support
from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
Quote Reply
Re: [webmaster33] BUG: search substring In reply to
In Reply To:
Quote:
(i.e. if you search for 'car' in google, you don't get results for 'scar').

Note that however Google does (left & right) substring match in the URL...

So does Gossamer Links:

http://www.gossamer-threads.com/...=picture&URL=ino

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Robert] BUG: search substring In reply to
In Reply To:
Can i change the score with a global value?
Looking for pets offers 1,19,7, but i want the links with a picture first;
so i should add to score a value in a field "searchvalue" for example; now i dont know if this field is counted while there isnīt the word pets inside.

If you wanted to change the scores, it would require a plugin to override the default search. However, you could just sort by the picture field instead of sorting by relevance.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] BUG: search substring In reply to
 
The: URL=eto
http://www.gossamer-threads.com/...i?query=&URL=eto
lists http://www.princeton.edu/~artarch/
and returns 543 links.
This is fine.

But the: query=eto&URL=eto
http://www.gossamer-threads.com/...uery=eto&URL=eto
but returns 0 links.

Also: query=eto
http://www.gossamer-threads.com/...search.cgi?query=eto
returns 0 links.


Couldn't be possible to join both the results of query and URL, so
http://www.gossamer-threads.com/...search.cgi?query=eto
should query should also return URL=eto results, too?
At least optionally.

Best regards,
Webmaster33


Paid Support
from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...