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_extractva...

Katrin

...

-----Original Message----- From: Paul [mailto:paul.a@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@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>