- Koha-devel - lists.koha-community.org

Fixes to opac-search.pl and opac-advsearch.tmpl
by Wagner, Jane 28 Apr '09

28 Apr '09

I've been working on the OPAC advanced search page. I solved the problem of expanded search options not showing up. Now that they do, there's a section called Limit Type To that is puzzling me. Here's a sample entry. <td><input type="checkbox" id="mc-bks" name="limit" value="mc:t" /><label for="mc-bks" title="Books, Pamphlets, Technical reports, Manuscripts, Legal papers, Theses and dissertations"><img border="0" src="/intranet-tmpl/prog/en/images/AF.gif" alt="Books" />Books</label></td> First problem is that the images being called apparently don't exist anywhere, so the screen reads BooksBooks (alt text plus the text). Apart from that, I'm trying to figure out exactly what this is supposed to be searching. If I check the box and then search, I get an error of No results match your search for "mc:t" I'm still trying to learn the zebra stuff, but I couldn't find any reference to any of the mc: whatevers found in the various search elements here. Any idea what this is supposed to be doing? Is this a holdover from an old version that shouldn't be here any more, or something that got added but never worked? Jane Wagner Library Systems Analyst PTFS Inc. Content Management and Library Solutions 6400 Goldsboro Road, Suite 200 Bethesda, MD 20817 (301) 654-8088 x 151 jwagner(a)ptfs.com

4 8

Due Date check in C4::Circulation::CanBookBeIssued?
by Michael Hafen 28 Apr '09

28 Apr '09

The Due Date check is commented out in CanBookBeIssued. I'm planning uncomment and expand it. Before I do that I want to know why it's commented out. I seem to recall it being a problem for Offline Circ, but looking at process_koc.pl CanBookBeIssued isn't even called. Anyone know about this? -- Michael Hafen Systems Analyst and Programmer Washington County School District Utah, USA for Koha checkout http://development.washk12.org/gitweb/ or git://development.washk12.org/koha

2 5

Should we be cleaning zebraqueue and action_logs tables periodically?
by Michael Hafen 27 Apr '09

27 Apr '09

Please forgive me for pulling this bit from the patches list. I think the relevant discussion should be on this list. On Sat, 2009-04-25 at 13:29 -0400, Ryan Higgins wrote: > If you've never truncated your zebraqueue table, you might want to > update your index and truncate it before applying this patch and running updatedatabase. Truncating the zebraqueue table, as noted by Ryan with this patch, is probably something Koha itself should do periodically. Last time I looked at the cron example I didn't see anything to this end. The data in the table is quite small, but there are still a lot of rows there. This could also be applied to the action_logs table, which holds more data, and has more rows in my installation. Problem is troubleshooting or data retention requirements. I suppose there should be some config option to set a threshold on how old of data should be kept here. Or maybe a system preference could do that job. I for one would like to see Koha clearing these table itself, so there is one less thing for me to take care of. This is especially important to me as I didn't realize before today that these tables would be as large as they are ( as far as number of rows is concerned ). I would say it's safe to assume other system admins also aren't thinking about the size of these tables. Comments please. -- Michael Hafen Systems Analyst and Programmer Washington County School District Utah, USA for Koha checkout http://development.washk12.org/gitweb/ or git://development.washk12.org/koha

3 2

Amazon Documentation Question
by Nicole Engard 27 Apr '09

27 Apr '09

Hi all, With all of the recent Amazon patched, I'm reworking the documentation. I do have one question though. I have this note in several places "IMPORTANT: If this is ON, make sure that GoogleJackets and BakerTaylorEnabled are OFF." Is this still true? If you turn on more than one covers or book service which will work? Or if you have multiple on will you get duplicate info from each service? --- 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/

2 2

Regional Hack Fest - Connecticut
by Brendan Gallagher 27 Apr '09

27 Apr '09

