Hi, I didn't realize that it was the same installation/library. What I was trying to find out with the test was if this was the old issue or a new one. If the test didn't result in a doubled up itemnumber, this might be something else. Maybe someone else has an idea how this could happen. As the itemnumber is set by the database, I am not sure how it's possible. Re-adding the mailing list. Katrin On 30.05.24 17:00, City & Guilds of London Art School Admin wrote:
Hi Katrin,
/> in this case I think it would be good to have the exact Koha version and the DBMS version.../
I begin my email with that information.
/> resetting the PK counters on MySQL restart might be good. /
Do you mean resetting the auto increment count?
/> What you can do.../
Yes, I can test that the documented fix works as you decribe, but that's not the concern either Christina or myself have raised. Which is more about understanding why the issue has re-occured in an installation with that fix applied following an update, and understanding if that documented fix is still relevant.
All the best,
Chris
On Thu, May 30, 2024 at 1:37 PM Katrin Fischer <katrin.fischer.83@web.de> wrote:
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