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@gmail.com> To: koha@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 @)