- Koha - lists.katipo.co.nz

25 Apr '07

Two Parts: #1, first I would enter the ISBN number and do a Z39.50 search to get the Biblio info...after upgrading to 2.2.8 from 2.2.7 when I search it tries to download the 'search.pl' file rather than populating the fields in the biblio... ******** some of the error_log output ************ [Mon Apr 23 11:50:32 2007] [error] [client 66.14.52.238] something went wrong: No error at /var/www/koha/intranet/cgi-bin/z3950/search.pl line 134., referer: http://library.paasda.org/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isb… [Mon Apr 23 11:50:32 2007] [error] [client 66.14.52.238] doing the search at /var/www/koha/intranet/cgi-bin/z3950/search.pl line 144., referer: http://library.paasda.org/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isb… [Mon Apr 23 11:50:33 2007] [error] [client 66.14.52.238] connection 0: event 1 (connect), referer: http://library.paasda.org/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isb… [Mon Apr 23 11:50:33 2007] [error] [client 66.14.52.238] connection 0: event 6 (send apdu), referer: http://library.paasda.org/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isb… [Mon Apr 23 11:50:33 2007] [error] [client 66.14.52.238] connection 0: event 2 (send data), referer: http://library.paasda.org/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isb… [Mon Apr 23 11:50:45 2007] [error] [client 66.14.52.238] connection 0: event 3 (receive data), referer: http://library.paasda.org/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isb… [Mon Apr 23 11:50:45 2007] [error] [client 66.14.52.238] connection 0: event 7 (receive apdu), referer: http://library.paasda.org/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isb… [Mon Apr 23 11:50:45 2007] [error] [client 66.14.52.238] connection 0: event 6 (send apdu), referer: http://library.paasda.org/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isb… [Mon Apr 23 11:50:45 2007] [error] [client 66.14.52.238] connection 0: event 2 (send data), referer: http://library.paasda.org/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isb… [Mon Apr 23 11:50:46 2007] [error] [client 66.14.52.238] connection 0: event 3 (receive data), referer: http://library.paasda.org/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isb… [Mon Apr 23 11:50:46 2007] [error] [client 66.14.52.238] connection 0: event 7 (receive apdu), referer: http://library.paasda.org/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isb… [Mon Apr 23 11:50:46 2007] [error] [client 66.14.52.238] connection 0: event 9 (receive search), referer: http://library.paasda.org/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isb… [Mon Apr 23 11:50:46 2007] [error] [client 66.14.52.238] connection 0: event 10 (end), referer: http://library.paasda.org/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isb… [Mon Apr 23 11:50:46 2007] [error] [client 66.14.52.238] z3950.loc.gov at /var/www/koha/intranet/cgi-bin/z3950/search.pl line 160., referer: http://library.paasda.org/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isb… [Mon Apr 23 11:50:46 2007] [error] [client 66.14.52.238] 0 z3950.loc.gov error @attr 1=7 "/": Unsupported search (3) Missconfigured search, malformed at opac, referer: http://library.paasda.org/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isb… [Mon Apr 23 11:50:46 2007] [error] [client 66.14.52.238] Premature end of script headers: search.pl, referer: http://library.paasda.org/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isb… #2, now it seems that there are 7 or so REQUIRED fields that MUST be filled out in order to add an item...any way to change that? Should I just revert back to 2.2.7? If so, what are the steps for doing so? mv cgi-binDATE cgi-bin ? where DATE is the time/date stamp for when the upgrade occurred? and do the same for the htdocs? in both the opac and the intranet directories? Thanks, --Huck

2 1

migration assistance
by Daniel Armando Rodriguez 24 Apr '07

24 Apr '07

hi, at work we are using a windows based software called 'aguapey'. It uses marc format but i can´t figure out how to import those data into koha. Can you give me some generic steps to follow? regards ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Daniel Armando Rodriguez Departamento de Informática Ministerio de Cultura y Educación +54 (03752) 447613 int. 161

1 0

Koha mysql error
by Dennis B. Mendiola 24 Apr '07

24 Apr '07

