Things seem ok when I try to check out an item, but when I try to check it in, I get the error 'Cannot Check In: This item must be checked in at its home library. NOT CHECKED IN' -- Tim McMahon Technical Services West Liberty Public Library 400 N. Spencer St. West Liberty, IA 52776 Phone: 319-627-2084 Fax: 319-627-2135 tmcmahon@wlpl.org http://www.wlpl.org
I found a little more info. Things seem ok from the web interface when I try to check out an item, but there is an error logged in koha-error_log. circulation.pl: DBD::mysql::st execute failed: Column 'itemtype' cannot be null at /usr/share/koha/lib/C4/Stats.pm line 83., referer: http://192.168.1.4:8080/cgi-bin/koha/circ/circulation.pl Tim McMahon wrote:
Things seem ok when I try to check out an item, but when I try to check it in, I get the error 'Cannot Check In: This item must be checked in at its home library. NOT CHECKED IN'
-- Tim McMahon Technical Services West Liberty Public Library 400 N. Spencer St. West Liberty, IA 52776 Phone: 319-627-2084 Fax: 319-627-2135 tmcmahon@wlpl.org http://www.wlpl.org
Do you have a valid itemtype set on all of the bibs in your database? You can find this out by running SELECT biblio.biblionumber, biblio.title, biblio.author, biblioitems.itemtype from biblio LEFT JOIN biblioitems USING(biblionumber) WHERE itemtype IS NULL OR itemtype = '' -- Jesse
Yes. I even double-checked it with your query and it returned an empty set. My attempts to return the items are entered into the statistics table with itemtypes, but this error is keeping the issues from getting stored there. Jesse wrote:
Do you have a valid itemtype set on all of the bibs in your database?
You can find this out by running SELECT biblio.biblionumber, biblio.title, biblio.author, biblioitems.itemtype from biblio LEFT JOIN biblioitems USING(biblionumber) WHERE itemtype IS NULL OR itemtype = ''
-- Jesse
------------------------------------------------------------------------
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Tim McMahon Technical Services West Liberty Public Library 400 N. Spencer St. West Liberty, IA 52776 Phone: 319-627-2084 Fax: 319-627-2135 tmcmahon@wlpl.org http://www.wlpl.org
On Mon, May 12, 2008 at 12:21 PM, Tim McMahon <tmcmahon@wlpl.org> wrote:
Things seem ok when I try to check out an item, but when I try to check it in, I get the error 'Cannot Check In: This item must be checked in at its home library. NOT CHECKED IN'
Check the syspref item-level_itypes. If you're coming from rel_2_2, you probably have them set at the bib level, so you'll want to turn that OFF. If you want to enable itemtypes at the item leve, turn it on, but the items then need to have itype filled out for all items. So short term fix is to turn OFF item-level_itypes (I suspect). Hope that helps. Cheers, -- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE CEO migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf@liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS
Sorry I didn't reply about this earlier. It didn't make a difference. I'm also having problems with the status showing in search results. Joshua Ferraro wrote:
On Mon, May 12, 2008 at 12:21 PM, Tim McMahon <tmcmahon@wlpl.org> wrote:
Things seem ok when I try to check out an item, but when I try to check it in, I get the error 'Cannot Check In: This item must be checked in at its home library. NOT CHECKED IN'
Check the syspref item-level_itypes. If you're coming from rel_2_2, you probably have them set at the bib level, so you'll want to turn that OFF. If you want to enable itemtypes at the item leve, turn it on, but the items then need to have itype filled out for all items.
So short term fix is to turn OFF item-level_itypes (I suspect).
Hope that helps.
Cheers,
-- Tim McMahon Technical Services West Liberty Public Library 400 N. Spencer St. West Liberty, IA 52776 Phone: 319-627-2084 Fax: 319-627-2135 tmcmahon@wlpl.org http://www.wlpl.org
Sorry Josh. I meant to send this to the group. In case anyone else is having this problem, atz on IRC asked me to try setting the systempref IndependantBranches to off and this helped. Tim McMahon wrote:
Sorry I didn't reply about this earlier. It didn't make a difference. I'm also having problems with the status showing in search results.
Joshua Ferraro wrote:
On Mon, May 12, 2008 at 12:21 PM, Tim McMahon <tmcmahon@wlpl.org> wrote:
Things seem ok when I try to check out an item, but when I try to check it in, I get the error 'Cannot Check In: This item must be checked in at its home library. NOT CHECKED IN'
Check the syspref item-level_itypes. If you're coming from rel_2_2, you probably have them set at the bib level, so you'll want to turn that OFF. If you want to enable itemtypes at the item leve, turn it on, but the items then need to have itype filled out for all items.
So short term fix is to turn OFF item-level_itypes (I suspect).
Hope that helps.
Cheers,
-- Tim McMahon Technical Services West Liberty Public Library 400 N. Spencer St. West Liberty, IA 52776 Phone: 319-627-2084 Fax: 319-627-2135 tmcmahon@wlpl.org http://www.wlpl.org
participants (3)
-
Jesse -
Joshua Ferraro -
Tim McMahon