[Koha-bugs] [Bug 1286] New: Opac Biblio Details missing Note ( MARC21 520a )
bugzilla-daemon at daddy.katipo.co.nz
bugzilla-daemon at daddy.katipo.co.nz
Thu Feb 15 22:25:20 CET 2007
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 at kados.org
ReportedBy: mhafen at i.washk12.org
QAContact: koha-bugs at 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.
More information about the Koha-bugs
mailing list