Hi Chris, in this case I think it would be good to have the exact Koha version and the DBMS version to be able to investigate further. Also verifying if the script does what it's supposed to - resetting the PK counters on MySQL restart might be good. What you can do: * Create an item, note the itemnumber * Delete it * Restart MySQL * Create a new item * Verify the itemnumber - if it's the same as the deleted item, something is not right yet. Hope that helps, Katrin On 30.05.24 14:27, City & Guilds of London Art School Admin wrote:

Hi Katrin,

These points are addressed in the email Christina sites: https://lists.katipo.co.nz/public/koha/2023-December/060411.html

The problem is exactly recurrence of the issue, after the fix described in the Wiki had been applied, and with a more recent version of the db.

All the best,

Chris

On Thu, May 30, 2024 at 1:12 PM Katrin Fischer <katrin.fischer.83@web.de> wrote:

Hi Christina,

did you see the wiki page about the issue?

https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix

It should only appear with certain older versions of DBMS. So this would be a first thing to check.

If you happen to use one of the older versions, maybe consider updating. Otherwise you will have to implement the script described in the wiki.

Hope this helps,

Katrin

On 28.05.24 10:00, Fairlamb, Christina wrote: > Morning, > > I just upgraded to 23.11 today and have come across the same issue as > another user back in december. > > Database discrepancy flagged after Koha upgrade: > > https://lists.katipo.co.nz/public/koha/2023-December/060411.html > > I've done the same routine as the last time this cropped up a > few major versions ago and I've deleted the entries in the > deletedbiblioitems table, but I'm also worried that this issue is back. > _______________________________________________

Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha