https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43899 --- Comment #4 from Kyle M Hall (khall) <kyle@bywatersolutions.com> --- Created attachment 209724 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=209724&action=edit Bug 43899: Add check for userid / cardnumber conflicts to search_for_data_inconsistencies.pl Patrons can log in with either their userid or their cardnumber, but Koha doesn't stop one patron's userid from being another patron's cardnumber ( bug 33905 ). Libraries need a way to find the conflicts they already have. This patch adds a check to search_for_data_inconsistencies.pl that lists them. Test Plan: 1) Apply this patch 2) Give patron 19 the koha user's card number ( 42 ) as their username: UPDATE borrowers SET userid = '42' WHERE borrowernumber = 19; 3) perl misc/maintenance/search_for_data_inconsistencies.pl 4) Note the new "Patrons with a userid that is another patron's cardnumber" section lists both patrons! 5) prove t/db_dependent/Koha/Database/DataInconsistency.t Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.