http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3309

Mirko Tietgen <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[email protected]

--- Comment #1 from Mirko Tietgen <[email protected]> ---
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.
_______________________________________________
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/

Reply via email to