[Koha-bugs] [Bug 1286] New: Opac Biblio Details missing Note ( MARC21 520a )

[bugzilla-daemon]

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1286

           Summary: Opac Biblio Details missing Note ( MARC21 520a )
           Product: Koha
           Version: 2.2.7
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: P2
         Component: OPAC
        AssignedTo: address@hidden
        ReportedBy: address@hidden
         QAContact: address@hidden


The getMARCnotes sub in the SearchMarc module, which is used by the Opac
Details page, searches the marc_subfield_table for subfieldvalue relative to
note tags.  It fails to account for the bloblink in the query, there for
missing notes that get moved to the marc_blob_table due to the size of the
field.

The line in SearchMarc is :
        my $sth=$dbh->prepare("SELECT subfieldvalue,tag FROM
marc_subfield_table
 WHERE bibid=? AND tag BETWEEN ? AND ? ORDER BY tagorder");

and should probably be something like :
        my $sth = $dbh->prepare( "SELECT IF( valuebloblink IS NULL,
marc_subfield_table.subfieldvalue, marc_blob_subfield.subfieldvalue ) AS
subfieldvalue, tag FROM marc_subfield_table LEFT JOIN marc_blob_subfield ON
marc_subfield_table.valuebloblink = marc_blob_subfield.blobidlink WHERE bibid =
? AND tag BETWEEN ? AND ? ORDER BY tagorder" );

I checked this in 2.2.7, though I found the bug in 2.2.5.  I'm guessing that
the blob table is still being missed in 2.2.7, but I could be wrong about that.

Thanks for your support.




------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.