http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=785 Summary: OPAC Search Errors Product: Koha Version: CVS Platform: PC OS/Version: Linux - Debian Status: NEW Severity: normal Priority: P2 Component: OPAC AssignedTo: chris@katipo.co.nz ReportedBy: jferraro@athenscounty.lib.oh.us QAContact: koha-bugs@lists.sourceforge.net Here are some OPAC errors I get when I do a 'title' search using the new MARC OPAC advanced search: [Thu May 20 14:10:14 2004] [error] [client 62.178.231.109] Invalid method in request get /scripts/..%c0%af..%c0%af..%c0%af..%c0%af..%c0%af..%c0%af..%c0%af..%c0%af/winnt/system32/cmd.exe?/c%20dir DBD::mysql::st execute failed: Unknown column 'itemtype' in 'where clause' at /usr/local/koha/intranet/modules//C4/Biblio.pm line 230. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/modules//C4/Biblio.pm line 231. DBD::mysql::st execute failed: Unknown column 'itemtype' in 'where clause' at /usr/local/koha/intranet/modules//C4/Biblio.pm line 234. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/modules//C4/Biblio.pm line 236. DBD::mysql::st execute failed: Unknown column 'itemtype' in 'where clause' at /usr/local/koha/intranet/modules//C4/Biblio.pm line 243. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/modules//C4/Biblio.pm line 251. IN THERE at /usr/local/koha/opac/cgi-bin/opac-search.pl line 61. Q2 : select distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_word as m1,marc_word 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 'Programming%' and m1.tag+m1.subfieldid in ('245a'))and (m2.word like 'Perl%' and m2.tag+m2.subfieldid in('245a'))) order by biblio.title at /usr/local/koha/intranet/modules//C4/SearchMarc.pm line 167. [Thu May 20 16:48:28 2004] [error] [client 24.208.178.229] File does not exist: /usr/local/koha/opac/htdocs/opac-tmpl/css/en/images/background-opac.gif ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.