Hey All -- We will be having a hackfest for Koha this coming Tuesday April 28th at the Middlebury Public Library, in Middlebury, CT 06762. If anyone is in the area and would like to attend please let me know (either on list or off list). We have a room scheduled at the library from 11am until 6pm. We will be providing lunch and caffeine for all those interested in attending. This will be in the style of an unconference, so there is no agenda or anything set. Personally I was interested in clearing a few more bugs and looking to see what bug work we can get moving on. If anyone has any ideas or thoughts - please forward them on. Thanks and I hope to see some of you, Cheers, Brendan --------------------------------------------------------------------------------------------------------------------------------- Brendan A. Gallagher ByWater Solutions CEO, Director of Innovation Support and Consulting for Open Source Software Installation, Data Migration, Training, Customization, Hosting, Complete Support Packages Headquarters: Santa Barbara, CA - Office: West Haven, CT Phone # (203)823-5847 http://bywatersolutions.com info(a)bywatersolutions.com ---------------------------------------------------------------------------------------------------------------------------------

4 4

Koha hosting - Zebra issues
by C W Nel 27 Apr '09

27 Apr '09

Can anyone help with tips how to configure zebra in a hosted environment? With other words, how to create another zebra database and what is to be changed in the koha-conf.xml instances? Thanks

2 1

Proposed fixes for XSLT files
by Wagner, Jane 27 Apr '09

27 Apr '09

I'm working on several changes to the XSLT files for hitlist and individual record display. Some of them are listed as bugs, while others should probably be so listed. We also have some that are individual to the site; I thought I'd fix the overall problems and send a patch, then do the site's changes. Before I send a patch, I want to run my proposed fixes by everyone. Bug 2822 for leader6 types of i (nonmusical) or j (musical), the hitlist uses an icon and label of Sound while the record display page uses Music. Modified record display to use Sound. Bug 2551 for leader7 type of i says it's type Serial which is incorrect. The bug report suggested Integrating Resource" but the latest install's hitlist page uses Continuing Resource. Changed the record display page to also use Continuing Resource. Not reported as a bug, but we've run into it and I should create a bug report -- if you have a 110 or 710 with a subfield a and a subfield b, there's no space between them (on either hitlist or record display). The two headings run together in the display. Modified the utils file to force a space. Bug 2771 asks to have the 245 subfields a,b,p,n display. The latest files seem to have a,b,h in the hitlist and a,b,h,f,g,k,n,p,s in the record display page. Does that meet the need, or should I add n and p to the hitlist page while I'm at it? I have two other bug reports in which I haven't quite figured out how to do yet -- making the XSLT pages obey the sysprefs for opening URLs in new windows and substituting URL link text. Jane Wagner Library Systems Analyst PTFS Inc. Content Management and Library Solutions 6400 Goldsboro Road, Suite 200 Bethesda, MD 20817 (301) 654-8088 x 151 jwagner(a)ptfs.com

2 2

Koha 3 and Zebra indexing with ICU
by Pongtawat Chippimolchai 27 Apr '09

27 Apr '09

