http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3309 Mirko Tietgen <mirko@abunchofthings.net> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |mirko@abunchofthings.net --- Comment #1 from Mirko Tietgen <mirko@abunchofthings.net> --- 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. 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' -- You are receiving this mail because: You are watching all bug changes.