- Koha - lists.katipo.co.nz

DBD::mysql::db selectrow_array failed.
by Barry Cannon 25 Feb '09

25 Feb '09

Hello, Can anyone help me with the error below? I got similar on the make test but assumed it was having trouble with a table that hadn't been created yet. I am now getting this error when trying to start ZebraQueue. I have DBD::mysql installed and as far a I can see all other perl modules. thanks DBD::mysql::db selectrow_array failed: Table 'koha.systempreferences' doesn't exist at C4/Context.pm line 485. DBD::mysql::st execute failed: Table 'koha.zebraqueue' doesn't exist at misc/bin/zebraqueue_daemon.pl line 123. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at misc/bin/zebraqueue_daemon.pl line 124. DBD::mysql::st execute failed: Table 'koha.zebraqueue' doesn't exist at misc/bin/zebraqueue_daemon.pl line 123. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at misc/bin/zebraqueue_daemon.pl line 124. DBD::mysql::st execute failed: Table 'koha.zebraqueue' doesn't exist at misc/bin/zebraqueue_daemon.pl line 123. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at misc/bin/zebraqueue_daemon.pl line 124. DBD::mysql::st execute failed: Table 'koha.zebraqueue' doesn't exist at misc/bin/zebraqueue_daemon.pl line 123. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at misc/bin/zebraqueue_daemon.pl line 124. DBD::mysql::st execute failed: Table 'koha.zebraqueue' doesn't exist at misc/bin/zebraqueue_daemon.pl line 123. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at misc/bin/zebraqueue_daemon.pl line 124. DBD::mysql::st execute failed: Table 'koha.zebraqueue' doesn't exist at misc/bin/zebraqueue_daemon.pl line 123. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at misc/bin/zebraqueue_daemon.pl line 124. DBD::mysql::st execute failed: Table 'koha.zebraqueue' doesn't exist at misc/bin/zebraqueue_daemon.pl line 123. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at misc/bin/zebraqueue_daemon.pl line 124. DBD::mysql::st execute failed: Table 'koha.zebraqueue' doesn't exist at misc/bin/zebraqueue_daemon.pl line 123. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at misc/bin/zebraqueue_daemon.pl line 124. DBD::mysql::st execute failed: Table 'koha.zebraqueue' doesn't exist at misc/bin/zebraqueue_daemon.pl line 123. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at misc/bin/zebraqueue_daemon.pl line 124. DBD::mysql::st execute failed: Table 'koha.zebraqueue' doesn't exist at misc/bin/zebraqueue_daemon.pl line 123. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at misc/bin/zebraqueue_daemon.pl line 124. DBD::mysql::st execute failed: Table 'koha.zebraqueue' doesn't exist at misc/bin/zebraqueue_daemon.pl line 123. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at misc/bin/zebraqueue_daemon.pl line 124. DBD::mysql::st execute failed: Table 'koha.zebraqueue' doesn't exist at misc/bin/zebraqueue_daemon.pl line 123. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at misc/bin/zebraqueue_daemon.pl line 124. DBD::mysql::st execute failed: Table 'koha.zebraqueue' doesn't exist at misc/bin/zebraqueue_daemon.pl line 123. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at misc/bin/zebraqueue_daemon.pl line 124. DBD::mysql::st execute failed: Table 'koha.zebraqueue' doesn't exist at misc/bin/zebraqueue_daemon.pl line 123. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at misc/bin/zebraqueue_daemon.pl line 124. DBD::mysql::st execute failed: Table 'koha.zebraqueue' doesn't exist at misc/bin/zebraqueue_daemon.pl line 123. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at misc/bin/zebraqueue_daemon.pl line 124. DBD::mysql::st execute failed: Table 'koha.zebraqueue' doesn't exist at misc/bin/zebraqueue_daemon.pl line 123. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at misc/bin/zebraqueue_daemon.pl line 124. DBD::mysql::st execute failed: Table 'koha.zebraqueue' doesn't exist at misc/bin/zebraqueue_daemon.pl line 123. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at misc/bin/zebraqueue_daemon.pl line 124. DBD::mysql::st execute failed: Table 'koha.zebraqueue' doesn't exist at misc/bin/zebraqueue_daemon.pl line 123. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at misc/bin/zebraqueue_daemon.pl line 124. DBD::mysql::st execute failed: Table 'koha.zebraqueue' doesn't exist at misc/bin/zebraqueue_daemon.pl line 123. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at misc/bin/zebraqueue_daemon.pl line 124. DBD::mysql::st execute failed: Table 'koha.zebraqueue' doesn't exist at misc/bin/zebraqueue_daemon.pl line 123. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at misc/bin/zebraqueue_daemon.pl line 124.

2 1

Acquisitions
by Lenora Oftedahl 25 Feb '09

25 Feb '09

Hi. I have a suggestion that I would like to order. I'm using Koha 3.0 which seems to be a bit different. I've got funds, budgets, etc. configured. I've entered the Vendor. However, when I try to edit the suggestion and add as an order to the vendor, the machine just blinks at me. Nothing is saved when I click on the button and the screen never changes. help? Lenora

