[Koha-bugs] [Bug 785] New: OPAC Search Errors

bugzilla-daemon at wilbur.katipo.co.nz bugzilla-daemon at wilbur.katipo.co.nz
Thu May 20 22:50:31 CEST 2004


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 at katipo.co.nz
        ReportedBy: jferraro at athenscounty.lib.oh.us
         QAContact: koha-bugs at 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.




More information about the Koha-bugs mailing list