[Koha-bugs] [Bug 26025] Data loss issue during Schema database upgrade from 16.11 to 20.05

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26025

Jonathan Druart <jonathan.druart at bugs.koha-community.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jonathan.druart at bugs.koha-c
                   |                            |ommunity.org

--- Comment #1 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
Hi Vinod,

This is a quite old update DB version, and I am not sure it makes sense to fix
it as nobody else reported the problem before.

To handle this you could:
1. Restore a previous version of the DB
2. Fix the id collision in deletedbiblioitems
This wiki page will help you to catch the problematic entries:
https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix#Is_your_data_corrupted.3F
Basically you need find the duplicate ID in deletedbiblio[items] tables, like:

select count(*) as c, biblionumber from deletedbiblio group by biblionumber
having c > 1;

The easier is to remove the duplicated ID, but you may delete important data.
If you want to keep the data you should modify the ID (this can be tricky,
depending on the other data you have in biblio[items])

3. Execute the updatedatabase script

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.