http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3309
Jonathan Druart <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] | |m --- Comment #3 from Jonathan Druart <[email protected]> --- (In reply to Mirko Tietgen from comment #1) > Two things happen: > - DBD::mysql::st execute failed: Unknown column 'id' in 'where clause' at > /home/mirko/koha/admin/authorised_values.pl line 228. > - value is deleted, field shows '-5' > > So there is no routine to check if the value is used and there is something > wrong with the deletion. The line in referenced in the error message is > > $sth = $dbh->prepare("DELETE FROM authorised_values_branches WHERE id = ?"); > > authorised_values_branches does not have a column called 'id', it is called > 'av_id' This is fixed by bug 9272, not related to the main problem. (In reply to Owen Leonard from comment #2) > (In reply to Mirko Tietgen from comment #1) > > This seems to still be valid. To reproduce I > > - added a value to NOT_LOAN: '-5' with value 'fish' > > - set an item to use that value > > - deleted the authorizes value. > > I find that this is still the case -- I'm not blocked from deleting an > authorized value which is in use by an item. However I see no related errors > in the log. Not sure how we could fix this problem. We will need to check all items, it will be time consuming. But we could imagine a "check" function to know if the AV is used (category linked to a framework and value in the DB field). -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] http://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/
