[Koha] "Item-level_itypes set but no itemtype set" leads to 'Can't locate object method "ymd"'

[King, Fred]

Thank you! It worked like a charm. Given that we're a medical library and one of the titles making Koha crash was the New England Journal of Medicine, it's kinda nice to have the problem fixed.

Fred King
Medical Librarian, MedStar Washington Hospital Center
fred.king at medstar.net
202-877-6670
ORCID 0000-0001-5266-0279

I have one of those metabolisms where I can eat whatever I want and my body converts it to energy and stores the excess as fat.
--Randall Munroe, xkcd


-----Original Message-----
From: Koha [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Jonathan Druart
Sent: Thursday, December 29, 2016 4:05 AM
To: koha at lists.katipo.co.nz
Subject: Re: [Koha] "Item-level_itypes set but no itemtype set" leads to 'Can't locate object method "ymd"'

Hello Fred,

If bug 17502 fixes your problem that mean that you have the items.onloan field set to '0000-00-00'. That could happen with old database. The easiest way to fix it is to fix the value in the database directly.
You can fix it (without applying the patch) by setting this value to NULL.
Otherwise apply the patch and sign it off :)

Same for the other error (item-level_itypes). It is not related but you can fix it by setting a relevant value for the items.itype row.

Regards,
Jonathan


On Wed, 28 Dec 2016 at 19:36 King, Fred <Fred.King at medstar.net> wrote:

> Greetings to all,
>
> System: Koha 16.11.00, Ubuntu 14.04.
>
> When I rebuild zebra, I get a series of error messages 
> "item-level_itypes set but no itemtype set for item (itemnumber) at 
> /usr/share/koha/lib/Koha/Schema/Result/Item.pm line 698." I've looked 
> up the corresponding biblio number and barcode for the items in an 
> inventory report, but when I try to search for them I get the error 
> message 'Can't locate object method "ymd" via package "dateonly" 
> (perhaps you forgot to load "dateonly"?) at 
> /usr/share/koha/lib/Koha/DateUtils.pm line 225.' I get the same 
> message whether I search for item number, biblio number, barcode, or 
> title. Some of the items don't have barcodes-I don't know whether that's part of the problem.
>
> It looks as if part of the 'Can't locate object method "ymd"' problem 
> is being fixed with Bug 17502, but I can't tell if it's just a date 
> problem that I can fix easily since I can't call up the record to look 
> at it. Same with item-level itemtype.
>
> Does this sound familiar to anyone? Does anyone know of a way to call 
> up items that keep crashing Koha?
>
> Thanks,
>
> Fred King
> Medical Librarian, MedStar Washington Hospital Center 
> fred.king at medstar.net<mailto:fred.king at medstar.net>
> 202-877-6670
> ORCID 0000-0001-5266-0279
>
> I have one of those metabolisms where I can eat whatever I want and my 
> body converts it to energy and stores the excess as fat.
> --Randall Munroe, xkcd
>
> ----------------------------------------------------------------------
> MedStar Health is a not-for-profit, integrated healthcare delivery 
> system, the largest in Maryland and the Washington, D.C., region. 
> Nationally recognized for clinical quality in heart, orthopaedics, cancer and GI.
>
> IMPORTANT: This e-mail (including any attachments) may contain 
> information that is private, confidential, or protected by 
> attorney-client or other privilege. If you received this e-mail in 
> error, please delete it from your system without copying it and notify 
> sender by reply e-mail, so that our records can be corrected... Thank you.
>
> Help conserve valuable resources - only print this email if necessary.
>
>
> _______________________________________________
> Koha mailing list  
> https://urldefense.proofpoint.com/v2/url?u=http-3A__koha-2Dcommunity.o
> rg&d=DgIGaQ&c=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M&r=vKh6XwOmjy
> C51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI&m=1pNbP9tdwRUjkMqcQgZI4ChKlcb6HMWTEP
> 3123-GuwA&s=-frC1YRdTzSYrBFay6MUtY5dIwq-fPy3gppma9a9w1Q&e=
> Koha at lists.katipo.co.nz
> https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.katipo.co.n
> z_mailman_listinfo_koha&d=DgIGaQ&c=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVx
> j8-bJ04M&r=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI&m=1pNbP9tdwRUjk
> MqcQgZI4ChKlcb6HMWTEP3123-GuwA&s=7NwEP5Zq8EKhBFmtrVvrWo18CzKu09Q368eat
> ipln-g&e=
>
_______________________________________________
Koha mailing list  https://urldefense.proofpoint.com/v2/url?u=http-3A__koha-2Dcommunity.org&d=DgIGaQ&c=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M&r=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI&m=1pNbP9tdwRUjkMqcQgZI4ChKlcb6HMWTEP3123-GuwA&s=-frC1YRdTzSYrBFay6MUtY5dIwq-fPy3gppma9a9w1Q&e=
Koha at lists.katipo.co.nz
https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.katipo.co.nz_mailman_listinfo_koha&d=DgIGaQ&c=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M&r=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI&m=1pNbP9tdwRUjkMqcQgZI4ChKlcb6HMWTEP3123-GuwA&s=7NwEP5Zq8EKhBFmtrVvrWo18CzKu09Q368eatipln-g&e=