Bug 28643

Summary: On import, if login_attempts is not specified, it throws an error
Product: Koha Reporter: Enica Davis <enica>
Component: PatronsAssignee: Bugs List <koha-bugs>
Status: CLOSED INVALID QA Contact: Testopia <testopia>
Severity: minor    
Priority: P5 - low CC: gmcharlt, kyle
Version: 19.11   
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 Enica Davis 2021-06-30 18:53:53 UTC
When importing borrowers in the staff client, it requires you to specify a borrowers.login_attempts value of '0'.

DBD::mysql::st execute failed: Column 'login_attempts' cannot be null [for Statement "INSERT INTO `borrowers`

File has branchcode, cardnumber, categorycode, surname, firstname, sort1.

Work around: add login_attempts with '0' value.  Import works.

Might be related to bug 25664?
Comment 1 Kyle M Hall (khall) 2021-07-15 11:41:20 UTC
Tested and working in master.