October 2003 - Koha - lists.katipo.co.nz

koha-2.0.0pre4 error
by muhammad aslam 03 Nov '03

03 Nov '03

Hi, I am trying to install koha on test machine for Kabul University library. The installation went smoothly and i can access both OPAC and intranet section of koha. But when i try to add new member or do any other modifications i get the following errors, the contents of my koha-rror_log file is as follows: " [Sat Oct 25 01:08:32 2003] [error] [client 65.162.19.211] data: at /usr/local/koha/intranet/cgi-bin/memberentry.pl line 69., referer: http://65.162.19.241:8080/cgi-bin/koha/member.pl [Sat Oct 25 01:08:32 2003] [error] [client 65.162.19.211] autoMemberNum is 1, referer: http://65.162.19.241:8080/cgi-bin/koha/member.pl [Sat Oct 25 01:08:32 2003] [error] [client 65.162.19.211] XX at /usr/local/koha/intranet/modules/C4/Koha.pm line 198., referer: http://65.162.19.241:8080/cgi-bin/koha/member.pl [Sat Oct 25 01:08:32 2003] [error] [client 65.162.19.211] XX at /usr/local/koha/intranet/modules/C4/Koha.pm line 198., referer: http://65.162.19.241:8080/cgi-bin/koha/member.pl [Sat Oct 25 01:08:37 2003] [error] [client 65.162.19.211] autoMemberNum is 1, referer: http://65.162.19.241:8080/cgi-bin/koha/member.pl [Sat Oct 25 01:08:37 2003] [error] [client 65.162.19.211] XX at /usr/local/koha/intranet/modules/C4/Koha.pm line 198., referer: http://65.162.19.241:8080/cgi-bin/koha/member.pl [Sat Oct 25 01:08:37 2003] [error] [client 65.162.19.211] XX at /usr/local/koha/intranet/modules/C4/Koha.pm line 198., referer: http://65.162.19.241:8080/cgi-bin/koha/member.pl [Sat Oct 25 01:08:42 2003] [error] [client 65.162.19.211] File does not exist: /usr/local/koha/intranet/htdocs/images, referer: http://65.162.19.241:8080/cgi-bin/koha/mainpage.pl?logout.x=1 [Sat Oct 25 01:08:46 2003] [error] [client 65.162.19.211] File does not exist: /usr/local/koha/intranet/htdocs/images, referer: http://65.162.19.241:8080/cgi-bin/koha/mainpage.pl?logout.x=1 [Sat Oct 25 01:14:37 2003] [error] [client 65.162.19.211] data: at /usr/local/koha/intranet/cgi-bin/memberentry.pl line 69., referer: http://65.162.19.241:8080/cgi-bin/koha/members-home.pl [Sat Oct 25 01:14:37 2003] [error] [client 65.162.19.211] autoMemberNum is 1, referer: http://65.162.19.241:8080/cgi-bin/koha/members-home.pl [Sat Oct 25 01:14:37 2003] [error] [client 65.162.19.211] XX at /usr/local/koha/intranet/modules/C4/Koha.pm line 198., referer: http://65.162.19.241:8080/cgi-bin/koha/members-home.pl [Sat Oct 25 01:14:37 2003] [error] [client 65.162.19.211] XX at /usr/local/koha/intranet/modules/C4/Koha.pm line 198., referer: http://65.162.19.241:8080/cgi-bin/koha/members-home.pl [Sat Oct 25 01:14:41 2003] [error] [client 65.162.19.211] autoMemberNum is 1, referer: http://65.162.19.241:8080/cgi-bin/koha/memberentry.pl?type=Add [Sat Oct 25 01:14:41 2003] [error] [client 65.162.19.211] XX at /usr/local/koha/intranet/modules/C4/Koha.pm line 198., referer: http://65.162.19.241:8080/cgi-bin/koha/memberentry.pl?type=Add [Sat Oct 25 01:14:41 2003] [error] [client 65.162.19.211] XX at /usr/local/koha/intranet/modules/C4/Koha.pm line 198., referer: http://65.162.19.241:8080/cgi-bin/koha/memberentry.pl?type=Add [Sat Oct 25 01:15:13 2003] [error] [client 65.162.19.211] could not find : /usr/local/koha/opac/htdocs/includes/acquisition-top.inc at /usr/local/koha/intranet/modules/C4/Output.pm line 360., referer: http://65.162.19.241:8080/cgi-bin/koha/acqui.simple/addbooks.pl [Sat Oct 25 01:16:56 2003] [error] [client 65.162.19.211] XX at /usr/local/koha/intranet/modules/C4/Koha.pm line 198., referer: http://65.162.19.241:8080/cgi-bin/koha/acqui.simple/addbooks.pl [Sat Oct 25 01:16:56 2003] [error] [client 65.162.19.211] XX at /usr/local/koha/intranet/modules/C4/Koha.pm line 198., referer: http://65.162.19.241:8080/cgi-bin/koha/acqui.simple/addbooks.pl [Sat Oct 25 01:17:04 2003] [error] [client 65.162.19.211] XX at /usr/local/koha/intranet/modules/C4/Koha.pm line 198., referer: http://65.162.19.241:8080/cgi-bin/koha/circ/circulation.pl [Sat Oct 25 01:17:04 2003] [error] [client 65.162.19.211] XX at /usr/local/koha/intranet/modules/C4/Koha.pm line 198., referer: http://65.162.19.241:8080/cgi-bin/koha/circ/circulation.pl [Sat Oct 25 01:17:12 2003] [error] [client 65.162.19.211] XX at /usr/local/koha/intranet/modules/C4/Koha.pm line 198., referer: http://65.162.19.241:8080/cgi-bin/koha/circ/branchtransfers.pl [Sat Oct 25 01:17:12 2003] [error] [client 65.162.19.211] XX at /usr/local/koha/intranet/modules/C4/Koha.pm line 198., referer: http://65.162.19.241:8080/cgi-bin/koha/circ/branchtransfers.pl [Sat Oct 25 01:17:29 2003] [error] [client 65.162.19.211] Premature end of script headers: stats.pl, referer: http://65.162.19.241:8080/cgi-bin/koha/reports-home.pl [Sat Oct 25 01:17:29 2003] [error] [client 65.162.19.211] ERROR: Date::Manip unable to determine TimeZone., referer: http://65.162.19.241:8080/cgi-bin/koha/reports-home.pl [Sat Oct 25 01:17:29 2003] [error] [client 65.162.19.211] !Date::Manip::Date_TimeZone called at /usr/lib/perl5/vendor_perl/5.8.0/Date/Manip.pm line 629, referer: http://65.162.19.241:8080/cgi-bin/koha/reports-home.pl [Sat Oct 25 01:17:29 2003] [error] [client 65.162.19.211] !Date::Manip::Date_Init() called at /usr/lib/perl5/vendor_perl/5.8.0/Date/Manip.pm line 1365, referer: http://65.162.19.241:8080/cgi-bin/koha/reports-home.pl [Sat Oct 25 01:17:29 2003] [error] [client 65.162.19.211] !Date::Manip::ParseDate('today') called at /usr/local/koha/intranet/cgi-bin/stats.pl line 55, referer: http://65.162.19.241:8080/cgi-bin/koha/reports-home.pl " thanks, - Aslam __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com

