[Koha] help me auto increment issue to be fixed

Jonathan Druart jonathan.druart at bugs.koha-community.org
Thu May 31 01:58:11 NZST 2018


Hello,

Did you read the wiki page? Do you understand the problem?

Regards,
Jonathan

On Wed, 30 May 2018 at 04:28 takan bhatt <takan.bhatt at gmail.com> wrote:

> Data problems
>
> Some of your tables have problems with their auto_increment values which
> may lead to data loss.
>
> *You should not ignore this warning.*
>
> The problem is that InnoDB does not keep auto_increment across SQL server
> restarts (it is only set in memory). So on server startup the
> auto_increment values are set to max(table.id)+1.
>
> To know how to avoid this problem see the related wiki page: DBMS auto
> increment fix <
> https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix>
> Problems found Patrons
>
> The following ids exist in both tables *borrowers* and *deletedborrowers*:
>
> 28
>
>
> I am geting this warning.I have full koha backup. kindly help me. to
> resolve this problem. I already fixed auto-incrementation bug.
>
>
> Sincerely yours rajesh
>
>
> I am using maria db
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>


More information about the Koha mailing list