[Koha-bugs] [Bug 20461] New subscription form: "Item type" and "item type for older issues" fields are ignored

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

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

--- Comment #13 from Victor Grousset/tuxayo <victor.grousset at 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.