Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Strange search results / problems

(Page 2 of 2)
> >
Quote Reply
Re: [katakombe] Strange search results / problems In reply to
Hi,

I haven't heard anything yet. I pointed them in the direction of this post, so hopefully they will just reply here Smile

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Strange search results / problems In reply to
Hello everyone!

I would not want to be boring, but from my perspective, this is a big problem for me because the site is live and searches give inaccurate search results to users.

Is there any chance that someone from GT can explain the reasons for these problems?

Once again, many thanks in advance.

Last edited by:

katakombe: Mar 25, 2013, 2:53 AM
Quote Reply
Re: [katakombe] Strange search results / problems In reply to
Hi,

It may be worth emailing them to see if they've had a chance to look at it (just to give a nudge Whistle)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Strange search results / problems In reply to
Hi again Andy!

I've already thought about it, but I'll wait one more day to see if anyone from GT send a reply to this topic here ...

BR//
Quote Reply
Re: [katakombe] Strange search results / problems In reply to
Sorry, I'm been really busy with a project at the moment and haven't had a chance to look into this one.

Adrian
Quote Reply
Re: [brewt] Strange search results / problems In reply to
Hello Adrian, no problem!

Do you need access to my server?

Thanks.
Quote Reply
Re: [brewt] Strange search results / problems In reply to
Hi everyone!

As I already said, I would not want to be boring, but to me this is very important.

What should I do - is this my fault or problem lies in something else?

Once again, thanks.
Quote Reply
Re: [katakombe] Strange search results / problems In reply to
Is this the same problem:

http://www.gossamer-threads.com/...th_checkbox_P199182/

and

http://www.gossamer-threads.com/..._checkboxes_P263919/

?

I'm totally confused ...
Quote Reply
Re: [katakombe] Strange search results / problems In reply to
Hi,

It appears to be, yes.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Strange search results / problems In reply to
Hello again Andy!

I'm not at all happy that the problem exists, but I'm glad that I'm not alone Crazy

If that is the case, GT should solve this somehow ..

Regards,
Quote Reply
Re: [katakombe] Strange search results / problems In reply to
Sorry, still trying to get this project out, so I'll be busy for a few more days.

Adrian
Quote Reply
Re: [brewt] Strange search results / problems In reply to
Hello!

It's been 10 days - is there anything new?

Kind regards
Quote Reply
Re: [katakombe] Strange search results / problems In reply to
Sorry about the delay. Try this patch:

Code:
Index: Base.pm
===================================================================
RCS file: GT/SQL/Base.pm,v
retrieving revision 1.72
diff -u -r1.72 Base.pm
--- Base.pm 13 May 2011 23:56:51 -0000 1.72
+++ Base.pm 23 Apr 2013 20:46:11 -0000
@@ -15,6 +15,7 @@
# ===============================================================
use GT::Base;
use GT::AutoLoader;
+use GT::SQL::Display::HTML;
use strict;
use vars qw($ERRORS $DEBUG @ISA $VERSION $ERROR_MESSAGE);
@ISA = qw/GT::Base/;
@@ -529,7 +530,12 @@
push @$add, $_;
}
if ( @$add ) {
- push @ins, [$field, 'IN', $add];
+ if ( $c->{$field}->{form_type} eq 'CHECKBOX' ) {
+ push @ins, [$field, 'LIKE', $s . join($GT::SQL::Display::HTML::INPUT_SEPARATOR . $s, sort @$add) . $e];
+ }
+ else {
+ push @ins, [$field, 'IN', $add];
+ }
}
}
elsif ($opts->{$field} =~ /^(>=?|<=?|!)(.*)/) {

Adrian

Last edited by:

brewt: Apr 23, 2013, 1:47 PM
Quote Reply
Re: [brewt] Strange search results / problems In reply to
Sorry:

Quote:
Unable to load GT::Base::in_eval: Compilation error at /mywebsite/public_html/cgi-bin/admin/GT/AutoLoader.pm line 129.
Compilation failed in require at /mywebsite/public_html/cgi-bin/admin/GT/SQL.pm line 19.
BEGIN failed--compilation aborted at /mywebsite/public_html/cgi-bin/admin/GT/SQL.pm line 19.
Compilation failed in require at /mywebsite/public_html/cgi-bin/admin/GT/Delay.pm line 50.

Frown
Quote Reply
Re: [brewt] Strange search results / problems In reply to
Please accept my apologies - my mistake:

It's not:

Quote:
+use GT::SQL::Display::HTML;

it's:

Quote:
use GT::SQL::Display::HTML;

(without "+")

I made a short test and it seems that everything is OK

WhistleCool
Quote Reply
Re: [brewt] Strange search results / problems In reply to
I'm sorry, but this nightmare is not over ...

Both in admin and on the user side I get incorrect results when I'm looking for only one variable:

For example, I'm looking in "Additional_Data" field for Elevator (6) and I get 253 results out of 350 possible which is not true ...

Something is definitely wrong and I humbly ask that GT team closely check what's the problem here.

Many thanks in advance.
Quote Reply
Re: [katakombe] Strange search results / problems In reply to
If the field is a number, that search isn't going to be a good one since the search is a LIKE search.

Adrian
Quote Reply
Re: [katakombe] Strange search results / problems In reply to
The final solution:

For all those who have, or will have the same problems as me, I would like to make a modest contribution and describe the solution:

If you use:

Code:
Column Type: CHAR
Column Index: None
Form Type: CHECKBOX or MULTI-SELECT

and for all links:

Code:
Indexing Scheme: INTERNAL

then for:

Code:
Form Names

you can use a maximum of 10 unique values as numbers (0,1,2,3,4,5,6,7,8,9)

If you need more than 10 values (up to a maximum of 26), you can use the alphabet (A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z) as I did.

(For a maximum of 36 combinations you can use both letters and numbers)

For "Search Weight" field you must assign a value of at least 1 and you have to do "Rebuild Search".

Your entire database will not work properly unless you install Adrian's patch:

http://www.gossamer-threads.com/...ems_P314942/#p314942

So much of me. I sincerely hope that everyone will benefit from this. Good luck!
Quote Reply
Re: [katakombe] Strange search results / problems In reply to
Or you can go 2 characters and not use any single character values (eg. 10, 11, or aa, ab, ac, etc).

Adrian
Quote Reply
Re: [brewt] Strange search results / problems In reply to
Hi,

It seems there is still a problem. An example listing has checkboxes B I and O selected. Thats all fine.

The SQL query being run at its simplest, is:


Code:
GT::SQL::Driver::MYSQL::sth (15093): Executing query: SELECT * FROM glinks_Links WHERE (ExpiryDate >= 1375945671 AND isValidated = 'Yes' AND Additional_Data LIKE '%B
%I
%O%') LIMIT 0, 10

...but the DB, its stored as:

A
K
L
M
N
O
Q
R
B
E
G
H
I

...and because they don't match that order, it can't find them. It seems like for some reason GT::SQL isn't saving the checkbox info in the correct order.
Quote Reply
Re: [brewt] Strange search results / problems In reply to
Hello!

Is there any progress with this issue after 20 days?

Thanks
> >