[Koha-devel] bulkmarcimport -d and -fk

[Katrin Fischer]

Hi all,

if you want to follow-up, the bug Stefano describes has been filed here:

bulkmarcimport.pl -d option should use DELETE instead of TRUNCATE
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12488

Katrin


On 18.10.18 15:56, Stefano Bargioni wrote:
> Hi, all,
> before adding a bug, I'd like to discuss this issue with others.
> For testing, I installed Koha 18.06.00.032 and Elasticsearch on a Debian 8 virtual machine, using packages koha-common and koha-elasticsearch.
> Mysql is "mysql Ver 14.14 Distrib 5.5.60, for debian-linux-gnu (x86_64) using readline 6.3".
>
> bulkmarcimport.pl -d fails with errors like
>   Cannot truncate a table referenced in a foreign key constraint
> when going to truncate tables biblio, biblioitems, items. The -fk option is required.
>
> This is probably due to the more strict "way of life" of Mysql.
> Do we need to force -fk when -d is specified? Or simply we have to update the -h documentation?
> Thx. Stefano
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at 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/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20181027/efebae99/attachment.html>