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.<br>
<br>When I try to delete my BKS item type, it says: "<strong>This record is used 219 times</strong>." Compare from the following queries:<br><br><span style="font-family: courier new,monospace;">mysql> select itemtype, count(*) from biblioitems group by 1;</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">+----------+----------+</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">| itemtype | count(*) |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">+----------+----------+</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">| NULL | 10 | </span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| AR | 5 | </span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">| <b>BKS </b> | <b>219</b> | </span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| CF | 176 | </span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">| SER | 202 | </span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| SR | 216 | </span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">| VR | 195 | </span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">+----------+----------+</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">7 rows in set (0.00 sec)</span><br style="font-family: courier new,monospace;">
<br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">mysql> select itype, count(*) from items group by 1;</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">+-------+----------+</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| itype | count(*) |</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">+-------+----------+</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| NULL | 4 | </span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">| <b>BKS </b> | <b>555</b> | </span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| CF | 480 | </span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">| SER | 480 | </span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| SR | 537 | </span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">| VR | 450 | </span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">+-------+----------+</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">6 rows in set (0.01 sec)</span><br><br>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.<br>
<br>--Joe<br><br><div class="gmail_quote">On Wed, Jan 7, 2009 at 11:49 AM, Rachel Hollis <span dir="ltr"><<a href="mailto:Rachel.Hollis@stevenshenager.edu">Rachel.Hollis@stevenshenager.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<font face="Gill Sans MT, sans-serif" size="2">
<div><font color="#17365d">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?</font></div>
<div><font color="#17365d"> </font></div>
<div><font color="#17365d">What we've got:</font></div>
<div><font color="#17365d">Koha version: 3.01.00.001</font></div>
<div><font color="#17365d">OS version: Linux library 2.6.18-6-686 #1 SMP Fri Jun 6 22:22:11 UTC 2008</font></div>
<div><font color="#17365d">i686 GNU/Linux</font></div>
<div><font color="#17365d">Zebra version: Zebra 2.0.32</font></div>
<div><font color="#17365d" face="Calibri, sans-serif" size="2"> </font></div>
<div><font color="#17365d">Rachel Hollis, librarian</font></div>
<div><font color="#17365d">Stevens-Henager College, Boise Idaho Campus</font></div>
</font></div></blockquote></div>