[Koha-bugs] [Bug 15479] New: SIPserver rejects renewals for patrons with alphanumeric cardnumbers

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15479

            Bug ID: 15479
           Summary: SIPserver rejects renewals for patrons with
                    alphanumeric cardnumbers
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P5 - low
         Component: SIP2
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: colin.campbell at ptfs-europe.com
        QA Contact: testopia at bugs.koha-community.org
                CC: colin.campbell at ptfs-europe.com

If you allow non-numeric characters in patron barcodes they may be stored in
either lower or uppercase in the borrowers table which is defined with a _ci
(case insensitive) collation and therefore treats both forms as equivalent.
However when the sipserver processes an issue transaction (used by most devices
for both issue and renew) the test to see if the issue is in fact a renew uses
a case sensitive comparison of the incoming cardnumber and that in the database
causing the renewal to be rejected as 'Item checked out to another patron'

e.g. this client sends cardnumber A17 but the database has stored this as 'a17'

Request:11YN20160106    12164220160828   
093005AO|AAA17|AB502326000767|AC|AD|BOY|AY1AZED86
Response:120NUN20160106    121642AOCPL|AAA17|AB502326000767|AJProzac nation
[region 2] [import]|AH|AFItem checked out to another
patron|BLY|AY1AZD57E[0d][0a]
Request:11YN20160106    12164220160828   
093005AO|AAA17|AB502326000755|AC|AD|AY2AZEEEE
Response:120NUN20160106    121642AOCPL|AAA17|AB502326000755|AJAdvanced
programming in the UNIX environment /|AH|AFItem checked out to another
patron|BLY|AY2AZD100[0d][0a]

Patron status reveals cardnumber as stored and that the two items are indeed on
loan to this patron:

Request:6302420160106    121642  Y       AOCPL|AAA17|AC|AD|AY3AZF34D
Response:64              02420160106   
121642000000000002000000000000AOCPL|AAa17|AEFHT
Trial|BLY|CQN|BV2.00|CC5|AU502326000767|AU502326000755|PCST|PIY|AFGreetings
from Koha.  -- Patron owes 2.00|AY3AZCE4B[0d][0a]

Comparison in code should use same type of comparison as the database

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.