Re: [Koha-devel] AUTO_INCREMENT fix - prevent data lost

2017-07-12 Thread David Cook
I’ve looked at the wiki page, but I haven’t looked at Bugzilla or the source code. Why on Earth would we get lost data? Shouldn’t we be copying the code to the “deleted*” tables and THEN deleting it from the main table? In pre-5.7 versions, you could produce this same behaviour by running OP

Re: [Koha-devel] Koha with Zebra 2.10

2017-07-12 Thread David Cook
Nope, haven’t tried Zebra 2.1 yet, although I noticed recently that it had been released. What problems did you have with 2.0.61? That’s unfortunate that you had to backtrack to 2.0.59 since it’s broken for ICU. I’m still on 2.0.60 for my main install, although we have other things to do bef

Re: [Koha-devel] AUTO_INCREMENT fix - prevent data lost

2017-07-12 Thread Jonathan Druart
It affects all versions of Koha with any versions of MySQL or MariaDB. Last versions of Koha have been affected with bad bugs because we tried to fix the problem at code level. We introduced other related issues, see bug 18242 and 18651. If you have 18242 without 18651 you may encounter problems wh

[Koha-devel] Expected behaviour if itemtype does not exist

2017-07-12 Thread Jonathan Druart
Hi devs, Since bug 17843 I get errors if the item type (items.itype or biblioitems.itemtype depending on the pref item_level_itypes) does not exist as an item type (table itemtypes, filled by Administration › Item types administration). The error (Can't call method "translated_description" on an u

Re: [Koha-devel] AUTO_INCREMENT fix - prevent data lost

2017-07-12 Thread Rodrigo Santellan
I only have one question about it, it only affects MySQL 5.7 and MariaDB 10.02? Koha should not say that it works with certain version of the MySQL or MariaDB? I been struggling a lot with issues on the DB because I'm on new version. Regards, Rodrigo On Wed, Jul 12, 2017 at 3:11 PM, Jonathan Dr

[Koha-devel] AUTO_INCREMENT fix - prevent data lost

2017-07-12 Thread Jonathan Druart
Hi devs, Please review and test https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix I have added a ref from the Koha on Debian wiki page https://wiki.koha-community.org/wiki/Koha_on_Debian#Further_Configuration It sounds like I should add it somewhere more visible, but do not find where,

[Koha-devel] Koha Development IRC meeting 12 July 2017

2017-07-12 Thread Nick Clemens
Hi All, A late reminder that there is a development meeting scheduled for today at 21UTC Place: #koha If you don't have an IRC client you can join the meeting using your web browser Time: 21 UTC 12 July 2017, 21:00 UTC Time and Date.com converter for vari