https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15962 Bug ID: 15962 Summary: Currency deletion doesn't correctly identify currencies in use Change sponsored?: --- Product: Koha Version: master Hardware: All URL: /cgi-bin/koha/admin/currency.pl?op=delete_confirm OS: All Status: NEW Severity: normal Priority: P5 - low Component: Acquisitions Assignee: koha-bugs@lists.koha-community.org Reporter: oleonard@myacpl.org QA Contact: testopia@bugs.koha-community.org currency.pl tries to see if a currency is active before deleting it: my $total_row = $dbh->selectrow_hashref( 'select count(*) as total from aqbooksellers where currency=?', {}, $curr ); However it doesn't look like the currency column in aqbooksellers is used (anymore?). It looks to me like there are two columns to check: List prices aqbooksellers.listprice) and invoice price (aqbooksellers.invoiceprice). If you try to delete a currency which is in use as a list or invoice price in a vendor record the process will fail silently: currency.pl: DBD::mysql::db do failed: Cannot delete or update a parent row: a foreign key constraint fails (`koha`.`aqbasket`, CONSTRAINT `aqbasket_ibfk_3` FOREIGN KEY (`basketgroupid`) REFERENCES `aqbasketgroups` (`id`) ON UPDATE CASCADE) -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.