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

Re: [Koha] Authorization problems between Koha and Mysql
by csg7142＠students.kennesaw.edu 05 Nov '04

05 Nov '04

4 13

Koha - copyright date
by Bernadette Cassidy 02 Nov '04

02 Nov '04

Hi, Since the upgrade of Koha to version 2.0, I've noticed when adding new items that Koha doesn't display the publication date - see attached catalogue record. Does anyone know why?! Kind regards, Bernadette Bernadette Cassidy Library & Learning Coordinator Allan Bean Centre for Research and Learning in Rehabilitation Private Bag 4708 Christchurch Tel: (03) 383 9492 Fax (03) 383 7500 Email: bernadettec(a)burwood.org.nz <mailto:bernadettec@burwood.org.nz>

2 1

Re: Thanks :)
by Olwen 29 Oct '04

29 Oct '04

1 0

Server Error: opac-main.pl, path problem
by Library 29 Oct '04

29 Oct '04

I tried to install koha-2.0.1. After installtion, the home page cgi-bin/koha/opac-main.pl, in browser gave following error. > The server encountered an internal error and was unable to complete > your request. Error message: Premature end of script headers: opac-main.pl On manual running it gave following error: > [root@glide cgi-bin]# ./opac-main.pl > Can't locate C4/Auth.pm in @INC (@INC contains: > /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 > /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi > /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl > /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi > /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl > /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 .) at > ./opac-main.pl line 7. > BEGIN failed--compilation aborted at ./opac-main.pl line 7. > [root@glide cgi-bin]# If I include path like perl -I /usr/local/koha/intranet/modules/ opac-main.pl , then it executed fine. On using: export PERL5LIB="/usr/local/koha/intranet/modules" it runs fine, when used as ./opac-main.pl and [root@glide cgi-bin]# export shows following: declare -x PERL5LIB="/usr/local/koha/intranet/modules" But through browser, it gave same error of "Premature end of script headers: opac-main.pl". What will be solution? -- H.S.Rai

3 2

Authorization problems between Koha and Mysql
by csg7142＠students.kennesaw.edu 29 Oct '04

29 Oct '04

My apologies if this issue has been addressed previously, I didnt find it in the archives. After logging into Koha the login screen keeps appearing again after clicking on a new link. We where able to add a branch but no books or new users. The Mysql Koha tables are empty. Any help would be beneficial. We are running: http://localhost:8080/cgi-bin/koha/about.pl Koha version: 2.0.1RC1 OS version (from 'uname -a'): OpenBSD 3.4 GENERIC#18 i386 Perl version: 5.008 MySQL version: 3.23.58 Apache version: Apache/1.3.28 (Unix) mod_ssl/2.8.15 OpenSSL/0.9.7b bash-2.05b# less /usr/local/koha/log/koha-error_log [Thu Oct 28 00:08:20 2004] [error] [client ###.###.###.###] File does not exist: /usr/local/koha/intranet/htdocs/favicon.ico DBD::mysql::st execute failed: Unknown column 'password' in 'field list' at /usr/local/koha/intranet/modules/C4/Auth.pm line 351. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Auth.pm line 353. DBD::mysql::st execute failed: Unknown column 'password' in 'field list' at /usr/local/koha/intranet/modules/C4/Auth.pm line 359. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Auth.pm line 361. DBD::mysql::db selectrow_array failed: Table 'Koha.sessions' doesn't exist at /usr/local/koha/intranet/modules/C4/Auth.pm line 224. DBD::mysql::st execute failed: Unknown column 'password' in 'field list' at /usr/local/koha/intranet/modules/C4/Auth.pm line 351. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Auth.pm line 353. DBD::mysql::st execute failed: Unknown column 'password' in 'field list' at /usr/local/koha/intranet/modules/C4/Auth.pm line 359. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Auth.pm line 361. DBD::mysql::db do failed: Table 'Koha.sessions' doesn't exist at /usr/local/koha/intranet/modules/C4/Auth.pm line 281. DBD::mysql::db do failed: Table 'Koha.sessions' doesn't exist at /usr/local/koha/intranet/modules/C4/Auth.pm line 283. DBD::mysql::st execute failed: Unknown column 'userid' in 'where clause' at /usr/local/koha/intranet/modules/C4/Auth.pm line 400. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Auth.pm line 401. DBD::mysql::st execute failed: Unknown column 'flags' in 'field list' at /usr/local/koha/intranet/modules/C4/Auth.pm line 385. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Auth.pm line 386. DBD::mysql::st execute failed: Table 'Koha.userflags' doesn't exist at /usr/local/koha/intranet/modules/C4/Auth.pm line 388. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Auth.pm line 389. DBD::mysql::st execute failed: Unknown column 'userid' in 'where clause' at /usr/local/koha/intranet/modules/C4/Auth.pm line 426. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Auth.pm line 428. =-=-=-=-=-=-= Chris Gilbert Kennesaw State University -------------------------------------------------

