[Koha-devel] Orphaned biblioitems

[Nick Clemens]

Hi Paul,

>From how I read this report it returns records with matching Ids (i.e.
Control numbers)  I don't think Koha enforces unique control numbers.

-Nick



On Wed, Apr 30, 2014 at 10:03 AM, Paul A <paul.a at navalmarinearchive.com>wrote:

> Can anyone please suggest where I could start looking in the code for what
> might cause orphaned biblioitems?
>
> Running the following query:
>
> SELECT GROUP_CONCAT('<a target="_blank" href=\"/
> cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=',biblionumber,'\">',biblionumber,'</a>'
> SEPARATOR ', ') AS BibNums,
> EXTRACTVALUE(marcxml,'//controlfield[@tag="001"]') AS Id FROM biblioitems
> GROUP BY Id HAVING count(Id) > 1;
>
> finds ~0.1% of our total catalogue with orphans -- often, but not quite
> always, they are consecutive biblionumbers leading me to think that this
> happens during cataloguing (but there seems to be no rhyme nor reason as to
> how it happens, we cannot purposefully duplicate the error.)
>
> It's fairly trivial to correct with a " DELETE * FROM biblioitems WHERE
> biblionumber=123456; " but I'd like to stop it from happening in the first
> place.
>
> Thanks for any suggestions,
> Paul
>
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at lists.koha-community.org
> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : http://www.koha-community.org/
> git : http://git.koha-community.org/
> bugs : http://bugs.koha-community.org/
>



-- 
Nick Clemens
Quechee & Wilder Libraries
Nick at quecheelibrary.org
http://www.QuecheeLibrary.org
Q (802) 295-1232 W (802) 295-6341
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20140430/351fdde1/attachment-0001.html>