- Koha - lists.katipo.co.nz

Installation of koha-3
by vijay kumar 09 Jul '08

09 Jul '08

Dear Members, I am trying to install KOHA 3 on Fedora 7 and I did all procedure step by step provided in manuals .But during installation of KOHA 3 (koha-3.00.00-stableRC1) getting some error.............. Shall I proceed with this error further.......... Or how can I overcome from this problem........... Anyone please suggest me...................................... This is one screenshot of my problem 1/4DBD::mysql::db selectrow_array failed: Table 'koha.systempreferences' doesn't exist at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Context.pm line 456. Use of uninitialized value in string eq at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Date.pm line 49. Use of uninitialized value in string eq at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Date.pm line 49. Use of uninitialized value in string eq at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Date.pm line 49. Use of uninitialized value in concatenation (.) or string at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Date.pm line 63. # Failed test 'format_date_in_iso' # at t/Date.t line 29. # got: '' # expected: '1973-05-21' # Looks like you planned 4 tests but only ran 3. # Looks like you failed 1 test of 3 run. t/Date......................dubious Test returned status 1 (wstat 256, 0x100) DIED. FAILED tests 2, 4 Failed 2/4 tests, 50.00% okay t/Dates.....................ok 1/126# # Testing Legacy Functions: format_date and format_date_in_iso DBD::mysql::db selectrow_array failed: Table 'koha.systempreferences' doesn't exist at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Context.pm line 456. Use of uninitialized value in hash element at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Dates.pm line 127. Use of uninitialized value in concatenation (.) or string at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Dates.pm line 127. Invalid date format '' from system preferences at t/Dates.t line 31 # Looks like you planned 126 tests but only ran 1. # Looks like your test died just after 1. t/Dates.....................dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 2-126 Failed 125/126 tests, 0.79% okay t/Debug.....................# BEFORE use: $debug is not defined # BEFORE use: $cgi_debug is not defined t/Debug.....................ok 1/3# AFTER use: $debug is 0 # AFTER use: $cgi_debug is 0 # Done. t/Debug.....................ok t/dummy.....................ok t/icondirectories...........Use of uninitialized value in string eq at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Koha.pm line 460. DBD::mysql::db selectrow_array failed: Table 'koha.systempreferences' doesn't exist at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Context.pm line 456. Use of uninitialized value in concatenation (.) or string at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Koha.pm line 464. DBD::mysql::db selectrow_array failed: Table 'koha.systempreferences' doesn't exist at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Context.pm line 456. Use of uninitialized value in concatenation (.) or string at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Koha.pm line 461. Can't stat /usr/share/koha/opac/htdocs/opac-tmpl//itemtypeimg: No such file or directory at t/icondirectories.t line 37 Can't stat /usr/share/koha/intranet/htdocs/intranet-tmpl//img/itemtypeimg: No such file or directory at t/icondirectories.t line 45 t/icondirectories...........ok t/Input.....................ok t/Items.....................DBD::mysql::db selectrow_array failed: Table 'koha.systempreferences' doesn't exist at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Context.pm line 456. t/Items.....................ok 1/28DBD::mysql::db selectrow_array failed: Table 'koha.systempreferences' doesn't exist at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Context.pm line 456. Use of uninitialized value in hash element at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Dates.pm line 127. Use of uninitialized value in concatenation (.) or string at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Dates.pm line 127. Invalid date format '' from system preferences at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Items.pm line 1728 # Looks like you planned 28 tests but only ran 13. # Looks like your test died just after 13. t/Items.....................dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 14-28 Failed 15/28 tests, 46.43% okay t/Koha......................ok t/Labels....................DBD::mysql::db selectrow_array failed: Table 'koha.systempreferences' doesn't exist at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Context.pm line 456. t/Labels....................ok t/Languages.................ok t/Maintainance..............ok t/Output....................ok t/Record....................ok t/Review....................ok t/Scrubber..................ok 1/10# Note: scrubber test output will have whitespace collapsed for readability # done. t/Scrubber..................ok t/Stats.....................ok Failed Test Stat Wstat Total Fail Failed List of Failed ------------------------------------------------------------------------------- t/Date.t 1 256 4 3 75.00% 2 4 t/Dates.t 255 65280 126 250 198.41% 2-126 t/Items.t 255 65280 28 30 107.14% 14-28 Failed 3/24 test scripts, 87.50% okay. 142/207 subtests failed, 31.40% okay. make: *** [test_dynamic] Error 255 Thanks, Vijay Kumar NCSI,IISc Bangalore

2 2

Re: [Koha] Bulkmarcimport.pl: importing new batch of records
by Tomasz Holdowanski 09 Jul '08

09 Jul '08

