- Koha - lists.katipo.co.nz

Installer not creating database tables
by Chris Alfano 23 Mar '09

23 Mar '09

Hi Everyone, I just setup Koha on a Gentoo machine running Apache 2.2.10 / mod_perl 2.0.3-r2 / Perl 5.8.8-r5 / MySQL 5.0 plus all the CPAN modules reported by Makefile.PL When I access the intranet URL to finish the setup, I am redirected to the install script and see: > production mode - trapped fatal error > /var/log/koha/koha-error_log says: [Wed Mar 11 14:10:17 2009] [error] [client 170.235.0.111] [Wed Mar 11 > 14:10:17 2009] install.pl: DBD::mysql::st execute failed: Table > 'koha.language_subtag_registry' doesn't exist at > /usr/share/koha/lib/C4/Languages.pm line 178. > [Wed Mar 11 14:10:17 2009] [error] [client 170.235.0.111] [Wed Mar 11 > 14:10:17 2009] install.pl: DBD::mysql::st fetchrow_hashref failed: fetch() > without execute() at /usr/share/koha/lib/C4/Languages.pm line 179. > [Wed Mar 11 14:10:17 2009] [error] [client 170.235.0.111] [Wed Mar 11 > 14:10:17 2009] install.pl: DBD::mysql::db selectrow_array failed: Table > 'koha.systempreferences' doesn't exist at /usr/share/koha/lib/C4/Context.pm > line 479. > [Wed Mar 11 14:10:17 2009] [error] [client 170.235.0.111] [Wed Mar 11 > 14:10:17 2009] install.pl: Use of uninitialized value in string eq at > /usr/share/koha/lib/C4/Context.pm line 45. > [Wed Mar 11 14:10:17 2009] [error] [client 170.235.0.111] [Wed Mar 11 > 14:10:17 2009] install.pl: Use of uninitialized value in string eq at > /usr/share/koha/lib/C4/Context.pm line 45. > [Wed Mar 11 14:10:17 2009] [error] [client 170.235.0.111] [Wed Mar 11 > 14:10:17 2009] install.pl: Can't call method "id" on an undefined value at > InstallAuth.pm line 278. > The installer is not creating any tables in the MySQL database. I used all default values for Makefile.PL except for the DB specifics and have confirmed the configuration by copying and pasting the DB values from /etc/koha/koha-conf.xml into the command line mysql client and was able to create and manipulate tables just fine. The fact that I am seeing table doesn't exist errors instead of access denied tells me that it is connecting to MySQL alright. Where could I begin trying to debug this? Can I disable the error message suppression? Thanks to anyone who can offer some insight. Here is my intranet vhost configuration: > <VirtualHost *:80> > ServerName koha.scienceleadership.org > > ServerAdmin calfano(a)scienceleadership.org > DocumentRoot /usr/share/koha/intranet/htdocs > ScriptAlias /cgi-bin/koha/ "/usr/share/koha/intranet/cgi-bin/" > ScriptAlias /index.html "/usr/share/koha/intranet/cgi-bin/mainpage.pl" > ScriptAlias /search "/usr/share/koha/intranet/cgi-bin/search.pl" > > <Directory "/usr/share/koha/intranet"> > Options Indexes > AllowOverride None > > Order allow,deny > Allow from all > </Directory> > > 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/share/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] > </VirtualHost> > > <VirtualHost *:80> > ServerName library.scienceleadership.org > ServerAdmin calfano(a)scienceleadership.org > > DocumentRoot /usr/share/koha/opac/htdocs > > ScriptAlias /cgi-bin/koha/ "/usr/share/koha/opac/cgi-bin/opac/" > ScriptAlias /index.html "/usr/share/koha/opac/cgi-bin/opac/opac-main.pl" > ScriptAlias /opac-search.pl "/usr/share/koha/opac/cgi-bin/opac/search" > ScriptAlias /search "/usr/share/koha/opac/cgi-bin/opac/search" > > <Directory "/usr/share/koha/opac"> > Options Indexes > AllowOverride None > > Order allow,deny > Allow from all > </Directory> > > 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/share/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] > </VirtualHost> > -- Best Regards, Chris Alfano Systems Administrator Science Leadership Academy

3 3

Re: [Koha] Cataloguing articles within serials
by Nelson Fredsell -CCE 23 Mar '09

23 Mar '09

