[Koha] Returns in version 3

Tim McMahon tmcmahon at wlpl.org
Tue May 13 05:32:54 NZST 2008


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 at 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 at wlpl.org	http://www.wlpl.org


More information about the Koha mailing list