Bugzilla – Attachment 190014 Details for
Bug 41008
bulkmarcimport.pl -d broken for authorities
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 41008: Fix bulkmarimport.pl -a -d
Bug-41008-Fix-bulkmarimportpl--a--d.patch (text/plain), 1.59 KB, created by
Marcel de Rooy
on 2025-11-28 09:59:34 UTC
(
hide
)
Description:
Bug 41008: Fix bulkmarimport.pl -a -d
Filename:
MIME Type:
Creator:
Marcel de Rooy
Created:
2025-11-28 09:59:34 UTC
Size:
1.59 KB
patch
obsolete
>From f24fcb664aa442ea0cd21765fbc2fc70bc50b173 Mon Sep 17 00:00:00 2001 >From: Katrin Fischer <katrin.fischer@bsz-bw.de> >Date: Tue, 14 Oct 2025 10:10:08 +0200 >Subject: [PATCH] Bug 41008: Fix bulkmarimport.pl -a -d >Content-Type: text/plain; charset=utf-8 > >After bug 35659 that added the OAI harvester to Koha the -d switch >for deleting authorities before importing with bulkmarcimport.pl >was broken and resulted in a FK error. > >Switching from truncate to DELETE FROM like we already did for items, >biblio etc. fixes the issue. > >To test: >- Make sure you have some authorities in your database >- Export some into a file for importing >- Run bulkmarcimport -a -d --file <filename> >- Verify you get the a DB FK constraint error. >- Apply patch >- Repeat steps, verify the script now works as expected again > * Existing authorities are deleted > * File is imported > >Signed-off-by: David Cook <dcook@prosentient.com.au> >Signed-off-by: Jan Kissig <bibliothek@th-wildau.de> > >Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >--- > misc/migration_tools/bulkmarcimport.pl | 2 +- > 1 file changed, 1 insertion(+), 1 deletion(-) > >diff --git a/misc/migration_tools/bulkmarcimport.pl b/misc/migration_tools/bulkmarcimport.pl >index cd5fa255a6..147aa57118 100755 >--- a/misc/migration_tools/bulkmarcimport.pl >+++ b/misc/migration_tools/bulkmarcimport.pl >@@ -236,7 +236,7 @@ if ($delete) { > $dbh->do("ALTER TABLE items AUTO_INCREMENT = 1"); > } else { > print "Deleting authorities\n"; >- $dbh->do("truncate auth_header"); >+ $dbh->do("DELETE FROM auth_header"); > } > $dbh->do("truncate zebraqueue"); > } >-- >2.39.5
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 41008
:
187852
|
188458
|
189916
| 190014