Hi Paul, This seems to do the trick for me:
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:[email protected]] > 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: [email protected] 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> > _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
