Victor- In the past I have fixed this by logging into the database and changing the issue id in the issues table, correcting the auto increment value that is to be used next. The auto increment value used next needs to be higher than the highest id found in the old issues table. Check the Koha wiki to see if the DBMS page for more specific information on fixing it. https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix
joy On Fri, Aug 6, 2021 at 8:42 AM Victor Barroso Oliveira <vbovic...@gmail.com> wrote: > In System Information: > "Some of your tables have problems with their auto-increment values, which > can lead to data loss. > > You must not ignore this warning. > > The problem is that InnoDB does not maintain auto-increment on SQL server > restarts (it is only set in memory). Therefore, at server startup, > auto-increment values are set to max (table.id) +1. > > To find out how to avoid this problem, see the related wiki page: DBMS > autofix > > Problems found > Loans > The following IDS exist in two issues and old_issues tables: > > 2, 1 > > Em sex., 6 de ago. de 2021 às 11:39, Joy Nelson <j...@bywatersolutions.com> > escreveu: > >> Hi Victor- >> Can you access the About page in your Koha install and tell us what >> errors are being reported there? >> >> -joy >> >> On Fri, Aug 6, 2021 at 8:37 AM Victor Barroso Oliveira < >> vbovic...@gmail.com> wrote: >> >>> Good morning, >>> There was an error trying to return an item. >>> "The item was not returned due to a configuration problem on your system. >>> You should ask an administrator to check.about the page and correct all >>> errors shown on the "System information" tab" >>> How can I fix this error? >>> Thanks, >>> Victor >>> _______________________________________________ >>> >>> Koha mailing list http://koha-community.org >>> Koha@lists.katipo.co.nz >>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >>> >> _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
