http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11045
--- Comment #2 from mathieu saby <[email protected]> --- (In reply to Jared Camins-Esakov from comment #1) > (In reply to mathieu saby from comment #0) > > C4::Biblios::GetBiblioData and GetBiblioItemData are doing : > > SELECT [...] itemtypes.notforloan [...] > > [...] > > LEFT JOIN itemtypes ON biblioitems.itemtype = itemtypes.itemtype > > > > This is wrong becaause itemtypes table could be linked with items.itype (as > > in my library) and not with biblioitems.itemtype. > > Actually, I think this is correct, since this is for biblio-level item > types, rather than item-level, which are treated elsewhere. You toggle > between the two with the item-level_itypes syspref. In my library, I have 'LIVRE' (book), 'REVUE' etc. in biblioitems.itemtypes. I have "DPN", "DPL" (normal/long check out length) etc in items.itype We have "DPN","DPL" etc itemtypes table We use item level type for issuing rules. So when these subs are making a JOIN between biblioitems.itemtype and itemtypes.itemtype, it means trying to join "LIVRE,REVUE" and "DPN,DPL" etc. So it will never get anything. What I was wondering is : is Koha's code calling this sub supposing that some value should always be retreived from the join, and using these values for some purpose ? If it is not the case, that's not an issue. But I was not sure... Mathieu -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