I need help. I believe, anyone here could be my savior. I installed Koha 2.2.8 on a Fedora Core 5 with Apache 2.2.4, MySQL 5.0.37. In the Perl Modules, I got this message in red: PERL MODULES Checking perl modules ... Subroutine PDF::API2::Resource::Font::Postscript::O_RDONLY redefined at /usr/lib/perl5/5.8.8/Exporter.pm line 65. at /usr/lib/perl5/site_perl/5.8.8/PDF/API2/Resource/Font/Postscript.pm line 46 The installation proceeded but when I got to the database portion, here's what I got: CREATING DATABASE Creating the MySQL database for Koha... ERROR 1045 (28000): Access denied for user 'kohaadmin'@'localhost' (using password: YES) DBI connect('Koha:localhost','kohaadmin',...) failed: Access denied for user 'kohaadmin'@'localhost' (using password: YES) at /usr/local/koha/intranet/modules/C4/Context.pm line 411 Can't call method "prepare" on an undefined value at scripts/updater/updatedatabase line 1553. Problem updating database... I logged in as root to the mysql server, and then repeated the process. Here's what I got: ROOT USER PASSWORD To create the koha database, please enter your mysql server's root user password: Password: CREATING DATABASE Creating the MySQL database for Koha.../usr/local/mysql/bin/mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'Koha'; database exists' ERROR CREATING DATABASE Couldn't connect to the MySQL server for the reason given above. This is a serious problem, the database will not get installed. Press <ENTER> to continue: DBI connect('Koha:localhost','kohaadmin',...) failed: Access denied for user 'kohaadmin'@'localhost' (using password: YES) at /usr/local/koha/intranet/modules/C4/Context.pm line 411 Can't call method "prepare" on an undefined value at scripts/updater/updatedatabase line 1553. Problem updating database... What's the problem here? I used the same root password for mysql. I'd appreciate anybody's help. Thanks so much. -- Dennis B. Mendiola Philippines

3 2

Re: [Koha] About Installation
by Ata ur Rehman 23 Apr '07

23 Apr '07

Dear Khaled I will advice you to read and learn about MARC format. There is no MFN and ACC No Field in MARC but you can use locally assigned numbers in 9xx tags. For example in koha, MARC code 952$p is used for barcode which is like Acc number in Winisis. Similarly you can use Biblio Record No instead of MFN. You can add multiple copies of one title in one Biblio Record number. Regards, Ata On 4/22/07, Mohammed Abu Khaled Chowdhury <makc75(a)yahoo.com> wrote: > > Dear Sir, > Thanks for the information regarding the Z39.50 features. Yes, I have seen > that there is a option in Koha 2.2.7 version. But I have not yet used the > option. Last few days I am trying to familiar with the some basic function > in Koha. I was familiar with WINISIS and Koha is more complicated than > winisis as it has more option than WINSIS. > > Anyway I have not found the fields of Accession no., Number of copies and > MFN number in MARC format which is very important both in Catalogue and > Circulation. In Winisis, we mentioned all the accession numbers (if multiple > copies of the same books available) and MFN number automatically given by > the software. Would you pls help me how can I get this option in Koha. > > Also do you have any introductory guide on koha operation manual? > > Best Regards, > Khaled > > > *Ata ur Rehman <ata.rehman(a)gmail.com>* wrote: > > Dear > > Congratulations, if you are going to install koha on linux just for Z39.50, > then you dont need to do that. Z39.50 features are now available at > windows too (Koha 2.27 for Windows) > > Ata > > On 4/18/07, Mohammed Abu Khaled Chowdhury <makc75(a)yahoo.com> wrote: > > > > *Dear Ferraro and Rehman,* > > *Thanks for your information regarding koha installation. Finally we > > have successfully installed the software(Windows version). I am now trying > > to familier with the software. At the same time I'm trying to install it > > into Linux for its Z39.50 features. If I face any problem, I hope I'll > > get kind help from u.* > > ** > > *Thanks* > > *Khaled* > > > > *"Joshua M. Ferraro" < jmf(a)liblime.com>* wrote: > > > > Hi Mohammed, > > > > > ----- Original Message ----- > > > From: "Mohammed Abu Khaled Chowdhury" > > > We are trying to Install Koha in Windows platform for the > > > first time in our library. Would u pls let me know about > > > the workable version of Koha, Perl, Apache and MySql and > > > give me necessary link (web address) to download the > > > programmes. Also I am looking useful documentation on Koha > > > on Installation, Data input, circulation module, > > > modification etc. > > You might want to check out the Koha for Windows installation > > package: > > > > http://www.koha.rwjr.com/ > > > > Also, please see http://kohadocs.org if you need help with > > user and administrative documentation. > > > > Hope that helps, let us know if you have additional questions. > > > > Sincerely, > > > > -- > > Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE > > President, Technology migration, training, maintenance, support > > LibLime Featuring Koha Open-Source ILS > > jmf(a)liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS > > > > > > ------------------------------ > > Ahhh...imagining that irresistible "new car" smell? > > Check out new cars at Yahoo! Autos.<http://us.rd.yahoo.com/evt=48245/*http://autos.yahoo.com/new_cars.html;_ylc…> > > > ------------------------------ > Ahhh...imagining that irresistible "new car" smell? > Check out new cars at Yahoo! Autos.<http://us.rd.yahoo.com/evt=48245/*http://autos.yahoo.com/new_cars.html;_ylc…>

