January 2004 - Koha - lists.katipo.co.nz

List of what each field in the various tables do
by Freddie Cash 21 Apr '04

21 Apr '04

We're just starting out with Koha 2.0 to see if it could be used as a replacement for Follett. However, we are running into a few snags that should be fairly simple to fix. Our major snag is lack of documentation for the internals of Koha. For instance, is there a description of the various database tables, and what each field is used for? This would make mapping fields to MARC fields much simpler. We're running into problems with our mappings, especially with the distinction between items and biblioitems, for instance. Is this kind of low-level documentation available anywhere?? -- Freddie Cash District HelpDesk / Network Admin fcash(a)sd73.bc.ca helpdesk(a)sd73.bc.ca (250) 377-HELP [(250) 377-4357]

5 4

marc records...
by ablackie＠mailer.fsu.edu 30 Jan '04

30 Jan '04

Hello all, Could someone kindly tell us what to do to uplaod bulk marc records? We have tried doing it but it did not give the following information: Itemtype Class Location Date due last Seen Barcode We are using version 1.2.2, what do we do to upgrade? Thanks for your kind support, Anthony

2 1

client configuration
by Stefanie Mohsennia 30 Jan '04

30 Jan '04

Dear all, I volunteer for a library considering to set up a Koha library system, we are still in the planning stage. Are there any recommendations for the clients, e.g. computer at the desk with lending functions, cataloguing computer etc.? Thank you all for your support! Greetings from Germany, Stefanie Mohsennia

1 0

Re: Problems with Z3950 searching
by T & J Kotula 30 Jan '04

30 Jan '04

