[Bug 25664] New: login_attempts for imported borrowers can be set to NULL
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@lists.koha-community.org Reporter: nick@bywatersolutions.com QA Contact: testopia@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.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25664 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |24379 CC| |jonathan.druart@bugs.koha-c | |ommunity.org, | |kelly@bywatersolutions.com Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24379 [Bug 24379] Borrowers Login Attempts is NULL -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25664 --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- hm the column is 'default 0', so I guess the import must explicitly set it to NULL somewhere? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25664 Kyle M Hall <kyle@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |kyle@bywatersolutions.com Resolution|--- |INVALID Status|NEW |RESOLVED --- Comment #2 from Kyle M Hall <kyle@bywatersolutions.com> --- Tested and working in master. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org