Irma wrote: > Hello Tomasz, > > We are working with the same kind of issues at the moment. > > 1) I can send you some files with very good full MARC records, if that were > to help you. But do you use MARC21? Thanks, but that`s not the case. I have my own records in the other ILS (ALEPH to be specific). I extracted the raw data from it in order to figure out the best way of importing it into KOHA and to develop a procedure that would give best results with least effort. After success, I allowed my colleagues to test KOHA, however the biblio and items databases were already outdated. New biblios and items are in Aleph, I can extract them and make them KOHA-importable. The problem would not exist if there were ONLY new biblios with items, however there are items that should be attached to biblio records already existing in KOHA. > 3) Are you using as Koha test the 2.2.9 version or 3.0? I use a Polish fork developed by Wojciech Zatorski. He is developing an "university library" version, I work in a public library, so it`s not the best fit, but still better than "mainstream" KOHA. The fork is heavily modified 2.4 with additions from later versions. Full compatibility is long gone, I guess. > 4) There is a script already written for merging brief and full records in > the Koha reservoir. I just need to ask for it. Not my case again :) I have biblios with items with Koha, just need to attach more items to those biblios: read record from file -> look at ISBN in subfield 020a, search biblioitems for matching isbn -> if found, import field 952 only with biblionumber and biblioitemnumber of the found record. If not found, import all fields as a new biblio/biblioitem/item. I know it would create duplicate biblios, but less than importing everything as complete records. Or maybe someone has a better idea?... Regards, Tomasz.

2 1

Bulkmarcimport.pl: importing new batch of records
by Tomasz Holdowanski 09 Jul '08

09 Jul '08

