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: jmf@kados.org ReportedBy: mhafen@i.washk12.org QAContact: koha-bugs@nongnu.org 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.