https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31740
Bug ID: 31740
Summary: Illrequests table has a foreign key constraint on
status_alias
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P5 - low
Component: Architecture, internals, and plumbing
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
I am not sure the intent of this foreign key, however it seems problematic as
we can't tie it to a single category
To test:
1 - Add an authorised value for Asort1:
Authorised value: MONKEY
Description: Capuchin
2 - Add an authroised value for LOC:
Authorised value: MONKEY
Description: Spider
3 - Put an illrequest in the DB:
INSERT INTO illrequests (branchcode,status,status_alias) VALUES
('CPL','REQUEST_TEST','MONKEY')
4 - Delete one of the authorised values above
5 - Check the DB:
SELECT status_alias FROM illrequests WHERE status = 'REQUEST_TEST'
6 - Note the status is nulled by deletion of unrelated authroised value
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
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/
