Bug 789

Summary: Cannot search for member by last name, first name
Product: Koha Reporter: Owen Leonard <oleonard>
Component: PatronsAssignee: Galen Charlton <gmcharlt>
Status: CLOSED FIXED QA Contact:
Severity: major    
Priority: P2 CC: librarian
Version: 2.0.0   
Hardware: All   
OS: All   
GIT URL: Initiative type: ---
Sponsorship status: --- Comma delimited list of Sponsors:
Crowdfunding goal: 0 Crowdfunding committed: 0
Crowdfunding contact: Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Chris Cormack 2010-05-20 23:35:17 UTC


---- Reported by oleonard@myacpl.org 2004-06-10 07:37:07 ----

Latest versions of Koha (both rel_2_0 and HEAD) will return no results for a
member search by "lastname, firstname" even if the name is in the database. It
doesn't matter if the first name is full or partial. Searches will only return
results for last names.

The solution needs to no only allow one to search for members by inputting
searches for names with single last names likes "Smith, John" but also
multiple-word last names like "Van Dyke, John."



---- Additional Comments From mjr@ttllp.co.uk 2004-07-01 01:37:53 ----

No data loss or crash. Downgrading to major.

Maybe the split() in modules/C4/Search.pm:1895 should split on ', ' instead of '
'? Please let me know.




---- Additional Comments From oleonard@myacpl.org 2004-07-01 02:50:56 ----

As I recall, the solution that Chris and I discussed hinged on requiring a comma
between first and last names.  Maybe Chris can confirm.  I don't have any
problem with requiring the comma.



---- Additional Comments From st.hedges@gmail.com 2004-09-06 10:43:16 ----

changed member.pl (removed commas from search string) and Search.pm
BornameSearch function (in HEAD).



---- Additional Comments From mjr@ttllp.co.uk 2004-09-06 11:53:13 ----

Believe unfixed in 2.0: can you provide patchfile of the HEAD fix, please?




---- Additional Comments From mjr@ttllp.co.uk 2004-10-30 08:42:14 ----

Patchfile received. Will include in 2.0.2.




--- Bug imported by chris@bigballofwax.co.nz 2010-05-20 23:35 UTC  ---

This bug was previously known as _bug_ 789 at http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=789

Actual time not defined. Setting to 0.0
The original assignee of this bug does not have
   an account here. Reassigning to the default assignee
   for the component, gmcharlt@gmail.com.
   Previous assignee was mjr@ttllp.co.uk.