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 <[email protected]>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 > [email protected] > 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 [email protected] http://www.QuecheeLibrary.org Q (802) 295-1232 W (802) 295-6341
_______________________________________________ Koha-devel mailing list [email protected] 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/
