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@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@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@quecheelibrary.org http://www.QuecheeLibrary.org Q (802) 295-1232 W (802) 295-6341