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@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