[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Koha-bugs] [Bug 1286] New: Opac Biblio Details missing Note ( MARC21 52
From: |
bugzilla-daemon |
Subject: |
[Koha-bugs] [Bug 1286] New: Opac Biblio Details missing Note ( MARC21 520a ) |
Date: |
Fri, 16 Feb 2007 10:25:20 +1300 (NZDT) |
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.
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Koha-bugs] [Bug 1286] New: Opac Biblio Details missing Note ( MARC21 520a ),
bugzilla-daemon <=