Bug 17122 - Paying fines via Koha offline circulation reports false success for non-existing cardnumbers
Summary: Paying fines via Koha offline circulation reports false success for non-exist...
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Circulation (show other bugs)
Version: Main
Hardware: All All
: P5 - low normal
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-08-14 21:13 UTC by Katrin Fischer
Modified: 2016-08-14 21:13 UTC (History)
2 users (show)

See Also:
GIT URL:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Katrin Fischer 2016-08-14 21:13:24 UTC
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