[Koha-bugs] [Bug 11045] Wrong query in C4/Biblios.pm : join between biblioitems.itemtypes and itemtypes table

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11045 --- Comment #1 from Jared Camins-Esakov <jcamins@cpbibliography.com> --- (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. -- You are receiving this mail because: You are watching all bug changes.