[Bug 12488] Make bulkmarcimport.pl -d use DELETE instead of TRUNCATE

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[Bug 12488] Make bulkmarcimport.pl -d use DELETE instead of TRUNCATE

bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12488

--- Comment #15 from Martin Renvoize <[hidden email]> ---
Created attachment 84963
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=84963&action=edit
Bug 12488: Make bulkmarcimport.pl -d use DELETE instead of TRUNCATE

On MySQL >= 5.5 bulkmarcimport.pl with the -d (delete) switch gives
an error like "Cannot truncate a table referenced in a foreign
key constraint". This patch proposes to replace the offending
TRUNCATE with DELETE. Auto incerement counters are reset to 1 to
preserve the functionality from TRUNCATE.

To test:
- Make sure you havae a test database with some records and items
- Run bulkmarcimport.pl with the -d switch
- Observe the error described above
- Apply this patch
- Run bulkmarcimport.pl with the -d switch again
- Observe the lack of an error
- Verify that the newly imported records and items have biblionumber
  and itemnumbers starting with 1

Signed-off-by: Martin Renvoize <[hidden email]>

https://bugs.koha-community.org/show_bug.cgi?id=21488

--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/