If the title for biblionumber 313 is the same bib that is referenced in your error message then it would appear that the bibliographic record you reference has already been deleted. Was it reimported with the 999 tag intact which recreated it in biblio/biblioitems? Otherwise, the numbers in your tables have gotten out of sync somehow. You will have to clean this manually in the database. If you do not need to retain the data in the deletedbiblio/deletedbiblioitems/deleteditems table I would truncate those tables and try your delete again. Or you could delete the bibs you are trying to remove from biblio and biblioitems tables. You would need to reindex after doing your deletions in this way. -joy On Wed, May 31, 2017 at 8:00 AM, <lukasz.mesek@alingsas.se> wrote:
Hello,
I have generated report of empty records and as a result I've got about 2 000 of them.
When I had tried to batch delete them I've got a message that it is imposible.
It looks like this:
Bibliographic record 313 was not deleted. An error occurred. (The error was: DBD::mysql::st execute failed: Duplicate entry '313' for key 'PRIMARY' [for Statement "INSERT INTO deletedbiblioitems SET number = ?,marcxml = ?,publishercode = ?,cn_source = ?,pages = ?,collectionissn = ?,place = ?,collectionvolume = ?,totalissues = ?,volume = ?,cn_class = ?,editionstatement = ?,biblionumber = ?,size = ?,timestamp = ?,lccn = ?,marc = ?,agerestriction = ?,ean = ?,url = ?,publicationyear = ?,volumedesc = ?,cn_item = ?,itemtype = ?,volumedate = ?,editionresponsibility = ?,cn_sort = ?,illus = ?,isbn = ?,cn_suffix = ?,collectiontitle = ?,biblioitemnumber = ?,notes = ?,issn = ?" with ParamValues: 0=undef, 1=" 00396camsa2200157ba 4500 009698 940202 1 Hcee.03 Hce.03 Hce.03 SANDBURG, Carl Dikter i urval 1934 0096...", 2=undef, 3=undef, 4=undef, 5=undef, 6=undef, 7=undef, 8=undef, 9=undef, 10=undef, 11=undef, 12='313', 13=undef, 14='2016-06-07 20:42:21', 15=undef, 16='00396camsa2200157ba 450000100070000000800390000708 100280004610000190007424500190009326000090011259600390012170 0002100160886003200181900001200213999001300225.009698.940202 1 . .aHcee.03.kHce.03.hHce.03.1 .aSANDBURG, Carl.10.aDikter i urval.0 .c1934. .x009698.bDiktonius, Elmer / övers..10.aDiktonius, Elmer.0 .bLA ASWSW0000SWES BD.2PULSEN.00.a2158328. .c313.d313..', 17=undef, 18=undef, 19=undef, 20=undef, 21=undef, 22=undef, 23=undef, 24=undef, 25=undef, 26='', 27=undef, 28=undef, 29=undef, 30=undef, 31='313', 32=undef, 33=undef] at /home/kohaadmin/kohaclone/C4/Biblio.pm line 3419. , see the Koha log file for more information).
Does anyone have an idea what is a problem?
Do I have go through it manually?
Med vänlig hälsning Lukasz Mesek Vuxenbibliotekarie Alingsås bibliotek lukasz.mesek@alingsas.se _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Joy Nelson Director of Migrations ByWater Solutions <http://bywatersolutions.com> Support and Consulting for Open Source Software Office: Fort Worth, TX Phone/Fax (888)900-8944 What is Koha? <http://bywatersolutions.com/what-is-koha/>