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

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11045

            Bug ID: 11045
           Summary: Wrong query in  C4/Biblios.pm : join between
                    biblioitems.itemtypes and itemtypes table
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P5 - low
         Component: Cataloging
          Assignee: gmcharlt at gmail.com
          Reporter: mathieu.saby at univ-rennes2.fr
        QA Contact: testopia at bugs.koha-community.org
                CC: m.de.rooy at rijksmuseum.nl

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.

M. Saby

-- 
You are receiving this mail because:
You are watching all bug changes.