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: [email protected]
          Reporter: [email protected]
        QA Contact: [email protected]
                CC: [email protected]

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.
_______________________________________________
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/

Reply via email to