- Koha - lists.katipo.co.nz

installation help for newbie
by David Bucknell 25 Feb '02

25 Feb '02

Hi, I just installed koha and opac on a Red Hat 7.2 server with mysql. I set up the database. I made an alias to /koha and another to opac and put both in /usr/local/share/opac/htdocs and /usr/local/share/koha/htdocs I used the apache cgi-bin and put the koha scripts in there I put the C4 dir in the site_perl path (below it, actually) In short, I _sort of_ followed the directions. Now the Web sites work, the search engine _tries to work_, but none of the links to acquisitions, etc work. Guesses so I can ask the right question? Thank you, David Bucknell -- http://www.iteachnet.org http://members.iteachnet.org http://opensourceschools.org http://schoolforge.net member ------------------------------------------------ http://members.iteachnet.org/ http://www.opensourceschools.org/

3 2

searching?
by Adam Thick 20 Feb '02

20 Feb '02

haven't got any problems with the scripts themselves, so no, don't have anything in the apache logs... thought it might have more to do with the database, extracted some of the SQL from the Search.pm. This one works fine, nice and simple : "Select * from biblio where ((title like 'adam%' or title like '% adam%')) or ((author like 'adam%' or author like '% adam%')) or ((seriestitle like 'adam%' or seriestitle like '% adam%')) or ((notes like 'adam%' or notes like '% adam%')) order by title limit 0,10" Get no results from this query though. There's no data in some of these tables. I was wondering whether all data gets entered using the simple Acquistions page? Or is there extra data that I need to enter? "Select * from biblio,bibliosubtitle,biblioitems where biblio.biblionumber=biblioitems.biblionumber and biblio.biblionumber=bibliosubtitle.biblionumber and (((title like 'adam%' or title like '% adam%')) or ((subtitle like 'adam%' or subtitle like '% adam%')) or ((seriestitle like 'adam%' or seriestitle like '% adam%')) or ((biblio.notes like 'adam%' or biblio.notes like '% adam%')) or ((biblioitems.notes like 'adam%' or biblioitems.notes like '% adam%'))) group by biblio.biblionumber" Cheers, Adam Thick.

2 1

(no subject)
by Adam Thick 20 Feb '02

20 Feb '02

Hi, me again... I forgot to mention that I'm using scripts downloaded from CVS... I'm also getting a few problems with the insertion of MARC data? This is the error I get from the apache logs... I figure it's a table that's missing but any info on that would be a great help. =) DBD::mysql::st execute failed: Table 'Koha.uploadedmarc' doesn't exist at /usr/local/www/koha/cgi-bin/koha/acqui.simple/marcimport.pl line 1045. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/www/koha/cgi-bin/koha/acqui.simple/marcimport.pl line 1047. DBD::mysql::st execute failed: Table 'Koha.uploadedmarc' doesn't exist at /usr/local/www/koha/cgi-bin/koha/acqui.simple/marcimport.pl line 159, <fh00001S%3A\Clients\Philanthrophy Australia\MARC\VPHY-B.PRD000022649.PRD> line 1. DBD::mysql::st execute failed: Table 'Koha.uploadedmarc' doesn't exist at /usr/local/www/koha/cgi-bin/koha/acqui.simple/marcimport.pl line 1045, <fh00001S%3A\Clients\Philanthrophy Australia\MARC\VPHY-B.PRD000022649.PRD> line 1. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/www/koha/cgi-bin/koha/acqui.simple/marcimport.pl line 1047, <fh00001S%3A\Clients\Philanthrophy Australia\MARC\VPHY-B.PRD000022649.PRD> line 1. Adam Thick.

1 0

searching?
by Adam Thick 19 Feb '02

19 Feb '02

G'day, have recently installed Koha and am having a little problem with returning results from the catalogue search. Have actually just entered dummy data using the acquisitions page, we used systemprefs and are using the simple page. I return results when the opac-search.pl is run but don't return data when searching from catalogue, the search.pl script... Any ideas? Cheers, Adam Thick

1 0

Release of software under open source license
by Andrew McMillan 16 Feb '02

16 Feb '02

Hi, I hope you don't mind this off-topic post (please reply off-list if you think this is impertinent :-) I am currently involved in a project to produce software for a public service in New Zealand and consideration is being given to releasing the resulting software under the [MG]PL. I would really appreciate hearing from the Koha team on their experiences in this process. The key issue for us at present is the (somewhat lame?) one of 'security through obscurity' that you get by not telling everyone how you did this. Any and all experiences would be interesting to me. Once again, I apologise for intruding. As an open-source developer (I am a member of the Debian project, and could package Koha for Debian if you wish me to) I have followed Koha with some interest. If you consider this off-topic then please abuse me in private :-) Kind regards, Andrew McMillan -- -------------------------------------------------------------------- Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington WEB: http://catalyst.net.nz/ PHYS: Level 2, 150-154 Willis St DDI: +64(4)916-7201 MOB: +64(21)635-694 OFFICE: +64(4)499-2267 Are you enrolled at http://schoolreunions.co.nz/ yet?

2 1

small bug or bad installation + a question
by paul POULAIN 14 Feb '02

14 Feb '02

1 0

Pending release of 1.2.0
by Tonnesen Steve 14 Feb '02

