http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3309 Jonathan Druart <jonathan.druart@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart@biblibre.co | |m --- Comment #3 from Jonathan Druart <jonathan.druart@biblibre.com> --- (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.