[Koha] OPAC display "double vision"

[Paul]

At 11:37 AM 10/9/2012 +0200, Fischer, Katrin wrote:
>Hi Paul,
>This seems to do the trick for me:

Hi Katrin -- and for me :=)  Found one more "floating RLIN" in the 600$a 
fields and also ran it for all other 6xx without further errors showing up.

Many thanks for a great start to my day.

Paul


>SELECT
>   biblionumber
>FROM
>   biblioitems
>WHERE
>   ExtractValue(marcxml,'//datafield[@tag="600"]/subfield[@code="a"]') = ""
>   AND 
> ExtractValue(marcxml,'count(//datafield[@tag="600"]/subfield[@code="a"])') = 1
>
>Found the solution here: 
>http://dev.mysql.com/doc/refman/5.1/en/xml-functions.html#function_extractvalue
>
>Katrin
>
>
> > -----Original Message-----
> > From: Paul [mailto:paul.a at aandc.org]
> > Sent: Monday, October 08, 2012 10:58 PM
> > To: Fischer, Katrin; Koha list
> > Subject: Re: AW: [Koha] OPAC display "double vision"
> >
> > At 09:40 PM 10/8/2012 +0200, Fischer, Katrin wrote:
> > >Hi Paul,
> > >
> > >I think your problem could be related to a 6xx field without $a. The
> > >label
> > >Subject(s) is showing up, but there is no link after it. I think there
> > >is an open anchor tag that doesn't close breaking your display here.
> >
> > Hi Katrin -- many thanks for the reply, you "hit the nail on the head."
> >
> > We did have for this record:
> >
> > =600  \\$a $915837
> >
> > which is the "RLIN" for the author (how it got there, from the 100$a,
> > with an empty 600$a is a mystery), and now after deleting the RLIN,
> > there's no 600 and the web page is just fine.
> >
> > Would you by any chance have a suggestion as to a mysql query to find
> > other records that contain the same error.  I've tried:
> >
> > SELECT biblio.biblionumber, biblio.title, biblio.author FROM biblio
> > RIGHT JOIN biblioitems ON biblio.biblionumber = biblioitems.biblionumber
> > LEFT JOIN items ON biblio.biblionumber = items.biblionumber WHERE
> > ExtractValue(marcxml,'//datafield[@tag="600"]/subfield[@code>="a"]')
> > IS NULL AND
> > ExtractValue(marcxml,'//datafield[@tag="600"]/subfield[@code>="9"]')
> >
> > but get nothing. Maybe (wild dream?) there's no other erroneous records,
> > but much more probably the mysql code misses the truth (it runs without
> > apparent error, but...)
> >
> > Again, many thanks and best regards -- Paul
> >
> >
> > >Katrin
> > >
> > >
> > >-----Ursprüngliche Nachricht-----
> > >Von: koha-bounces at lists.katipo.co.nz im Auftrag von Paul
> > >Gesendet: Mo 08.10.2012 21:32
> > >An: Koha list
> > >Betreff: [Koha] OPAC display "double vision"
> > >
> > >For just a very few of our holdings (and so far we haven't found a
> > >pattern for the behaviour), we are getting a "double vision" effect in
> > >Firefox, Chrome, Opera so it doesn't seem to be browser specific.
> > >
> > >The book/item is found without problem, but just under the "Holdings -
> > >Title notes - Comments" tabs, it starts a new "page" with "No results
> > >found!"  As soon as you click on any of those tabs, the "double"
> > >disappears ... but "reload" brings it back ...
> > >
> > >For an example please see
> > ><http://navalmarinearchive.com/ims/opac_double.jpg>
> > >
> > >Has anyone else ever noticed this behaviour in Koha 3.8.x?
> > >
> > >Many thanks -- and for Canadians, Happy Thanksgiving Day.
> > >
> > >Paul
> >
> > ---
> > Maritime heritage and history, preservation and conservation, research
> > and education through the written word and the arts.
> > <http://NavalMarineArchive.com> and <http://UltraMarine.ca>
> >

---
Maritime heritage and history, preservation and conservation,
research and education through the written word and the arts.
<http://NavalMarineArchive.com> and <http://UltraMarine.ca>