[Koha] No results returned

Don Robertson don at robertson.net.nz
Thu Feb 3 14:08:33 NZDT 2005


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





More information about the Koha mailing list