Bug 13671

Summary: Search returning empty
Product: Koha Reporter: Isabela Terra <isabelaterra>
Component: SearchingAssignee: Galen Charlton <gmcharlt>
Status: CLOSED INVALID QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: ketan, liz, tomascohen
Version: 3.18   
Hardware: All   
OS: Linux   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:

Description Isabela Terra 2015-02-05 16:05:37 UTC
After migration from 3.14 to 3.18 koha even with the database fed the search always returns empty.

I noticed that the installation of the pt-BR language is in conflict with the Zebra. The zebra indicates en-US and Koha indicates pt-BR.
Comment 1 Tomás Cohen Arazi 2015-02-05 17:15:36 UTC
It sounds like an invalid bug.

You should at least reproduce the steps you followed to reach this error condition. It should include:

- Install method.
- Steps done to get the DB migrated.
- If you installed using the packages, the way you created the instance
- Steps you followed to reindex the database.
Comment 2 Isabela Terra 2015-02-06 10:29:05 UTC
Hi, Tomás!

I do usually from 3:18 installation.
After test and verify it was working normally, did the migration of 3.14 database to 3.18 and then the errors began to appear.

The main thing is that even with the supplied base, results in searches are always empty.
"No results matching your search for 'kw, wrdl: assis'".
Comment 3 Isabela Terra 2015-02-06 14:28:16 UTC
I visualized the log and found the following errors in the files:

So does the OPAC and Intranet log files.

ERROR:

[Fri Feb 06 12:46:18.784614 2015] [cgi:error] [pid 13873] [client 192.168.52.72:64110] AH01215: [Fri Feb  6 12:46:18 2015] search.pl: CGI::param called in list context from package main line 169, this can lead to vulnerabilities. See the warning in "Fetching the value or values of a single named parameter" at /usr/share/perl5/CGI.pm line 436., referer: http://192.168.3.82:8080/cgi-bin/koha/catalogue/search.pl?q=assis

[Fri Feb 06 12:46:18.929536 2015] [cgi:error] [pid 13873] [client 192.168.52.72:64110] AH01215: [Fri Feb  6 12:46:18 2015] search.pl: CGI::param called in list context from package main line 387, this can lead to vulnerabilities. See the warning in "Fetching the value or values of a single named parameter" at /usr/share/perl5/CGI.pm line 436., referer: http://192.168.3.82:8080/cgi-bin/koha/catalogue/search.pl?q=assis

[Fri Feb 06 12:46:18.929818 2015] [cgi:error] [pid 13873] [client 192.168.52.72:64110] AH01215: [Fri Feb  6 12:46:18 2015] search.pl: CGI::param called in list context from package main line 395, this can lead to vulnerabilities. See the warning in "Fetching the value or values of a single named parameter" at /usr/share/perl5/CGI.pm line 436., referer: http://192.168.3.82:8080/cgi-bin/koha/catalogue/search.pl?q=assis

[Fri Feb 06 12:46:18.930056 2015] [cgi:error] [pid 13873] [client 192.168.52.72:64110] AH01215: [Fri Feb  6 12:46:18 2015] search.pl: CGI::param called in list context from package main line 403, this can lead to vulnerabilities. See the warning in "Fetching the value or values of a single named parameter" at /usr/share/perl5/CGI.pm line 436., referer: http://192.168.3.82:8080/cgi-bin/koha/catalogue/search.pl?q=assis

[Fri Feb 06 12:46:18.930293 2015] [cgi:error] [pid 13873] [client 192.168.52.72:64110] AH01215: [Fri Feb  6 12:46:18 2015] search.pl: CGI::param called in list context from package main line 407, this can lead to vulnerabilities. See the warning in "Fetching the value or values of a single named parameter" at /usr/share/perl5/CGI.pm line 436., referer: http://192.168.3.82:8080/cgi-bin/koha/catalogue/search.pl?q=assis

[Fri Feb 06 12:46:18.930529 2015] [cgi:error] [pid 13873] [client 192.168.52.72:64110] AH01215: [Fri Feb  6 12:46:18 2015] search.pl: CGI::param called in list context from package main line 417, this can lead to vulnerabilities. See the warning in "Fetching the value or values of a single named parameter" at /usr/share/perl5/CGI.pm line 436., referer: http://192.168.3.82:8080/cgi-bin/koha/catalogue/search.pl?q=assis

[Fri Feb 06 12:46:18.930766 2015] [cgi:error] [pid 13873] [client 192.168.52.72:64110] AH01215: [Fri Feb  6 12:46:18 2015] search.pl: CGI::param called in list context from package main line 420, this can lead to vulnerabilities. See the warning in "Fetching the value or values of a single named parameter" at /usr/share/perl5/CGI.pm line 436., referer: http://192.168.3.82:8080/cgi-bin/koha/catalogue/search.pl?q=assis

[Fri Feb 06 12:46:18.931003 2015] [cgi:error] [pid 13873] [client 192.168.52.72:64110] AH01215: [Fri Feb  6 12:46:18 2015] search.pl: CGI::param called in list context from package main line 421, this can lead to vulnerabilities. See the warning in "Fetching the value or values of a single named parameter" at /usr/share/perl5/CGI.pm line 436., referer: http://192.168.3.82:8080/cgi-bin/koha/catalogue/search.pl?q=assis
Comment 4 Ketan Kulkarni 2015-09-01 07:20:03 UTC
I am also facing the same issue in koha 3.20.3.

Not sure if any part of the code will need an update to work with CGI::Param.
Comment 5 Liz Rea 2015-10-28 09:52:37 UTC
I just saw this happen moving from 3.14 -> 3.20 - I'm sure I've solved it before but for the life of me I can't remember what I did.
Comment 6 Liz Rea 2015-10-28 09:52:48 UTC
I just saw this happen moving from 3.14 -> 3.20 - I'm sure I've solved it before but for the life of me I can't remember what I did.
Comment 7 Liz Rea 2015-10-28 09:52:54 UTC
I just saw this happen moving from 3.14 -> 3.20 - I'm sure I've solved it before but for the life of me I can't remember what I did.
Comment 8 Liz Rea 2015-10-28 09:52:58 UTC
I just saw this happen moving from 3.14 -> 3.20 - I'm sure I've solved it before but for the life of me I can't remember what I did.
Comment 9 Liz Rea 2015-10-28 09:53:13 UTC
jesus, sorry about that.
Comment 10 Owen Leonard 2016-08-10 16:10:33 UTC
I think this report must be considered invalid unless someone can provide additional details about reproducing the problem.