"Item-level_itypes set but no itemtype set" leads to 'Can't locate object method "ymd"'
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@medstar.net<mailto:fred.king@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.
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@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@medstar.net<mailto:fred.king@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 http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
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@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@lists.katipo.co.nz] On Behalf Of Jonathan Druart Sent: Thursday, December 29, 2016 4:05 AM To: koha@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@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@medstar.net<mailto:fred.king@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@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@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=
Bug 17502 still needs your attention btw. ________________________________ Van: Koha <koha-bounces@lists.katipo.co.nz> namens King, Fred <Fred.King@Medstar.net> Verzonden: donderdag 29 december 2016 21:39 Aan: 'Jonathan Druart'; koha@lists.katipo.co.nz Onderwerp: Re: [Koha] "Item-level_itypes set but no itemtype set" leads to 'Can't locate object method "ymd"' 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@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@lists.katipo.co.nz] On Behalf Of Jonathan Druart Sent: Thursday, December 29, 2016 4:05 AM To: koha@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@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@medstar.net<mailto:fred.king@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@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@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= _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
If you mean me, I'm afraid I'm not the right person to do it. I have my talents, but applying a patch to Koha and signing off on it is not yet one of them. I fixed my problem with an SQL statement kindly provided by Jonathan. Fred -----Original Message----- From: Koha [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Marcel de Rooy Sent: Tuesday, January 03, 2017 7:56 AM To: koha@lists.katipo.co.nz Subject: Re: [Koha] "Item-level_itypes set but no itemtype set" leads to 'Can't locate object method "ymd"' Bug 17502 still needs your attention btw. ________________________________ Van: Koha <koha-bounces@lists.katipo.co.nz> namens King, Fred <Fred.King@Medstar.net> Verzonden: donderdag 29 december 2016 21:39 Aan: 'Jonathan Druart'; koha@lists.katipo.co.nz Onderwerp: Re: [Koha] "Item-level_itypes set but no itemtype set" leads to 'Can't locate object method "ymd"' 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@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@lists.katipo.co.nz] On Behalf Of Jonathan Druart Sent: Thursday, December 29, 2016 4:05 AM To: koha@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@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@medstar.net<mailto:fred.king@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@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@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= _______________________________________________ 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=az68q21lGO0XjUyRmu0yHdBr7P7tGasOuFC_G9oPNfA&s=25vysL3SEC4_fdfuM9fZQwJ7CwDt44pYTWhJyWUjwag&e= Koha@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=az68q21lGO0XjUyRmu0yHdBr7P7tGasOuFC_G9oPNfA&s=thyg05Q515p-DzMHl80VNnskZ5wN1eQiLB2kpB95-y8&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=az68q21lGO0XjUyRmu0yHdBr7P7tGasOuFC_G9oPNfA&s=25vysL3SEC4_fdfuM9fZQwJ7CwDt44pYTWhJyWUjwag&e= Koha@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=az68q21lGO0XjUyRmu0yHdBr7P7tGasOuFC_G9oPNfA&s=thyg05Q515p-DzMHl80VNnskZ5wN1eQiLB2kpB95-y8&e=
participants (3)
-
Jonathan Druart -
King, Fred -
Marcel de Rooy