[Koha] No results returned

[Stephen Hedges]

Hi, Don -

The "error" you report is actually normal Koha behavior -- it records the
search SQL statement that has been performed, in case you need to find out
what happened when you did a search and got unexpected results.  For
instance, in this case it looks like the problem is not the "Zoo" you
searched for in tag 245a, but perhaps the "HSL1" you searched for from the
952 tag.  (Is that a branch id code or something? "Hun Sen Library"
maybe?)

Stephen

Don Robertson said:
> Hi all,
> I have installed and got Koha going, and added the sample data.
>
> When I do a search I get no results returned, and errors in the error
> log :
>
> [Wed Feb 02 11:39:26 2005] [error] [client 192.168.1.2] , and, ,
> contains, , 0,20,biblio.title at
> /var/www/koha/intranet/modules/C4/SearchMarc.pm line 169., referer:
> http://192.168.1.2:8000/cgi-bin/koha/opac-search.pl
> [Wed Feb 02 11:39:26 2005] [error] [client 192.168.1.2] Q2 : select
> distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_word as
> m1,marc_subfield_table as m2 where
> biblio.biblionumber=marc_biblio.biblionumber and
> biblio.biblionumber=biblioitems.biblionumber and
> m1.bibid=marc_biblio.bibid and (m1.bibid=m2.bibid) and ((m1.word  like
> 'Zoo' and m1.tagsubfield in ('245a'))and (m2.subfieldvalue = 'HSL1'  and
> concat(m2.tag,m2.subfieldcode) in ('952d','952b'))) order by
> biblio.title term is   Zoo    HSL1     at
> /var/www/koha/intranet/modules/C4/SearchMarc.pm line 269., referer:
> http://192.168.1.2:8000/cgi-bin/koha/opac-search.pl
>
>
> There is an item called Zoo in the database.
>
> --
> Don Robertson
> Systems Administrator
> Hun Sen Library
> Royal University of Phnom Penh
> don at robertson.net.nz
>
-- 
Stephen Hedges
Skemotah Solutions, USA
www.skemotah.com  --  shedges at skemotah.com