5 13

Greetings.
by Viktor 03 Nov '03

03 Nov '03

Greeting! It has taken place in a short time a lot. I was some time ago in the seminar of open software, in which, with lectures on the use of open software in our monastery and the future development in regard to them. In my lecture I also processed the KOHA library system. This lecture accomplished the surprising series of events. This series of events culminated in the announcement just received by me that Education ministry of Finland grants 11000 euros to the thorough testing, examining and localisation of the KOHA library system of the assistance to Finnish language. During this project all material to be produced, results and the possible modifications are available freely according to the principles of open software. In the project there are the monastery of Valamo, University of Oulu, the city library of Vaasa and the city library of Muurola involved. The following targets are examined and during the project are developed. 1. Localisation to Finnish language 2. Test listing using the UTF8 character set in the library of the monastery of Valamo. 3. Installation to the testing to city library of Vaasa, 550000 volumes and necessary conversion programs. 4. Cooperation with other library systems. -- Monk Viktor Valamo monastery http://www.valamo.fi

2 1

RE: [Koha] from ISIS to Koha
by Lucia Phillip 03 Nov '03

03 Nov '03

Hi, I know a number of libraries that would like to use Koha. Many of them are at present working with WINISIS. With the version 1.92 i was able to take MARC records exported as an ISO 2709 and import them into the breeding farm. i was then able to search for records and then import them into KOHA. To do this I reversed the changes that had been made to fit Winisis such as the subfield delimiters, the end of field and the end of record symbols. With this latest version however although I am able to import records into the breeding farm, when I go to Add biblio and do a search of a record that I know was among those imported, I get the message that <Nothing found>. I am wondering why this is happening with this version. Lucia Phillip National Library and Information System Authority Trinidad nad Tobago -----Original Message----- From: paul POULAIN [mailto:paul.poulain@free.fr] Sent: Monday, October 13, 2003 8:35 AM To: koha; Koha-devel Subject: [Koha] from ISIS to Koha Hi, I've a (future ?) customer that want to switch from winISIS to Koha. He sends me lot of exports, but none of them work with classic dumpmarc.pl script of Koha (refused by MARC::Record) Does anyone here know how to setup winISIS export options to get a valid iso2709 file ? Thanks -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org) _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

