[Koha-devel] Losing biblio.author in 3.8.5

Tue Oct 30 17:12:13 CET 2012

At 08:09 PM 10/29/2012 +0100, you wrote:
>Hi Paul,
>the fields in biblio, biblioitems and items are connected to MARC fields 
>by the Koha-to-MARC-Mappings in the administration area. Have you checked 
>if someone changed the mapping for your author fields? Also the mappings 
>are 1:1, so say someone tried mapping 700, 100 would no longer be used.

Hi Katrin,

Thanks for the reply. "Author" is mapped to 100$a, no change from 
previously. But, respectfully, the point of my email was a bit different: 
it appears maybe that we have a "?corrupt?" MySQL db since 3.8.5 which 
might explain all my woes with authorities, and I don't want to have to do 
hundreds of INSERT ... INTO ... WHERE ... manually.

The SQL structure itself appears to have changed. Here's a well snipped 
output of 'mysql> SELECT biblionumber, datecreated, biblio.author FROM 
biblio ORDER BY datecreated ASC;' :

|   256 | 2011-03-10  | Arundel, 
Louis                                                                | 
512 | 2011-03-10  | Barris, 
Ted                                                                   | 
768 | 2011-03-10  | Berton, Pierre
/ ... /
| 18030 | 2012-09-22  | Heyerdahl, 
Thor                                                               | 18031 
| 2012-09-23  | Cook, 
Graeme                                                                  | 
18032 | 2012-09-23  | Lubbock, Alfred Basil
#
# 3.8.5 upgrade this date
#
| 18033 | 2012-09-24  | 
NULL 
| 18034 | 2012-09-24  | 
NULL 
| 18035 | 2012-09-24  | NULL
/ ... /
| 18363 | 2012-10-29  | 
NULL 
| 18364 | 2012-10-29  | 
NULL 
| 18365 | 2012-10-29  | NULL

So it's pretty clear that 100$a is NOT being "put into the right place" in 
MySQL since the 3.8.5 upgrade. It's being stored somewhere, perhaps in an 
XML format, because if I run a Koha /tools/export.pl (and I haven't looked 
to see if this queries XML or not) for e.g. the last biblionumber above I 
get a proper 100$a:

=LDR  01432nam a2200313 a 4500
=001  1906853
=003  DLC
=005  20121029154904.0
=008  850207s1984\\\\onca\\\\\b\\\\000\0\eng\\
=010  \\$a   84199029
=020  \\$a0660115530 :$c{dollar}5.25 ({dollar}6.30 other countries)
=040  \\$aDLC$cOPIACS$dDLC$beng
=041  1\$aengfre
=043  \\$an-cn-qu$an-cn-on
=050  00$aHE401.O88$bL3413 1984
=082  00$a386/.48/097138$219
=100  1\$aLafreniere, Normand.$93870
=240  10$aReseau de canalisation de la riviere des Outaouais.$lEnglish
=245  14$aThe Ottawa River canal system /$cNormand Lafreniere.
=260  \\$a[Ottawa] :$bNational Historic Parks and Sites Branch, Parks 
Canada, Environment Canada ;$aHull, Quebec, Canada :$bCanadian Govt. Pub. 
Centre, Supply and Services Canada [distributor],$c1984.
=300  \\$a95 p. :$bill. ;$c23 cm.$3pb
=440  \0$aStudies in archaeology, architecture, and history,$x0821-1027$917623
=500  \\$aTranslation of: Le reseau de canalisation de la riviere des 
Outaouais.
=504  \\$aBibliography: p. 87-95.
=520  \\$aOttawa Valley, canal system
=650  \0$aCanals$zOttawa River (Quand Ont.)$xHistory.$917624
=942  \\$2z$cBK
=999  \\$c18365$d18365
=952 
\\$w2012-10-29$p1GRLK12100005$r2012-10-29$4-2$ehhalliday$00$6GRLKLAFR2$918905$10$oGRLK-LAFR-2$d2012-10-16$zOttawa 
Valley, canals$8great_lak$50$71$cgreat_lak $2z$g12.00$yBK$iOttawa Valley, 
canals$xg pb

>For your reports you always have the option to query the MARCXML data 
>directly, nothing should be lost.

I agree -- in fact for staff, I've already written a new report replacing 
biblio.author with 
ExtractValue(marcxml,'//datafield[@tag="100"]/subfield[@code>="a"]') and it 
works perfectly.

But this doesn't "correct" the MySQL db.  Where/why on earth has it gone 
wrong, and how to correct it?  Does this affact 'authorities'?

Thanks and regards -- Paul

>Hope that helps,
>
>Katrin
>
>
>-----Ursprüngliche Nachricht-----
>Von: koha-devel-bounces at lists.koha-community.org im Auftrag von Paul
>Gesendet: Mo 29.10.2012 19:55
>An: koha-devel at lists.koha-community.org
>Betreff: [Koha-devel] Losing biblio.author in 3.8.5
>
>We have a [rather important, it's for donors' tax receipts] report that
>includes:
>
>SELECT
>items.barcode AS Barcode,items.dateaccessioned AS 'Acc Date',
>biblio.title AS Title, biblio.author AS Author,biblioitems.publishercode AS
>Publisher,biblioitems.publicationyear AS Year,
>biblioitems.editionstatement AS Edition,
>items.price as FMV, etc etc etc
>
>It worked perfectly from 3.6.1 up to and including 3.8.4
>
>Since we upgraded to 3.8.5 (24 Sep, to fix bug 8520), something has changed
>-- biblio.author systematically comes up empty (all 245$a fields are
>present) while *all* the other field are perfect. (added later: just
>checked some other reports that use biblio.author -- same result, other
>fields are good, author fails.)
>
>I've looked around release notes and bugs without finding anything
>relevant, and am now at a loss as to what I should look for.
>
>Any suggestions warmly accepted.
>
>Thanks and regards,
>Paul
>
>_______________________________________________
>Koha-devel mailing list
>Koha-devel at lists.koha-community.org
>http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
>website : http://www.koha-community.org/
>git : http://git.koha-community.org/
>bugs : http://bugs.koha-community.org/

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