> -----Original Message----- > From: Veronica Lencinas [mailto:verolencinas@yahoo.com.ar] > Sent: 17 March 2009 02:29 PM > To: Nelson Fredsell > Subject: Re: [Koha] Cataloguing articles within serials > > > Hello Nelson, > [see question 1 below] > what you need is analytical cataloging. It's quite simple. Use 1XX and > 245 as usual for author and title of the article. The information about > the serial is recorded in the field 773 - Host Item Entry > (http://www.loc.gov/marc/bibliographic/bd773.html) You can add subject > headings as usual in 650. Does this mean I would first catalogue the serial as an item, then I would catalogue each article separately, as an additional item in our catalogue, and reference the serial using 773? So, a serial with 10 articles would result in 11 items in the ILS, both with subject and keywords? This way when a patron searches, both the serial and the specific article within that serial edition would be found? The patron would then have to figure out that the two are connected. Thanks, Nelson > > Verónica Lencinas > Córdoba, Argentina > > > --- El mar 17-mar-09, Nelson Fredsell <nelson(a)cfce.org.za> escribió: > > > De: Nelson Fredsell <nelson(a)cfce.org.za> > > Asunto: [Koha] Cataloguing articles within serials > > Para: "Koha list" <koha(a)lists.katipo.co.nz> > > Fecha: martes, 17 de marzo de 2009, 5:29 am > > Dear all, > > > > > > > > 1) We would like to catalogue individual > > articles/chapters within some > > of our serials/journals/periodicals. I understand that > > using MARC 5xx or > > 6xx is a preferred method. I've been unable to find > > examples of this on > > the liblime demos thus far, and would like to see how this > > works both from > > an administrator's standpoint and from a patron's. > > > > > > > > > > 2) After seeing an article, I'd also love to be > > able to Search for this > > article to see whether I could find it in the catalogue, > > alongside books. > > > > > > > > 3) I'd like for patron searches to include books, > > serials and articles > > within serials, *within a single search of keyword, subject > > and title*. I'd > > perhaps like this to be the default search, rather than an > > Advanced Search. > > Is Koha configurable in this way (without lots and lots of > > effort)? > > > > > > > > Could anyone point me to an example or two, especially > > relating to point 1? > > > > > > > > > > (We're a small NGO/non-profit in the field of > > independent education.) > > > > > > > > Thanks! > > > > Nelson > > > > > > > > Administration > > > > Centre for Creative Education > > > > Cape Town | South Africa > > > > www.cfce.org.za > > > > > > > > _______________________________________________ > > Koha mailing list > > Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > Yahoo! Cocina > Recetas prácticas y comida saludable > http://ar.mujer.yahoo.com/cocina/ _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

2 1

serial not showing in OPAC search
by mallikarjun dora 23 Mar '09

23 Mar '09

Dear All, i have add a new subscription , but its not showing while i am searching in OPAC. what may be the reason. Thanks

2 1

Koha Workshops at Mysore (9-10 Apr) & Mumbai (17-18 Apr)
by savitra sirohi 23 Mar '09

23 Mar '09

All, We have 2 workshops planned in April here in India, more information here: http://www.osslabs.biz/koha_library_management_system/workshop.html Those who wish to register please fill this form: http://spreadsheets.google.com/viewform?formkey=cFJnR0JMMEF4cHpwT0MyWUxQTm9… Thanks, Savitra Sirohi Nucsoft OSS Labs http://www.osslabs.biz

1 0

Re: [Koha] Invitation for those in Bangkok -- Open Source SchoolsConference Plan
by BWS Johnson 22 Mar '09

22 Mar '09

Salvete! When we compartmentalise overmuch, we lose that which is most relevant to all: the flow of information. Hopefully we have open minds with open source ;) Wish I were in Bangkok! Cheers, Brooke >Please excuse this somewhat tangential topic. I hope you agree it is >relevant. >

1 0

Invitation for those in Bangkok -- Open Source Schools Conference Planning Session
by David M. Bucknell 22 Mar '09

22 Mar '09

Dear Colleagues, Please excuse this somewhat tangential topic. I hope you agree it is relevant. If you are in Bangkok, and I believe a few of your are, please let me know if you'd like to help brainstorm ideas for our first Open Source Schools conference. Koha will definitely be a prominent option; we need to decide how -- and what else? I have ideas; I'm sure you do, too. Tuesday, 7PM, JW Marriott, Boardroom 1 at Business Center, 4th Floor I look forward to hearing from you. Announcement of Conference: http://opensourceschools.org/oss2009bangkok "I'm interested" link: http://opensourceschools.org/flossedinbkk2009enquiry Sincerely, David Bucknell http://opensourceschools.org -- * IKN (International Knowledge Networks, Co., Ltd. Thailand) * http://intknowledge.com * Web Tools and Web sites for Teachers, Schools, Businesses and You. * Cell: +66(0*)84 329 1183; Office: +66(0*)2 980 9464 (*No "0" if calling from overseas.)* Skype: dbucknell ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.

1 0

Updating Zebra index
by Bob Birchall ＠ Calyx 22 Mar '09

22 Mar '09

What is the correct way to update the zebra indexes? The koha manual at Appendices/Cron Jobs suggests that rebuild_zebra.pl ( with -z option) should be run every n minutes, however ... guidance I've received is that using zebraqueue_daemon.pl is the correct method. Which is correct? If the latter, then the manual needs an update, I think? Is the rest of the guidance in the 'Cron Jobs' section of the manual still correct? Many thanks, Bob Birchall CALYX

1 0

Re: [Koha] Authority search
by Liny Varghese 21 Mar '09

21 Mar '09

Hi this is the logfile i am getting while adding an authority 12:00:34-21/03 zebrasrv(5) [log] profilePath=/etc/koha/zebradb/authorities/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/authorities:/etc/koha/zebradb/lang_defs/en cwd=/var/lib/koha/zebradb/authorities 12:00:34-21/03 zebrasrv(5) [log] record 0 type XML 12:00:34-21/03 zebrasrv(5) [log] 845 bytes: <?xml version="1.0" encoding="UTF-8"?> <record xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://w ... 12:00:34-21/03 zebrasrv(5) [warn] record.abs:13: Couldn't find att 'any' in attset 12:00:34-21/03 zebrasrv(5) [warn] Record didn't contain match fields in (bib1,Local-Number) 12:00:34-21/03 zebrasrv(5) [warn] Bad match criteria (recordID) 12:00:34-21/03 zebrasrv(5) [log] zebra_update_record returned res=1 12:00:34-21/03 zebrasrv(5) [warn] zebra_update_record failed r=1 12:00:34-21/03 zebrasrv(5) [log] zebra_end_trans (permission error has gone) this is the log while searching for an authority 12:07:25-21/03 zebrasrv(9) [session] Session - OK 9 unix:/var/run/koha/zebradb/authoritysocket 6564 12:07:25-21/03 zebrasrv(9) [log] User perm for perm.kohauser: rw 12:07:25-21/03 zebrasrv(9) [request] Auth idPass kohauser - 12:07:25-21/03 zebrasrv(9) [request] Init OK - ID:81/81 Name:ZOOM-C/YAZ Version:1.116.2.1/2.1.56 12:07:25-21/03 zebrasrv(9) [log] ResultSet '1' 12:07:25-21/03 zebrasrv(9) [debug][log] zebra_register_open rw = 0 useshadow=0 p=0x836ea20,n=,rp=(none) 12:07:25-21/03 zebrasrv(9) [log] profilePath=/etc/koha/zebradb/authorities/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/authorities:/etc/koha/zebradb/lang_defs/en cwd=/var/lib/koha/zebradb/authorities 12:07:25-21/03 zebrasrv(9) [log] 0 keys, 0 sysnos, sort 12:07:25-21/03 zebrasrv(9) [log] term="0" nn=0 type=void count=0 12:07:25-21/03 zebrasrv(9) [log] term="paul" nn=0 type=void count=0 12:07:25-21/03 zebrasrv(9) [log] user/system: 0/0 12:07:25-21/03 zebrasrv(9) [request] Search authorities OK 0 1 1+0 RPN @attrset Bib-1 @or @attr "1=Heading" @attr 7=1 0 @attr 4=6 @attr 5=1 @attr "1=Heading" paul 12:07:25-21/03 zebrasrv(9) [session] Connection closed by client 12:07:25-21/03 zebrasrv(9) [debug][log] zebra_register_close p=0x836ea20 regards liny

1 0

Advance search limits by language
by Shelley Sii 20 Mar '09

20 Mar '09

Dear all, Advance search limits by language is not working although I add a line 'language' =>'008:35-37' to NoZebraIndexes I read from CCL Indexing Chart which language only index from 041, but I think 008:35-37 will be more specific. Anyone can help? Shelley Sii 徐微菁 Assistant Librarian Logos Evangelical Seminary 正道福音神學院 Tel : 626-571-5110 ext.124 Fax : 626-571-5119 <http://www.logos-seminary.edu> www.logos-seminary.edu

1 0

MARC to Koha mapping of item records
by Beth Willis 20 Mar '09

20 Mar '09

Dear list, I am mapping item records from our current system to Koha. Not all of the fields in our item record are represented on the item linking table. For example, I don't see a Koha field for total checkouts in the items table. Is it possible to add this field? Can this be done through the GUI? Thanks for your help. -- Beth Willis Catalog & Digital Librarian North of Boston Library Exchange, Inc. Danvers, Massachusetts willis(a)noblenet.org

3 2