https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38983
Bug ID: 38983
Summary: Foreign key constraints are case insensitive so can
lead to erroneous data input via the API
Change sponsored?: ---
Product: Koha
Version: Main
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: REST API
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
CC: [email protected]
This one is fun...
You can input randomly cases branchcodes via the API for patrons without
receiving an error. This appears to be because sql's foreign key constraints
aren't being triggered. This is fine in the database, but as soon as we start
returning the data via API javascript is case sensitive in the UI and can crash
To replicate, try adding a library with the code `CAPITALS` and then add a user
via the API with a library_id of `Capitals`. If you then search for that user,
the patron search table will fail to load and you'll get errors in the console.
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