1 0

Bookbag "Send" Email Probems and Virtual Shelves Not Working
by Chartrand, Michael 20 Apr '07

20 Apr '07

We'd love to be able to use the "bookbag" feature in the OPAC, but when a patron sends an email to me with their bookbag items in it, I have no idea who it's from as Koha always uses my email address [the system administrator] as the "sender" and does not include the patron's email address or record number. My second problem is that I would love to use the Virtual Shelves as well, but when I select an item and then click on "Add to Virtual Shelf", nothing happens---the window just sits there! Not sure what's going on there. Any advice/help you could render would be appreciated. Michael K Chartrand Library Technician Hunter-Rice Health Sciences Library Samaritan Medical Center Watertown, NY 13601 Phone: 315-785-4191 FAX 315-779-5173 email: mchartrand(a)shsny.com

2 1

Koha Marc Fields
by sgmurphy19＠sbcglobal.net 19 Apr '07

19 Apr '07

We just installed Koha and have finished a trial run to see if it is a program that will work for us (i.e. replace Athena). We feel it has everything we need. Now we need a little push to help us set it up. So this may be the first of many questions to come :) I set up a Biblio-Framework (biblio-framework.pl) for our organization and can see all the Marc Fields. But when an admin goes to add a biblio (addbiblio.pl), not all the fields are seen there. What needs to be done in order to set the fields we want to see for biblio records we create? Thank you, Sean Murphy Botanical Research Institute of Texas sgmurphy(a)brit.org

1 0

Re: [Koha] About Installation
by Ata ur Rehman 18 Apr '07

18 Apr '07

Dear Congratulations, if you are going to install koha on linux just for Z39.50, then you dont need to do that. Z39.50 features are now available at windows too (Koha 2.27 for Windows) Ata On 4/18/07, Mohammed Abu Khaled Chowdhury <makc75(a)yahoo.com> wrote: > > *Dear Ferraro and Rehman,* > *Thanks for your information regarding koha installation. Finally we have > successfully installed the software(Windows version). I am now trying to > familier with the software. At the same time I'm trying to install it into > Linux for its Z39.50 features. If I face any problem, I hope I'll get kind > help from u.* > ** > *Thanks* > *Khaled* > > *"Joshua M. Ferraro" <jmf(a)liblime.com>* wrote: > > Hi Mohammed, > > > ----- Original Message ----- > > From: "Mohammed Abu Khaled Chowdhury" > > We are trying to Install Koha in Windows platform for the > > first time in our library. Would u pls let me know about > > the workable version of Koha, Perl, Apache and MySql and > > give me necessary link (web address) to download the > > programmes. Also I am looking useful documentation on Koha > > on Installation, Data input, circulation module, > > modification etc. > You might want to check out the Koha for Windows installation > package: > > http://www.koha.rwjr.com/ > > Also, please see http://kohadocs.org if you need help with > user and administrative documentation. > > Hope that helps, let us know if you have additional questions. > > Sincerely, > > -- > Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE > President, Technology migration, training, maintenance, support > LibLime Featuring Koha Open-Source ILS > jmf(a)liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS > > > ------------------------------ > Ahhh...imagining that irresistible "new car" smell? > Check out new cars at Yahoo! Autos.<http://us.rd.yahoo.com/evt=48245/*http://autos.yahoo.com/new_cars.html;_ylc…>

