[Koha] Problems on working with authority

[Zeno Tajoli]

Hi to all,

I'm tring to insert person into authority and the sistem doesn't work.
I insert the data with the framework but when I try to save the data, 
I receive this error
in the browser:
Koha error

The following fatal error has occurred:

No _parse_* routine defined on this driver (if it a filter, remember 
to set the Parent property) 
[XML::LibXML::SAX::Parser=HASH(0x88db240)] at 
/usr/share/perl5/XML/SAX/Base.pm line 2308.


In the koha-error-log I read:

[Wed Jun 04 17:48:09 2008] [error] [client 131.175.80.94] [Wed Jun  4 
17:48:09 2008] authorities.pl: DBD::mysql::st execute failed: Column 
'authtypecode' cannot be null at 
/var/donw/kohaclone/kohaclone2/C4/AuthoritiesMarc.pm line 566., 
referer: 
http://131.175.9.5:8080/cgi-bin/koha/authorities/authorities.pl?authtypecode=
[Wed Jun 04 17:48:09 2008] [error] [client 131.175.80.94] [Wed Jun  4 
17:48:09 2008] authorities.pl: DBD::mysql::st execute failed: Table 
'auth_subfield_structure' was not locked with LOCK TABLES at 
/var/donw/kohaclone/kohaclone2/C4/AuthoritiesMarc.pm line 85., 
referer: 
http://131.175.9.5:8080/cgi-bin/koha/authorities/authorities.pl?authtypecode=
[Wed Jun 04 17:48:09 2008] [error] [client 131.175.80.94] [Wed Jun  4 
17:48:09 2008] authorities.pl: DBD::mysql::st fetchrow failed: 
fetch() without execute() at 
/var/donw/kohaclone/kohaclone2/C4/AuthoritiesMarc.pm line 86., 
referer: 
http://131.175.9.5:8080/cgi-bin/koha/authorities/authorities.pl?authtypecode=
[Wed Jun 04 17:48:09 2008] [error] [client 131.175.80.94] [Wed Jun  4 
17:48:09 2008] authorities.pl: INDEXING :Sivier at 
/var/donw/kohaclone/kohaclone2/C4/Biblio.pm line 2303., referer: 
http://131.175.9.5:8080/cgi-bin/koha/authorities/authorities.pl?authtypecode=
[Wed Jun 04 17:48:09 2008] [error] [client 131.175.80.94] [Wed Jun  4 
17:48:09 2008] authorities.pl: INDEXING :Ellen at 
/var/donw/kohaclone/kohaclone2/C4/Biblio.pm line 2303., referer: 
http://131.175.9.5:8080/cgi-bin/koha/authorities/authorities.pl?authtypecode=
[Wed Jun 04 17:48:09 2008] [error] [client 131.175.80.94] [Wed Jun  4 
17:48:09 2008] authorities.pl: INDEXING 
:20080604     50                     at 
/var/donw/kohaclone/kohaclone2/C4/Biblio.pm line 2303., referer: 
http://131.175.9.5:8080/cgi-bin/koha/authorities/authorities.pl?authtypecode=
[Wed Jun 04 17:48:09 2008] [error] [client 131.175.80.94] [Wed Jun  4 
17:48:09 2008] authorities.pl: INDEXING : at 
/var/donw/kohaclone/kohaclone2/C4/Biblio.pm line 2303., referer: 
http://131.175.9.5:8080/cgi-bin/koha/authorities/authorities.pl?authtypecode=
[Wed Jun 04 17:48:10 2008] [error] [client 131.175.80.94] [Wed Jun  4 
17:48:10 2008] detail.pl: Use of uninitialized value in pattern match 
(m//) at /usr/local/share/perl/5.8.8/MARC/File/XML.pm line 437., 
referer: 
http://131.175.9.5:8080/cgi-bin/koha/authorities/authorities.pl?authtypecode=
[Wed Jun 04 17:48:10 2008] [error] [client 131.175.80.94] [Wed Jun  4 
17:48:10 2008] detail.pl: No _parse_* routine defined on this driver 
(if it a filter, remember to set the Parent property) 
[XML::LibXML::SAX::Parser=HASH(0x88db240)] at 
/usr/share/perl5/XML/SAX/Base.pm line 2308., referer: 
http://131.175.9.5:8080/cgi-bin/koha/authorities/authorities.pl?authtypecode=

I think the problem could be in the column 'authtypecode' of the 
tables 'auth_subfield_structure' and 'auth_tag_structure'.
In the English SQL definition of Unimarc-Auth
( 
../installer/data/mysql/en/marcflavour/unimarc/mandatory/authorities_normal_unimarc.sql)
  those columns are left empty.
In the Franch SQL definition of Unimarc-Auth
(.../installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Obligatoire/autorites_norme_unimarc.sql)
  those columns have values

Do you know how to fix the problem ?
Do I need to insert a defaul value into the two table ?

I think this problem is connect with this mail:

>Date: Mon, 03 Mar 2008 23:02:42 -0430
>From: Jose Miguel Parrella Romero <joseparrella at gmail.com>
>To: koha at lists.katipo.co.nz
>Subject: [Koha] Problems with authority searching in Koha3


My enviroment:
Linux Debian Etch
Installation type: 'dev'
Last update: today from git repository
Apache Server version: Apache/2.2.3 Server built: Jan 27 2008 18:13:21
Koha 3.00.00.087
Koha DB 3.0000087
MySQL mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using 
readline 5.2
Perl 5.008008
NoZebra = ON
BiblioAddsAuthorities = OFF
dontmerge = ON
OpacAuthorities = ON
OpacBrowser = OFF

Thank you very much for your attention

Cheers
Zeno Tajoli



Zeno Tajoli
CILEA - Segrate (MI)
tajoliAT_SPAM_no_prendiATcilea.it
(Indirizzo mascherato anti-spam; sostituisci quanto tra AT con @)