[Koha] What's on in koha-devel #15

[Michael Kuhn]

Hi Jonathan

> The what's on in koha-devel #15 is available on the Koha website:
> https://koha-community.org/whats-on-in-koha-devel-15


Thanks for the update! In the section about corrupted data you wrote:

 > The last month we communicate about a bug in previous Koha versions
 > that can lead to corrupted data.
 > Worst, some attempts to fix this problem have introduced critical
 > behaviors.
 > So, this is my last call.
 > If you are using one of these versions:
 >
 >    16.11.07, 16.11.08, 16.11.09
 >    16.05.12, 16.05.13, 16.05.14
 >    17.05.00, 17.05.01
 >
 > You must upgrade as soon as possible.
 > To avoid corrupted data, you must set the DBMS auto increment fix up
 > correctly at DBMS configuration.

Am I correct with the following statements?

1. This problem is only relevant for libraries that are actually using 
the circulation module (or want to do so in the future) because it is 
only about corrupted circulation data in tables: borrowers, biblio, 
items, issues, reserves

2. The update (and as well the solution described in 
https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix) will only 
prevent corrupted data in the future, but is not fixing data that is 
already corrupt

3. Instead of an update (which is sometimes more difficult) it is 
possible to just follow the steps described in 
https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix

4. So far there is no approach as how to correct corrupted data (as I 
see the propsed script in 
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 has 
still to be written and is however not part of any Koha version or 
revision yet)

Best wishes: Michael
-- 
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E mik at adminkuhn.ch · W www.adminkuhn.ch