Hello, I have problems trying to enable ICU support in Zebra under Koha 3. After enabling ICU support in Zebra and reindex Koha, all Koha search will return nothing. However, if I change Zebra to listen to TCP port and query it directly using SRU, it will give the correct results. I try to change many things without any success. I'm running Koha 3.0.1 on Ubuntu 8.04, Zebra is at version 2.0.36 from Index Data APT repository. ICU is enabled by adding "index: icu.idx" line to Koha-Zebra's .cfg (zebra-biblios.cfg, etc). Default word and phrase index setting in icu.idx is used. Other missing index types (u, n, 0, y, d) are added to icu.idx by copying from default.idx. Some files are copied to /etc/koha/zebradb/etc in order to make ICU indexing works. With icuchain option (the default one), searhing in Koha won't work. However, if I remove icuchain option searching will partially work (whole phrase exact search only). At first I though there is a problem with icuchain rule, but I test it with yaz-icu and it give the correct results. I also try patching Zebra ( http://lists.indexdata.dk/pipermail/zebralist/2009-March/002134.html) but it doesn't help either. What's strange is that if I put Zebra on TCP port and query it directly, e.g. " http://localhost:9999/biblios?version=1.1&operation=searchRetrieve&query=sc…", I get the expected answer (while there are no answer in Koha). So, could anybody please give me some suggestions? Thank you very much in advance! Pongtawat C. (pongtawat.ait(a)gmail.com) ==== Log file when searching in Koha ==== ... 14:54:35-27/04 zebrasrv(2) [debug] server select: config=/etc/koha/zebradb/zebra-biblios.cfg 14:54:35-27/04 zebrasrv(2) [debug] bend_init 14:54:35-27/04 zebrasrv(2) [debug] zebra_open zs=0x80756e8 returns 0x807aab0 14:54:35-27/04 zebrasrv(2) [debug] Sort handler installed 14:54:35-27/04 zebrasrv(2) [debug] Search handler installed 14:54:35-27/04 zebrasrv(2) [debug] ESRequest handler installed 14:54:35-27/04 zebrasrv(2) [debug] Delete handler installed 14:54:35-27/04 zebrasrv(2) [debug] Scan handler installed 14:54:35-27/04 zebrasrv(2) [debug] Segment handler installed 14:54:35-27/04 zebrasrv(2) [debug] result immediately available 14:54:35-27/04 zebrasrv(2) [debug] ir_session (output) 14:54:35-27/04 zebrasrv(2) [debug] Wrote PDU, 114 bytes 14:54:35-27/04 zebrasrv(2) [debug] ir_session (input) 14:54:35-27/04 zebrasrv(2) [debug] Got PDU, 447 bytes: lead=B6 80 8D 14:54:35-27/04 zebrasrv(2) [debug] ResultSet '1' 14:54:35-27/04 zebrasrv(2) [debug] zebra_register_open rw=0 useshadow=0 p=0x810fb28 n= rp=(none) 14:54:35-27/04 zebrasrv(2) [debug] mf_init(register) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: sort100 consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: sort96 consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: sort58 consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: sort40 consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: sort30 consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: isambD consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: gmatch consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: reci consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: dict consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: isambA consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: sort50 consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: sort26 consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: sort92 consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: isambB consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: isambC consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: recdB consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: sort36 consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: sort63 consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: sort44 consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: sort85 consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: recdA consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] Using default resource recordCompression:none 14:54:35-27/04 zebrasrv(2) [debug] mf_open(reci bs=128, RDONLY) 14:54:35-27/04 zebrasrv(2) [debug] mf_open(recdA bs=128, RDONLY) 14:54:35-27/04 zebrasrv(2) [debug] mf_open(recdB bs=512, RDONLY) 14:54:35-27/04 zebrasrv(2) [debug] mf_open(dict bs=4096, RDONLY) 14:54:35-27/04 zebrasrv(2) [debug] Using default resource isamcDebug:0 14:54:35-27/04 zebrasrv(2) [debug] mf_open(isambA bs=32, RDONLY) 14:54:35-27/04 zebrasrv(2) [debug] mf_open(isambB bs=128, RDONLY) 14:54:35-27/04 zebrasrv(2) [debug] mf_open(isambC bs=512, RDONLY) 14:54:35-27/04 zebrasrv(2) [debug] mf_open(isambD bs=2048, RDONLY) 14:54:35-27/04 zebrasrv(2) [debug] data1_fath_fopen path=/etc/koha/zebradb/biblios/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/biblios:/etc/koha/zebradb/lang_defs/en root=NULL file=explain.abs mode=r 14:54:35-27/04 zebrasrv(2) [debug] data1_fath_fopen path=/etc/koha/zebradb/biblios/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/biblios:/etc/koha/zebradb/lang_defs/en root=NULL file=explain.att mode=r 14:54:35-27/04 zebrasrv(2) [debug] data1_fath_fopen path=/etc/koha/zebradb/biblios/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/biblios:/etc/koha/zebradb/lang_defs/en root=NULL file=explain.tag mode=r 14:54:35-27/04 zebrasrv(2) [debug] data1_fath_fopen path=/etc/koha/zebradb/biblios/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/biblios:/etc/koha/zebradb/lang_defs/en root=NULL file=tagsetm.tag mode=r 14:54:35-27/04 zebrasrv(2) [debug] Using default resource notimestamps:0 14:54:35-27/04 zebrasrv(2) [debug] read runnumber=10 14:54:35-27/04 zebrasrv(2) [debug] zebra_register_open ok p=0x810fb28 14:54:35-27/04 zebrasrv(2) [debug] Using default resource sortmax:1000 14:54:35-27/04 zebrasrv(2) [debug] rpn_search_APT 14:54:35-27/04 zebrasrv(2) [debug] index_type=p 14:54:35-27/04 zebrasrv(2) [debug] complete_flag=1 14:54:35-27/04 zebrasrv(2) [debug] search_type=phrase 14:54:35-27/04 zebrasrv(2) [debug] rank_type=rank,w=32,u=36 14:54:35-27/04 zebrasrv(2) [log] input school 14:54:35-27/04 zebrasrv(2) [debug] Using default resource truncmax:10000 14:54:35-27/04 zebrasrv(2) [debug] term_limits_APT ref_id=none limit=0 14:54:35-27/04 zebrasrv(2) [debug] data1_fath_fopen path=/etc/koha/zebradb/biblios/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/biblios:/etc/koha/zebradb/lang_defs/en root=NULL file=bib1.att mode=r 14:54:35-27/04 zebrasrv(2) [debug] data1_fath_fopen path=/etc/koha/zebradb/biblios/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/biblios:/etc/koha/zebradb/lang_defs/en root=NULL file=gils.att mode=r 14:54:35-27/04 zebrasrv(2) [log] output M-7EE?\x01\x0A\x01\x0A 14:54:35-27/04 zebrasrv(2) [log] dict_lookup_grep: (\x01()M-7EE\?\x01\x01\x01\x0A\x01\x01\x01\x0A 14:54:35-27/04 zebrasrv(2) [debug] dict_lookup_grep range=0 14:54:35-27/04 zebrasrv(2) [debug] 0 40 ( 14:54:35-27/04 zebrasrv(2) [debug] 1 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 2 40 ( 14:54:35-27/04 zebrasrv(2) [debug] 3 41 ) 14:54:35-27/04 zebrasrv(2) [debug] 4 77 M 14:54:35-27/04 zebrasrv(2) [debug] 5 45 - 14:54:35-27/04 zebrasrv(2) [debug] 6 55 7 14:54:35-27/04 zebrasrv(2) [debug] 7 69 E 14:54:35-27/04 zebrasrv(2) [debug] 8 69 E 14:54:35-27/04 zebrasrv(2) [debug] 9 92 \ 14:54:35-27/04 zebrasrv(2) [debug] 10 63 ? 14:54:35-27/04 zebrasrv(2) [debug] 11 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 12 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 13 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 14 10 ? 14:54:35-27/04 zebrasrv(2) [debug] 15 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 16 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 17 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 18 10 ? 14:54:35-27/04 zebrasrv(2) [debug] max_pos = 1 14:54:35-27/04 zebrasrv(2) [debug] 0 positions 14:54:35-27/04 zebrasrv(2) [debug] Using default resource trunclimit:10000 14:54:35-27/04 zebrasrv(2) [debug] term_limits_APT ref_id=none limit=0 14:54:35-27/04 zebrasrv(2) [debug] rpn_search_APT 14:54:35-27/04 zebrasrv(2) [debug] index_type=p 14:54:35-27/04 zebrasrv(2) [debug] complete_flag=1 14:54:35-27/04 zebrasrv(2) [debug] search_type=phrase 14:54:35-27/04 zebrasrv(2) [debug] rank_type=rank,w=28,u=4 14:54:35-27/04 zebrasrv(2) [log] input school 14:54:35-27/04 zebrasrv(2) [debug] Using default resource truncmax:10000 14:54:35-27/04 zebrasrv(2) [debug] term_limits_APT ref_id=none limit=0 14:54:35-27/04 zebrasrv(2) [log] output M-7EE?\x01\x0A\x01\x0A 14:54:35-27/04 zebrasrv(2) [log] dict_lookup_grep: (\x01,)M-7EE\?\x01\x01\x01\x0A\x01\x01\x01\x0A 14:54:35-27/04 zebrasrv(2) [debug] dict_lookup_grep range=0 14:54:35-27/04 zebrasrv(2) [debug] 0 40 ( 14:54:35-27/04 zebrasrv(2) [debug] 1 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 2 44 , 14:54:35-27/04 zebrasrv(2) [debug] 3 41 ) 14:54:35-27/04 zebrasrv(2) [debug] 4 77 M 14:54:35-27/04 zebrasrv(2) [debug] 5 45 - 14:54:35-27/04 zebrasrv(2) [debug] 6 55 7 14:54:35-27/04 zebrasrv(2) [debug] 7 69 E 14:54:35-27/04 zebrasrv(2) [debug] 8 69 E 14:54:35-27/04 zebrasrv(2) [debug] 9 92 \ 14:54:35-27/04 zebrasrv(2) [debug] 10 63 ? 14:54:35-27/04 zebrasrv(2) [debug] 11 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 12 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 13 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 14 10 ? 14:54:35-27/04 zebrasrv(2) [debug] 15 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 16 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 17 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 18 10 ? 14:54:35-27/04 zebrasrv(2) [debug] max_pos = 1 14:54:35-27/04 zebrasrv(2) [debug] 0 positions 14:54:35-27/04 zebrasrv(2) [debug] Using default resource trunclimit:10000 14:54:35-27/04 zebrasrv(2) [debug] term_limits_APT ref_id=none limit=0 14:54:35-27/04 zebrasrv(2) [debug] rpn_search_APT 14:54:35-27/04 zebrasrv(2) [debug] index_type=w 14:54:35-27/04 zebrasrv(2) [debug] complete_flag=0 14:54:35-27/04 zebrasrv(2) [debug] search_type=phrase 14:54:35-27/04 zebrasrv(2) [debug] rank_type=rank,w=26,u=4 14:54:35-27/04 zebrasrv(2) [log] input school 14:54:35-27/04 zebrasrv(2) [debug] Using default resource truncmax:10000 14:54:35-27/04 zebrasrv(2) [debug] term_limits_APT ref_id=none limit=0 14:54:35-27/04 zebrasrv(2) [log] output M-7EE?\x01\x0A\x01\x0A 14:54:35-27/04 zebrasrv(2) [log] dict_lookup_grep: (\x01*)M-7EE\?\x01\x01\x01\x0A\x01\x01\x01\x0A 14:54:35-27/04 zebrasrv(2) [debug] dict_lookup_grep range=0 14:54:35-27/04 zebrasrv(2) [debug] 0 40 ( 14:54:35-27/04 zebrasrv(2) [debug] 1 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 2 42 * 14:54:35-27/04 zebrasrv(2) [debug] 3 41 ) 14:54:35-27/04 zebrasrv(2) [debug] 4 77 M 14:54:35-27/04 zebrasrv(2) [debug] 5 45 - 14:54:35-27/04 zebrasrv(2) [debug] 6 55 7 14:54:35-27/04 zebrasrv(2) [debug] 7 69 E 14:54:35-27/04 zebrasrv(2) [debug] 8 69 E 14:54:35-27/04 zebrasrv(2) [debug] 9 92 \ 14:54:35-27/04 zebrasrv(2) [debug] 10 63 ? 14:54:35-27/04 zebrasrv(2) [debug] 11 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 12 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 13 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 14 10 ? 14:54:35-27/04 zebrasrv(2) [debug] 15 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 16 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 17 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 18 10 ? 14:54:35-27/04 zebrasrv(2) [debug] max_pos = 1 14:54:35-27/04 zebrasrv(2) [debug] 0 positions 14:54:35-27/04 zebrasrv(2) [debug] Using default resource trunclimit:10000 14:54:35-27/04 zebrasrv(2) [debug] term_limits_APT ref_id=none limit=0 14:54:35-27/04 zebrasrv(2) [debug] rpn_search_APT 14:54:35-27/04 zebrasrv(2) [debug] index_type=w 14:54:35-27/04 zebrasrv(2) [debug] complete_flag=0 14:54:35-27/04 zebrasrv(2) [debug] search_type=and-list 14:54:35-27/04 zebrasrv(2) [debug] rank_type=rank,w=16,u=-1 14:54:35-27/04 zebrasrv(2) [log] input school 14:54:35-27/04 zebrasrv(2) [debug] Using default resource truncmax:10000 14:54:35-27/04 zebrasrv(2) [debug] term_limits_APT ref_id=none limit=0 14:54:35-27/04 zebrasrv(2) [debug] result immediately available 14:54:35-27/04 zebrasrv(2) [debug] ir_session (output) 14:54:35-27/04 zebrasrv(2) [debug] Wrote PDU, 38 bytes 14:54:35-27/04 zebrasrv(2) [debug] ir_session (input) 14:54:35-27/04 zebrasrv(2) [debug] ir_session (input) 14:54:35-27/04 zebrasrv(2) [debug] zebra_close zh=0x807aab0 14:54:35-27/04 zebrasrv(2) [debug] zebra_register_close p=0x810fb28 14:54:35-27/04 zebrasrv(2) [debug] mf_close(dict) 14:54:35-27/04 zebrasrv(2) [debug] isamb_close returned 0 values, skipped 0 14:54:35-27/04 zebrasrv(2) [debug] mf_close(isambA) 14:54:35-27/04 zebrasrv(2) [debug] mf_close(isambB) 14:54:35-27/04 zebrasrv(2) [debug] mf_close(isambC) 14:54:35-27/04 zebrasrv(2) [debug] mf_close(isambD) 14:54:35-27/04 zebrasrv(2) [debug] mf_close(reci) 14:54:35-27/04 zebrasrv(2) [debug] mf_close(recdA) 14:54:35-27/04 zebrasrv(2) [debug] mf_close(recdB) ==== Log file when searching with Zebra directly ==== 14:59:39-27/04 zebrasrv(1) [debug] server select: config=/etc/koha/zebradb/zebra-biblios.cfg 14:59:39-27/04 zebrasrv(1) [debug] yaz_srw_decode returned 2 14:59:39-27/04 zebrasrv(1) [debug] yaz_sru_decode returned 0 14:59:39-27/04 zebrasrv(1) [debug] ResultSet 'default' 14:59:39-27/04 zebrasrv(1) [debug] rpn_search_APT 14:59:39-27/04 zebrasrv(1) [debug] index_type=w 14:59:39-27/04 zebrasrv(1) [debug] complete_flag=0 14:59:39-27/04 zebrasrv(1) [debug] search_type=phrase 14:59:39-27/04 zebrasrv(1) [debug] rank_type=void 14:59:39-27/04 zebrasrv(1) [log] input school 14:59:39-27/04 zebrasrv(1) [debug] Using default resource truncmax:10000 14:59:39-27/04 zebrasrv(1) [debug] term_limits_APT ref_id=none limit=0 14:59:39-27/04 zebrasrv(1) [log] output M-7EE?\x01\x0A\x01\x0A 14:59:39-27/04 zebrasrv(1) [log] dict_lookup_grep: (\x01\x0D)M-7EE\?\x01\x01\x01\x0A\x01\x01\x01\x0A 14:59:39-27/04 zebrasrv(1) [debug] dict_lookup_grep range=0 14:59:39-27/04 zebrasrv(1) [debug] 0 40 ( 14:59:39-27/04 zebrasrv(1) [debug] 1 1 ? 14:59:39-27/04 zebrasrv(1) [debug] 2 13 ? 14:59:39-27/04 zebrasrv(1) [debug] 3 41 ) 14:59:39-27/04 zebrasrv(1) [debug] 4 77 M 14:59:39-27/04 zebrasrv(1) [debug] 5 45 - 14:59:39-27/04 zebrasrv(1) [debug] 6 55 7 14:59:39-27/04 zebrasrv(1) [debug] 7 69 E 14:59:39-27/04 zebrasrv(1) [debug] 8 69 E 14:59:39-27/04 zebrasrv(1) [debug] 9 92 \ 14:59:39-27/04 zebrasrv(1) [debug] 10 63 ? 14:59:39-27/04 zebrasrv(1) [debug] 11 1 ? 14:59:39-27/04 zebrasrv(1) [debug] 12 1 ? 14:59:39-27/04 zebrasrv(1) [debug] 13 1 ? 14:59:39-27/04 zebrasrv(1) [debug] 14 10 ? 14:59:39-27/04 zebrasrv(1) [debug] 15 1 ? 14:59:39-27/04 zebrasrv(1) [debug] 16 1 ? 14:59:39-27/04 zebrasrv(1) [debug] 17 1 ? 14:59:39-27/04 zebrasrv(1) [debug] 18 10 ? 14:59:39-27/04 zebrasrv(1) [debug] max_pos = 11 14:59:39-27/04 zebrasrv(1) [debug] 1 positions 14:59:39-27/04 zebrasrv(1) [debug] Using default resource trunclimit:10000 14:59:39-27/04 zebrasrv(1) [debug] term_limits_APT ref_id=none limit=0 14:59:39-27/04 zebrasrv(1) [debug] isamb_pp_close lev=0 returned 0 values, skipped 0 14:59:39-27/04 zebrasrv(1) [debug] isamb_pp_close lev=0 returned 0 values, skipped 246 14:59:39-27/04 zebrasrv(1) [debug] srw_bend_fetch 1 14:59:39-27/04 zebrasrv(1) [debug] retrieve localno=256 score=-1 14:59:39-27/04 zebrasrv(1) [debug] grs_retrieve 14:59:39-27/04 zebrasrv(1) [debug] data1_fath_fopen path=/etc/koha/zebradb/biblios/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/biblios:/etc/koha/zebradb/lang_defs/en root=NULL file=record.abs mode=r 14:59:39-27/04 zebrasrv(1) [debug] data1_fath_fopen path=/etc/koha/zebradb/biblios/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/biblios:/etc/koha/zebradb/lang_defs/en root=NULL file=bib1.att mode=r 14:59:39-27/04 zebrasrv(1) [debug] data1_fath_fopen path=/etc/koha/zebradb/biblios/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/biblios:/etc/koha/zebradb/lang_defs/en root=NULL file=gils.att mode=r 14:59:39-27/04 zebrasrv(1) [debug] data1_fath_fopen path=/etc/koha/zebradb/biblios/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/biblios:/etc/koha/zebradb/lang_defs/en root=NULL file=usmarc.mar mode=r 14:59:39-27/04 zebrasrv(1) [debug] Got regexp: [^@]*/leader/record/$ 14:59:39-27/04 zebrasrv(1) [debug] Created xpath: '/*/controlfield[@tag="001"]' [.. lots of lines like above 2 ..] 14:59:39-27/04 zebrasrv(1) [debug] Created xpath: '/*/datafield[@tag="952"]/subfield[@code="y"]' 14:59:39-27/04 zebrasrv(1) [debug] Got regexp: [^(a)]*/subfield/datafield/.*/$ 14:59:39-27/04 zebrasrv(1) [debug] grs_retrieve: size 14:59:39-27/04 zebrasrv(1) [debug] grs_retrieve: syntax mapping 14:59:39-27/04 zebrasrv(1) [debug] grs_retrieve: schemaIdentifier 14:59:39-27/04 zebrasrv(1) [debug] grs_retrieve: element spec 14:59:39-27/04 zebrasrv(1) [debug] Esetname 'F' in simple compspec 14:59:39-27/04 zebrasrv(1) [debug] Element: all match 14:59:39-27/04 zebrasrv(1) [debug] grs_retrieve: transfer syntax mapping 14:59:39-27/04 zebrasrv(1) [debug] ir_session (output) 14:59:39-27/04 zebrasrv(1) [debug] Wrote PDU, 1757 bytes

