[Koha-bugs] [Bug 12488] Make bulkmarcimport.pl -d use DELETE instead of TRUNCATE
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12488 Fridolin SOMERS changed: What|Removed |Added CC||fridolin.som...@biblibre.co ||m Status|Pushed to Stable|RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 12488] Make bulkmarcimport.pl -d use DELETE instead of TRUNCATE
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12488 Lucas Gass changed: What|Removed |Added CC||lu...@bywatersolutions.com --- Comment #21 from Lucas Gass --- backported to 18.05.x for 18.05.11 -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 12488] Make bulkmarcimport.pl -d use DELETE instead of TRUNCATE
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12488 Martin Renvoize changed: What|Removed |Added Status|Pushed to Master|Pushed to Stable --- Comment #20 from Martin Renvoize --- Pushed to 18.11.x for 18.11.04 -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 12488] Make bulkmarcimport.pl -d use DELETE instead of TRUNCATE
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12488 Nick Clemens changed: What|Removed |Added CC||n...@bywatersolutions.com Status|Passed QA |Pushed to Master --- Comment #19 from Nick Clemens --- Awesome work all! Pushed to master for 19.05 -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 12488] Make bulkmarcimport.pl -d use DELETE instead of TRUNCATE
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12488 --- Comment #18 from Marcel de Rooy --- (In reply to Marcel de Rooy from comment #17) > @RM: We still keep: > $dbh->do("truncate auth_header"); > $dbh->do("truncate zebraqueue"); The lowercase here is bad here imo btw. Harder to locate.. -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 12488] Make bulkmarcimport.pl -d use DELETE instead of TRUNCATE
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12488 --- Comment #17 from Marcel de Rooy --- @RM: We still keep: $dbh->do("truncate auth_header"); $dbh->do("truncate zebraqueue"); -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 12488] Make bulkmarcimport.pl -d use DELETE instead of TRUNCATE
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12488 Marcel de Rooy changed: What|Removed |Added Attachment #84963|0 |1 is obsolete|| --- Comment #16 from Marcel de Rooy --- Created attachment 85148 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=85148=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 Signed-off-by: Marcel de Rooy -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 12488] Make bulkmarcimport.pl -d use DELETE instead of TRUNCATE
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12488 Marcel de Rooy changed: What|Removed |Added QA Contact|testo...@bugs.koha-communit |m.de.r...@rijksmuseum.nl |y.org | Assignee|gmcha...@gmail.com |mag...@libriotech.no CC||m.de.r...@rijksmuseum.nl -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 12488] Make bulkmarcimport.pl -d use DELETE instead of TRUNCATE
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12488 Marcel de Rooy changed: What|Removed |Added Status|Signed Off |Passed QA -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 12488] Make bulkmarcimport.pl -d use DELETE instead of TRUNCATE
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12488 Martin Renvoize changed: What|Removed |Added Attachment #84961|0 |1 is obsolete|| -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 12488] Make bulkmarcimport.pl -d use DELETE instead of TRUNCATE
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12488 --- Comment #15 from Martin Renvoize --- Created attachment 84963 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=84963=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 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 Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 12488] Make bulkmarcimport.pl -d use DELETE instead of TRUNCATE
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12488 Martin Renvoize changed: What|Removed |Added Status|Needs Signoff |Signed Off CC||martin.renvoize@ptfs-europe ||.com --- Comment #14 from Martin Renvoize --- It's eminently sane to make this change and it works for me.. Signing Off. -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 12488] Make bulkmarcimport.pl -d use DELETE instead of TRUNCATE
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12488 --- Comment #13 from Magnus Enger --- I added a patch so there is something concrete to test. :-) -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 12488] Make bulkmarcimport.pl -d use DELETE instead of TRUNCATE
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12488 --- Comment #12 from Magnus Enger --- Created attachment 84961 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=84961=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 -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 12488] Make bulkmarcimport.pl -d use DELETE instead of TRUNCATE
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12488 Magnus Enger changed: What|Removed |Added Status|NEW |Needs Signoff Patch complexity|--- |Small patch -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 12488] Make bulkmarcimport.pl -d use DELETE instead of TRUNCATE
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12488 Magnus Enger changed: What|Removed |Added Summary|bulkmarcimport.pl -d option |Make bulkmarcimport.pl -d |should use DELETE instead |use DELETE instead of |of TRUNCATE |TRUNCATE -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/