I'm still having z3950 problems :-( I downloaded RC3 (which I noticed has Paul's proposed solution: > Kudos, that's it, i'm (almost) sure. > On line 246, replace : > my $stj=$dbh->prepare("update .... > by > my $stj=$dbi->prepare("update .... However I still have the same problem with >DBD::mysql::st execute failed: MySQL server has gone away at >>/usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 136. I also tried adding another of Paul's solutions: > my $dbh = C4::Context->dbh; > Please, copy the line 107 after the while(1), on line 131, just after > print "starting loop\n"; but to no avail. Someone else also suggested increasing mysql's connect_timeout. I thought adding 'connect_timeout=15' to /etc/my.cnf [mysql_server] section would do it - but it didn't change the timeout, so I can not verify if this is a fix or not. As before - could anyone help me please. Thanks tomasz kotula.

1 0

Koha2.0.0RC3 released
by paul POULAIN 28 Jan '04

28 Jan '04

As stated yesterday, I've released a 2.0.0RC3 version of Koha. This version is mostly interesting for french users. Other may wait until 2.0.0RC4 (or 2.0.0 final ?) BUGS FIXED since 2.0.0RC2 : * LOT of bugs in french translation * fixed bug in z3950 client daemon that makes "mySQL connection lost during query". * 605 : circulation.pl only shows one waiting item * 293 : Error Issuing Book - 1 IMPROVEMENTS since 2.0.0RC2 : NONE -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

1 0

Re: [Koha] Problems with Z3950 search
by paul POULAIN 28 Jan '04

28 Jan '04

dmoses2(a)uwo.ca wrote: >I didn't send this to the list, because it might be a false lead. >It talks about the problem of running two processes... >Have a look at. >http://www.mail-archive.com/dbi-users@perl.org/msg18091.html > Kudos, that's it, i'm (almost) sure. On line 246, replace : my $stj=$dbh->prepare("update z3950results set active=1 where id=?"); by my $stj=$dbi->prepare("update z3950results set active=1 where id=?"); As $dbh is defined BEFORE the fork, and may create the problem, while $dbi is defined INSIDE the if{} following the fork and is a process-specific handler. confirm this works on the list pls. -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

1 0

upgrade to 2.0.0RC2
by Tony Adams 28 Jan '04

28 Jan '04

I installed koha from "koha-1.2.3.tar.gz", and now wish to upgrade to V2.0.0 I have a copy of "koha-2.0.0RC2.tar.gz", but if I try "perl koha.upgrade" it complains about not knowing the version that is currently installed. Now, a bit of code investigation suggests that: * this is because the line "kohaversion=foo" is missing from "/etc/koha.conf", * install.pm is going to set this to "1.3.3RC26". Q.1: What should "kohaversion=" before I upgrade? Q.2: Why is Install.pm going to set this to "1.3.3RC26", and not "2.0.0"? Q.3: No "kohaversion=" line is present in any of the examples or hints about the config file. If this is important to koha why not? Thanks Tony NOTICE & DISCLAIMER This email including attachments (this "Document") is confidential and may contain legally privileged information. If you have received this Document in error please notify the sender immediately and delete this Document from your system without using, copying, disclosing or disseminating it or placing any reliance upon its contents. We cannot accept liability for any breaches of confidence arising through use of this Document. The information contained in this Document is provided solely for information purposes on an "as is" basis without warranty of any kind, either express or implied, including without limitation any implied warranty of satisfactory or merchantable quality, fitness for a particular purpose or freedom from error or infringement. The user relies on the information contained herein, and its accuracy or otherwise, entirely at their own risk. Any opinions expressed in this Document are those of the author and do not necessarily reflect the opinions of Telsis. We will not accept responsibility for any commitments made by our employees outside the scope of our business.

2 1

Re: [Koha] Problems with Z3950 search
by paul POULAIN 28 Jan '04

28 Jan '04

dmoses2(a)uwo.ca wrote: >Thanks Paul: > >I've checked the items you suggested. And as far as I know all appears to be >set correctly. >- I am doing an ISBN search. >- as far as I know the fields are linked. >- I've checked my marc_breeding table and it has the correct field. > >Hey ... I've just got it working ... >Oh my god.... The ISBN number has to be entering in the ISBN field of the >addbiblio.pl page as well. > :-) >That is foolish ... the ISBN is carried in the url, why doesn't it get dumped >to the form. I'm going to rewrite it so the value get passed into the form too. >I bet that's the problem that the other folks are having too. >Thanks for all the help Paul. I feel REALLY stupid. > > You're not stupid. I agree it's really poor not to carry ISBN to the addbiblio.pl screen too. But it's really a pain to do, as Koha support any MARC flavour, and ISBN/title/author is NOT in the same field/subfield in every MARC flavour. So we had to find in which subfield the ISBN/title/author is hidden... for T. Kotula : > DBD::mysql::st execute failed: MySQL server has gone away at > /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 136. No, I don't know why this happends. I sometimes (rarely) had this problem, and haven't found a solution yet. -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

2 2

Fw: [Koha] Problems with Z3950 search
by T & J Kotula 28 Jan '04

28 Jan '04

Thanks Paul, > After a look in Search.pm, I see 2 possibilities : > * did you type an ISBN, or a title, or an author, BEFORE clicking on > "z3950 search". Because the search can be done only on those 3 fields > for instance. I foolishly thought that koha remembered ISBN from acqui.simple/addbooks.pl page (it kind of does because acqui.simple/addbiblio.pl?isbn=0596003137 contains ISBN number). OK now when I type ISBN into acqui.simple/addbiblio.pl?isbn=0596003137 and hit "z3950 search" the error log fills up with: starting loop 913/1 : Processing isbn=0596003137 at Library of Congress z3950.loc.gov:7090 voyager USMARC (1 forks) 913/1 : 2 >> 913/1 : creating and 913/1 : working on results entry 1 913/1 : connected to Library of Congress 913/1 : Library of Congress : no records found 913/1 : z3950.loc.gov:7090 search done. DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 136. DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 139. DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 144. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 145. where DBD lines just keep repeating. Any idea what broke it??? > * did you "link" ISBN & title & author MARC21 field to the corresponding > biblio or biblioitems in mySQL table. > A 3rd possibility : what's the structure of marc_breeding table. > For me it contains a z3950random varchar(40) field (even on 200RC2 DB > installed from scratch. i don't think there is a bug here) Not being a librarian nor a mysql guru I don't understand these two comments - hopefully will not have to:-) Last question. Can I batch LOC lookups or do I have to finish entering one biblio before issuing the next lookup? Thanks again tomasz kotula.

1 0

2.0.0RC3 tomorrow for french only
by paul POULAIN 27 Jan '04

27 Jan '04

Hi, Tomorrow, i'll release a 2.0.0RC3. It will include only fixes for french translation, as the 2.0.0RC2 had a dirty french version. No upgrade needed for english installations. -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

1 0