1 0

FW: [Koha] Modifying Field's Data Type In the Koha Database
by Irma Birchall 27 Apr '09

27 Apr '09

_____ From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Melanie Saldua Sent: Monday, 27 April 2009 11:16 AM To: koha(a)lists.katipo.co.nz Subject: [Koha] Modifying Field's Data Type In the Koha Database Hello! I'm a new koha user and I'm trying to migrate my existing database to the koha database. I was wondering if it is possible to change the data type of the fields in the koha database? I need to modify biblionumber's data type from int(11) to bigint(100). Is there a faster way to do it than modify every table?

1 0

Last Koha development version (from git) mentions missing prerequisites that are already installed
by Ricardo Dias Marques 24 Apr '09

24 Apr '09

Hi list, I'm updating a local Koha installation from "git" to the last commit available at this time (commit 8f95ec3dbef2cf9bf214fb2b25587f2bb4ebba15 sent by Owen Leonard, submitted on 20-Apr-2009, "Fix for Bug 3119: Add due date to the patron circulation history window"). In order to do this, I did a "git pull". I got the expected many lines of "Getting index for pack", "got", "walk", "create mode", "delete"... After doing this, I ran the following command: myhost:~/mykohaclone # perl Makefile.PL --prev-install-log /root/my-koha-head/misc/koha-install-log That command produced the expected output, EXCEPT for the last lines (that have some information that seems correct BUT other info seems wrong): _____________________ [Wed Apr 22 11:52:18 2009] Makefile.PL: Warning: prerequisite DBD::SQLite 1.13 not found. We have 1.11. [Wed Apr 22 11:52:18 2009] Makefile.PL: Warning: prerequisite Date::ICal 1.72 not found. [Wed Apr 22 11:52:18 2009] Makefile.PL: Warning: prerequisite HTTP::OAI 3.2 not found. [Wed Apr 22 11:52:19 2009] Makefile.PL: Warning: prerequisite JSON 2.07 not found. [Wed Apr 22 11:52:20 2009] Makefile.PL: Warning: prerequisite SMS::Send 0.05 not found. [Wed Apr 22 11:52:21 2009] Makefile.PL: Warning: prerequisite XML::SAX::Writer 0.44 not found. Writing Makefile for koha _____________________ OK. My setup is a Linux virtual machine, running SLES (SUSE Linux Enterprise Server) 10 with SP2 (Service Pack 2) installed. It is true that I had DBD::SQLite v1.11 installed in the past, from a RPM package for SLES: myhost:~/mykohaclone # rpm -qa | grep -i perl-dbd-sqlite perl-DBD-SQLite-1.11-14.6 So this first "Warning" line seems CORRECT: I have DBD::SQLite 1.11 installed, but I now need DBD::SQLite 1.13. OK, no problem. I installed it from CPAN. Now, the PROBLEM is in the 2nd line. I already have Date::ICal version 1.72 installed, also from a RPM package for SLES: myhost:~/mykohaclone # rpm -qa | grep -i perl-date-ical perl-Date-ICal-1.72-2.1 This seems to be confirmed by running the following command: myhost:~/mykohaclone # locate ICal | grep -i date /root/mykohaclone/perl-Date-ICal-1.72-2.1.i586.rpm /usr/lib/perl5/vendor_perl/5.8.8/Date/ICal /usr/lib/perl5/vendor_perl/5.8.8/Date/ICal/Duration.pm /usr/lib/perl5/vendor_perl/5.8.8/Date/ICal.pm /usr/share/doc/packages/perl-Date-ICal /usr/share/doc/packages/perl-Date-ICal/Changes /usr/share/doc/packages/perl-Date-ICal/README /usr/share/man/man3/Date::ICal.3pm.gz /usr/share/man/man3/Date::ICal::Duration.3pm.gz /var/adm/perl-modules/perl-Date-ICal So, is this "Warning", during Koha installation, WRONG (regarding Date::ICal not being installed)? I have the same problem with SMS::Send. I already have SMS::Send version 0.05 installed by RPM: myhost:~/mykohaclone # rpm -qa | grep -i sms perl-SMS-Send-0.05-3.2 But, as I pointed out above, I also got a Warning message, in this Koha update, saying that "[Wed Apr 22 11:52:20 2009] Makefile.PL: Warning: prerequisite SMS::Send 0.05 not found. " What do you think about this? Thanks in advance. Cheers, Ricardo Dias Marques lists AT ricmarques DOT net Installation Guide for Installing Koha 3 on openSUSE 11 http://wiki.koha.org/doku.php?id=opensuse_11.0

3 5