3 2

Re: [Koha] Greetings.
by Stephen Hedges 31 Oct '03

31 Oct '03

Wow, Viktor! Congratulations!! Stephen Hedges Nelsonville Public Library > Greeting! > > It has taken place in a short time a lot. > > I was some time ago in the seminar of open > software, in which, with > lectures on the use of open software in our > monastery and the future > development in regard to them. > > In my lecture I also processed the KOHA library > system. > > This lecture accomplished the surprising series > of events. > > This series of events culminated in the > announcement just received by me > that Education ministry of Finland grants 11000 > euros to the thorough > testing, examining and localisation of the KOHA > library system of the > assistance to Finnish language. > > During this project all material to be produced, > results and the > possible modifications are available freely > according to the principles > of open software. > > In the project there are the monastery of Valamo, > University of Oulu, > the city library of Vaasa and the city library of > Muurola involved. > > The following targets are examined and during the > project are developed. > 1. Localisation to Finnish language 2. Test > listing using the UTF8 > character set in the library of the monastery of > Valamo. 3. Installation > to the testing to city library of Vaasa, 550000 > volumes and necessary > conversion programs. 4. Cooperation with other > library systems. > > -- > Monk Viktor > Valamo monastery > http://www.valamo.fi > > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha >

3 2

z3950 problems
by T & J Kotula 30 Oct '03

30 Oct '03

Thanks for answers to my previous question. I got z3950 daemon going now, but I still can not make it work. RH8 and koha2pre5. 1. When I type ISBN number and then click on "z3950 search" link from addbiblio.pl, the z3950-daemon.log fills up with the following: Malformed UTF-8 character (1 byte, need 2, after start byte 0xc6) at /usr/local/koha/intranet/modules/C4/Biblio.pm line 2318. Malformed UTF-8 character (1 byte, need 2, after start byte 0xd0) at /usr/local/koha/intranet/modules/C4/Biblio.pm line 2319. Malformed UTF-8 character (1 byte, need 2, after start byte 0xd8) at /usr/local/koha/intranet/modules/C4/Biblio.pm line 2320. Malformed UTF-8 character (byte 0xfe) at /usr/local/koha/intranet/modules/C4/Biblio.pm line 2321. Malformed UTF-8 character (1 byte, need 3, after start byte 0xe6) at /usr/local/koha/intranet/modules/C4/Biblio.pm line 2322. ......... starting loop Library of Congress ==> at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 156. Processing isbn="0672316897" at Library of Congress z3950.loc.gov:7090 voyager (1 forks) Library of Congress ERROR: Can't call method "option" on an undefined value at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 157. z3950.loc.gov:7090 done. DBD::mysql::st execute failed: Lost connection to MySQL server during query at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 66. DBD::mysql::st fetchrow failed: Lost connection to MySQL server during query at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 68. DBD::mysql::st fetchrow failed: Lost connection to MySQL server during query at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 58. DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 123. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 124. DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 128. ........ 2. I'm still getting the same error I reported a couple of days ago, koha-error.log contains: search.pl : / / / at /usr/local/koha/intranet/cgi-bin/z3950/search.pl line 52. NO RANDOM at /usr/local/koha/intranet/cgi-bin/z3950/search.pl line 59. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/local/koha/intranet/modules/C4/Search.pm line 2438. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Search.pm line 2439. Can anyone help me with these ones? Thanks a lot tomasz kotula.

