[Koha] Database increment error returned 23.11

[Katrin Fischer]

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 at 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 at lists.katipo.co.nz
>     Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>