[Koha] Limits are killing the search

Beda Szukics beda at muri-gries.ch
Sat Sep 6 05:35:57 NZST 2008 

Hi

If I try to limit my search by itemtypes or location the result is zero.

Why so?

You can test it yourself at http://schulbibliothek.ksobwalden.ch

There are a lot of messages in koha-opac-error-log:

[Fri Sep 05 19:22:03 2008] [error] [client 83.79.191.6] [Fri Sep  5
19:22:03 2008] opac-search.pl:  leftresult :
641,zeittafelz-1;643,ideeundges-1;1010,frauenumgo-1;1279,goetheundg-1;1722,goetheeine-1;1887,meinlebene-1;3140,johannwolf-1;4524,dasewigwei-1;5334,aufkl\xc3\xa4rung-1;4975,historisch-1;4974,mythischeg-1;5191,balladenh\xc3\xb6-1;5683,manzgrosse-1;5188,stundenbl\xc3\xa4-1;5201,stundenbl\xc3\xa4-1;4962,diedeutsch-1;5622,dasdeutsch-1;5612,1000deutsc-1;5621,diedeutsch-1;5619,deutschero-1;5334,gedichteun-1;4960,geschichte-1;4969,imurteilde-1;4971,deutscheer-1;4970,deutschero-1;5523,interpreta-1;5297,lyriknach1-1;5298,naturlyrik-1;5615,wegezumged-1;5516,wegezurerz-1;5335,klassikund-1;5544,goetheharz-2;5326,johannwolf-1;5128,johannwolf-1;5327,johannwolf-1;5315,johannwolf-1;5319,johannwolf-1;5322,johannwolf-1;5521,erl\xc3\xa4uterun-1;5639,johannwolf-1;5166,goethesged-1;5107,johannwolf-1;5182,stundenbl\xc3\xa4-1;6018,johannwolf-1;172,s\xc3\xa4mtlichew-2;1342,faust-2;1343,dieleidesd-2;1498,diereisen/-2;3139,faust-2;3634,goetheswer-1;3635,s\xc3\xa4mtlicheg-2;3650,sturmunddr-1;4523,diewahlver-1;4654,faust/-1;5266,faust-2;5267,faust-2;5166,goethesged-1;172,s\xc3\xa4mtlichew-2;3650,sturmunddr-1;5612,1000deutsc-1;643,ideeundges-1;1010,frauenumgo-1;1279,goetheundg-1;1722,goetheeine-1;1887,meinlebene-1;3140,johannwolf-1;4524,dasewigwei-1;5544,goetheharz-2;5326,johannwolf-1;5128,johannwolf-1;5327,johannwolf-1;5315,johannwolf-1;5319,johannwolf-1;5322,johannwolf-1;5521,erl\xc3\xa4uterun-1;5639,johannwolf-1;5107,johannwolf-1;6018,johannwolf-1;
at /usr/share/koha/lib/C4/Search.pm line 1651., referer:
http://bibliothek.ksobwalden.ch/cgi-bin/koha/opac-search.pl
[Fri Sep 05 19:22:03 2008] [error] [client 83.79.191.6] [Fri Sep  5
19:22:03 2008] opac-search.pl:  rightresult :  at
/usr/share/koha/lib/C4/Search.pm line 1652., referer:
http://bibliothek.ksobwalden.ch/cgi-bin/koha/opac-search.pl
[Fri Sep 05 19:22:03 2008] [error] [client 83.79.191.6] [Fri Sep  5
19:22:03 2008] opac-search.pl: NZAND at /usr/share/koha/lib/C4/Search.pm
line 1657., referer:
http://bibliothek.ksobwalden.ch/cgi-bin/koha/opac-search.pl
[Fri Sep 05 19:22:03 2008] [error] [client 83.79.191.6] [Fri Sep  5
19:22:03 2008] opac-search.pl:   /
641,zeittafelz-1;643,ideeundges-1;1010,frauenumgo-1;1279,goetheundg-1;1722,goetheeine-1;1887,meinlebene-1;3140,johannwolf-1;4524,dasewigwei-1;5334,aufkl\xc3\xa4rung-1;4975,historisch-1;4974,mythischeg-1;5191,balladenh\xc3\xb6-1;5683,manzgrosse-1;5188,stundenbl\xc3\xa4-1;5201,stundenbl\xc3\xa4-1;4962,diedeutsch-1;5622,dasdeutsch-1;5612,1000deutsc-1;5621,diedeutsch-1;5619,deutschero-1;5334,gedichteun-1;4960,geschichte-1;4969,imurteilde-1;4971,deutscheer-1;4970,deutschero-1;5523,interpreta-1;5297,lyriknach1-1;5298,naturlyrik-1;5615,wegezumged-1;5516,wegezurerz-1;5335,klassikund-1;5544,goetheharz-2;5326,johannwolf-1;5128,johannwolf-1;5327,johannwolf-1;5315,johannwolf-1;5319,johannwolf-1;5322,johannwolf-1;5521,erl\xc3\xa4uterun-1;5639,johannwolf-1;5166,goethesged-1;5107,johannwolf-1;5182,stundenbl\xc3\xa4-1;6018,johannwolf-1;172,s\xc3\xa4mtlichew-2;1342,faust-2;1343,dieleidesd-2;1498,diereisen/-2;3139,faust-2;3634,goetheswer-1;3635,s\xc3\xa4mtlicheg-2;3650,sturmunddr-1;4523,diewahlver-1;4654,faust/-1;5266,faust-2;5267,faust-2;5166,goethesged-1;172,s\xc3\xa4mtlichew-2;3650,sturmunddr-1;5612,1000deutsc-1;643,ideeundges-1;1010,frauenumgo-1;1279,goetheundg-1;1722,goetheeine-1;1887,meinlebene-1;3140,johannwolf-1;4524,dasewigwei-1;5544,goetheharz-2;5326,johannwolf-1;5128,johannwolf-1;5327,johannwolf-1;5315,johannwolf-1;5319,johannwolf-1;5322,johannwolf-1;5521,erl\xc3\xa4uterun-1;5639,johannwolf-1;5107,johannwolf-1;6018,johannwolf-1;
, referer: http://bibliothek.ksobwalden.ch/cgi-bin/koha/opac-search.pl
[Fri Sep 05 19:22:03 2008] [error] [client 83.79.191.6] [Fri Sep  5
19:22:03 2008] opac-search.pl: NZAND DONE :  , referer:
http://bibliothek.ksobwalden.ch/cgi-bin/koha/opac-search.pl
[Fri Sep 05 19:22:03 2008] [error] [client 83.79.191.6] [Fri Sep  5
19:22:03 2008] opac-search.pl: results = at
/usr/share/koha/lib/C4/Search.pm line 1558., referer:
http://bibliothek.ksobwalden.ch/cgi-bin/koha/opac-search.pl
[Fri Sep 05 19:22:03 2008] [error] [client 83.79.191.6] [Fri Sep  5
19:22:03 2008] opac-search.pl: biblionumbers =  and ordering =
relevance, referer:
http://bibliothek.ksobwalden.ch/cgi-bin/koha/opac-search.pl
[Fri Sep 05 19:22:03 2008] [error] [client 83.79.191.6] File does not
exist: /usr/share/koha/opac/htdocs/intranet-tmpl, referer:
http://bibliothek.ksobwalden.ch/cgi-bin/koha/opac-search.pl?idx=kw&q=Goethe&idx=kw&idx=kw&limit=mc-itype%3ABUCH&sort_by=relevance&do=OK
[Fri Sep 05 19:22:04 2008] [error] [client 83.79.191.6] File does not
exist: /usr/share/koha/opac/htdocs/intranet-tmpl, referer:
http://bibliothek.ksobwalden.ch/cgi-bin/koha/opac-search.pl?idx=kw&q=Goethe&idx=kw&idx=kw&limit=mc-itype%3ABUCH&sort_by=relevance&do=OK
[Fri Sep 05 19:22:05 2008] [error] [client 83.79.191.6] File does not
exist: /usr/share/koha/opac/htdocs/intranet-tmpl, referer:
http://bibliothek.ksobwalden.ch/cgi-bin/koha/opac-search.pl?idx=kw&q=Goethe&idx=kw&idx=kw&limit=mc-itype%3ABUCH&sort_by=relevance&do=OK
koha at web-kso1:/var/log/koha$ less koha-opac-error_log
[Fri Sep 05 19:21:49 2008] [error] [client 83.79.191.6] File does not
exist: /usr/share/koha/opac/htdocs/intranet
-tmpl, referer: http://bibliothek.ksobwalden.ch/cgi-bin/koha/opac-search.pl
[Fri Sep 05 19:21:50 2008] [error] [client 83.79.191.6] File does not
exist: /usr/share/koha/opac/htdocs/intranet
-tmpl, referer: http://bibliothek.ksobwalden.ch/cgi-bin/koha/opac-search.pl
[Fri Sep 05 19:22:03 2008] [error] [client 83.79.191.6] [Fri Sep  5
19:22:03 2008] opac-search.pl: ---------, ref
erer: http://bibliothek.ksobwalden.ch/cgi-bin/koha/opac-search.pl
[Fri Sep 05 19:22:03 2008] [error] [client 83.79.191.6] [Fri Sep  5
19:22:03 2008] opac-search.pl: Enter buildQue
ry, referer: http://bibliothek.ksobwalden.ch/cgi-bin/koha/opac-search.pl
[Fri Sep 05 19:22:03 2008] [error] [client 83.79.191.6] [Fri Sep  5
19:22:03 2008] opac-search.pl: --------- at /
usr/share/koha/lib/C4/Search.pm line 863., referer:
http://bibliothek.ksobwalden.ch/cgi-bin/koha/opac-search.pl
[Fri Sep 05 19:22:03 2008] [error] [client 83.79.191.6] [Fri Sep  5
19:22:03 2008] opac-search.pl: TRUNCATION: NO
N:>Goethe< RIGHT:>< LEFT:>< RIGHTLEFT:>< REGEX:>< at
/usr/share/koha/lib/C4/Search.pm line 1000., referer: http:/
/bibliothek.ksobwalden.ch/cgi-bin/koha/opac-search.pl
[Fri Sep 05 19:22:03 2008] [error] [client 83.79.191.6] [Fri Sep  5
19:22:03 2008] opac-search.pl: TRUNCATED OPER
AND: >< at /usr/share/koha/lib/C4/Search.pm line 1041., referer:
http://bibliothek.ksobwalden.ch/cgi-bin/koha/opa
c-search.pl
[Fri Sep 05 19:22:03 2008] [error] [client 83.79.191.6] [Fri Sep  5
19:22:03 2008] opac-search.pl: STEMMED OPERAN
D: >< at /usr/share/koha/lib/C4/Search.pm line 1047., referer:
http://bibliothek.ksobwalden.ch/cgi-bin/koha/opac-
search.pl
[Fri Sep 05 19:22:03 2008] [error] [client 83.79.191.6] [Fri Sep  5
19:22:03 2008] opac-search.pl: FIELD WEIGHTED
 OPERAND: >< at /usr/share/koha/lib/C4/Search.pm line 1054., referer:
