https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20461 --- Comment #13 from Victor Grousset/tuxayo <victor.grousset@biblibre.com> --- == Going further: handling corrupted data == This leaves corrupted data that can break at least "transferstoreceive.pl" (circulation → Transfers to receive) For reference, the error message is:
item-level_itypes set but no itemtype set for item (12345) at /home/koha/src/Koha/Schema/Result/Item.pm line 698. Can't call method "description" on an undefined value at /home/koha/src/circ/transferstoreceive.pl line 99.
=== Manual fix === ==== Subcriptions ==== So the problem is that subscriptions created before the fix have "Item type" and "item type for older issues" set to NULL. This (subscriptions) is data creating corrupted data (items). So one must fix them (get the subscriptionid list from the SQL bellow) one by one to set the correct types. Or with an SQL query if for all the subscriptions you put the same "Item type" and "item type for older issues" ==== Items ==== One must also fix them (get itemnumber list from SQL bellow) one by one to set the correct types. Or with batch item modification, for all the items you put the same "Item type" But if you have a different item type for the last issue, them your dreams of mass fixing the issue will likely be crushed :( (hopefully there are still way depending on the cases) === SQL queries to find corrupted data === When your fixes are done, the following SQL queries should return nothing. select itemnumber from items where itype is null; subscriptionid FROM subscription WHERE previousitemtype is null or itemtype is null; -- You are receiving this mail because: You are watching all bug changes.