[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] , and, ,
contains, , 0,20,biblio.title at
/var/www/koha/intranet/modules/C4/SearchMarc.pm line 169., referer:
[Wed Feb 02 11:39:26 2005] [error] [client] 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:

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