Gossamer Forum: Products: Gossamer Links: Discussions: Strange search results / problems: Page 2

Mar 21, 2013, 2:59 AM

Andy

Veteran / Moderator (18436 posts)

Mar 21, 2013, 2:59 AM

Post #26 of 46

Shortcut

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

Mar 25, 2013, 2:52 AM

katakombe

User (208 posts)

Mar 25, 2013, 2:52 AM

Post #27 of 46

Shortcut

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

Mar 25, 2013, 3:21 AM

Andy

Veteran / Moderator (18436 posts)

Mar 25, 2013, 3:21 AM

Post #28 of 46

Shortcut

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

Mar 25, 2013, 3:28 AM

katakombe

User (208 posts)

Mar 25, 2013, 3:28 AM

Post #29 of 46

Shortcut

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//

Mar 25, 2013, 1:01 PM

brewt

Staff (4101 posts)

Mar 25, 2013, 1:01 PM

Post #30 of 46

Shortcut

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

Mar 25, 2013, 11:50 PM

katakombe

User (208 posts)

Mar 25, 2013, 11:50 PM

Post #31 of 46

Shortcut

Re: [brewt] Strange search results / problems In reply to

Hello Adrian, no problem!

Do you need access to my server?

Thanks.

Apr 1, 2013, 12:27 AM

katakombe

User (208 posts)

Apr 1, 2013, 12:27 AM

Post #32 of 46

Shortcut

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.

Apr 2, 2013, 6:54 AM

katakombe

User (208 posts)

Apr 2, 2013, 6:54 AM

Post #33 of 46

Shortcut

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 ...

Apr 2, 2013, 6:59 AM

Andy

Veteran / Moderator (18436 posts)

Apr 2, 2013, 6:59 AM

Post #34 of 46

Shortcut

Re: [katakombe] Strange search results / problems In reply to

Hi,

It appears to be, yes.

Cheers

Andy (mod)
andy@ultranerds.co.uk

Apr 2, 2013, 7:20 AM

katakombe

User (208 posts)

Apr 2, 2013, 7:20 AM

Post #35 of 46

Shortcut

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,

Apr 2, 2013, 3:01 PM

brewt

Staff (4101 posts)

Apr 2, 2013, 3:01 PM

Post #36 of 46

Shortcut

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

Apr 12, 2013, 9:14 AM

katakombe

User (208 posts)

Apr 12, 2013, 9:14 AM

Post #37 of 46

Shortcut

Re: [brewt] Strange search results / problems In reply to

Hello!

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

Kind regards

Apr 23, 2013, 1:47 PM

brewt

Staff (4101 posts)

Apr 23, 2013, 1:47 PM

Post #38 of 46

Shortcut

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

Apr 24, 2013, 7:02 AM

katakombe

User (208 posts)

Apr 24, 2013, 7:02 AM

Post #39 of 46

Shortcut

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.

Apr 24, 2013, 7:45 AM

katakombe

User (208 posts)

Apr 24, 2013, 7:45 AM

Post #40 of 46

Shortcut

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

Whistle

Jul 29, 2013, 6:38 AM

katakombe

User (208 posts)

Jul 29, 2013, 6:38 AM

Post #41 of 46

Shortcut

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.

Jul 30, 2013, 5:33 PM

brewt

Staff (4101 posts)

Jul 30, 2013, 5:33 PM

Post #42 of 46

Shortcut

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

Aug 1, 2013, 11:12 PM

katakombe

User (208 posts)

Aug 1, 2013, 11:12 PM

Post #43 of 46

Shortcut

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!

Aug 2, 2013, 2:41 PM

brewt

Staff (4101 posts)

Aug 2, 2013, 2:41 PM

Post #44 of 46

Shortcut

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

Aug 8, 2013, 12:56 AM

katakombe

User (208 posts)

Aug 8, 2013, 12:56 AM

Post #45 of 46

Shortcut

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.

Aug 28, 2013, 7:55 AM

katakombe

User (208 posts)

Aug 28, 2013, 7:55 AM

Post #46 of 46

Shortcut

Re: [brewt] Strange search results / problems In reply to

Hello!

Is there any progress with this issue after 20 days?

Thanks

Strange search results / problems

(Page 2 of 2)

Last edited by:

Last edited by: