- Koha - lists.katipo.co.nz

Koha 3 beta install on openSUSE
by mlasater＠rollinghills.lib.mo.us 05 Jun '08

05 Jun '08

Hello everyone, I have installed Koha on my server running openSUSE 10.3. I am to the point where I go to the web installer, but instead I get an error. When I go to: http://rhclkoha:8080 it sends me to: http://rhclkoha:8080/cgi-bin/koha/installer/install.pl then I get the following error message: production mode - trapped fatal error What does this error mean. I have done another install and when I go to the :8080 port it starts the installer, I answer the questions and I am done. Any help with this would be greatly appreciated. Thank you, Michael Lasater

4 5

Problems on working with authority
by Zeno Tajoli 05 Jun '08

05 Jun '08

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?authtypecod… [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?authtypecod… [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?authtypecod… [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?authtypecod… [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?authtypecod… [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?authtypecod… [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?authtypecod… [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?authtypecod… [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?authtypecod… 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(a)gmail.com> >To: koha(a)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 @)

1 0

Re: [Koha] [Koha-devel] Koha 3.0 Stable Release Plan
by BWS Johnson 05 Jun '08

05 Jun '08

Salvete! I think that I'm most worried not about bug reporting and rating, but about usability. As I go through and construct a revamped newbies guide and cataloguing tutorial, I'm very impressed by the amount of new features. You're all to be applauded for all of the new stuff that keeps popping up. I was thrilled to see some RDA stuff in there, too. It's got a lot of bells and whistles now. On the other hand, I think some of the crappy slogging that one has to do in Horizon has crept into the mix. I *hate* having to confirm things three and for times before it's actually done, and there's some of that in cataloguing now. The menus are also getting kind of cluttered, and I've been trying to think of logical trees and what not, since I don't believe in griping without trying to help. Thanks again for all of your hard work. I don't want to lose the group spirit that was present in versions one and two. Just my musings, Brooke

2 1

Problems on working with authority
by Zeno Tajoli 04 Jun '08

04 Jun '08

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?authtypecod… [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?authtypecod… [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?authtypecod… [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?authtypecod… [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?authtypecod… [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?authtypecod… [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?authtypecod… [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?authtypecod… [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?authtypecod… 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(a)gmail.com> >To: koha(a)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 @)

1 0

Re: [Koha] Need help for Data migration
by Marijana Glavica 04 Jun '08

04 Jun '08

On Wed, Jun 04, 2008 at 04:49:22PM +0100, Manju Kaliany wrote: > SOUL Provides export and import facility and adheres to ISO 2709 format. For more details > > http://www.punjabiuniversity.ac.in/pages/dlis/salin/soul.htm#strong.html That's great. Koha have tools for importing ISO 2709 format. That is for bibliographic data. Another issue is migrating patron and circulation data. Plain csv file should be fine for patrons. I am not sure about circulation because I don't need it, but for patrons there is import patron tool in Koha. I am speeking about Koha 3. Marijana --- Marijana Glavica Faculty of Humanities and Social Sciences Libraries I. Lucica 3, 10000 Zagreb, Croatia http://www.knjiznice.ffzg.hr

1 0

help for koha 2.2.9 on windows
by Morium Morshed 04 Jun '08

04 Jun '08

i installed koha 2.2.9 on windows it runs perfectly .i can login from my browser by default password and user name which is koha.But i could not add any data in my koha system from parameter option.As i know if i want to work with KOHA i have to set some parameter from parameter option...so please sir could you help me as soon as possible about these problem.....

1 0

help KOHA
by morium morshed 04 Jun '08

04 Jun '08

i installed koha 2.2.9 on windows XP and it runs ok if i type in my browser intranet and i can login by default password and card number which is koha .But i could not add data from perameter and systempreference option ......please sir could you help me about these problem...

1 0

(no subject)
by Mohammad Islam 04 Jun '08

04 Jun '08

Dear...... I want to escape from the koha list. Would you help me. Send free SMS to your Friends on Mobile from your Yahoo! Messenger. Download Now! http://messenger.yahoo.com/download.php

2 1

Items Shelving Location
by Pseudo Admin 04 Jun '08

04 Jun '08

How do I configure Koha to display items Shelving location (MARC 952 c) on OPAC search results?

3 2

How to configure httpd.conf
by Anahit Hovhannisyan 04 Jun '08

04 Jun '08

Deal all, Please help me how to configure httpd.conf file for koha-3.00.00-beta and apache 2.2.8 on Red hat. I put the following directives in descriptors of VirtualHost in httpd.conf , and it gave me the errors like "Rewrite is unknown directive", when I commented these lines and browsed koha site I see nothing. Please tell me what I did wrong. Thanks in advance. Anahit,Yerevan,Armenia ## OPAC <VirtualHost 193.232.228.68:80> ServerAdmin webmaster@FLIBKOHA DocumentRoot /usr/local/koha/opac/htdocs ServerName FLIBKOHA # ServerAlias opac.mydomain.com ScriptAlias /cgi-bin/koha/ "/usr/local/koha/opac/cgi-bin/opac/" ScriptAlias /index.html "/usr/local/koha/opac/cgi-bin/opac/opac-main.pl" ScriptAlias /opac-search.pl "/usr/local/koha/opac/cgi-bin/opac/search" ScriptAlias /search "/usr/local/koha/opac/cgi-bin/opac/search" ErrorLog /var/log/koha/koha-opac-error_log # TransferLog /var/log/koha/koha-opac-access_log SetEnv KOHA_CONF "/etc/koha/koha-conf.xml" SetEnv PERL5LIB "/usr/local/koha/lib" Options +FollowSymLinks ErrorDocument 400 /cgi-bin/koha/errors/400.pl ErrorDocument 401 /cgi-bin/koha/errors/401.pl ErrorDocument 403 /cgi-bin/koha/errors/403.pl ErrorDocument 404 /cgi-bin/koha/errors/404.pl ErrorDocument 500 /cgi-bin/koha/errors/500.pl Rewrite Rules RewriteEngine On # Uncomment to turn on rewrite logging # RewriteLog /var/log/koha/koha-opac-rewrite.log # RewriteLogLevel 1 RewriteCond %{QUERY_STRING} (.*?)(?:[A-Za-z0-9_-]+)=&(.*) RewriteRule (.+) $1?%1%2 [N,R,NE] RewriteRule ^/bib/([^\/]*)/?$ /cgi-bin/koha/opac-detail\.pl?bib=$1 [PT] RewriteRule ^/isbn/([^\/]*)/?$ /search?q=isbn:$1 [PT] RewriteRule ^/issn/([^\/]*)/?$ /search?q=issn:$1 [PT] <Directory "/usr/local/koha/opac/"> AllowOverride None Options None Order allow,deny Allow from all </Directory> </VirtualHost> ## Intranet <VirtualHost 193.232.228.68:8080> ServerAdmin webmaster@FLIBKOHA DocumentRoot /usr/local/koha/intranet/htdocs ServerName FLIBKOHA:8080 # ServerAlias intranet.mydomain.com ScriptAlias /cgi-bin/koha/ "/usr/local/koha/intranet/cgi-bin/" ScriptAlias /index.html "/usr/local/koha/intranet/cgi-bin/mainpage.pl" ScriptAlias /search "/usr/local/koha/intranet/cgi-bin/search.pl" ErrorLog /var/log/koha/koha-error_log #TransferLog /var/log/koha/koha-access_log SetEnv KOHA_CONF "/etc/koha/koha-conf.xml" SetEnv PERL5LIB "/usr/local/koha/lib" Options +FollowSymLinks ErrorDocument 400 /cgi-bin/koha/errors/400.pl ErrorDocument 401 /cgi-bin/koha/errors/401.pl ErrorDocument 403 /cgi-bin/koha/errors/403.pl ErrorDocument 404 /cgi-bin/koha/errors/404.pl ErrorDocument 500 /cgi-bin/koha/errors/500.pl ##RewriteEngine On # Uncomment to turn on rewrite logging # RewriteLog /var/log/koha/koha-intranet-rewrite.log # RewriteLogLevel 1 RewriteCond %{QUERY_STRING} (.*?)(?:[A-Za-z0-9_-]+)=&(.*) RewriteRule (.+) $1?%1%2 [N,R,NE] RewriteRule ^/bib/([^\/]*)/?$ /cgi-bin/koha/detail\.pl?bib=$1 [PT] RewriteRule ^/isbn/([^\/]*)/?$ /search?q=isbn:$1 [PT] RewriteRule ^/issn/([^\/]*)/?$ /search?q=issn:$1 [PT] <Directory "/usr/local/koha/intranet/"> AllowOverride None Options None Order allow,deny Allow from all </Directory> </VirtualHost>

2 1