- Koha - lists.katipo.co.nz

help me for koha database structure
by wahyu prasetyo 15 Feb '07

15 Feb '07

Hai all I am currently using koha 2.2.7 on win XP SP2, running smooth and well, but there are some question about database for koha. 1. cataloging books. For cataloging. For example: I have 100 books titled "MatLab Programming", of course with the same ISBN and barcode. And I want to add into biblio, but when i look the sample227 one book identified with one barcode. How can I put my 100 books into item counts without having 100 different barcodes? 2. members. For members. How can I make the differences between members and borrowers? Is that any tools to view report for just member count or for just active borrowers? 3. parameters - Link Koha - MARC DB How can I set this parameters without error? Can anybody give the example? thanks a lot --------------------------------- Sekarang dengan penyimpanan 1GB http://id.mail.yahoo.com/

1 0

Can't search by branch
by cat tom 15 Feb '07

15 Feb '07

I imported a batch of Marc records from Horizon 7.3.4. By default, Horizon puts library branch code in subfield m of tag 949 while put item type in 949 t. I deleted the whole 952 in Koha and re-configured 949 in order to map Item.homebranch to 949's m and item.itemtype to 949 t. Of course, I have created a same branch code and itype in koha. Now, I can search by itype and find titles imported from horizon, whereras search by branch flatly blew. Even, I can not search by any branch name except any branch. Thank you. --------------------------------- All new Yahoo! Mail - --------------------------------- Get a sneak peak at messages with a handy reading pane.

2 1

Koha is using incorrect @INC details
by Noth 12 Feb '07

12 Feb '07

Hi All, I've got a small problem with a couple of modules (everything except z3950 searching and barcodes is working great. When they are run I get errors in my logs telling me they can't find the modules they need (ZOOM and PDF::API2) and looking through the log message I can see those modules are not included in the @INC list. I have updated perl to 5.8.8 after installing Koha, to fix some errors, and have since tried to reinstall ZOOM and PDF::API2. The problem seems to be Koha holding onto an old version of the @INC list (from perl 5.8.6) meaning that it doesnt reference the 5.8.8 directory propperly. I'm sure that a reinstall of perl then Koha would fix these issues but I'd rather not do that if I can avoid it (I just got it setup the way I like it) does anyone have an alternate way to refresh Koha's @INC list to the current version? Or to push additional values into it? Many Thanks, Noth -- View this message in context: http://www.nabble.com/Koha-is-using-incorrect-%40INC-details-tf3198487.html… Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 1

No Unicode support in bulkmarcimport.pl script
by Ata ur Rehman 12 Feb '07

12 Feb '07

Dear All I am importing data from MS Access which is in Unicode (Arabic + Urdu Language). When I import MARC record with breeding.pl (Through Koha GUI), everything is ok but when i import with bulkmarcimport.pl script, i found garbage instead of urdu and arabic data. what should i do? Ata

1 0

Solaris
by Carl J. Russo 10 Feb '07

10 Feb '07

Has anybody successfully installed Koha on Solaris? I've read in some older threads that it has been done, just looking to confirm that users have been able to do so. Thanks, Joe

2 2

Installing Z3950 Zoom Issues on Centos 4.4
by David Shaner 09 Feb '07

09 Feb '07

