[Koha-bugs] [Bug 3309] Deleting authorized values when data exists
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Tue Mar 24 10:49:33 CET 2015
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3309
Jonathan Druart <jonathan.druart at biblibre.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |jonathan.druart at biblibre.co
| |m
--- Comment #3 from Jonathan Druart <jonathan.druart at 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.
More information about the Koha-bugs
mailing list