[Koha-devel] AUTO_INCREMENT fix - prevent data lost

[Tomas Cohen Arazi]

For reports a view can work.

El vie., 21 jul. 2017 a las 2:49, Katrin (<katrin.fischer.83 at web.de>)
escribió:

> 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
> <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> 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 listKoha-devel at lists.koha-community.orghttp://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/
>
>
> _______________________________________________
> 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/

-- 
Tomás Cohen Arazi
Theke Solutions (https://theke.io <http://theke.io/>)
✆ +54 9351 3513384
GPG: B2F3C15F
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20170721/f765384d/attachment-0001.html>