← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 13:43 | kados | paul: you here? |
| 13:43 | paul | yep |
| 13:43 | (5:45PM in france) | |
| 13:43 | kados | paul: I was wondering if you could send me the init scripts you have |
| 13:43 | paul: I will compare them to ours and commit something | |
| 13:43 | paul | ??? |
| 13:43 | kados | paul: for zebra |
| 13:43 | paul: to daemonize zebra, etc. | |
| 13:44 | paul | ah, ok. I don't have anything related to daemonization of zebra |
| 13:44 | you should ask sanop... | |
| 13:44 | (although we will need something soon, as IPT will migrate to 3.0 in february probably... | |
| 13:44 | ) | |
| 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 | yet even | |
| 13:48 | I get back on Thursday morning EST | |
| 13:50 | mail sent | |
| 13:52 | paul: I just updated rel_2 and I get: | |
| 13:52 | Can't locate C4/Calendar/Calendar.pm in @INC | |
| 13:52 | paul: is it a new dependency? | |
| 13:54 | paul: it seems it was added to Circ2.pm | |
| 13:54 | paul: but there is no C4/Calendar/Calendar.pm | |
| 13:55 | :-) | |
| 13:55 | rch | kados: cvs -d ? |
| 13:56 | kados | hmmm |
| 13:56 | guess I didn't | |
| 13:57 | _paul | kados : |
| 13:57 | toins worked this morning on 2.2.7.1 | |
| 13:57 | he created the CVS branch & synched everything from 2.2.7 considering only bugfixes. | |
| 13:57 | 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 | 2.2.8 + improvements = 2.2.9 | |
| 13:59 | kados | I agree 2.2.8 is better |
| 13:59 | do we want to try to build translations too? | |
| 14:00 | 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 | so I hope soon it will be ready | |
| 14:01 | _paul: there are many languages there now, have a look when you get a chance :-) | |
| 14:01 | I think there is a bug for generating the po file for the intranet templates though | |
| 14:01 | at least the last time I tried it | |
| 14:02 | _paul | is it a 0.2 version of kartouche ? |
| 14:02 | or a newer one ? | |
| 14:02 | because kartouche seems an abandonned project | |
| 14:03 | kados | it's .2 + many improvements |
| 14:03 | I have contacted the maintainer | |
| 14:03 | 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 | 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 | kados, btoumi is here now ;-) | |
| 14:04 | btoumi | hi kados |
| 14:04 | kados | hi btoumi |
| 14:04 | btoumi: did you see my question to koha-devel? | |
| 14:05 | btoumi: maybe you could respond with some details about how you manage the zebra server's process | |
| 14:05 | btoumi: if you have some time? | |
| 14:05 | btoumi | have some time? |
| 14:05 | i have some time | |
| 14:05 | 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 | btoumi: it would be useful to know what techniques others are using | |
| 14:07 | btoumi: because there are many possible ways :-) | |
| 14:08 | btoumi | ok |
| 14:08 | 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 | kados can i join attcahed file for kohadevel? | |
| 14:13 | kados | btoumi: yep |
| 14:13 | btoumi | ok i do it |
| 14:27 | kados i do something with small explanation | |
| 14:35 | kados it's ok | |
| 14:39 | bye all | |
| 14:40 | kados | btoumi++ |
| 17:24 | cht | morning, chris. ru there? |
| 17:59 | i discovered an interesting bug with 2.2.6 and mysql 5 on debian sarge this week... | |
| 17:59 | (i know this is an unsupported platform) | |
| 18:00 | on the issuing rules page, when you enter something like 1,7,3 in one or more of the "fines" boxes... | |
| 18:01 | and save, what you get back when the page repaints is something like "1.000000,3". | |
| 18:04 | rch | hmm. |
| 18:04 | 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 | this is what i did | |
| 18:05 | in other words, it is an HTML problem | |
| 18:06 | or a number formatting problem in mysql 5 | |
| 18:42 | rch | cht: committed fix for rel_2_@ |
| 18:43 | 2_2, even | |
| 18:46 | cht | cool |
| 18:46 | 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 | did you format in issuingrules.pl? or just template change/ | |
| 18:54 | cht | just the simple template change |
| 18:57 | if yuo got too carried away with formatting, you would run into currency localization issues for some currencies | |
| 18:58 | perhaps currency localization ought to be a future koha feature? | |
| 18:58 | 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 | 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 | 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 | 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 | not biblio | |
| 23:53 | chris | yes |
| 23:53 | rickw | i just did a koha.upgrade |
| 23:53 | 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 | ciao | |
| 23:54 | rickw | yes i am reading the web annotation |
| 23:54 | 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 | 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 | no, unless that error is in the actual error logs | |
| 23:55 | rickw | irma is reading this right now too |
| 23:55 | 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 | actually i lie you will | |
| 23:57 | its in the same db | |
| 23:57 | rickw | oly few ees bib records have MARC data |
| 23:57 | chris | they all do |
| 23:58 | 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 | where? | |
| 23:59 | in 2.2.7 ,,,in the preferences? are they automated? | |
| 23:59 | chris | go to system administration |
| 23:59 | there should be a link to stop words | |
| 23:59 | 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 | from a 2.0.0 so its not a stock 2.2.7 install | |
| 00:02 | as part of the install it makes stop words, im not sure it does as part of an upgrade | |
| 00:02 | 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 | oh its mysql 5 right, you have made the mysql 5 changes to the search right? | |
| 00:04 | 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 | yes, i hgave made the chanegs to source code (two files Search*.pm) for mysql 5 | |
| 00:05 | 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 | okay | |
| 00:07 | searched for 'uranium' | |
| 00:07 | no errors in log file | |
| 00:07 | no serach results | |
| 00:07 | :( | |
| 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 | but nothing came out now | |
| 00:07 | 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 | well, intranet, catalogue serach page | |
| 00:09 | chris | apache 1.3 or apache 2 |
| 00:09 | rickw | sorry, should have been specifiec! |
| 00:09 | apacehe 2 | |
| 00:09 | chris | ok, anything in /var/log/apache2/error_log |
| 00:09 | rickw | my url: http://koha227:8080/cgi-bin/ko[…].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 | 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 | 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 | "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 | Empty set (0.00 sec) | |
| 00:12 | 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 | if you had gone mining* | |
| 00:13 | in your search | |
| 00:13 | rickw | can I in the user inerface, on the serach page |
| 00:13 | i.e. use % and _ ??? | |
| 00:13 | chris | * you can use |
| 00:13 | rickw | ah, okay |
| 00:14 | i guess most ppl unnerstand * | |
| 00:14 | chris | yep |
| 00:14 | 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 | return | |
| 00:14 | anything ? | |
| 00:14 | rickw | select count(*) from marc_word; |
| 00:14 | +----------+ | |
| 00:14 | | count(*) | | |
| 00:14 | +----------+ | |
| 00:14 | | 0 | | |
| 00:14 | +----------+ | |
| 00:14 | hahahaha | |
| 00:15 | um, should be perhaps run a script to "MARC-size" everything? | |
| 00:15 | chris | theres your problem right there |
| 00:15 | 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 | should i ?? | |
| 00:16 | chris | hang on |
| 00:16 | do you have a copy of the 2.0.0 database? | |
| 00:16 | rickw | yes i do |
| 00:16 | 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 | if there was data in marc_word | |
| 00:18 | if not, then we can try running koha2marc.pl | |
| 00:18 | rickw | marc_word not foudn in the entire dataset :( |
| 00:18 | 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 | prolly root is easiest | |
| 00:19 | rickw | how do you generally run your perl shell scripts? |
| 00:19 | (a) ensure they are in $PATH | |
| 00:19 | (b) perl /full/path/ot/perl/script | |
| 00:19 | ? | |
| 00:19 | chris | like this usually |
| 00:20 | 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 | it is running | |
| 00:20 | Processing 336 | |
| 00:20 | 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 | yeah, open another shell | |
| 00:21 | rickw | select count(*) from marc_word; |
| 00:21 | +----------+ | |
| 00:21 | | count(*) | | |
| 00:21 | +----------+ | |
| 00:21 | | 18466 | | |
| 00:21 | +----------+ | |
| 00:21 | 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 | yeah its creating all the marc, ie taking biblio.title and making that 245a | |
| 00:22 | basically its making skeletal marc records of all your data | |
| 00:22 | 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 | do you get results | |
| 00:23 | rickw | yes we do |
| 00:23 | thanks!! | |
| 00:23 | chris | cool |
| 00:23 | rickw | so, is this new to 2,2,7 |
| 00:23 | ? | |
| 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 | well, as long as I know now | |
| 00:24 | 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 | 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 | perhaps it should be part of the koha.upgrade script?!?! | |
| 00:27 | 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 | (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 | if they already exist as far more is stored in there, and you will end up clobbering it | |
| 00:28 | so the odd thing was that your koha didnt have the marc tables already | |
| 00:29 | 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 | but if it works thats fine :) | |
| 00:30 | rickw | hmmm .. cannot 'find' an author |
| 00:31 | oops, | |
| 00:31 | that script is till running | |
| 00:31 | tell me, should i perhaps do a count(*) and all the marc tables? | |
| 00:31 | or is that script going to populate all the marc-related tables? | |
| 00:31 | irma now .... | |
| 00:33 | 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 | ive u go to sys-params, then to the 'Links Koha - MARC DB' url | |
| 00:36 | 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/ko[…]koha2marclinks.pl |
| 00:39 | and this -> http://koha227:8080/cgi-bin/ko[…]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 |
← Previous day | Today | Next day → | Search | Index