[Koha] Auto-increment issue persists even after applying Koha Wiki fix

[Texicon Software Solutions]

Hi Koha Community,

I’m facing an unresolved auto-increment issue in one of my Koha instances after upgrading from 17.11 to 24.11.

Issue Summary:

Even after following the official Koha Wiki instructions to repair auto-increment corruption ( https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix ), the issue still persists.

When I attempt to delete a bibliographic record through the staff interface:

The deletion fails.


In the About page, I get a warning about auto-increment problems with deleted biblionumber from the deletedbiblio table.


if i delete the bibilo from deleted biblio table it was getting deleted from there .But  after that when  i try delete from Koha UI the same message coming in koha about page even after i put the script as pet the wiki .



Additional Context:

Another Koha instance on the same server, using the same MariaDB version (10.11.11) and Koha 24.11 codebase, is working correctly. 



Question:

What else should I check to fully resolve this auto-increment problem?

Is there a deeper issue in the biblio / deletedbiblio table definitions or the auto-increment logic that I might have missed?



Appreciate your guidance and help!

Jithin

Malappuram, Kerala