23 Jan
2020
23 Jan
'20
12:43 p.m.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21674 --- Comment #9 from Nick Clemens <nick@bywatersolutions.com> --- (In reply to Jonathan Druart from comment #8)
(In reply to Jonathan Druart from comment #7)
Created attachment 97667 [details] [review] [review] Bug 21674: Remove duplicates from library_groups before adding the uniq constraint
To avoid to make it fails if duplicates existed prior to this change
There is certainly a more efficient (SQL) way to do that.
DELETE FROM library_groups WHERE id NOT IN (SELECT MIN(id) FROM library_groups WHERE parent_id IS NOT NULL GROUP BY parent_id,branchcode) AND parent_id IS NOT NULL; -- You are receiving this mail because: You are watching all bug changes.