2 1

Re: [Koha] Intranet error
by Joe Atzberger 25 Feb '09

25 Feb '09

It sounds like you have the wrong apache installed for your architecture, since the fork is failing. Look for the alternate version supported on win32. --Joe On Feb 25, 2009 1:07 AM, "eddy wetaba" <eddy.wetaba(a)gmail.com> wrote: Hi good people,someone please help with the attached error i have tried every trick on the config files but havent been successful. -- Michael Wetaba 0721566886 3755410 _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Trying to import from a RHEL/Oracle 10g (Sirsidynix) db to a Debian/MySQL system. Any suggestions as to how to go about this?? Thank for the input. Todd Goatley
by Goatley, Todd 25 Feb '09

25 Feb '09

Trying to import from a RHEL/Oracle 10g (Sirsidynix) db to a Debian/MySQL system. Any suggestions as to how to go about this?? Thank for the input. Todd L. Goatley DCAS Washoe County Library - Spanish Springs 7100A Pyramid Lake Highway Sparks, NV 89436 Email: tgoatley(a)washoecounty.us W: 775-424-1843 C: 775-771-3489

2 1

Fiscal close?
by Steven Owley 25 Feb '09

25 Feb '09

Hi everyone and thanks, What options does Koha's budget functions offer at the close of the fiscal year? Does it allow you to carry over funds, or not, depending on your policies? Or do you have to handle this yourself? Thanks again, Steve

3 2

Intranet error
by eddy wetaba 25 Feb '09

25 Feb '09

Hi good people,someone please help with the attached error i have tried every trick on the config files but havent been successful. -- Michael Wetaba 0721566886 3755410

1 0

Trouble with z39.50 Search
by Dr Emits 24 Feb '09

24 Feb '09