1 0

Koha DB framework mapping problem and side effects
by Anthony Manzo 18 Apr '07

18 Apr '07

Hi, I am unable to return anything from subject searches in OPAC although when I look at the bibliosubject.subject field within the mysql db the data I am searching for does exist (and there are numbers in the bibliosubject.biblionumber fields as well). I setup my framework to have MARC field 650a link to bibliosubject.subject. Additionally, when I run the MARC Check I receive no errors. Two important side notes: 1. When I do the OPAC 'any word' search I DO return results. 2. When I run the rebuildnonmarc perl script after adjusting the framework I receive an error but it does seem to make the changes ( or perhaps this is the cause of the problem) -- This error follows my email becuase it is quite long. I am running Koha v2.27 Thanks for any help. Best, Tony Manzo The Salk Institute ! Error Msg begins here: where biblioitemnumber = at /usr/lib/perl5/site_perl/5.8.5/C4/Biblio.pm line 1819. DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at misc/rebuildnonmarc.pl line 99. .DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 22 at /usr/lib/perl5/site_perl/5.8.5/C4/Biblio.pm line 1817. Update biblioitems set itemtype = NULL, url = 'http://www.sciencedirect.com/science/journal/09442006', isbn = NULL, issn = '0944-2006', publishercode = 'G. Fischer,', publicationyear = NULL, classification = NULL, dewey = NULL, subclass = NULL, illus = 'ill.', pages = NULL, volumeddesc = NULL, volumedate = NULL, notes = NULL, size = NULL, place = 'Jena, Germany :', volume = NULL, number = NULL, lccn = NULL where biblioitemnumber = at /usr/lib/perl5/site_perl/5.8.5/C4/Biblio.pm line 1819. DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at misc/rebuildnonmarc.pl line 99. DBD::mysql::st execute failed: Column 'biblionumber' cannot be null at /usr/lib/perl5/site_perl/5.8.5/C4/Biblio.pm line 1895. 2350 MARC record done in 53.7834188938141 seconds

1 0

marc_sbufields_structure.pl - koha 2.0
by robin ros 17 Apr '07

17 Apr '07

hi everyone, i have an error in my koha 2.0, ( i know there is the koha 2.8 now, but is very hard to translate to spanish so i keep with that if it possible), when i try to edit marc subfields, the koha error in the log is: [Tue Apr 17 04:34:36 2007] [error] [client xxx.xxx.xxx.xxx] Premature end of script headers: marc_subfields_structure.pl, referer: http://zzz.zzz.zzz.zzz.:8080/cgi-bin/koha/admin/marc_subfields_structure.pl… [Tue Apr 17 04:43:54 2007] [error] [client xxx.xxx.xxx.xxx] can't opendir ../value_builder: No such file or directory at /usr/local/koha/intranet/cgi-bin/admin/marc_subfields_structure.pl line 137., referer:http://zzz.zzz.zzz.zzz:8080/cgi-bin/koha/admin/marc_subfields_structure.pl?tagfield=245 and in the browser give the option to download the marc_subfields_structure.pl archive, can anyone helpme please??, thanks a lot for you help regards robin PD: sorry my english

1 0

How can I export koha bibliography into csv file (or excel)
by Hero_xbd!.RRR 15 Apr '07

15 Apr '07

Our university authority need each department to report books in excel format. Is there a neat way to generate a excel spreadsheet containing the required MARC fields? Thanks in advance! -- Xu Benda Fundamental Science of Mathematics and Physics, Tsinghua University, Beijing, P.R.China, 100084 tel:86-10-51531861 http://learn.tsinghua.edu.cn:8080/2005012177

2 3