2 1

Koha Admin Screens
by Rachel Hamilton-Williams 27 Oct '04

27 Oct '04

Hi all, I was setting up a quick demo Koha today for someone and it got me thinking about a better way to layout the admin screens. http://katipo.co.nz/gallery/koha-admin Are some pictures. My general feeling was that there are only a few things you need to set if you're just wanting to put in a few books and see what it does (hence the short list of required settings) But that then the other preferences should be grouped into the area they relate to perhaps? I did think that they could be grouped into "things to do if you've got a big library" and things to do if you don't - but that seemed a bit harder to decide on. Anyway let me know if it appeals - we might give it a try in the Katipo templates first. PLUS are there actually more admin parameters than I've got here.... And are any of them MARC/NON MARC specific - I'd particularly like to not have people setting variables that they don't have to. Cheers Rachel -- _____________________________________________________________ Rachel Hamilton-Williams Katipo Communications MANAGING DIRECTOR Ph 021 389 128 or +64 04 934 1285 mailto:rachel@katipo.co.nz PO Box 12487, Wellington http://www.katipo.co.nz New Zealand Koha Open Source Library System http://www.koha.org

1 0

First screenshot of Koha in Bangla was -> Re: [Koha] Translation trouble with Koha
by Indranil Das Gupta 26 Oct '04

26 Oct '04

Hi Paul, On Tue, 2004-10-26 at 09:41 +0200, Paul POULAIN wrote: <snipped> > /me should remove tmpl_process.pl from CVS... because the script to use > is the tmpl_process3.pl !!! Thanks a bunch for pointing this out... of course as I am sitting on Gentoo, I needed to do an `emerge Locale-PO` before I could get tmpl_process3.pl to run... but thats another story ;-) Well, tmpl_process3.pl worked... I have some errors with unterminated strings etc. and I will go over them again... in the meantime here is the Koha About Page rendered on Konqueror 3.3.0 in Bangla (BN) http://www.ilug-cal.org/koha-scrn-01.jpg Right now I am compiling cvs mozilla which has much better support of CSS IMHO > Should be the source of your problem ;-) *grins* thanks again... -indra. -- ------------------------------------------------------------- Indranil Das Gupta, Project Lead, CASTLE Project [Computer Aided Studies, Teaching and Learning Environment] In collaboration with: West Bengal University of Technology Calcutta, INDIA www.wbut.net ------------------------------------------------------------- L2C2.ORG - Bringing Localized Low-Cost Computing to People -------------------------------------------------------------

1 0

CALL for HELP (french => english) translation
by Paul POULAIN 26 Oct '04

26 Oct '04

Hi, I've written a 15 pages OpenOffice document that describes Koha 2.2 (all features : old and new ones). It's in french. So if someone volunteers to translate it english or any other language, feel free to ask. Note it's NOT a user manual. It's a "should I become a user ?" manual ;-) -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

3 3

Catalog search table and breeder table mis-match?
by Rich Baldwin 26 Oct '04

26 Oct '04

3 5

Re: [Koha] Marc Field 008?
by Baljkas Family 26 Oct '04

26 Oct '04

Tuesday, October 19, 2004 11:55 CDT Hi, Andres, A really quick response ... > I'm currently brushing up my mapping to MARC, in order not > to lose meaningful information (from my present database). > > We have a doubt about field 008: Does Koha uses it? How is > filled? When I last asked about this recently, I was told that Koha doesn't use the 008. I am not sure how it would be filled automatically, or even if that is what Koha tries to do with it. Otherwise, I think you'd have to create a coding sequence that would suffice for your library's needs and meet at least the minimum requirements (008 positions 6, 7-10, 11-14, 15-17, 35-37, 38 and 39). Properly, a cataloguer should be coding the 008 field *individually for each MARC record*, since the elements that constitute the 008 can only be coded accurately from inspection of the item being described. Hope this helps. Cheers, Steven F. Baljkas library tech at large Koha neophyte Winnipeg, MB, Canada

4 5