I seem to have encountered a flaw with my Koha installation. When importing records with the z39.50 client their appears to be mismatched fields (seems to be like this fellow's problem http://lists.katipo.co.nz/public/koha/2009-January/016700.html) Also no title or author appears in the columns of the search results (although ISBN does). I'm using the default z39.50 clients that come pre installed with Koha. Thanks, Emits

2 1

koha 3 on ubuntu 8.04
by john smith 24 Feb '09

24 Feb '09

Hi to all I try to insatall koha 3 on ubuntu 8.04 but when run make test i found this error: e# make test PERL_DL_NONLAZY=1 KOHA_CONF=blib/KOHA_CONF_DIR/koha-conf.xml /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/PERL_MODULE_DIR', 'blib/arch')" t/*.t t/Amazon.......................ok t/Barcodes_PrinterConfig.......ok t/Bookfund.....................ok t/Bookseller...................ok t/Boolean......................ok t/Branch.......................ok t/Calendar.....................ok t/Charset......................ok t/Circulation_barcodedecode....ok t/Dates........................ok 1/126# # In order to run without DB access, this test will substitute 'us' # as your default date format. Export environmental variable KOHA_TEST_DATE_FORMAT # to override this default, or pass the value as an argument to this test script. # # NOTE: we test for the system handling dd=00 and 00 for TIME values, # therefore you *should* see some warnings 'Illegal date specified' related to those. # # Testing Legacy Functions: format_date and format_date_in_iso # Illegal date specified (year = 1952, month = 1, day = 00) at t/Dates.t line 58 Illegal date specified (year = 1952, month = 1, day = 00) at t/Dates.t line 61 # # Testing 4 formats. # Testing no input (defaults): # # Testing with valid inputs: Illegal date specified (year = 1952, month = 1, day = 00) at t/Dates.t line 80 Illegal date specified (year = 1952, month = 1, day = 00) at t/Dates.t line 80 Illegal date specified (year = 1952, month = 1, day = 00) at t/Dates.t line 80 Illegal date specified (year = 1952, month = 1, day = 00) at t/Dates.t line 80 # # Testing object independence from class # done. # Looks like you planned 126 tests but ran 9 extra. t/Dates........................dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 127-135 Failed 9/126 tests, 92.86% 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/Input........................ok t/Koha.........................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/Dates.t 255 65280 126 9 7.14% 127-135 Failed 1/21 test scripts, 95.24% okay. -9/189 subtests failed, 104.76% okay. make: *** [test_dynamic] Error 255 if any body can help me regards _________________________________________________________________ Show them the way! Add maps and directions to your party invites. http://www.microsoft.com/windows/windowslive/products/events.aspx

1 0

Re: [Koha] I'm confused about where normal view customization occurs
by Doug Dearden 24 Feb '09

24 Feb '09

Rachel, Do you have the XSLT options turned on or off in the System Prefrences? Also, in the 245$b subfield Advanced Constraints, is there anything in the Koha link field? You say that 245 a & b display, do they both display in the Normal View, or only in the Marc View? Thanks, Doug >>> Rachel Hollis <Rachel.Hollis(a)stevenshenager.edu> 2/23/2009 11:37 AM >>> Hi Doug, some display customization is available in Admin. I am not sure if it affects one or both Staff and OPAC views. https://sites.google.com/a/liblime.com/koha-manual/Home/Table-of-Contents/a… I checked both Staff and OPAC views in our Koha (3.0) and 245a & b display; I checked Advanced Constraints under MARC Frameworks > MONO Framework Structure > Tag 245 Subfield Structure > Edit subfields constraints and Hidden values are both zero (0). That said - while 650a displays in the OPAC and Staff views, 651a does not displays in the OPAC but does in Staff view. Under subfields constraints, Hidden values are zero (0) for 650a and 651a. I hope this helps, Rachel Hollis, librarian Stevens-Henager College, Boise Idaho Campus -----Original Message----- From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Doug Dearden Sent: Friday, February 20, 2009 10:46 AM <snip> So is the answer to my question that the customization for this occurs at the Perl template level? Or is there some other place in the Admin that I can add other fields to the Title line in the Normal View? Thanks, Doug This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited.

1 0

Re: [Koha] mapping data in Koha 3.0
by lauraj＠tcoek12.org 24 Feb '09

24 Feb '09

Thank you for the quick responses from you and Brendan will help alot! I think I may start with the MarcEdit and then try the Koha Mapping. I want to make sure my data is readable with the Koha database, not like my first import. Thanks again for your help! Quoting Doug Dearden <dearden(a)sarsf.org>: > Laura, > > Take a look at this page in the doc: > https://sites.google.com/a/liblime.com/koha-manual/Home/Table-of-Contents/C… > > Koha stores the item info in the 952 field. It looks like your > item info is in the 999 field. You need to work out a mapping to > move the info from the subfields in the 999 field to the right > subfield in the 952 (or other) field. You can use MarcEdit to do > this, I think by making individual passes at the file to move the > subfield info one at a time. Or you can generate a script from > MarcEdit and modify it. > > Also take a look at the Koha to Marc mapping in the Administration > page of the Staff client. This is where the links between the two > are defined. If your item types are in 245$h, Koha won't be > looking there. The default is to look in 942$c for the item type, > and at the item level to look in the 952$y field. In the koha to > marc mapping there are three screens, biblio, biblioitems and items > that you access with the drop down menu. Be careful changing > these links. If you can use MarcEdit to modify your incoming file > to match that is probably best. > > You might try making a file with just one or two records, manually > editing them and then use MarkMaker to make a file. Import that > and see how it looks. Tweak your mapping until it is right then > use MarcEdit to move the subfields around in mass. > > Best, > > Doug Dearden > > > >>>> "Laura Johnson" <lauraj(a)tcoek12.org> 2/23/2009 2:22:43 PM >>> > Hello, > > > > I have installed Koha on 3.0 and I am ready to import my records (again) and > would like some advice on the best practice of mapping my data. I have the > title listed under 245$a and the media type under 245$h. Here is a sample > of the items we carry in our library. Our library consists of Video > Cassettes and audio books. > > > > > > > > =LDR 00660ngm 2200169 4500 > > > =005 20030703081938.0 > > > =007 vuucuuuuu > > > =008 991123s1989\\\\\\\030 > > > =050 \\$bVC3194$c0 > > > =245 \\$aReading Rainbow: Humphrey The Lost Whale: A True Story$hVC > > > =260 \\$bGPN$c1989 > > > =300 \\$a30$bcol$e1 > > > =520 \\$aBased on the true story of a California Humpback whale that gets > lost, the book by Wendy Tokuda and Richard Hall inspires Levar to spend a > day at sea whale watching. > > > =521 \\$aPrimary > > > =650 \\$aLIFE SCIENCE, BIOLOGY-MAMMALS > > > =650 \\$aLANGUAGE AND LITERATURE-CHILDREN'S LITERATURE > > > =999 \\$pVC319401$cMain Library$k01$r0.00$a01/01/1980$b12/31/2022$yVC3194 > > > > Last time I imported the data, only the description is visible. I ended up > deleting the Koha database and so I can start with a fresh database. I would > like to use the mapping tool in Koha, but if I need to use MarcEdit to > change the tag numbers please let me know. I just want to make sure that I > am using the tools correctly. > > > > Has anyone had the same experience of importing similar data into Koha and > if you have a detailed description of the best practice for this procedure. > > > > Thank you in advanced and for your patience with my limited knowledge of the > Koha Software. > > > > Sincerely, > > > > Laura Johnson > > System Administrator and Health Assistant > > Trinity County Office of Education > > 201 Memorial Dr. > > P.O. Box 1256 > > Weaverville, CA 96093 > > www.tcoek12.org > > (530) 623-2861 ext236 > > (530 ) 623-4489 FAX > > > > > Links: ------ [1] https://sites.google.com/a/liblime.com/koha-manual/Home/Table-of-Contents/C…

3 2