Bug 35971 - Adding a patron/recipient to a routing list twice creates an error
Summary: Adding a patron/recipient to a routing list twice creates an error
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Serials (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-02-01 12:42 UTC by Christian Stelzenmüller
Modified: 2024-02-01 12:42 UTC (History)
0 users

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Christian Stelzenmüller 2024-02-01 12:42:19 UTC
If you try to add a patron or recipient twice to a routing list, it creates an error.

To test:
1.	Create a subscription
2.	Create a routing list.
3.	Click ‚Add recipients‘ to the routing list. 
4.	Search for a patron, and add them. Then, add the same person again.

Part of the error trace:

C4::Serials::addroutingmember(): DBI Exception: DBD::mysql::st execute failed: Duplicate entry '2-19' for key 'subscriptionid' at /kohadevbox/koha/serials/routing.pl line 69
 at /usr/share/perl5/DBIx/Class/Exception.pm line 77