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@robertson.net.nz
-- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges@skemotah.com