[Koha-bugs] [Bug 25664] New: login_attempts for imported borrowers can be set to NULL

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

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

            Bug ID: 25664
           Summary: login_attempts for imported borrowers can be set to
                    NULL
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: major
          Priority: P5 - low
         Component: Tools
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: nick at bywatersolutions.com
        QA Contact: testopia at bugs.koha-community.org

On bug 24379 there has been some conversation about login_attempts being set to
null.

While it doesn't seem to happen at creation it does during an import

To recreate:
1 - Check your DB
    select distinct login_attempts from borrowers;
2 - All should be 0 (if you have some nulls already, thats ok)
3 - Run a report and download as CSV (you may need to set the delimiter syspref
to comma)
   select surname, cardnumber, categorycode, branchcode
   FROM borrowers
4 - Tools -> Import borrowers
5 - Set to match on cardnumber and overwrite patrons
6 - Check the DB after import
    select distinct login_attempts from borrowers;
7 - All login_attempts are NULL

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