Re: [Koha] How to get statistic for borrowed item by borrower with department

2019-04-23 Thread ikbar
hi katrin yes, im run them in koha -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] SQL for Auto Increment verification

2019-04-23 Thread Tom Hanstra
Based upon a blog post from a couple of versions back, we regularly run some SQL on our databases to ensure that auto increment is working properly on a number of tables. We have had some problems with this, however, in version 17.11 with database locks on table updates which have resulted in downt

Re: [Koha] SQL for Auto Increment verification

2019-04-23 Thread Alvaro Cornejo
Hi Tom The auto increment issue is an issue from mysql. It is not a koha issue. Also, this issue only happens on mysql restart. It should not be necessary to run the sql code you mention if mysql was not restarted. Regards, Alvaro |-

Re: [Koha] SQL for Auto Increment verification

2019-04-23 Thread Katrin Fischer
Hi Tom, you can find more information about the issue on the wiki. There is a fix that will run the SQL automatically on MySQL restart, it should not be necessary to do anything manually if you have implemented it correctly. Also, we have noted the MariaDB and MySQL versions where the bug is fixe

Re: [Koha] Unable to bulk modify/insert marc field

2019-04-23 Thread Katrin Fischer
Hi Vijay, 952 is the item field and not stored in the MARC record, if you want to change that something related to 952, you can use the batch item modification tool. For exporting, make sure you have unchecked the item related settings on the export tool form (with items owned by the following l