[Koha] deleting item types with phantom uses

[Joe Atzberger]

When the item types interface says that the type is in use X number of
times, it means that there are X records in biblioitems with that itemtype,
not items w/ the itype.  I'm not sure whether this is helpful or not.

When I try to delete my BKS item type, it says: "*This record is used 219
times*."  Compare from the following queries:

mysql> select itemtype, count(*) from biblioitems group by 1;
+----------+----------+
| itemtype | count(*) |
+----------+----------+
| NULL     |       10 |
| AR       |        5 |
| *BKS     * |      *219* |
| CF       |      176 |
| SER      |      202 |
| SR       |      216 |
| VR       |      195 |
+----------+----------+
7 rows in set (0.00 sec)

mysql> select itype, count(*) from items group by 1;
+-------+----------+
| itype | count(*) |
+-------+----------+
| NULL  |        4 |
| *BKS  * |      *555* |
| CF    |      480 |
| SER   |      480 |
| SR    |      537 |
| VR    |      450 |
+-------+----------+
6 rows in set (0.01 sec)

So the result message is clearly from biblioitems count.  Shouldn't it be
from items table?  I know how to delete items.  Not sure about biblioitems
though.

--Joe

On Wed, Jan 7, 2009 at 11:49 AM, Rachel Hollis <
Rachel.Hollis at stevenshenager.edu> wrote:

>  Greetings friends, according to the report on item types, there are 25
> total biblios in my catalog. They are Books, CD-ROMs, Reference, Periodicals
> and Visuals. When I try to delete Audio under Item Types and Circulation
> Codes, it tell me that it is in use 2 times; when I try to delete Books, it
> tells me that it in use 32 times. How do I access these phantom Audio
> biblios so that I can delete them and then delete the item type?
>
> What we've got:
> Koha version: 3.01.00.001
> OS version: Linux library 2.6.18-6-686 #1 SMP Fri Jun 6 22:22:11 UTC 2008
> i686 GNU/Linux
> Zebra version: Zebra 2.0.32
>
> Rachel Hollis, librarian
> Stevens-Henager College, Boise Idaho Campus
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20090107/5c4da43e/attachment.htm