http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1861 Summary: Unique patrons logins not (totally) enforced Product: Koha Version: rel_3_0 Platform: PC OS/Version: Linux - Gentoo Status: NEW Severity: normal Priority: P4 Component: Patron Import AssignedTo: chris@bigballofwax.co.nz ReportedBy: dswhite42@yahoo.com QAContact: koha-bugs@nongnu.org The Koha 3.0 patron admin page will prevent you from creating a user who has an identical OPAC login as someone else (though I would change the error message from "Login/password already exists." to "Login already exists.", since it's not the password that's the problem). However, there's nothing enforced in the MySQL database to prevent patrons from being imported or manually inserted with duplicate logins. Would it be better to change the MySQL spec from this: KEY `userid` (`userid`) to this? UNIQUE KEY `userid` (`userid`) ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.