Bug #31029 for Sphinx-Search: Sphinx::Search

Wed Nov 28 06:45:35 2007 technik [...] auxion.de - Ticket created

CC:	<technik [...] auxion.de>
Subject:	Sphinx::Search
Date:	Wed, 28 Nov 2007 12:44:13 +0100
To:	<bug-sphinx-search [...] rt.cpan.org>
From:	"Technik via auxion.de" <technik [...] auxion.de>

Hi Jon; Im not sure if its a bug or bad doing by myself, but anyway I will send it to you J use Sphinx::Search; my $spx = Sphinx::Search->new(); $spx->SetMatchMode("SPH_MATCH_EXTENDED"); if($form{desc} eq 'yes') { $toTableQuery .= ' @idDesc ' . $toTableQuery; } $results = $spx->Query('@itTitle ' $toTableQuery); This is the code I use But there isnt any document returned. [Wed Nov 28 12:21:31 2007] 0.002 sec [all/0/rel 0 (0,50000)] [*] @itTitle +116 [Wed Nov 28 12:21:42 2007] 0.002 sec [all/0/rel 0 (0,50000)] [*] @itTitle +116 @idDesc +116 If I do this search without the limitation, how it is currently it gives me back this: [Wed Nov 28 12:30:23 2007] 0.007 sec [all/0/rel 2011 (0,50000)] [*] +116 I would apriciate if you have any hint for me. The problme is, that it does not returns any value if I do a extended search using Perl, But it returns the right if I do it directly www2@s-esl7:/www/sphinx/bin$ ./search -e @itTitle 116 Sphinx 0.9.8-dev (r871) Copyright (c) 2001-2007, Andrew Aksyonoff using config file '/www/sphinx//etc/sphinx.conf'... index 'shock1': query '@itTitle 116 ': returned 373 matches of 373 total in 0.000 sec displaying matches: 1. document=851890474, weight=1688, itseller=176388, itclose=Wed Dec 12 07:54:28 2007, itopen=Mon Nov 12 07:54:28 2007, itcategory=23570, itstart=5.950000, itauctiontyp=2 itTitle=TKKG 116. Klassenfahrt zur Hexenburg. CD - Stef... itOpen=1194850468 itImage=http://www.alphamusic.de/cover/n/790/2635790.jpg 2. document=852518369, weight=1688, itseller=176388, itclose=Thu Nov 29 07:08:07 2007, itopen=Mon Oct 29 07:08:07 2007, itcategory=23570, itstart=5.950000, itauctiontyp=2 itTitle=TKKG 116. Klassenfahrt zur Hexenburg. CD - Stef... itOpen=1193638087 itImage=http://www.alphamusic.de/cover/n/790/2635790.jpg . words: 1. '116': 1844 documents, 2223 hits index 'shock2': query '@itTitle 116 ': returned 28 matches of 28 total in 0.000 sec displaying matches: 1. document=855258952, weight=1698, itseller=167116, itclose=Sat Dec 1 12:21:16 2007, itopen=Wed Nov 28 12:21:16 2007, itcategory=6216, itstart=21.650000, itauctiontyp=0 itTitle=FL 1932 Nr 116-118 * 174B86 itOpen=1196248876 itImage=http://217.74.200.42/10067/17/4B/174B86/fl-116-118.JPG?PIC 2. document=855262897, weight=1698, itseller=167116, itclose=Sat Dec 1 12:27:33 2007, itopen=Wed Nov 28 12:27:33 2007, itcategory=6216, itstart=21.650000, itauctiontyp=0 itTitle=FL 1932 Nr 116-118 * 1928FA itOpen=1196249253 itImage=http://217.74.200.42/10067/19/28/1928FA/fl-116-118.JPG?PIC words: 1. '116': 138 documents, 179 hits Mit freundlichen Grüssen Thomas Goik -- Lofox GmbH Geschäftsführerin: Evelyn Fuchs Im Kamperholz 48 44805 Bochum - Germany Amtsgericht Bochum HRB 7042 USt-IdNr.: DE215698227 St.-Nr. Bochum 306/5885/0172

