[Koha-devel] AUTO_INCREMENT fix - prevent data lost

[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 when checking in.
That is why it is preferable to not try to fix the other tables
('borrowers', 'reserves' and 'biblio') at code level using the same trick
we did for 'issues'.

On Wed, 12 Jul 2017 at 15:44 Rodrigo Santellan <rsantellan at gmail.com> wrote:

> 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 Druart <
> jonathan.druart at bugs.koha-community.org> wrote:
>
>> 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, any ideas?
>>
>> See also bug 18931 where I would like to add a warning on the about page
>> if data are corrupted.
>>
>> Please review quickly, that way we can share the tips on the general
>> mailing list.
>>
>> Cheers,
>> Jonathan
>>
>> _______________________________________________
>> 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/20170712/87df9191/attachment.html>