I am still trying to get KOHA 2.2.7 to work properly on Centos 4.4 and receive when trying to us -MCPAN to install ZOOM. If I download it and compile, it runs fine but the Z3950 searches return 500 errors. Below is the result of trying to install ZOOM. Any guidance or suggestions would be appreciated. Thanks in Advance Dave CPAN: Storable loaded ok Going to read /root/.cpan/Metadata Database was generated on Fri, 09 Feb 2007 00:08:36 GMT Running install for module ZOOM Running make for M/MI/MIRK/Net-Z3950-ZOOM-1.16.tar.gz CPAN: Digest::MD5 loaded ok Checksum for /root/.cpan/sources/authors/id/M/MI/MIRK/Net-Z3950-ZOOM-1.16.tar.gz ok Scanning cache /root/.cpan/build for sizes Net-Z3950-ZOOM-1.16/ Net-Z3950-ZOOM-1.16/samples/ Net-Z3950-ZOOM-1.16/samples/zoom/ Net-Z3950-ZOOM-1.16/samples/zoom/update.pl Net-Z3950-ZOOM-1.16/samples/zoom/async.pl Net-Z3950-ZOOM-1.16/samples/zoom/zoomtst3.pl Net-Z3950-ZOOM-1.16/samples/zoom/zoomtst1.pl Net-Z3950-ZOOM-1.16/samples/zoom/trivial-async.pl Net-Z3950-ZOOM-1.16/samples/zoom/zhello.pl Net-Z3950-ZOOM-1.16/samples/zoom/zselect Net-Z3950-ZOOM-1.16/samples/cql/ Net-Z3950-ZOOM-1.16/samples/cql/pqf.properties Net-Z3950-ZOOM-1.16/samples/net-z3950/ Net-Z3950-ZOOM-1.16/samples/net-z3950/zoomtst1.pl Net-Z3950-ZOOM-1.16/samples/net-z3950-zoom/ Net-Z3950-ZOOM-1.16/samples/net-z3950-zoom/async.pl Net-Z3950-ZOOM-1.16/samples/net-z3950-zoom/zoomtst1.pl Net-Z3950-ZOOM-1.16/samples/net-z3950-zoom/zoomtst3.pl Net-Z3950-ZOOM-1.16/samples/records/ Net-Z3950-ZOOM-1.16/samples/records/esdd0006.grs Net-Z3950-ZOOM-1.16/samples/ccl/ Net-Z3950-ZOOM-1.16/samples/ccl/default.bib Net-Z3950-ZOOM-1.16/samples/README Net-Z3950-ZOOM-1.16/t/ Net-Z3950-ZOOM-1.16/t/18-charset.t Net-Z3950-ZOOM-1.16/t/21-option-callback.t Net-Z3950-ZOOM-1.16/t/11-option-callback.t Net-Z3950-ZOOM-1.16/t/25-scan.t Net-Z3950-ZOOM-1.16/t/16-packages.t Net-Z3950-ZOOM-1.16/t/22-query.t Net-Z3950-ZOOM-1.16/t/23-resultset.t Net-Z3950-ZOOM-1.16/t/12-query.t Net-Z3950-ZOOM-1.16/t/19-events.t Net-Z3950-ZOOM-1.16/t/29-events.t Net-Z3950-ZOOM-1.16/t/26-packages.t Net-Z3950-ZOOM-1.16/t/28-charset.t Net-Z3950-ZOOM-1.16/t/1-Net-Z3950-ZOOM.t Net-Z3950-ZOOM-1.16/t/24-sorting.t Net-Z3950-ZOOM-1.16/t/27-logging.t Net-Z3950-ZOOM-1.16/t/15-scan.t Net-Z3950-ZOOM-1.16/t/17-logging.t Net-Z3950-ZOOM-1.16/t/13-resultset.t Net-Z3950-ZOOM-1.16/t/10-options.t Net-Z3950-ZOOM-1.16/t/14-sorting.t Net-Z3950-ZOOM-1.16/t/2-ZOOM.t Net-Z3950-ZOOM-1.16/t/20-options.t Net-Z3950-ZOOM-1.16/Changes Net-Z3950-ZOOM-1.16/lib/ Net-Z3950-ZOOM-1.16/lib/Net/ Net-Z3950-ZOOM-1.16/lib/Net/Z3950.pm Net-Z3950-ZOOM-1.16/lib/Net/Z3950/ Net-Z3950-ZOOM-1.16/lib/Net/Z3950/ZOOM.pm Net-Z3950-ZOOM-1.16/lib/ZOOM.pod Net-Z3950-ZOOM-1.16/lib/ZOOM.pm Net-Z3950-ZOOM-1.16/MANIFEST Net-Z3950-ZOOM-1.16/typemap Net-Z3950-ZOOM-1.16/META.yml Net-Z3950-ZOOM-1.16/ZOOM.xs Net-Z3950-ZOOM-1.16/MANIFEST.SKIP Net-Z3950-ZOOM-1.16/Makefile.PL Net-Z3950-ZOOM-1.16/README Removing previously used /root/.cpan/build/Net-Z3950-ZOOM-1.16 CPAN.pm: Going to build M/MI/MIRK/Net-Z3950-ZOOM-1.16.tar.gz Checking if your kit is complete... Looks good Writing Makefile for Net::Z3950::ZOOM cp lib/Net/Z3950/ZOOM.pm blib/lib/Net/Z3950/ZOOM.pm cp lib/ZOOM.pod blib/lib/ZOOM.pod cp lib/ZOOM.pm blib/lib/ZOOM.pm cp lib/Net/Z3950.pm blib/lib/Net/Z3950.pm /usr/bin/perl /usr/lib/perl5/5.8.5/ExtUtils/xsubpp -typemap /usr/lib/perl5/5.8.5/ExtUtils/typemap -typemap typemap ZOOM.xs > ZOOM.xsc && mv ZOOM.xsc ZOOM.c gcc -c -DYAZ_HAVE_XML2=1 -DYAZ_HAVE_XSLT=1 -I/usr/local/include -I/usr/local/include/libxml2 -I/usr/local/include -DYAZ_POSIX_THREADS=1 -D_REENTRANT -D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -m32 -march=i386 -mtune=pentium4 -DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -fPIC "-I/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE" ZOOM.c Running Mkbootstrap for Net::Z3950::ZOOM () chmod 644 ZOOM.bs rm -f blib/arch/auto/Net/Z3950/ZOOM/ZOOM.so gcc -shared -L/usr/local/lib ZOOM.o -o blib/arch/auto/Net/Z3950/ZOOM/ZOOM.so -L/usr/local/lib -lyaz -L/usr/local/lib -lxslt -lxml2 -lz -lm -lssl -lcrypto -lgssapi_krb5 -lkrb5 -lcom_err -lk5crypto -lresolv -ldl -lz -lpthread chmod 755 blib/arch/auto/Net/Z3950/ZOOM/ZOOM.so cp ZOOM.bs blib/arch/auto/Net/Z3950/ZOOM/ZOOM.bs chmod 644 blib/arch/auto/Net/Z3950/ZOOM/ZOOM.bs cp samples/zoom/zselect blib/script/zselect /usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/zselect Manifying blib/man3/Net::Z3950::ZOOM.3pm Manifying blib/man3/ZOOM.3pm /usr/bin/make -- OK Running make test PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t t/1-Net-Z3950-ZOOM......dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-22 Failed 22/22 tests, 0.00% okay t/10-options............dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-51 Failed 51/51 tests, 0.00% okay t/11-option-callback....dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-19 Failed 19/19 tests, 0.00% okay t/12-query..............dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-41 Failed 41/41 tests, 0.00% okay t/13-resultset..........dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-24 Failed 24/24 tests, 0.00% okay t/14-sorting............dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-29 Failed 29/29 tests, 0.00% okay t/15-scan...............dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-87 Failed 87/87 tests, 0.00% okay t/16-packages...........dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-40 Failed 40/40 tests, 0.00% okay t/17-logging............dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-11 Failed 11/11 tests, 0.00% okay t/18-charset............dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-9 Failed 9/9 tests, 0.00% okay t/19-events.............dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1, 3-23 Failed 22/23 tests, 4.35% okay t/2-ZOOM................dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-22 Failed 22/22 tests, 0.00% okay t/20-options............dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-51 Failed 51/51 tests, 0.00% okay t/21-option-callback....dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-19 Failed 19/19 tests, 0.00% okay t/22-query..............dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-41 Failed 41/41 tests, 0.00% okay t/23-resultset..........dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-24 Failed 24/24 tests, 0.00% okay t/24-sorting............dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-29 Failed 29/29 tests, 0.00% okay t/25-scan...............dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-87 Failed 87/87 tests, 0.00% okay t/26-packages...........dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-40 Failed 40/40 tests, 0.00% okay t/27-logging............dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-11 Failed 11/11 tests, 0.00% okay t/28-charset............dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-9 Failed 9/9 tests, 0.00% okay t/29-events.............dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-23 Failed 23/23 tests, 0.00% okay Failed Test Stat Wstat Total Fail List of Failed ------------------------------------------------------------------------------- t/1-Net-Z3950-ZOOM.t 255 65280 22 43 1-22 t/10-options.t 255 65280 51 101 1-51 t/11-option-callback.t 255 65280 19 37 1-19 t/12-query.t 255 65280 41 81 1-41 t/13-resultset.t 255 65280 24 47 1-24 t/14-sorting.t 255 65280 29 57 1-29 t/15-scan.t 255 65280 87 173 1-87 t/16-packages.t 255 65280 40 79 1-40 t/17-logging.t 255 65280 11 21 1-11 t/18-charset.t 255 65280 9 17 1-9 t/19-events.t 255 65280 23 43 1 3-23 t/2-ZOOM.t 255 65280 22 43 1-22 t/20-options.t 255 65280 51 101 1-51 t/21-option-callback.t 255 65280 19 37 1-19 t/22-query.t 255 65280 41 81 1-41 t/23-resultset.t 255 65280 24 45 1-24 t/24-sorting.t 255 65280 29 56 1-29 t/25-scan.t 255 65280 87 171 1-87 t/26-packages.t 255 65280 40 79 1-40 t/27-logging.t 255 65280 11 21 1-11 t/28-charset.t 255 65280 9 16 1-9 t/29-events.t 255 65280 23 45 1-23 Failed 22/22 test scripts. 711/712 subtests failed. Files=22, Tests=712, 2 wallclock secs ( 1.76 cusr + 0.29 csys = 2.05 CPU) /usr/bin/make test -- NOT OK Running make install make test had returned bad status, won't install without force ____________________________________________________________________________________ Need a quick answer? Get one in minutes from people who know. Ask your question on www.Answers.yahoo.com