http://bibliothek.ksobwalden.ch/cgi-bin/koh
a/opac-search.pl
[Fri Sep 05 19:22:03 2008] [error] [client 83.79.191.6] [Fri Sep  5
19:22:03 2008] opac-search.pl: QUERY BEFORE L
IMITS: > kw,wrdl: Goethe< at /usr/share/koha/lib/C4/Search.pm line
1098., referer: http://bibliothek.ksobwalden.c
h/cgi-bin/koha/opac-search.pl
[Fri Sep 05 19:22:03 2008] [error] [client 83.79.191.6] [Fri Sep  5
19:22:03 2008] opac-search.pl: QUERY:kw,wrdl=
 Goethe and (mc-itype=BUCH) at /usr/share/koha/lib/C4/Search.pm line
1161., referer: http://bibliothek.ksobwalden
.ch/cgi-bin/koha/opac-search.pl
[Fri Sep 05 19:22:03 2008] [error] [client 83.79.191.6] [Fri Sep  5
19:22:03 2008] opac-search.pl: QUERY CGI:idx=
kw&q=Goethe at /usr/share/koha/lib/C4/Search.pm line 1162., referer:
http://bibliothek.ksobwalden.ch/cgi-bin/koha
/opac-search.pl
[Fri Sep 05 19:22:03 2008] [error] [client 83.79.191.6] [Fri Sep  5
19:22:03 2008] opac-search.pl: QUERY DESC:kw,
wrdl: Goethe at /usr/share/koha/lib/C4/Search.pm line 1163., referer:
http://bibliothek.ksobwalden.ch/cgi-bin/koh
a/opac-search.pl
[Fri Sep 05 19:22:03 2008] [error] [client 83.79.191.6] [Fri Sep  5
19:22:03 2008] opac-search.pl: LIMIT:and (mc-
itype=BUCH) at /usr/share/koha/lib/C4/Search.pm line 1164., referer:
http://bibliothek.ksobwalden.ch/cgi-bin/koha
/opac-search.pl
[Fri Sep 05 19:22:03 2008] [error] [client 83.79.191.6] [Fri Sep  5
19:22:03 2008] opac-search.pl: LIMIT CGI:&lim
it=mc-itype:BUCH at /usr/share/koha/lib/C4/Search.pm line 1165.,
referer: http://bibliothek.ksobwalden.ch/cgi-bin


What is wrong here?

By Beda

More information about the Koha mailing list