From tjkotula@paradise.net.nz Tue Jan 11 01:05:22 2005
From: T & J Kotula <tjkotula@paradise.net.nz>
To: koha-devel@lists.koha-community.org
Subject: [Koha-devel] A couple of search bugs in koha2.2
Date: Tue, 11 Jan 2005 01:06:15 +0000
Message-ID: <001c01c4f7bc$0b41f200$4305a8c0@PII300>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============4110001061102864816=="

--===============4110001061102864816==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit

Hi,

I just started playing with Koha2.2, running FC3 and noticed a couple of
error entries in the koha-error_log.

1. When I search for <Any word> 'searchword', from
search.marc/search.pl?type=intranet I get the following:
[error] Q : select distinct m1.bibid from
biblio,biblioitems,marc_biblio,marc_word as m1 where
biblio.biblionumber=marc_biblio.biblionumber and
biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid
and (m1.word  like 'searchword') order by biblio.title at
/usr/local/koha/intranet/modules/C4/SearchMarc.pm line 272.

2. When I search for <Title> 'searchword', from
search.marc/search.pl?type=intranet in addition to the above error I also
get:
[error] , and, , contains, , 0,20,biblio.title at
/usr/local/koha/intranet/modules/C4/SearchMarc.pm line 169.

In both cases if I search for a meaningful word I get some search results.

Thanks

tomasz kotula.




--===============4110001061102864816==--


From paul.poulain@free.fr Tue Jan 11 01:57:26 2005
From: Paul POULAIN <paul.poulain@free.fr>
To: koha-devel@lists.koha-community.org
Subject: Re: [Koha-devel] A couple of search bugs in koha2.2
Date: Tue, 11 Jan 2005 01:58:10 +0000
Message-ID: <41E3A2B3.5010608@free.fr>
In-Reply-To: <001c01c4f7bc$0b41f200$4305a8c0@PII300>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============1363870831107673493=="

--===============1363870831107673493==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 8bit

T & J Kotula a écrit :
> 1. When I search for <Any word> 'searchword', from
> search.marc/search.pl?type=intranet I get the following:
> [error] Q : select distinct m1.bibid from
> biblio,biblioitems,marc_biblio,marc_word as m1 where
> biblio.biblionumber=marc_biblio.biblionumber and
> biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid
> and (m1.word  like 'searchword') order by biblio.title at
> /usr/local/koha/intranet/modules/C4/SearchMarc.pm line 272.

This is not really an error.
This is reported to the error log to help understanding a search that 
get strange results according to the library.
It has been helpfull many many times for me. It should probably never be 
removed (i am sometimes asked "I searched harry potter and got no 
results". Looking in the error  log help me saying "yes, but you entered 
harry potter as a subject search, not as title...")

> 2. When I search for <Title> 'searchword', from
> search.marc/search.pl?type=intranet in addition to the above error I also
> get:
> [error] , and, , contains, , 0,20,biblio.title at
> /usr/local/koha/intranet/modules/C4/SearchMarc.pm line 169.

This is a forgotten developper trace. I will remove it, it's useless for 
most ppl.
-- 
Paul POULAIN
Consultant indépendant en logiciels libres
responsable francophone de koha (SIGB libre http://www.koha-fr.org)


--===============1363870831107673493==--