[Koha] Querry related to Deletion in KOHA.

[Paul]

At 05:09 PM 8/23/2013 +0530, Mayank Srivastava wrote:
>Yes, I am looking for that biblionumber,
>And it is still there. and No corresponding entry is made in deleteditems.

We have occasionally found that an orphaned biblioitem gets left behind 
(not deleted) when the corresponding biblio is successfully deleted and 
items are successfully deleted or moved from that biblionumber to a new 
one. As the biblioitem contains the biblionumber, this can lead to it being 
found under some search circumstances.

I have never worked out exactly "why" [1] so have no easy solution.  I just 
delete them manually directly in MySQL [WARNING, may be hazardous to your 
db health: DELETE FROM biblioitems WHERE biblionumber=xyz].

[1] My cataloguers suggest that it occurs when they "overwrite" a single 
old biblio with a new Z39.50 download, and then move multiple items from 
several old biblios to the new one prior to rebuilding Zebra -b -r.  I have 
been able to reproduce this, but not systematically ... (this happens more 
often with serials than books, but it's not framework dependant.)

Best - Paul


>Regards
>Mayank
>
>
>On Fri, Aug 23, 2013 at 4:59 PM, Tomas Cohen Arazi 
><tomascohen at gmail.com>wrote:
>
> > On Fri, Aug 23, 2013 at 8:22 AM, Mayank Srivastava <
> > mayanksri1989 at gmail.com> wrote:
> >
> >> Hi,
> >>
> >> Thanks for the reply.
> >> My version is 3.02.03.067.
> >>
> >
> > Your Koha version is hopelessly obsolete I'm afraid. We won't be able to
> > help you/fix it. We are currently on 3.12.3 (.4 releases today) and the
> > oldest maintained version is 3.8.16.
> >
> >
> >> What kind of checks are you talking about?
> >>
> >
> > When you delete an item, it is identified on the URL by its itemnumber and
> > biblionumber. Is that what you look for in the items table?
> >
> > Regards
> > To+
> >
> >  P.S. please respond to the list, to all the recipients in this case.
> >
>
>
>
>--
>*Mayank Srivastava*
>Techlet Solutions Pvt. Ltd.
>Ph:9718516955
>New Delhi
>_______________________________________________
>Koha mailing list  http://koha-community.org
>Koha at lists.katipo.co.nz
>http://lists.katipo.co.nz/mailman/listinfo/koha

---
Maritime heritage and history, preservation and conservation,
research and education through the written word and the arts.
<http://NavalMarineArchive.com> and <http://UltraMarine.ca>