Time Nick Message 13:43 kados paul: you here? 13:43 paul yep 13:43 paul (5:45PM in france) 13:43 kados paul: I was wondering if you could send me the init scripts you have 13:43 kados paul: I will compare them to ours and commit something 13:43 paul ??? 13:43 kados paul: for zebra 13:43 kados paul: to daemonize zebra, etc. 13:44 paul ah, ok. I don't have anything related to daemonization of zebra 13:44 paul you should ask sanop... 13:44 paul (although we will need something soon, as IPT will migrate to 3.0 in february probably... 13:44 paul ) 13:46 kados anyone from sanop here? 13:47 paul btoumi seems here on #koha-fr, but don't answer 13:47 kados I'll write a note to koha-devel 13:47 paul are u back to US ? 13:47 kados not uet 13:47 kados yet even 13:48 kados I get back on Thursday morning EST 13:50 kados mail sent 13:52 kados paul: I just updated rel_2 and I get: 13:52 kados Can't locate C4/Calendar/Calendar.pm in @INC 13:52 kados paul: is it a new dependency? 13:54 kados paul: it seems it was added to Circ2.pm 13:54 kados paul: but there is no C4/Calendar/Calendar.pm 13:55 kados :-) 13:55 rch kados: cvs -d ? 13:56 kados hmmm 13:56 kados guess I didn't 13:57 _paul kados : 13:57 _paul toins worked this morning on 2.2.7.1 13:57 _paul he created the CVS branch & synched everything from 2.2.7 considering only bugfixes. 13:57 _paul he tells me it's done. 13:57 kados great 13:57 _paul so you can give it a try if you want 13:58 _paul 2.2.8 + improvements = 2.2.9 13:59 kados I agree 2.2.8 is better 13:59 kados do we want to try to build translations too? 14:00 kados for 2.2.8? as one of the enhancements? 14:00 _paul that should be easy, as almost nothing has changed in templates 14:00 kados I have asked several translators to test http://translate.koha.org/ 14:01 kados so I hope soon it will be ready 14:01 kados _paul: there are many languages there now, have a look when you get a chance :-) 14:01 kados I think there is a bug for generating the po file for the intranet templates though 14:01 kados at least the last time I tried it 14:02 _paul is it a 0.2 version of kartouche ? 14:02 _paul or a newer one ? 14:02 _paul because kartouche seems an abandonned project 14:03 kados it's .2 + many improvements 14:03 kados I have contacted the maintainer 14:03 kados he says he no longer works on it but would 'hand over the reigns' to me :-) 14:03 _paul I tried too, but got no answers (because I added some features) 14:03 kados ahh, did you? 14:03 kados maybe you can send me your code and I will incorporate into my version 14:03 _paul yep. like searching a term 14:04 kados then once I have cvs access I will contribute them back 14:04 _paul instead of just entering an line # 14:04 _paul kados, btoumi is here now ;-) 14:04 btoumi hi kados 14:04 kados hi btoumi 14:04 kados btoumi: did you see my question to koha-devel? 14:05 kados btoumi: maybe you could respond with some details about how you manage the zebra server's process 14:05 kados btoumi: if you have some time? 14:05 btoumi have some time? 14:05 btoumi i have some time 14:05 btoumi just take minute to read ur message 14:06 kados _paul: that sounds like a great feature 14:06 btoumi ok kados u want to know some details to create zebra process 14:07 kados paul: you could just send me tar/gz of whole kartouche, I can dig :-) 14:07 kados btoumi: it would be useful to know what techniques others are using 14:07 kados btoumi: because there are many possible ways :-) 14:08 btoumi ok 14:08 btoumi i create a file who start stop and restart service zebra in mandriva 14:08 kados btoumi: can you send to koha-devel, along with attachment of file? 14:08 btoumi yes 14:09 kados thx, i think it will be useful for other zebra users too 14:09 btoumi i think so 14:12 btoumi kados can i join attcahed file for kohadevel? 14:13 kados btoumi: yep 14:13 btoumi ok i do it 14:27 btoumi kados i do something with small explanation 14:35 btoumi kados it's ok 14:39 btoumi bye all 14:40 kados btoumi++ 17:24 cht morning, chris. ru there? 17:59 cht i discovered an interesting bug with 2.2.6 and mysql 5 on debian sarge this week... 17:59 cht (i know this is an unsupported platform) 18:00 cht on the issuing rules page, when you enter something like 1,7,3 in one or more of the "fines" boxes... 18:01 cht and save, what you get back when the page repaints is something like "1.000000,3". 18:04 rch hmm. 18:04 rch just verified this on updated rel_2_2 etch/mysql5. 18:05 cht the simple solution is to edit the template to allow a longer maximum field length for the fines field 18:05 cht this is what i did 18:05 cht in other words, it is an HTML problem 18:06 cht or a number formatting problem in mysql 5 18:42 rch cht: committed fix for rel_2_@ 18:43 rch 2_2, even 18:46 cht cool 18:46 cht my first open source bug fix ;) 18:50 rch :) mysql5 changed the way it stores decimal data types. so if the column is defined as 6 decimal places, that's your output. 18:50 rch did you format in issuingrules.pl? or just template change/ 18:54 cht just the simple template change 18:57 cht if yuo got too carried away with formatting, you would run into currency localization issues for some currencies 18:58 cht perhaps currency localization ought to be a future koha feature? 18:58 cht the six decimal places does look pretty silly for dollars and cents 19:00 rch who uses more than 2 decimal places? 19:00 mason lawyers :) 19:01 rch :) 19:02 rch seriously... is there a reason to have >2 places? 19:02 mason hmm, i cant thik of any... 21:17 cht i guess there really is not a good reason for more, unless there is some currency somewhere that would require it 23:43 chris sounds like your marc framework is busted to me 23:49 mason try select * from biblio where title like '%welyk%'; 23:51 rickw question: does MySQL 5 allow 'contains' in where clauses? 23:52 chris no, and neither does 4 23:52 rickw select * from biblio where title contains 'welyk'; 23:52 rickw ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'contains 'welyk'' at line 1 23:52 rickw the above where is clause is generated by the koha search catalogue page (!) 23:52 kados select * from biblio where title like "welyk%"; 23:52 chris what version of koha are you running? 23:52 rickw plus: koha does not report an eror .. it silently returns an empty serach set 23:52 chris cos ive not seen that 23:52 rickw 2.2.7 23:52 kados that's a weird search ... 23:53 chris yeah, i cant find anywhere in the code that would make that search 23:53 rickw kados: yes, that is the syntax i would have xpected! 23:53 kados wouldn't expect that to be anywhere in koha ... searches are done now on marc_word in 2.2.7 23:53 kados not biblio 23:53 chris yes 23:53 rickw i just did a koha.upgrade 23:53 rickw from 2.0.0 to 2.2.7 23:53 kados ahh 23:53 mason ah, your reading from the web output aye 23:53 rickw successfully, as far as the databse itself goes 23:53 kados me has to run 23:53 kados ciao 23:54 rickw yes i am reading the web annotation 23:54 rickw perhaps it "lies" 23:54 chris i reckon the marc framework 23:54 mason its 'human friendy', ie not real sql 23:54 chris yeah 23:54 rickw btw: none of searches seem to work 23:54 chris probably you have no stopwords definied 23:54 chris and/or have no marc framework 23:54 rickw hmmmm ... so you don't suspect the sql itself. goof. 23:54 chris or no marc data 23:55 chris no, unless that error is in the actual error logs 23:55 rickw irma is reading this right now too 23:55 rickw and we are going "hmmmmmmmmmmmmm?" to ourslves 23:55 chris you have checked the error log? 23:56 rickw Chris it's Irma here...is the mARC data held in a different d/b or attached to those records that have MARC data? 23:56 chris well you wont have any marc data yet 23:57 chris actually i lie you will 23:57 chris its in the same db 23:57 rickw oly few ees bib records have MARC data 23:57 chris they all do 23:58 chris 2.0.0 stores marc data for you 23:58 rickw true 23:58 chris id check the stopwords 23:58 rickw so back to Rick's question of no display 23:58 rickw where? 23:59 rickw in 2.2.7 ,,,in the preferences? are they automated? 23:59 chris go to system administration 23:59 chris there should be a link to stop words 23:59 chris if none are defined, add one ... THE oughta do 00:00 mason yep 00:01 chris also the best place to look for errors is the error log usually in /usr/local/koha/log/ 00:01 dewey Hmm. No matches for that, chris. 00:01 rickw ok will do but remember Chris this is the unaltered Koha 2.2.7. download - no changes have been made to stop words by us as yet 00:02 chris right but you upgraded it right 00:02 chris from a 2.0.0 so its not a stock 2.2.7 install 00:02 chris as part of the install it makes stop words, im not sure it does as part of an upgrade 00:02 chris so id check 00:03 rickw we have 3 stop words in there already: a, an,the 00:04 chris k, then the next thing is to try a search, and then look at the error log 00:04 chris oh its mysql 5 right, you have made the mysql 5 changes to the search right? 00:04 chris anyway the error log will show if you havent right away :) 00:05 mason i'd turn the mysql logging on too 00:05 rickw rick here 00:05 rickw yes, i hgave made the chanegs to source code (two files Search*.pm) for mysql 5 00:05 rickw h5 just checking the error log now 00:05 chris i wouldnt yet, the error log will show what the error log is easy 00:05 rickw heh? 00:05 chris that was too mason 00:05 rickw too random! 00:06 chris mysql logging is going to just confuse things 00:06 mason Keep it stupid 00:06 rickw i am already stoopid! 00:07 rickw okay 00:07 rickw searched for 'uranium' 00:07 rickw no errors in log file 00:07 rickw no serach results 00:07 rickw :( 00:07 chris what is in the log file? 00:07 rickw well, there ar e hundresd of thousands of records in it ... ;) 00:07 rickw but nothing came out now 00:07 rickw i am doing a tail 00:08 chris on the koha-error_log ? 00:08 mason tail -f ? 00:08 rickw tail -f yup 00:08 mason cool 00:08 chris and you are trying the search in the librarian interface? 00:08 rickw yup 00:08 rickw well, intranet, catalogue serach page 00:09 chris apache 1.3 or apache 2 00:09 rickw sorry, should have been specifiec! 00:09 rickw apacehe 2 00:09 chris ok, anything in /var/log/apache2/error_log 00:09 rickw my url: http://koha227:8080/cgi-bin/koha/search.marc/search.pl?type=intranet 00:09 chris sometimes apache2 is weird 00:09 rickw um .. is apache2 writing TWO error logs for theone virtual host? 00:09 rickw i'll check, but i doubt it 00:10 chris no it has its main error log, then one per virtual host 00:10 rickw okay 00:10 chris sometimes errors that you would think would show up in the virtual host one, show up in the main one 00:10 rickw there is debug stuff (Q : select blah bklha) in apache error.log 00:10 chris right 00:10 chris see that oughta be in the koha-error_log 00:10 rickw (that is because the code is calling something like Apache.reuqest.write() or similar) 00:11 rickw "my" variable $thiscount masks earlier declaration in same scope at /usr/local/koha/intranet/cgi-bin/calyx/bibliobrowser-new.pl line 183. 00:11 chris i doubt it.. or not intentionaly its not 00:11 rickw is in error.log 00:11 chris right thats just a warn 00:11 mason yep 00:11 chris so the debug has the query, what happens if you run that query in mysql 00:12 rickw mysql> select distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_word as m1 where biblio.biblionumber=marc_biblio.biblionumber and biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and (m1.word like 'mining') order by biblio.title ASC; 00:12 rickw Empty set (0.00 sec) 00:12 rickw tell me .. was a different query being used in koha 2.0.0 00:12 chris probably 00:13 rickw the like clause looks sus ... should be like '%mining%' perhaps? 00:13 chris nope 00:13 rickw why use like? 00:13 chris cos you can wildcard it 00:13 chris if you had gone mining* 00:13 chris in your search 00:13 rickw can I in the user inerface, on the serach page 00:13 rickw i.e. use % and _ ??? 00:13 chris * you can use 00:13 rickw ah, okay 00:14 rickw i guess most ppl unnerstand * 00:14 chris yep 00:14 chris what does 00:14 rickw so the mystery is: why are our 2.2.7 seraches failing 00:14 chris select * from marc_word where word like 'mining'; 00:14 chris return 00:14 chris anything ? 00:14 rickw select count(*) from marc_word; 00:14 rickw +----------+ 00:14 rickw | count(*) | 00:14 rickw +----------+ 00:14 rickw | 0 | 00:14 rickw +----------+ 00:14 rickw hahahaha 00:15 rickw um, should be perhaps run a script to "MARC-size" everything? 00:15 chris theres your problem right there 00:15 chris select count(*) from biblio; 00:15 rickw (I have no idea what MARC is yet, or what this is all about ... i am jsut a humble programmer) 00:15 chris anything there? 00:15 rickw biblio is fine, 16644 records 00:15 chris hmmm 00:15 mason biblio2marc.pl ? 00:16 chris no mason 00:16 rickw i have never run that. 00:16 rickw should i ?? 00:16 chris hang on 00:16 chris do you have a copy of the 2.0.0 database? 00:16 rickw yes i do 00:16 rickw but not in mysql right now 00:16 chris can we just check marc_word is empty in it too 00:16 rickw i could import it in, if required 00:16 chris can just grep it 00:17 rickw hmmm ... i can get back to you iun a few minutes and let you know, if that is alright 00:17 chris k 00:17 rickw yeah, i can vi the file :) 00:17 chris should be a bunch of insert into marc_word lines 00:17 chris if there was data in marc_word 00:18 chris if not, then we can try running koha2marc.pl 00:18 rickw marc_word not foudn in the entire dataset :( 00:18 rickw i am willoing to try that 00:18 chris k 00:18 rickw (we can always recover this entire test system if need be :) 00:18 chris as a user that can read /etc/koha.conf 00:18 chris prolly root is easiest 00:19 rickw how do you generally run your perl shell scripts? 00:19 rickw (a) ensure they are in $PATH 00:19 rickw (b) perl /full/path/ot/perl/script 00:19 rickw ? 00:19 chris like this usually 00:20 chris perl -I /usr/local/koha/intranet/modules /usr/local/koha/intranet/scripts/misc/koha2marc.pl 00:20 rickw well, i do have $PERL4LIB set for my sehlls :) 00:20 rickw it is running 00:20 rickw Processing 336 00:20 rickw etc.etc. 00:20 chris cool 00:20 rickw s/PERL4/PERL5/ (oops) 00:20 chris you could look in mysql 00:20 rickw ]as it runs? 00:20 chris and see if marc_word is being populated 00:21 chris yeah, open another shell 00:21 rickw select count(*) from marc_word; 00:21 rickw +----------+ 00:21 rickw | count(*) | 00:21 rickw +----------+ 00:21 rickw | 18466 | 00:21 rickw +----------+ 00:21 rickw yay 00:21 chris sweet 00:21 rickw let me guess 00:21 chris select * from marc_word where word like 'mining'; 00:21 rickw it is creating an index of 'words' as found in the biblio tables?!?!? 00:21 chris return anything now? 00:21 chris yeah its creating all the marc, ie taking biblio.title and making that 245a 00:22 chris basically its making skeletal marc records of all your data 00:22 chris plus an index to search over 00:22 rickw yes .. heaps of results 00:22 chris cool 00:22 rickw this is what irma expects, which is great! 00:22 chris so if you try ur search in koha now 00:23 chris do you get results 00:23 rickw yes we do 00:23 rickw thanks!! 00:23 chris cool 00:23 rickw so, is this new to 2,2,7 00:23 rickw ? 00:23 mason nice work lads 00:23 chris 2.0.0 should have had marc .. im puzzled about that 00:23 rickw i.e. is that what you or mason meant about "it now uses a marc search" 00:23 rickw well, as long as I know now 00:24 rickw you see, this is a discardable test system 00:24 chris yep 00:24 rickw and the whole thing will have to be redone when we actually do our production migration 00:24 rickw in a while 00:26 chris yeah all the 2.2.x releases search using the marc_word table 00:26 rickw okay that's great to know now 00:26 rickw perhaps it should be part of the koha.upgrade script?!?! 00:27 rickw i don't recall this particular prob on the Koha mailing list. 00:27 chris well not really, cos 2.0.0 should have marc_word already 00:27 rickw are those librarians telepathic, clairvoyant or what? 00:27 rickw (I know they secretly communiate using channels the FBI and CIA cannot monitor!) 00:27 chris you dont want to rebuild the marc tables 00:28 chris if they already exist as far more is stored in there, and you will end up clobbering it 00:28 chris so the odd thing was that your koha didnt have the marc tables already 00:29 chris ie the upgrade from 1.2.x to 2.0.x 00:29 rickw yes, i am confgused and am asking irma ll about it as I type this 00:29 chris is where the koha2marc.pl should be run 00:29 chris but if it works thats fine :) 00:30 rickw hmmm .. cannot 'find' an author 00:31 rickw oops, 00:31 rickw that script is till running 00:31 rickw tell me, should i perhaps do a count(*) and all the marc tables? 00:31 rickw or is that script going to populate all the marc-related tables? 00:31 rickw irma now .... 00:33 rickw just clarifying...When a record is imported from another catalogue it's vis MARC protocol - when we have catalogued an item, ne MARC record was created or do I understand that a MARC record is created automatically anyway for each item catalogued? 00:33 mason hiya, its created automatically 00:34 rickw even the content of the notes field? mapped to which tag? 00:35 mason theres a bunch of koha to marc mapping stuff defined by efault 00:36 mason ive u go to sys-params, then to the 'Links Koha - MARC DB' url 00:36 mason s/ive/if 00:37 rickw ok...makes sense ...last configuration of koha for me is over 2 years ago with Alexandre and Katipo's help. 00:37 mason you can set what koha fields you want automatically mapped to which marc tags (and visa versa) 00:38 rickw thanks Mason. signing out. Thanks a lot Irma and Rick 00:39 mason try this link -> http://koha227:8080/cgi-bin/koha/admin/koha2marclinks.pl 00:39 mason and this -> http://koha227:8080/cgi-bin/koha/admin/marctagstructure.pl?frameworkcode= 00:40 rickw thanks will dooooooooo 00:40 mason coolies :) 00:40 rickw we owe you a couple of coolies :) 06:43 btoumi hi all