[Koha-devel] AUTO_INCREMENT fix - prevent data lost

[Katrin]

Merging the tables can only be a long term solution, but we need a 
solution for the stable branches now. If we agree to merge, not only 
reports will be affected for some of the tables, it will be a lot of work.

Katrin


On 21.07.2017 05:57, David Cook wrote:
>
> Jonathan, have you thought anymore about merging the deleted* tables 
> back in with the active tables? This would have the benefit of fixing 
> problems with things like “Checkout history” where issues containing 
> deleted borrowers or deleted items have these details nullified and 
> thus disappear from the system.
>
> I suppose we’d have to make sure the deleted flag is indexed, and it 
> would mean changing many SQL reports not to include deleted records… 
> so that might be easier said than done.
>
> Alternatively, maybe we need more robust logical (ie code) ways of 
> managing the relationships between active and inactive (ie deleted) 
> data? I mean… what’s the point of keeping a history of data if we 
> can’t use it?
>
> David Cook
>
> Systems Librarian
>
> Prosentient Systems
>
> 72/330 Wattle St
>
> Ultimo, NSW 2007
>
> Australia
>
> Office: 02 9212 0899
>
> Direct: 02 8005 0595
>
> *From:*koha-devel-bounces at lists.koha-community.org 
> [mailto:koha-devel-bounces at lists.koha-community.org] *On Behalf Of 
> *Jonathan Druart
> *Sent:* Friday, 21 July 2017 3:23 AM
> *To:* koha-devel at lists.koha-community.org
> *Subject:* Re: [Koha-devel] AUTO_INCREMENT fix - prevent data lost
>
> And see bug 18966 for a third (last!?) round. I tried to resume in the 
> description of the bug what has been done and what I propose to move 
> forward.
> BE INVOLVED!
>
> On Wed, 12 Jul 2017 at 15:11 Jonathan Druart 
> <jonathan.druart at bugs.koha-community.org 
> <mailto: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/20170721/aba3dfc9/attachment.html>