14 Feb '02

I'm working on a release candidate for Koha 1.2.0. I have a working Debian package, and an untested RPM package. I have no redhat machines to test it on. Are there any volunteers? A volunteer who will install the package and report back to me on the multitude of errors that will invariably result would be okay, a volunteer who has a test machine that I can get root access on would be even better. Big caveat: This package still isn't ready for upgrading production systems. New installs of Koha only for the moment. I need to determine what has changed in the database schema so that production systems can be updated properly. Steve.

2 1

[Fwd: [oss4lib-discuss] Use of Open Source ILS]
by Ben Ostrowsky 12 Feb '02

12 Feb '02

-----Forwarded Message----- From: Marshall Breeding <Breeding(a)LIBRARY.Vanderbilt.edu> To: oss4lib-discuss(a)lists.sourceforge.net Subject: [oss4lib-discuss] Use of Open Source ILS Date: 12 Feb 2002 10:23:25 -0600 I am interested in studying the progress of the use of Open Source library automation systems. To this end, I'm asking that any libraries that have implemented an open source ILS (Koha, Open Book, or any others) register on my lib-web-cats directory: http://staffweb.library.vanderbilt.edu/breeding/libwebcats.html Just click on the link to "submit" your library's information. This information would then be available to anyone else, since the "Advanced Search" page of lib-web-cats allows you to search by library automation system. thanks, -marshall ----------------- Marshall Breeding Library Technology Officer Vanderbilt University 419 21st Avenue South Nashville, TN 37240 Phone: (615) 343-6094 Fax (615) 343-8834 http://staffweb.library.vanderbilt.edu/breeding breeding(a)library.vanderbilt.edu _______________________________________________ oss4lib-discuss(a)lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/oss4lib-discuss see also http://www.oss4lib.org/

1 0

how to administer some tables + (small) bug in distro
by paul POULAIN 12 Feb '02

12 Feb '02

3 2

Script Modifications
by Larry Currie 06 Feb '02

06 Feb '02

I am attempting to modify some of the Perl scripts in Koha so that they conform to our local conditions. In the moremember.pl script, for instance, I have changed the ethnic classifications and I rewrote the checkdigit subroutine to reflect the type of patron barcodes we use. But I am not seeing these changes reflected in the koha intranet when I attempt to register new patrons. What do I need to do in order to have these changes take effect? I stopped and restarted the Apache server thinking that this would do it, but to no avail. The text of my changes is given below. Larry Currie Changes made to Perl script moremember.pl: my %env; print $input->header; #start the page and read in includes print startpage(); print startmenu('member'); my $data=borrdata('',$bornum); my @temp=split('-',$data->{'dateenrolled'}); $data->{'dateenrolled'}="$temp[2]/$temp[1]/$temp[0]"; @temp=split('-',$data->{'expiry'}); $data->{'expiry'}="$temp[2]/$temp[1]/$temp[0]"; @temp=split('-',$data->{'dateofbirth'}); $data->{'dateofbirth'}="$temp[2]/$temp[1]/$temp[0]"; if ($data->{'ethnicity'} eq 'white'){ $data->{'ethnicity'} = 'White'; } if ($data->{'ethnicity'}eq 'black'){ $data->{'ethnicity'} = 'Black'; } if ($data->{'ethnicity'}eq 'american indian'){ $data->{'ethnicity'} = 'American Indian'; } if ($data->{'ethnicity'}eq 'asian and pacific islander'){ $data->{'ethnicity'} = 'Asian and Pacific Islander'; } print <<printend Changes made to subroutine checkdigit in Input.pm: sub checkdigit { my ($env,$infl) = @_; $infl = uc $infl; my $sum1; my $sum2; my $sum3; my $i = 0; my $j = 1; my $valid = 0; # print $infl."<br>"; while ($i <14) { my $temp1 = substr($infl,$i,1); if ($temp1 = 0) { $temp1 = 0; } elsif ($temp1 = 1) { $temp1 = 2; } elsif ($temp1 = 2) { $temp1 = 4; } elsif ($temp1 = 3) { $temp1 = 6; } elsif ($temp1 = 4) { $temp1 = 8; } elsif ($temp1 = 5) { $temp1 = 0; } elsif ($temp1 = 6) { $temp1 = 3; } elsif ($temp1 = 7) { $temp1 = 5; } elsif ($temp1 = 8) { $temp1 = 7; } elsif ($temp1 = 9) { $temp1 = 9; $sum1 = $sum1 + $temp1; # print "$sum $temp1 $temp2<br>"; $i = $i + 2; } while ($j < 13) { my $temp2 = substr($infl,$j,1); $sum2 = $sum2 + $temp2; $j = $j + 2; } $sum3 = $sum1 + $sum2; my $rem = 10 - ($sum3%10); } #print $rem."<br>"; if ($rem eq substr($infl,13,1)) { $valid = 1; } return $valid; } END { } # module clean-up code here (global destructor) -- Lawrence W. Currie User Services Librarian California Academy of Sciences Golden Gate Park San Francisco, CA 94118 lcurrie(a)calacademy.org (415) 750-7108 (415) 750-7106 fax http://www.calacademy.org/research/library/

2 1