Wed Nov 28 07:22:01 2007 jon [...] jschutz.net - Correspondence added

Subject:	Re: [rt.cpan.org #31029] Sphinx::Search
Date:	Wed, 28 Nov 2007 22:51:15 +1030
To:	bug-Sphinx-Search [...] rt.cpan.org
From:	Jon Schutz <jon [...] jschutz.net>

Hi Thomas, You have quotes around SPH_MATCH_EXTENDED. Remove them and it will work fine. See the test case in t/search.t: # Extended on "bb ccc" $sphinx->SetMatchMode(SPH_MATCH_EXTENDED) ->SetLimits(0,20); $results = $sphinx->Query('@field1 bb @field2 ccc'); ok($results, "Results for 'bb ccc' EXTENDED"); print $sphinx->GetLastError unless $results; ok(@{$results->{matches}} == 2, "matches for 'bb ccc' EXTENDED"); Regards, -- Jon On Wed, 2007-11-28 at 06:45 -0500, Technik via auxion.de via RT wrote: Show quoted text

> Hi Jon; > > > > I’m not sure if it’s a bug or bad doing by myself, but anyway I will > send it to you J > > > > use Sphinx::Search; > > my $spx = Sphinx::Search->new(); > > $spx->SetMatchMode("SPH_MATCH_EXTENDED"); > > > > if($form{desc} eq 'yes') { > > $toTableQuery .= ' @idDesc ' . $toTableQuery; > > } > > $results = $spx->Query('@itTitle ' $toTableQuery); > > > > This is the code I use > > But there isn’t any document returned. > > > > [Wed Nov 28 12:21:31 2007] 0.002 sec [all/0/rel 0 (0,50000)] [*] > @itTitle +116 > > [Wed Nov 28 12:21:42 2007] 0.002 sec [all/0/rel 0 (0,50000)] [*] > @itTitle +116 @idDesc +116 > > > > If I do this search without the limitation, how it is currently it > gives me back this: > > [Wed Nov 28 12:30:23 2007] 0.007 sec [all/0/rel 2011 (0,50000)] [*] > +116 > > > > I would apriciate if you have any hint for me. > > > > The problme is, that it does not returns any value if I do a extended > search using Perl, > > But it returns the right if I do it directly > > > > > > www2@s-esl7:/www/sphinx/bin$ ./search -e @itTitle 116 > > Sphinx 0.9.8-dev (r871) > > Copyright (c) 2001-2007, Andrew Aksyonoff > > > > using config file '/www/sphinx//etc/sphinx.conf'... > > index 'shock1': query '@itTitle 116 ': returned 373 matches of 373 > total in 0.000 sec > > > > displaying matches: > > 1. document=851890474, weight=1688, itseller=176388, itclose=Wed Dec > 12 07:54:28 2007, itopen=Mon Nov 12 07:54:28 2007, itcategory=23570, > itstart=5.950000, itauctiontyp=2 > > itTitle=TKKG 116. Klassenfahrt zur Hexenburg. CD - Stef... > > itOpen=1194850468 > > itImage=http://www.alphamusic.de/cover/n/790/2635790.jpg > > 2. document=852518369, weight=1688, itseller=176388, itclose=Thu Nov > 29 07:08:07 2007, itopen=Mon Oct 29 07:08:07 2007, itcategory=23570, > itstart=5.950000, itauctiontyp=2 > > itTitle=TKKG 116. Klassenfahrt zur Hexenburg. CD - Stef... > > itOpen=1193638087 > > itImage=http://www.alphamusic.de/cover/n/790/2635790.jpg > > …. > > > > words: > > 1. '116': 1844 documents, 2223 hits > > > > index 'shock2': query '@itTitle 116 ': returned 28 matches of 28 total > in 0.000 sec > > > > displaying matches: > > 1. document=855258952, weight=1698, itseller=167116, itclose=Sat Dec > 1 12:21:16 2007, itopen=Wed Nov 28 12:21:16 2007, itcategory=6216, > itstart=21.650000, itauctiontyp=0 > > itTitle=FL 1932 Nr 116-118 * 174B86 > > itOpen=1196248876 > > > itImage=http://217.74.200.42/10067/17/4B/174B86/fl-116-118.JPG?PIC > > 2. document=855262897, weight=1698, itseller=167116, itclose=Sat Dec > 1 12:27:33 2007, itopen=Wed Nov 28 12:27:33 2007, itcategory=6216, > itstart=21.650000, itauctiontyp=0 > > itTitle=FL 1932 Nr 116-118 * 1928FA > > itOpen=1196249253 > > > itImage=http://217.74.200.42/10067/19/28/1928FA/fl-116-118.JPG?PIC > > … > > > > words: > > 1. '116': 138 documents, 179 hits > > > > Mit freundlichen Grüssen > > Thomas Goik > > > > -- > > Lofox GmbH > > Geschäftsführerin: Evelyn Fuchs > > Im Kamperholz 48 > > 44805 Bochum - Germany > > Amtsgericht Bochum HRB 7042 > > USt-IdNr.: DE215698227 > > St.-Nr. Bochum 306/5885/0172 > > > > > >

Wed Nov 28 07:22:05 2007 The RT System itself - Status changed from 'new' to 'open'

Wed Nov 28 08:03:30 2007 technik [...] auxion.de - Correspondence added

Subject:	RE: [rt.cpan.org #31029] Sphinx::Search
Date:	Wed, 28 Nov 2007 14:02:04 +0100
To:	<bug-Sphinx-Search [...] rt.cpan.org>
From:	"Technik via auxion.de" <technik [...] auxion.de>

Thanks! I works... of course! Mit freundlichen Grüssen Thomas Goik -- Lofox GmbH Geschäftsführerin: Evelyn Fuchs Im Kamperholz 48 44805 Bochum - Germany Amtsgericht Bochum HRB 7042 USt-IdNr.: DE215698227 St.-Nr. Bochum 306/5885/0172 Show quoted text

-----Mensaje original----- De: Jon Schutz via RT [mailto:bug-Sphinx-Search@rt.cpan.org] Enviado el: Mittwoch, 28. November 2007 13:22 Para: technik@auxion.de Asunto: Re: [rt.cpan.org #31029] Sphinx::Search <URL: http://rt.cpan.org/Ticket/Display.html?id=31029 > Hi Thomas, You have quotes around SPH_MATCH_EXTENDED. Remove them and it will work fine. See the test case in t/search.t: # Extended on "bb ccc" $sphinx->SetMatchMode(SPH_MATCH_EXTENDED) ->SetLimits(0,20); $results = $sphinx->Query('@field1 bb @field2 ccc'); ok($results, "Results for 'bb ccc' EXTENDED"); print $sphinx->GetLastError unless $results; ok(@{$results->{matches}} == 2, "matches for 'bb ccc' EXTENDED"); Regards, -- Jon On Wed, 2007-11-28 at 06:45 -0500, Technik via auxion.de via RT wrote:

> Hi Jon; > > > > Iâ€™m not sure if itâ€™s a bug or bad doing by myself, but anyway I will > send it to you J > > > > use Sphinx::Search; > > my $spx = Sphinx::Search->new(); > > $spx->SetMatchMode("SPH_MATCH_EXTENDED"); > > > > if($form{desc} eq 'yes') { > > $toTableQuery .= ' @idDesc ' . $toTableQuery; > > } > > $results = $spx->Query('@itTitle ' $toTableQuery); > > > > This is the code I use > > But there isnâ€™t any document returned. > > > > [Wed Nov 28 12:21:31 2007] 0.002 sec [all/0/rel 0 (0,50000)] [*] > @itTitle +116 > > [Wed Nov 28 12:21:42 2007] 0.002 sec [all/0/rel 0 (0,50000)] [*] > @itTitle +116 @idDesc +116 > > > > If I do this search without the limitation, how it is currently it > gives me back this: > > [Wed Nov 28 12:30:23 2007] 0.007 sec [all/0/rel 2011 (0,50000)] [*] > +116 > > > > I would apriciate if you have any hint for me. > > > > The problme is, that it does not returns any value if I do a extended > search using Perl, > > But it returns the right if I do it directly > > > > > > www2@s-esl7:/www/sphinx/bin$ ./search -e @itTitle 116 > > Sphinx 0.9.8-dev (r871) > > Copyright (c) 2001-2007, Andrew Aksyonoff > > > > using config file '/www/sphinx//etc/sphinx.conf'... > > index 'shock1': query '@itTitle 116 ': returned 373 matches of 373 > total in 0.000 sec > > > > displaying matches: > > 1. document=851890474, weight=1688, itseller=176388, itclose=Wed Dec > 12 07:54:28 2007, itopen=Mon Nov 12 07:54:28 2007, itcategory=23570, > itstart=5.950000, itauctiontyp=2 > > itTitle=TKKG 116. Klassenfahrt zur Hexenburg. CD - Stef... > > itOpen=1194850468 > > itImage=http://www.alphamusic.de/cover/n/790/2635790.jpg > > 2. document=852518369, weight=1688, itseller=176388, itclose=Thu Nov > 29 07:08:07 2007, itopen=Mon Oct 29 07:08:07 2007, itcategory=23570, > itstart=5.950000, itauctiontyp=2 > > itTitle=TKKG 116. Klassenfahrt zur Hexenburg. CD - Stef... > > itOpen=1193638087 > > itImage=http://www.alphamusic.de/cover/n/790/2635790.jpg > > â€¦. > > > > words: > > 1. '116': 1844 documents, 2223 hits > > > > index 'shock2': query '@itTitle 116 ': returned 28 matches of 28 total > in 0.000 sec > > > > displaying matches: > > 1. document=855258952, weight=1698, itseller=167116, itclose=Sat Dec > 1 12:21:16 2007, itopen=Wed Nov 28 12:21:16 2007, itcategory=6216, > itstart=21.650000, itauctiontyp=0 > > itTitle=FL 1932 Nr 116-118 * 174B86 > > itOpen=1196248876 > > > itImage=http://217.74.200.42/10067/17/4B/174B86/fl-116-118.JPG?PIC > > 2. document=855262897, weight=1698, itseller=167116, itclose=Sat Dec > 1 12:27:33 2007, itopen=Wed Nov 28 12:27:33 2007, itcategory=6216, > itstart=21.650000, itauctiontyp=0 > > itTitle=FL 1932 Nr 116-118 * 1928FA > > itOpen=1196249253 > > > itImage=http://217.74.200.42/10067/19/28/1928FA/fl-116-118.JPG?PIC > > â€¦ > > > > words: > > 1. '116': 138 documents, 179 hits > > > > Mit freundlichen GrÃ¼ssen > > Thomas Goik > > > > -- > > Lofox GmbH > > GeschÃ¤ftsfÃ¼hrerin: Evelyn Fuchs > > Im Kamperholz 48 > > 44805 Bochum - Germany > > Amtsgericht Bochum HRB 7042 > > USt-IdNr.: DE215698227 > > St.-Nr. Bochum 306/5885/0172 > > > > > >

Wed Nov 28 17:53:16 2007 JJSCHUTZ [...] cpan.org - Correspondence added

Resolving, not a bug.

Wed Nov 28 17:53:19 2007 JJSCHUTZ [...] cpan.org - Status changed from 'open' to 'rejected'