Hi everyone, I have set up Koha for testing, however the database I have imported is four months old. My colleagues complain about it and want me to add new records from other library software for more thorough testing. I could re-import the whole database, however it`s not a good solution in the long run - we have another ILS that has to stay for a while, all cataloging is done in that ILS and it has to stay that way for a year or so. I can prepare a batch of new records for importing into Koha, however don`t know if the bulkmarcimport script could do the job the way I`d like: - reject biblios that already are in the DB and import item-specific fields only, connecting them to existing biblios; - import biblios that are not in the DB, along with items. In other words: I need to perform many partial imports and avoid biblio and item duplicates. Has anyone tried something like that? Is there any way to do it? Thanks for anyhelp! Regards, Tomasz.

2 4

Error in installing KOHA3 on FC6
by shriram pandey 09 Jul '08

09 Jul '08

Hello List, I have installed successfully koha3 on fc6 with great difficulty, but not able to run koha through browser.it shows a blank page. When I run this through command mode (perl /usr/share/koha/opac/cgi-bin/opac/opac-main.pl), it shows the fallowing error. --------------------------------------- Can't locate C4/Auth.pm in @INC (@INC contains: /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.7/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7 /usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.7/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl/5.8.7 /usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.8/i386-linux-thread-multi /usr/lib/perl5/5.8.8 .) at /usr/share/koha/opac/cgi-bin/opac/opac-main.pl line 22. BEGIN failed--compilation aborted at /usr/share/koha/opac/cgi-bin/opac/opac-main.pl line 22. ---------------------------------------- any help is highly appriciated . -- Shri Ram Pandey Information and Knowledge Management Trainee NCSI,Indian Institute Of Science,Bangalore

2 1

Some coding guidelines required
by Ata ur Rehman 09 Jul '08

09 Jul '08

Dear Rob / All I have studied http://www.kohadocs.org/codingguidelines.html and http://wiki.koha.org/doku.php?id=en:development:codingguidelines for coding guidelines in Koha but looking for more. Actually I want to make some additional reports in koha. For example I want to have a report of Biblio records between two limits of barcode numbers. Now the query for this report is as under: SELECT items.barcode, biblio.title, biblio.author, biblio.copyrightdate, items.price FROM items, biblio WHERE items.biblionumber=biblio.biblionumber AND CAST(items.barcode AS UNSIGNED) BETWEEN 1 AND 10000 ORDER BY CAST(items.barcode AS UNSIGNED); Can someone guide me how to create .pl and .tmpl file for this query. User will input starting barcode and ending barcode in form and will get the results in PDF/HTML format Ata LISolutions http://www.lisolutions.org/

1 0

please help
by Dan Lenkarie 09 Jul '08

09 Jul '08

hi to all I am trying to install the koha system to be used by a special library.But I keep on hitting a hard place every time.can someone please help me by giving me clear instructions on what is needed for the system to work and how its supposed to be installed.please!!! I am working with a windows OS

2 1

BAR CODE
by Edisnel Carrazana Castro 08 Jul '08

08 Jul '08

Greeting, I need your suggestions about what model of bar code reader and bar code printer I could use with Koha? Someone has experience with this ?. Thank you.

2 1

Re: [Koha] Problems Adding Members
by Jesse 08 Jul '08

08 Jul '08

On Mon, Jul 7, 2008 at 6:31 PM, Stephanas Francis < stephanas.francis(a)yahoo.com> wrote: > Jesse, > > I tried installing the patch, but it did not help. > > The exact error in apache's intranet error log, with or without the patch, > is as below: > > [Mon Jul 07 20:27:40 2008] [error] [client 127.0.0.1] DBD::mysql::st > execute failed: Incorrect integer value: '' for column 'gonenoaddress' at > row 1 at c:/usr/koha229/intranet/modules/C4/Members.pm line 155., referer: > http://intranet/cgi-bin/koha/members/memberentry.pl > > Do you have any solution for this? > > regards, > Stephanas > > --- On *Mon, 7/7/08, Jesse <pianohacker(a)gmail.com>* wrote: > > From: Jesse <pianohacker(a)gmail.com> > Subject: Re: Problems Adding Members > To: stephanas.francis(a)yahoo.com > Date: Monday, July 7, 2008, 4:12 PM > > The original patch is at > http://www.nabble.com/Possible-patch-for-Koha-2.2.9-expiry-date-problems-p1…. You'll need the patch program to apply it; what operating system are you > running? > > > I have not faced that particular error; I'm sending this to the list, in case they have any ideas.

1 0

Re: [Koha] Now: Koha Manual and Licensing Terms. Was: authorities value-help
by Nicole Engard 08 Jul '08

08 Jul '08

I need you to email the entire list. I have never used your version of Koha and cannot help you. --- Nicole C. Engard Open Source Evangelist, LibLime (888) Koha ILS (564-2457) ext. 714 nce(a)liblime.com AIM/Y!/Skype: nengard http://liblime.com http://blogs.liblime.com/open-sesame/ On Tue, Jul 8, 2008 at 1:26 PM, Morium Morshed <morium_morshed(a)yahoo.com> wrote: > I am using koha 2.2.9 on windows xp..and When i click on > parametrs->authorised value then cilck on add authorities value and aslo > input data but no data is adding.....and there is New catagory option if i > also add some data here no data is added...how can i solve that..please help > me > And i am taking help from that > page"http://www.kohadocs.org/usersguide/ch01s03.html" but 3.2 option is not > working....which is "Authorised Values" > > So please help me.... > > --- On Tue, 7/8/08, Nicole Engard <nicole.engard(a)liblime.com> wrote: > > From: Nicole Engard <nicole.engard(a)liblime.com> > Subject: Re: [Koha] Now: Koha Manual and Licensing Terms. Was: authorities > value-help > To: "Paul POULAIN" <paul.poulain(a)free.fr> > Cc: Koha(a)lists.katipo.co.nz > Date: Tuesday, July 8, 2008, 9:59 AM > > I updated this page: http://sites.google.com/a/liblime.com/koha-manual/ > > It's not pretty or worded terribly well, but it's there and can stay > there while we wait to move the > documentation to a more community > friendly location. > > > --- > > Nicole C. Engard > Open Source Evangelist, LibLime > (888) Koha ILS (564-2457) ext. 714 > nce(a)liblime.com > AIM/Y!/Skype: nengard > > http://liblime.com > http://blogs.liblime.com/open-sesame/ > > > On Tue, Jul 8, 2008 at 12:57 PM, Nicole Engard > <nicole.engard(a)liblime.com> wrote: >> Okey Dokey >> >> >> --- >> >> Nicole C. Engard >> Open Source Evangelist, LibLime >> (888) Koha ILS (564-2457) ext. 714 >> nce(a)liblime.com >> AIM/Y!/Skype: nengard >> >> http://liblime.com >> http://blogs.liblime.com/open-sesame/ >> >> >> On Tue, Jul 8, 2008 at 12:55 PM, Paul POULAIN <paul.poulain(a)free.fr> > wrote: >>> Nicole Engard a écrit : >>>> >>>> I can't remove the >>>> LibLime branding due to the tool we're using. >>> >>> it's > fine with me too. GPL'ing doesn't mean anonymizing. >>> >>> Maybe just specify : "The LibLime logo is trademarked by LibLime. > It is not >>> considered as a part of this document (1)" >>> >>> (1) otherwise the logo become GPL & it's incompatible with > trademark I >>> think. The best solution is to exclude the logo from the document > licence >>> ;-) >>> The counterpart is that someone could copy/paste/remove the logo and > re >>> publish the docs without it. >>> -- >>> Paul POULAIN >>> http://www.biblibre.com >>> Expert en Logiciels Libres pour l'info-doc >>> Tel : 04 91 31 45 19 >>> >> > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha >

1 0

authorities value-help
by Morium Morshed 08 Jul '08

08 Jul '08

How can i add data in authorities value admin page.i can not add the data in this page..if i add the data,no data is added..but other data is added in my system like branches.

4 10