[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Fri Aug 11 12:28:40 CEST 2017


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

--- Comment #8 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
Created a problem in two tables:
 * Tables biblioitems/deletedbiblioitems: 2580, 2632
 * Tables reserves/old_reserves: 831, 833
Now fixing it with the script:
 * Tables biblioitems/deletedbiblioitems: 2580, 2632
Updating biblioitems.biblioitemnumber=2580 with new id 2634
Updating biblioitems.biblioitemnumber=2632 with new id 2635
 * Tables reserves/old_reserves: 831, 833
Updating reserves.reserve_id=831 with new id 835
Updating reserves.reserve_id=833 with new id 836
And now searching on opac. Crashes on opac-detail. Warnings on opac-search.pl
Can't call method "title" on an undefined value at
/usr/share/koha/masterclone/opac/opac-detail.pl line 454.
GetCOinSBiblio called with undefined record at
/usr/share/koha/masterclone/opac/opac-search.pl line 663.

We need to call ModZebra (or Elastic?) on these changed id's too.

Would it be safer to change id's in the old/deleted tables, and push the
autoincrement on the original table ?

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


More information about the Koha-bugs mailing list