1 0

Trouble with MySQL, DBI/DBD::mysql
by Chris Hammond-Thrasher 09 Feb '07

09 Feb '07

Folks, I am trying to setup a replica of an environment currently running at the Cook Islands National Library in order to diagnose two problems. It is a Koha 2.2.6 install with MySQL 5.0 (I have made all of the documented sql changes plus a couple of undocumented ones to support mysql 5 thanks to "Katipo Chris") on Debian Sarge. All modules and system components are installed, the /usr/local/koha directory tree has been restored from the Cook Islands' backup as has the MySQL database. Everything looks good, except that a browser call to opac_main.pl yields the following error in the apache log: DBI connect('CKI:localhost','kohaadmin',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/koha/intranet/modules/C4/Context.pm line 411 Can't call method "prepare" on an undefined value at opac-main.pl line 17. Running a quick "mysqladmin version" revealed that mysql socket location is actually /tmp/mysql.sock . However, /etc/mysql/my.cnf has both the client and server socket set to /var/run/mysqld/mysqld.sock . So I changed all mentions of /var/run/mysqld/mysqld.sock in my.cnf to /tmp/mysql.sock (and even set and exported the MYSQL_UNIX_PORT env variable for good measure) and restarted mysqld_safe, then requested opac-main.pl again and received the same error above. In summary, I cannot make mysqld_safe listen at anything other than /tmp/mysql.sock and I cannot make perl DBI/DBD::mysql attempt to connect anywhere other than /var/run/mysqld/mysqld.sock . Any ideas? -cht Chris Hammond-Thrasher MLIS Library Systems Manager University of the South Pacific Suva, Fiji +679 3232233 hammondthrasher_c(a)usp.ac.fj

4 7

HTML::Template::Extension::DOC
by Jason Ronallo 08 Feb '07

08 Feb '07

Has anyone used HTML::Template::Extension::DOC with Koha templates? The are some changes that I'm making to the templates to hide certain page elements (like login and authorities search) for the time being. Later I could simply remove the <TMPL_DOC></TMPL_DOC> tags when I want to show my users the functionality. Should this work alright? --Jason

1 0

Fix for Z3950 search by title
by Rob Weir 08 Feb '07

08 Feb '07

Hi Paul, I reviewed the logs of the irc meeting from yesterday, and you mentioned finding and fixing a bug in the Z3950 search module when searching by title. I have noticed some really strange results when searching by title in 2.2.7. Does your fix apply to 2.2.7, and could you please provide the details of how to get the fix? Thanks, Rob

1 0

Card Catalog
by cyberarian 08 Feb '07

08 Feb '07

hi all I am using koha on windows xp. Can i print or view my bibliographic record in card catalog format? cyberarian

3 2