2 1

koha2pre5 questions
by T & J Kotula 30 Oct '03

30 Oct '03

Hi, Just downloaded koha2pre5 and I have a couple of questions: 1. /usr/local/koha/intranet/scripts/z3950daemon/z3950-daemon-launch.sh script is expecting z3950-daemon-options file which is not in the pre5 distribution. Can someone tell me what it should have in it. 2. When I click on 'z3950 search' from acqui.simple/addbiblio.pl?isbn=0534348238, koha-error fills up with the following error messages being repeated every 6 seconds: search.pl : / / / at /usr/local/koha/intranet/cgi-bin/z3950/search.pl line 52. NO RANDOM at /usr/local/koha/intranet/cgi-bin/z3950/search.pl line 59. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/local/koha/intranet/modules/C4/Search.pm line 2438. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Search.pm line 2439. koha-access has the following lines: "GET /cgi-bin/koha/z3950/search.pl?bibid=&random= HTTP/1.1" 200 1438 I'm running it on a standard RH8. Thanks for your help, if someone thinks they are bugs, let me know and I'll bug it. tomasz kotula.

4 6

Removal from list
by S. Rodulfo 28 Oct '03

28 Oct '03

Please remove me from your listserv Thanks again. Selwyn Rodulfo Librarian Regional Seminary St. John Vianney & the Uganda Martyrs Mt. St. Benedict, Tunapuna P.O. Box 4964, Trinidad Trinidad & Tobago 1(868) 662-4983 semlib(a)carib-link.net

1 0

Modifying Koha interface and fucntionality.
by Matthew Malthouse 26 Oct '03

26 Oct '03

Hi, Second question resulting from my first go at installing and using Koha. In principal html, perl and sql should allow modification of the interface and functionality very easily however my skills are not up to doing that cold. Does anyone have any howtos or recipies for useful changes? What I'd particularly like to do is have an "Add to bookshelf..." facility at some point in the acquisitions process; either a text entry field or a drop down of already defined bookshelves. Entering all the books and then returning to input ISBN's into the bookshelf entry form is going to be too tedious yet the bookshelves would appear to be the most useful feature for my anticipated browsing. If this already exists and I've missed it feel free to point out how stupid I am. :-) A request for WAP-ready XML in the archives gets a second vote from me too. I'd enable my WAP account for the ability to browse from a bookshop and forever end those "Have I got that already?" moments. Matthew

6 10

koha 2.0.0pre5 released
by paul POULAIN 25 Oct '03

25 Oct '03

