http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=797 Summary: Search by ISBN fails. Product: Koha Version: 2.0.0 Platform: PC OS/Version: Windows 2000 Status: NEW Severity: normal Priority: P3 Component: Searching AssignedTo: chris@katipo.co.nz ReportedBy: gregk@no1.com.au QAContact: koha-bugs@lists.sourceforge.net All non MARC isbn searching is failing to return any records. To reproduce this, do the followign steps. 1. Do a search in OPAC to get a listing of results. The search type does not matter. 2. Select any entry from the result set by title. 3. The ISBN number is highlighted in the opac-detail.pl view for a single record. 4. Click the ISBN field link. Eg: http://opac.yourdomain.com/cgi-bin/koha/opac-searchresults.pl?isbn=015205160... Even if an entry for that ISBN number exists in the database, no results are returned. I looked at the intranet version of search.pl - it also fails, but for a different reason. ISBN exists as a valid search criteria: foreach my $term (qw(keyword subject author illustrator itemnumber isbn date-before class dewey branch title abstract publisher ttype)) BUT: isbn is not listed further down when the search is built. The following diff to 2.0 source corrects this. ----------- 185a186,189
if ($search{"isbn"}){ $search .= "&isbn=$search{isbn}"; $searchdesc.="isbn $search{isbn}, "; }
ISBN is now passed to the search engine, but like in the OPAC search screen, it returns a null result set. I dont know the system well enough (yet) to find this problem. If I get some time, I will debug this at a mysql level by looking at SQL logs to find out if the query generated looks OK or not. In the meantime, perhaps someone that is more familiar with this can dig around a bit. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.