Time  Nick   Message
11:19 btoumi joshua are u around ?
11:25 kados  btoumi: yes
11:25 kados  btoumi: what's up?
11:25 btoumi hi kodaos how are u?
11:25 btoumi i have question for u about mysql optimistation
11:27 btoumi kados: paul tell me that u have 512 ram for tempory operation from mysql
11:27 btoumi kados: how do u do that?
11:28 kados  you can check the my.cnf file and the documentation on mysql on that file
11:29 kados  after modifying the file, be sure to restart the mysql process
11:29 kados  are you having trouble with speed?
11:29 btoumi no just for optimisation
11:32 paul   btoumi: &kados : what I said to SAN was that you had the temporary mysql directory that was a RAM disk. It speeds up a lot sortings when needed
11:33 paul   (although thinking of it, i'm not sure it's as important with zebra as it was with marc_word SQL table...)
11:35 kados  I don't think it's necessary anymore
11:36 kados  NPL doesn't need it
11:59 paul   kados : http://i15.bureau.paulpoulain.com/cgi-bin/koha/mainpage.pl (test/test) will show you the IPT catalogue, fully migrated to koha 3.0... i'm working on some screenshots for french libraries, on infos list.
12:00 paul   (some encoding problems though, but not a big deal, I did it just as POC)
12:04 owen   kados, did I see in the log that bug 1215 has been resolved for cm?
12:21 kados  owen: yes, it was happening because she didn't have itemtypes
12:21 kados  owen: I'll close it out
12:21 owen   I just filed you a new one :)
12:21 kados  ok :-)
12:22 kados  paul: I'll take a look
12:23 kados  owen: that's a nice one :-)
12:23 owen   Yeah, I'm sure that'll be a fun one
12:24 owen   It's easy to see how that could be confusing
12:24 kados  well and or and not are keywords
12:24 kados  so it'll be tricky
12:24 kados  doable, but tricky :-)
12:24 kados  paul: do you have a sec?
12:24 paul   yep
12:25 kados  paul: I just discovered a bug in rel_2_2 caused by userenv
12:25 kados  paul: for a library that has insecure == 1
12:25 kados  paul: [Thu Dec 07 08:45:16 2006] [error] [client 71.124.123.132] Can't use string ("0") as a HASH ref while "strict refs" in use at /home/koha/rel22/koha/intranet/cgi-bin/MARCdetail.pl line 90.
12:25 paul   insecure==1 ??? wow, nobody is supposed to have insecure=1, it's just for developper testing (& w3c validating)
12:26 kados  paul: some libraries use Koha behind a firewall so it's OK
12:26 kados  paul: this is a corporate client
12:26 paul   I don't think so, because they are anonymous, so Koha won't know "who" did an acquisition, or a cataloguing, or ...
12:27 paul   that's the same as working with koha with the mysqladmin login/password : it's a very very bad idea
12:27 kados  it worked in a previous version of KOha but not in 2.2.7
12:27 kados  I believe it worked in 2.2.2
12:27 kados  they have been using Koha for several years and just upgraded to 2.2.7 and now have this problem
12:29 paul   kados :
12:29 paul   $template->param("candelete"=>1) if ($val==0||C4::Context->userenv->{flags} eq "1");
12:29 paul   replace by :
12:30 paul   $template->param("candelete"=>1) if ($val==0||(C4::Context->userenv && C4::Context->userenv->{flags} eq "1"));
12:30 paul   but I can't promize the problem won't occur somewhere else...
12:30 kados  ok, I'll test and commit
12:30 paul   anyway userenv->{something} fails when you're not logged in
12:30 kados  and if I find other examples I'll do the same
12:31 paul   so, just check that userenv exists before (= a user is logged in)
12:31 kados  right
12:32 kados  paul: also, this client was wondering if it woudl be OK to have a syspref for disabling the patron expiry code
12:32 kados  paul: do you have an opinion on that?
12:32 paul   mmm... setting 999years to membership duration is not enough ?
12:33 paul   not 999, but 99 (otherwise, you'll reach unix/linux date limits)
12:33 kados  right ...
12:33 paul   the patron still has an expiry date, but it's not reached
12:33 kados  but the expiry date is created when the patron is created so we'd need to change the dates in the database
12:34 kados  (not hard, just annoying for them)
12:34 kados  for existing patrons
12:34 kados  what about a syspref to disable the warning
12:34 paul   the expiry date is calculated from borrowercategory subscription duration, so th pb exist only for already existing ones
12:35 kados  paul: a syspref to disable the warning in circ ok with you?
12:35 paul   yes
12:36 paul   OK, but useless (until someone will be happy using it ;-) )
12:36 kados  right
12:39 kados  update borrowers set expiry='2099-01-01'; is too easy ;-)
13:11 _paul  kados ?
13:11 dewey  i guess kados is becoming a true Perl Monger...
13:11 _paul  a search on au-phr : what is the difference with a search on au ?
13:11 _paul  (it don't work on unimarc & we don't know why)
13:19 hdl    paul : As I understand it, phr stands for Full Phrase and normal sill search only on words.
13:19 hdl    s/sill/will/
13:20 paul   that's what I suspected, but it don't work at SANOP...
13:20 hdl    Do we have set Title:p  ?
13:20 hdl    for instance ?
13:20 hdl    in record.abs
13:22 paul   melm 200$a		title:w,title:p,title:s
13:22 paul   melm 200$f		author,author:p,author:s
13:23 paul   so, yes, we have author:p
13:23 hdl    ccl.properties ?
13:23 dewey  it has been said that ccl.properties is about 1000 lines of config and documentation
13:23 hdl    thx dewey :D
13:23 paul   st-phrase 4=1
13:23 paul   phr st-phrase
13:24 paul   (it's the kados one)
13:24 hdl    et au-phr ?
13:24 paul   none
13:53 rch    hdl: i'm looking at your authorities record.abs file...
13:53 paul   hi rch
13:53 rch    hi paul
13:53 hdl    hi rch
13:53 hdl    yes and ?
13:53 rch    he hdl
13:53 rch    (hi)
13:54 rch    hdl: can you comment on mainentry vs mainmainentry in the code?
13:54 rch    and Heading vs Heading-Entry?
13:55 hdl    Yes :
13:55 hdl    It was in order to cope with :
13:56 hdl    searching ONLY $a
13:56 hdl    and searching the WHOLE tag.
13:57 hdl    So Heading-Entity stands for the Whole Tag and Heading stands for $a only
13:57 hdl    (We had a search like that in rel_2_2.
13:57 hdl    )
13:57 hdl    Am I clear ?
13:59 hdl    rch ?
13:59 dewey  i guess rch is having some issues with customizablility in prog opac tmpl...
13:59 rch    okay, thx
13:59 rch    I get it.
14:00 rch    For some reason it looked backwards to me, but it is clear now
14:00 rch    :)
14:01 rch    I was getting full tag searchs when I wanted $a srch.
14:02 hdl    I wrote Entity and you read Entry...
14:02 rch    s/tr/tit/g
14:03 hdl    Sure, it is an vacabulary problem.
14:03 rch    my memory is not so sharp... :)
14:04 hdl    s/vacabulary/vocabulary/
16:21 owen   kados: are you around?
16:52 kados  owen: yep, am now
16:52 kados  got your email
16:52 kados  negitive values can't be reserved or checked out
16:53 kados  but I don't think they are excluded from search results
16:53 owen   Negative values can't be reserved? But we're using -1 for 'ordered,' and the point was for users to be able to reserve those items
16:54 kados  I'm sorry, I got it backwards
16:54 kados  positive values can't be reserved, negative ones can
16:55 kados  you could have a bookmobile status
16:56 kados  using notforloan or binding
16:56 kados  they both essentially work the same way
16:56 kados  the 'status change' page you describe would be pretty easy to set up
16:57 kados  I'd think 2-3 hours max
16:57 kados  feel free to file an enhancement request and I'll get to it as soon as I can
17:04 owen   Thanks. I'm quittin' early, so I'll read you later
20:00 mason  .
20:06 mason  hi joshua, i had a little question about the search urls in the marcdetail.pl view
20:07 mason  see this bib -> http://koha.liblime.com/cgi-bin/koha/MARCdetail.pl?bib=26180
20:07 mason  see the '245 -TITLE STATEMENT' block
20:09 mason  well, clicking on the '?' url on its right , kicks off a search for the title '101 Australian songs for easy guitar.'
20:09 mason  http://koha.liblime.com/cgi-bin/koha/search.marc/search.pl?op=do_search&marclist=245&operator==&type=intranet&value=101%20Australian%20songs%20for%20easy%20guitar.
20:11 mason  which successfully returns results
20:12 mason  .
20:12 mason  but on my dev koha, all the '?' searches fail for all of the MARC fields
20:13 mason  that dont have a tag value
20:15 mason  meaning , that dont have a marclist=245a in the url
20:17 mason  there seems to be something in the search sql in Search.pm? thats different in my koha to the liblime demo one.
20:19 mason  i think ill just wait till chris is about so i can see if we have a 2.2.6 koha ,so i can test the sql differences myself
20:24 kados  I'm sorry, I had a phone call
20:24 mason  ah, np
20:25 kados  afaik the marc searching by ? doesn't work in dev_week
20:25 mason  ah, i actually have a succinct question...
20:25 mason  see this -> http://koha.liblime.com/cgi-bin/koha/MARCdetail.pl?bib=26180
20:26 mason  why does the 260 block have its tag values (a,b,c) showing....
20:27 mason  and the 254 block , have a title record, but not a tag showing for the title?
20:27 mason  does something (hide_marc?? ) control which tags are hidden for display?
20:29 mason  .
20:29 mason  ah, see in the opac view of this bib, the 245a does show
20:29 mason  http://opac.liblime.com/cgi-bin/koha/opac-MARCdetail.pl?bib=26180
20:29 mason  245 -TITLE STATEMENT
20:29 mason  a 	Title 	101 Australian songs for easy guitar.
20:32 mason  .
20:33 mason  ah, i can find that out myself...
21:01 kados  mason: there's a visibility flag
21:01 kados  mason: it's the 'hidden' value
21:01 kados  mason: it has values ranging from -9 to 9
21:01 kados  mason: see the help file in the subfield edit screen
21:03 mason  ah thanks :)
04:49 rch    good morning France
05:07 _paul  hi rach
05:07 btoumi hi all
05:11 rch    hi paul , btoumi
05:12 btoumi hi rch
05:12 rch    can anyone verify that rel_3_0 authorities config files are working? (for unimarc,even)?
06:03 hdl    rch : Which problem do you have.
06:03 hdl    It works for Paul and me.
06:03 hdl    rch : Do you get nothing via yaz-client ?
06:04 hdl    rch : Does an internal server error occur when searching with Koha.
06:04 hdl    sorry to answer so late.
10:32 hdl    rch around ?