Koha 2.0.0pre5 has been released here : http://sourceforge.net/project/showfiles.php?group_id=16466 RELEASE NOTES ============= This version of Koha is the last one of the 2.0.0 series in the "unstable" tree. 5 libraries are using it, so it's quite useable. 2 last problems have to be solved before 2.0.0RC1 : * biblio deletion : at the moment, biblio deletion is buggy (does not work in MARC, delete only non-marc data) * upgrader is provided for the 1st time, so it's probably buggy. If you want to use Koha, you're welcomed, but you're warned that this version still has some bugs and missing features. INSTALLATION ========== * Download the package * tar xvfz koha-version.tar.gz * cd koha-version * ./installer.pl * follow the instructions. NOTE: You will need to add lines to your main httpd.conf to include /etc/koha-httpd.conf and to make sure it is listening on the right ports (using the Listen directive). Previous versions updated the httpd.conf file, some users thought it was bad/poor decision. UPGRADE from previous 2.0.0preX version ======= * Download the package * tar xvfz koha-version.tar.gz * cd koha-version * ./koha.upgrade * follow the instructions. UPGRADE from previous 1.2.x version ======= This upgrade is possible with this release for the 1st time. EXPECT IT TO HAVE SOME BUGS SOMEWHERE. USE IT ONLY IF YOU KNOW HOW TO GO BACK TO PREVIOUS SITUATION. Otherwise, WAIT for next version or so. * Download the package * tar xvfz koha-version.tar.gz * cd koha-version * ./koha.upgrade * follow the instructions. * launch Koha * Go to Parameters >> Marc structure option and Koha-MARC links option. * Modify default MARC structure to fit your needs. * open a console/term * Enter : cd /path/to/koha/misc export PERL5LIB=/path/to/koha ./koha2marc.pl the old DB is "copied" in the new MARC one. Koha 2.0.0 is ready. BUGFIXES/IMPROVEMENTS ======= BUGS FIXED : +++++++++ 619 : Visiting selectbranchprinter.pl automatically resets branch 618 : Add member process does not check for duplicate barcode 532 : Can't assign new password without changing UserID 599 : edited items are stored incorrectly in old Koha DB (aka : barcode non mandatory bug) 616 : MARCgetbiblio doesn't create leader 500 : [INTRANET]Only 21 items are displayed in the search result 595 : 'Add field' link in /acqui.simple/addbiblio.pl adds incorrect field. 622 : processz3950queue fails 576 : add install locale test 39 : Update Dirs in z3950 scripts 536 : bulkmarcimport.pl generates subtitle error 436 : circulation.pl only partially templated (this bug is partially fixed) IMPROVEMENTS +++++++++ * Polish version of Koha (courtesy of Benedykt) * some useful tools in misc directory to manage the DB * adding "fines" entry in parameters section : to manage fees when a book is returned too late -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

1 0

z3950 searches failures
by Matthew Malthouse 23 Oct '03

23 Oct '03

Hi, I've been using Koha for about 18 hours now. Yup, installed last night. :-) And I've got some question about publicly accessible z39.50 servers for MARC records. First, looking through the archives I see a suggestion that a list of publicly available might be complied. Has this happened? If so a pointer would be gratefully received. Side note: is there any effort at a coordinated free catalogue like the freecddb.org for music CD's? This is a project solely for myself and there's no way I can afford to pay out usd 500 for a subscription. Second I'm frustrated by the searches I have been able to do. The Library of Congress is already in the install. I've found and configured British Library, Library of Scotland and a "free trial" at Itsmark.com. So far I'm really disappointed at the level of response. I've tried 6 books by ISBN (which is the obvious way as I've a bar code reader to input the number) 2 US and 4 UK and 2 by author name. The author search found only one (and didn't return the book I had) from the LOC. ISBN search also found only one - wish some humour it was the O'Reilly HTML Pocket Reference. Here's the log entry for that good result: Processing isbn="1565925793" at 1 z3950.loc.gov:7090 voyager (4 forks) Q: @attr 1=7 "1565925793" SPEED: 1 z3950.loc.gov:7090 done 1 z3950.loc.gov:7090 done. However I have a bunch - in fact hundreds - of errors for the same search on the Itsmark server: Processing isbn="1565925793" at 2 z3950.itsmarc.com:5666 LCCurrentZ (2 forks) Q: @attr 1=7 "1565925793" ERROR: Can't call method "option" on an undefined value at /var/www/library/koha/intranet/scripts/z3950daemon/processz3950queue line 163, <KC> line 22. z3950.itsmarc.com:5666 done. That log is 3387 lines long. I can't see what value is "undefined". Can anyone suggest something? Cheers, Matthew

2 2