[Koha-bugs] [Bug 17122] New: Paying fines via Koha offline circulation reports false success for non-existing cardnumbers

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17122

            Bug ID: 17122
           Summary: Paying fines via Koha offline circulation reports
                    false success for non-existing cardnumbers
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P5 - low
         Component: Circulation
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: katrin.fischer at bsz-bw.de
        QA Contact: testopia at bugs.koha-community.org
                CC: gmcharlt at gmail.com, kyle.m.hall at gmail.com

If the cardnumber doesn't exist, applying the koc file will still report
success.

- Upload .koc file, don't apply directly, but add to queue.
- Take a look at the queue - verify cardnumbers shows in red and is not linked
(not found)
- Apply payment anyway - verify it reports "Success."


The logs show:

[Sun Aug 14 23:05:43.150296 2016] [cgi:error] [pid 18058] [client
127.0.0.1:43714] AH01215: [Sun Aug 14 23:05:43 2016] process.pl: DBD::mysql::st
execute failed: Column 'borrowernumber' cannot be null [for Statement "INSERT
INTO accountlines, referer:
http://localhost:8080/cgi-bin/koha/offline_circ/list.pl
[Sun Aug 14 23:05:43.150512 2016] [cgi:error] [pid 18058] [client
127.0.0.1:43714] AH01215: [Sun Aug 14 23:05:43 2016] process.pl:  
(borrowernumber,
accountno,date,amount,description,accounttype,amountoutstanding,manager_id,
note), referer: http://localhost:8080/cgi-bin/koha/offline_circ/list.pl
[Sun Aug 14 23:05:43.150848 2016] [cgi:error] [pid 18058] [client
127.0.0.1:43714] AH01215: [Sun Aug 14 23:05:43 2016] process.pl:   VALUES
(?,?,now(),?,'',?,?,?,?)" with ParamValues: 0=undef, 1=1, 2=-1.05, 3='Pay',
4=-1.05, 5="1", 6=''] at /home/katrin/kohaclone/C4/Accounts.pm line 157.,
referer: http://localhost:8080/cgi-bin/koha/offline_circ/list.pl

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