Time Nick Message 10:59 kados yep, that works 10:59 kados querytype ccl2rpn 10:59 kados or better 10:59 kados querytype ccl 10:59 kados maybe we need to say: 10:58 kados just a sec 10:58 kados I have the same prob 10:57 paul (note that I have zebra 1.3, not 2.0) 10:57 paul Elapsed: 0.006193 10:57 paul records returned: 0 10:57 paul SearchResult-1: term=ti dogmatique cnt=0 10:57 paul Number of hits: 0, setno 1 10:57 paul Search was a success. 10:57 paul Received SearchResponse. 10:57 paul Sent searchRequest. 10:57 paul Z> f ti=dogmatique 10:57 paul Elapsed: 0.002776 10:57 paul Options: search present delSet triggerResourceCtrl scan sort extendedServices namedResultSets 10:57 paul Version: Zebra 1.3.32/1.66/2.1.12 10:57 paul Name : Zebra Information Server/GFS/YAZ 10:57 paul ID : 81 10:57 paul Connection accepted by v3 target. 10:57 paul Sent initrequest. 10:57 paul Connecting...OK. 10:57 paul Z> open localhost:9900/biblios 10:56 kados > f ti=something 10:56 cm kados: thanks! I let you know how it works shortly. 10:56 kados > open localhost:9900/biblios 10:56 kados yaz-client -c /home/zebradbs/rel_3_0/biblios/etc/ccl.properties 10:56 kados try this: 10:55 paul [16:49] <paul> yaz-client -c /home/zebradbs/rel_3_0/biblios/etc/ccl.properties @:9900/biblios 10:55 paul yes : 10:55 kados yaz-client -c /path/to/ccl.properties 10:55 kados you must start yaz liek this; 10:54 kados ahh, I missread your error 10:54 paul ti u=4 s=pw 10:54 paul I tried both, without any difference 10:54 paul right. 10:54 kados right? 10:53 kados before you had ti u=4 s=something 10:53 kados you changed it! 10:53 paul (i don't have reindexed after adding title ti alias, but i don't think it matters) 10:53 paul title ti 10:53 paul ti u=4 10:53 kados for the ti line and tell me what it is 10:52 kados so check ccl.properties 10:52 kados and I assume you're using a ccl specification, right? 10:52 kados paul: first, you say 'ti=dogmatique' 10:52 kados paul: so lets trace what zebra is doing here 10:52 kados cm: ok, update and profit ;-) 10:51 paul no prob 10:50 kados paul: just a sec ... lemme commit this file 10:50 kados it should be specified in your record.abs 10:50 kados that means that attribute type 2 isn't supported 10:49 kados nope 10:49 paul which let me think he does not support ccl 10:49 paul [107] Query type not supported -- v2 addinfo 'type-2' 10:49 paul gives me a : 10:49 paul find "ti=dogmatique" 10:49 paul querytype ccl 10:49 cm zehr gut. :) 10:49 paul yaz-client -c /home/zebradbs/rel_3_0/biblios/etc/ccl.properties @:9900/biblios 10:48 paul another question : 10:48 kados cm: ok, I'll update it 10:48 cm do you mean utils/biblio_framework.sql? that doesn't have it. the latest cvs I just downloaded doesn't have it in there either. 10:48 kados maybe there is a way to tell it about ccl2rpn, but I don't know it 10:48 kados right 10:48 paul strange 10:48 paul zebra undestand cql2rpn but NOT ccl2rpn ? 10:48 kados (it's not ideal, I agree) 10:47 kados so we need one for zebra, and one for extra stuff 10:47 kados because zebra complains if there are unrecognized elements in <server element 10:47 paul while <cql2rpn>/home/zebradbs/rel_3_0/biblios/etc/pqf.properties</cql2rpn> is in <server id="..."> 10:47 kados yes 10:47 paul <ccl2rpn>/home/zebradbs/rel_3_0/biblios/etc/ccl.properties</ccl2rpn> in <serverinfo id="biblioserver"> section 10:46 paul kados : is there a reason to have, in koha.xml : 10:45 cm ok. let me look. 10:44 kados make sure it has: alter table kohanew.biblioitems add ccode varchar(4); 10:44 kados cm: can you check your biblioframework.sql file? 10:43 cm good. thanks. 10:42 kados I'll add the sql you need 10:41 kados ok ... so lemme check the wiki 10:41 kados but if you're not using zebra it shouldn't matter 10:41 kados that doesn't look good 10:41 cm but I think that can probably be ignored. i remember seeing something like that before 10:41 kados hmmm 10:41 cm ZOOM error 10000 "Connect failed" (addinfo: "tcp:@:9900") from diag-set 'ZOOM'root@koha:/usr/local/koha_cvs/dev_week/koha-new-upload/koha/misc/migration_tools 10:40 cm the other was: 10:40 kados that's an easy fix 10:40 cm yeah. :/ 10:40 kados right 10:40 cm DBD::mysql::st execute failed: Unknown column 'ccode' in 'field list' at /usr/local/koha/intranet/modules/C4/Biblio.pm line 1957. problem with Zebra at /usr/local/koha/intranet/modules/C4/Context.pm line 490. 10:40 kados bulkmarcimport errors? 10:40 cm uh oh. I got two errors: 10:32 cm okay. thanks. 10:32 kados let me know if the docs aren't clear in that file 10:31 kados and if I need to rebuild the index with the -all flag 10:31 kados but i run that with the -today flag for NPL in cron every evening 10:31 kados will probably need some customization 10:30 kados misc/update_items.pl 10:30 cm congrats. bugfixes are good! 10:27 kados discovered by yours truly :-) 10:27 kados :-) 10:27 kados bug 10:27 kados it has a bugfix for a nasty multiple simultaneous updates over extended services 10:27 cm good to know. i'll do that too. 10:26 kados released this morning 10:26 kados oh, and cm, you should upgrade to the latest zebra version in the 1.3 series 10:26 cm interesting. 10:26 kados I'll commit it now 10:26 kados I've got a new version of update_items that will rebuild the zebra index automagically 10:26 cm i'm very glad! 10:25 kados yep, makes sense 10:23 cm otherwise it takes too long. 10:23 cm i'm turning off zebra, though and uploading into zebra after import. 10:22 cm very likely. as long as it works. :) 10:22 kados cm: for importing I mean 10:22 kados cm: so is your plan to only use dev_week from the get-go now? 10:20 cm cool. I'll try it out. :D 10:20 cm i think. 10:20 cm but I don't have marc-*tables anymore (except the structure ones) 10:20 kados cm: committed bulkmarcimport 10:20 cm ah. okay. 10:19 kados ie, move from the marc-* tables to biblioitems.marc 10:19 kados that's what you need to update a rel_2_2 system to dev_week 10:19 kados zebraplugin/utils/move_marc_to_biblioitems.pl 10:19 cm for what? 10:19 kados oops gave you the wrong name 10:18 kados lemme check 10:18 cm is that in 2_2 or dev_week? 10:18 kados the way to populate biblioitems.marc is with import_to_biblioitems script 10:17 kados well, since you were going by way of rel_2_2 before 10:17 cm I tried it with rel_2_2, which worked, but nothing was imported into biblioitems.marc. Is that data needed, or will it be? 10:16 cm i think the first time i installed dev_week I used it, but I redid it a few weeks ago and I think I forgot and used the one in dev_week. 10:15 kados cm: (I thought you were going through rel_2_2's bulkmarcimport ... has that changed?) 10:15 cm lemme know when you're done. 10:15 cm thanks! 10:14 cm yeah, i think that's what I used the last time i did a full import. 10:14 kados cm: I will fix it immediately 10:14 cm hi paul! 10:14 kados cm: I didn't know you were using bulkmarcimport from dev_week 10:14 kados ahh yes ... here it is :-) 10:14 paul hello cm 10:14 cm hi kados. no, you didn't. :) 10:13 kados cm: did I ever respond to your email last week? 10:13 kados paul: in the same repo? 10:12 paul both are said "uptodate" 10:12 paul my ccl.properties from dev_week is 1020 lines long, & toins one is less than 100. 10:11 kados what's happening? 10:10 paul something seems wrong with CVS ... 10:07 paul mmm... my ccl.properties is really different from the dev_week one (beeping toins) 10:06 kados that'll work too 10:06 kados ahh 10:05 paul nop, just ti u=4 s=pw 10:05 kados (ie, an alias ) 10:05 kados ti title 10:05 kados do you have a line in ccl.properties: 10:03 paul but find "ti=<title>" does not work 10:03 paul find <author> works 10:03 paul find <title> works 10:03 paul kados : things are a little better : 09:57 kados profilePath:/koha/zebradb/biblios/tab/ 09:57 kados I ahve: 09:57 kados I would limit it to just the one dir 09:56 paul profilePath:${srcdir:-.}:/home/zebradbs/rel_3_0/biblios/tab/:/usr/local/share/idzebra/tab/:${srcdir:-.}/tab/ 09:56 kados check zebra-biblios.cfg tab file 09:56 kados can you confirm that zebra is indexing using the right config files? 09:55 paul maybe i'm using a file i'm not looking at... 09:55 kados hmmm 09:55 kados ok, then it doesn't :-) 09:55 paul so I thought it did not matter 09:55 paul your record.abs (the marc21 one on CVS) is case-variant. 09:54 kados not sure it matters 09:54 kados author vs Author 09:54 kados one thing 09:54 paul hehe what ? 09:54 paul that's my feeling... 09:54 paul bib1.att : att 1003 Author 09:54 paul ccl.properties : au u=1003 s=pw 09:54 paul record.abs : melm 200$f author,author:p,author:s 09:54 paul and for authors : 09:54 kados hehe 09:54 paul oups. not kicked... 09:54 kados looks fine 09:54 paul melm 545 title 09:54 paul melm 541 title 09:54 paul melm 540 title 09:54 paul melm 532 title 09:54 paul melm 531 title 09:54 paul melm 530 title 09:53 paul melm 520 title 09:53 paul melm 519 title 09:53 paul melm 518 title 09:53 paul melm 517 title 09:53 paul melm 516 title 09:53 paul melm 515 title 09:53 paul melm 514 title 09:53 paul melm 513 title 09:53 paul melm 512 title 09:53 paul melm 510 title 09:53 paul melm 503 title 09:53 paul melm 501 title 09:53 paul melm 500 title 09:53 paul # authorities title 09:53 paul melm 200$e title:w,title:p,title:s 09:52 paul # subtitle 09:52 paul melm 200$d title:w,title:p,title:s 09:52 paul melm 200$c title:w,title:p,title:s 09:52 paul melm 200$a title:w,title:p,title:s 09:52 kados ok, and record.abs for Title? 09:52 paul bib1.att : att 4 Title 09:52 kados (and by the way, I've been starting zebra on a unix socket these days, much faster even) 09:52 paul ccl.properties contains : ti u=4 s=pw 09:51 kados yep 09:51 paul yep : yaz-client -c /home/zebradbs/rel_3_0/biblios/etc/ccl.properties @:9900/biblios is enough right ? 09:51 kados paul: ti=chaos will work if you specified you're using ccl 09:51 paul (because it don't work either. only "find chaos" returns something) 09:51 dewey record.abs, bib1.att, ccl.properties are the most important files 09:51 kados record.abs, bib1.att, ccl.properties 09:50 paul in yaz-client find "ti=chaos" should return records with title=chaos, right ? 09:50 kados there are several places to check: 09:50 kados yep, sounds like it 09:48 paul this is not koha related, this is probably record.abs 09:47 paul kados : something is wrong with my setup : i can't do any search on something except title/subtitle : "find caroll" in yaz-client don't work, while "find chaos" works fine. 09:10 paul there is even a parameter not to dump your file & preserve your export, when you want to test things 09:09 paul you can do whatever you want, it creates what is needed. 09:08 kados or is it meant to be run every time you re-index? 09:07 kados so you only run it once, on installation? 09:07 kados cool 09:06 paul (& takes care of record.abs depending on your marc flavour) 09:06 paul so, once you have a koha.xml defined, just run it, it does what is needed where it is needed 09:06 paul - zebraidx 09:06 paul - dump the records 09:06 paul - creates the zebra-biblios.cfg with the dir structure too 09:05 paul - copies the needed files from zebraplugin into the directory structure 09:05 paul - create the directory structure 09:05 paul it : 09:05 paul s/kadose/kados/ 09:05 paul kadose : about my script that rebuild zebra : it does many things : 08:56 kados $query.=" $index: $operand"; would be safer (adds a space) 08:56 kados (in fact, if it works, it should be modified slightly to test for the existance of $index first 08:55 paul i'll test & let you know 08:55 kados but I'm not 100% sure, I'd have to test it 08:55 kados $query.="$index: $operand"; 08:55 kados maybe $query.=" $operand"; should be: 08:54 kados line even 08:54 kados around like 3265 08:54 kados if (!$index) { 08:54 kados $query.=" $operand"; 08:54 kados else { 08:54 kados see this clause: 08:53 kados I do see one possible problem 08:53 paul (could stemming=0 & field_weight=0 change sometihng ?) 08:52 paul unless he made something wrong no. 08:52 kados paul: are you sure toins has not modified buildQuery? 08:49 kados it should be au:chaos 08:49 paul nope. but I get answers anyway. 08:49 kados hi owen 08:49 owen Hi everybody 08:49 kados yes 08:49 kados (but do you have an author with 'chaos'? 08:49 paul same as SEARCHDESC so ? 08:48 kados au:chaos 08:48 kados on dev_week with MARC21 08:48 paul what should I see here ? 08:48 kados right 08:48 paul (because is was "author : chaos" 08:48 kados ahh, yes 08:48 paul should be related to author somewhere no ? 08:48 kados it will use the default 08:47 kados why? 08:47 paul QUERY:chaos seems wrong to me. 08:47 paul [Mon Oct 23 14:40:25 2006] [error] [client 192.168.0.2] QUERYING : chaos at /home/paul/koha.dev/rel_3_0/C4/Search.pm line 2776., referer: http://i18.bureau.paulpoulain.com/cgi-bin/koha/catalogue/search.pl 08:47 paul [Mon Oct 23 14:40:25 2006] [error] [client 192.168.0.2] FEDERATED QUERY:au= chaos at /home/paul/koha.dev/rel_3_0/C4/Search.pm line 3120., referer: http://i18.bureau.paulpoulain.com/cgi-bin/koha/catalogue/search.pl 08:47 paul [Mon Oct 23 14:40:25 2006] [error] [client 192.168.0.2] SEARCHDESC:au: chaos at /home/paul/koha.dev/rel_3_0/C4/Search.pm line 3119., referer: http://i18.bureau.paulpoulain.com/cgi-bin/koha/catalogue/search.pl 08:47 paul [Mon Oct 23 14:40:25 2006] [error] [client 192.168.0.2] QUERY:chaos at /home/paul/koha.dev/rel_3_0/C4/Search.pm line 3118., referer: http://i18.bureau.paulpoulain.com/cgi-bin/koha/catalogue/search.pl 08:47 paul and get : 08:47 kados it would be useful to see what the query is 08:47 paul warn "FEDERATED QUERY:".$federated_query; 08:47 paul warn "SEARCHDESC:".$human_search_desc; 08:47 paul warn "QUERY:".$koha_query; 08:47 paul I uncommented buildQuery last lines : 08:46 kados ok 08:46 paul yes, but I have a more precise question 08:46 kados it could be the zebra conf files 08:46 paul stemming=0, field_weightiing=0 too 08:46 kados there are so many possible reasons for that :-) 08:46 paul author <an author> => nothing 08:46 paul keyword : <an author> => returns nothing 08:45 paul author chaos => returns the same 10 biblios 08:45 paul keyword chaos => returns 10 biblios 08:45 paul sample : 08:45 paul when I search I get results only if I enter something that is in the title. 08:45 kados if you pass it the -all parameter 08:44 kados update_items already rebuilds the zebra index 08:44 paul but... 08:44 paul (& a new rebuild_zebra script i'll commit soon) 08:44 paul I have indexed a large (50 000 biblios) with zebra 08:44 kados yep 08:44 paul do you have a minut for a quick question ? 08:43 kados hi :-) 08:43 paul hello kados 08:43 kados paul: yep 08:30 paul kados around ?