[Koha-bugs] [Bug 7957] Routing lists: manage several routing list for each subscription, and export them as CSV

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7957

--- Comment #48 from Julian Maurice <julian.maurice at biblibre.com> ---
It seems you have a problem with your database.
On master, subscriptionroutinglist has UNIQUE (`subscriptionid`,
`borrowernumber`) so you shouldn't be able to have 2 rows with same
borrowernumber and subscriptionid.
Also, subscriptionroutinglist has a foreign key constraint on borrowernumber;
the "Cannot add or update a child row" error should not happen

I could "hide" those errors by adding IGNORE to the INSERT query, but I don't
know if it's the best thing to do.

-- 
You are receiving this mail because:
You are watching all bug changes.