Time  Nick          Message
23:25 chris         heh
23:25 brendan       ah the channel goes quiet after wizzyrea and owen leave :)
22:57 * owen        thinks, Let's see a monkey do that!
22:52 * owen        absolves wizzyrea
22:51 wizzyrea      dangit owen, now I feel guilty
22:51 wizzyrea      mason*
22:51 wizzyrea      lol masosn
22:51 mason         s/to/you/
22:51 mason         .. with a bunch of kids, waiting to ride you like a horsey -  when to get there ;)
22:49 wizzyrea      i'm like the thirsty person in the desert... belly crawling towards the end of day oasis
22:49 pianohacker   just enough time for a patch!
22:49 wizzyrea      can't... do... it...
22:49 owen          No, wizzyrea, 12 more minutes of productivity!
22:48 wizzyrea      I'm out, ttyl :)
22:45 brendan       heya mason
22:45 |Lupin|       k, time to go to bed, til soon everybody, bye
22:45 wizzyrea      hi mason
22:45 mason         heya folks..
22:44 chris         heh
22:44 owen          chris: It'll be time for a re-make by then
22:42 chris         2020 or soething
22:41 pianohacker   bleh. I generally oppose torrenting, but the release schedule for dr. who episodes in the US is truly ridiculous
22:40 owen          chris: Was it supposed to happen last week instead?
22:40 wizzyrea      probably.
22:40 chris         misread the mayan calendar
22:40 chris         did you see that totally screwed up the dates for that?
22:40 owen          wizzyrea: They're busy torrenting the new Dr. Who special.
22:40 pianohacker   owen: They sure don't make statues of liberty like they used to
22:39 wizzyrea      yay, 400k download speed here. Jebus, what happened to our ISP. Criminy
22:39 wizzyrea      lol owen
22:38 owen          Just in time for the **AAAHH** <crushed by a falling national monument>
22:38 chris         i hear that
22:38 chris         heh
22:38 * pianohacker adds it to Koha to-do list, notes that at this rate it'll get done sometime in 2012
22:37 chris         that works
22:37 pianohacker   I think I'd send an updatedatabase and tweaks to make it an actual bitmask, then fix the interface
22:37 chris         exactly
22:37 pianohacker   That's the only help page I've ever needed to refer to more than once
22:36 chris         i want to kill someone
22:36 chris         everytime i read 1 => !OPAC Intranet Editor Collapsed
22:36 pianohacker   chris: the far worse part is that the hidden field is allllmost a bitmask, but not quite
22:35 owen          Not sure if it's too impractical (or messy) to add functionality that works for only one tag's subfields.
22:35 chris         what are we indexdata
22:35 chris         with the hidden thing
22:34 chris         yeah can we kill those numbers
22:33 |Lupin|       owen: 995
22:33 owen          ..although the "hidden" field is for all tags, and this would only be relevant to 952 (or whatever it is in UNIMARC)
22:32 pianohacker   dropdown at least, preferably checkboxes
22:32 pianohacker   owen: I've wanted to redo hidden for a long time
22:32 pianohacker   wizzyrea: I think I have seen that
22:32 owen          Even if we didn't get as far as enabling reordering, perhaps we could add functionality to the "hidden" constraint in the subfield editor
22:32 chris         yes that would be right, because you dont want an ordinary user able to do, would be an easy way to get hacked
22:31 |Lupin|       I just tried to add a trigger and mysql said the SUPER privilege is required to do that...
22:31 wizzyrea      (though I think we've talked about that before_
22:31 wizzyrea      dk if you're familiar
22:31 wizzyrea      ph: i like that. See the WP widget interface
22:29 |Lupin|       shouldn't the koha user have all the priviledges over the koha db ?
22:29 |Lupin|       when one follows the instructions given in the INSTALL files
22:29 |Lupin|       hmm
22:29 owen          Not that I'm smart enough to make it happen...
22:29 pianohacker   owen: A cute little Reorder button that brought up a drag-and-drop display?
22:28 wizzyrea      owen++ that would roxxor my soxxors
22:28 owen          (...bringing up another interface disaster...)
22:28 owen          I wonder if we could add an option to frameworks to control display of subfields in the add item interface?
22:26 pianohacker   nothing too insane, but it would remove the need for the .pl to handle little things like logged-in branch first
22:25 pianohacker   owen: mainly the option to do _some_ post-processing of the data
22:25 owen          pianohacker: what kind of improvements would we get from an alternate templating system?
22:25 pianohacker   yup, that's entirely based on the MARC framework
22:24 pianohacker   There's a lot of tiny, in-many-places interface tweaks that our retarded templating system makes very difficult
22:24 owen          Yeah, edit items table is in subfield order.
22:24 wizzyrea      3. the edit items table should be optimized for usefulness, with commonly used columns like barcode and home/holding branch not on the part you can't see and have to scroll for.
22:23 wizzyrea      (in drop downs, both)
22:23 wizzyrea      2. logged in branch should always get preference
22:22 wizzyrea      1. alphabetization!
22:22 wizzyrea      ooh, I'm sure we can come up with some for you
22:22 owen          In fact I think the table isn't designed at all, I think it's just dumped.
22:22 owen          In fact I was thinking of doing a blog post on interface peeves
22:22 wizzyrea      and the barcode (used all the time) on the right?
22:22 wizzyrea      why put the fields that are not the most often used at the left of the table?
22:21 wizzyrea      ok, this is seriously a beef of mine
22:21 wizzyrea      well there's the edit items table...
22:21 * owen        tries to think of a good interface disaster to blame on monkeys
22:20 wizzyrea      not exactly the answer I was looking for
22:20 wizzyrea      doh
22:19 owen          I hear folks are getting very good results from monkeys these days.
22:19 pianohacker   We need your css, owen!
22:19 wizzyrea      who will design the koha interface?
22:19 * wizzyrea    will go kill owen herself if he goes to play in traffic and gets hurt.
22:19 pianohacker   Hehe
22:19 owen          Sorry pianohacker, I'm working the circ desk. Can't run out into traffic for another 45 min or so.
22:18 wizzyrea      ;)
22:18 wizzyrea      that's like, geek speak for "go play in traffic"
22:18 munin         joetho: The current temperature in DEAN\'S WEATHER STATION, PRESCOTT, Kansas is 4.7�C (3:43 PM CST on November 16, 2009). Conditions: Light Rain. Humidity: 97%. Dew Point: 4.0�C. Windchill: 2.0�C. Pressure: 29.95 in 1014.1 hPa (Rising).
22:18 joetho        @wunder fort scott, ks
22:18 * pianohacker hopes owen didn't take his rather droll joke literally
22:17 wizzyrea      gerg, I keep getting pulled off of my task by koha questions. Not that I mind particularly, but it does make getting things done rather difficult :/
22:17 munin         brendan: The operation succeeded.  Quote #47 added.
22:17 brendan       @quote add pianohacker bah, go collision attack the front of a moving car
22:15 wizzyrea      :)
22:15 munin         wizzyrea: Quote #23: "<gmcharlt> /msg munin register nick password" (added by wizzyrea_ at 12:25 PM, August 06, 2009)
22:15 wizzyrea      @quote get 23
22:15 munin         brendan: Error: You must be registered to use this command. If you are already registered, you must either identify (using the identify command) or add a hostmask matching your current hostmask (using the "hostmask add" command).
22:15 brendan       @quote add pianohacker bah, go collision attack the front of a moving car
22:15 wizzyrea      my quote add capability is somehow broken
22:15 wizzyrea      LOL someone quote add that
22:14 pianohacker   bah, go collision attack the front of a moving car
22:14 * owen        looks accusingly at everyone else
22:13 pianohacker   just a few
22:13 brendan       yeah I'd say there are some geeks in this channel
22:13 brendan       heh
22:13 wizzyrea      I always like it when a question I ask incites geekery well beyond the original question
22:12 pianohacker   brendan: though that falls into the category of an unintentional DOS
22:12 brendan       chris_n is into that kind of stuff
22:12 brendan       more like a prime number with 10 million digits
22:12 wizzyrea      lulz
22:12 pianohacker   finally, an actual practical use for memorizing pi
22:12 pianohacker   ooh
22:11 wizzyrea      like, pi to the 10000th digit?
22:11 wizzyrea      define "particularly long"
22:11 pianohacker   hehe, a particularly long passphrase might come close
22:11 wizzyrea      one of my libraries asked
22:11 wizzyrea      well, I can do my best I suppose ;)
22:11 owen          wizzyrea: Are you going to run right out and try to overload the password length?
22:10 |Lupin|       sorry wizzyrea to have been confusing
22:10 |Lupin|       oops
22:10 pianohacker   wizzyrea: np
22:10 pianohacker   </geekery>
22:10 pianohacker   tho we _really_ ought to be moving towards using sha-256, given the known collision attacks against MD5
22:10 wizzyrea      well it's a good thing I asked, thanks ph
22:10 wizzyrea      makes sense
22:09 wizzyrea      Ahhhhh
22:09 pianohacker   wizzyrea: no; the password is hashed using MD5, and the hash is always the same length
22:09 owen          But that's the md5'ed length, isn't it?
22:09 wizzyrea      wouldn't that mean 30?
22:09 wizzyrea      `password` varchar(30) default NULL,
22:07 pianohacker   There shouldn't actually be a max that you're likely to hit
22:07 pianohacker   |Lupin|: not in this case, since it's hashed
22:06 |Lupin|       wizzyrea: (it's a mysql statement)
22:06 |Lupin|       wizzyrea: desc borrowers should tell you
22:04 wizzyrea      erm... 1s I may be able to help myself on that one
22:04 wizzyrea      question: is there a max length for the OPAC password?
21:58 |Lupin|       so that's one thing to avoid for portability
21:58 |Lupin|       OLD and NEW are MySQL extensions to triggers.
21:51 chris         not sure, ive never tried triggers in mysql
21:49 hdl           chris is the syntax between mysql and postgresql the same ?
21:45 |Lupin|       hdl: well that's a temporary thing, so that's fine, and the benefit of having a real-time update of the shelf content is worth the price in the situation I think
21:45 chris         postgres has triggers
21:44 hdl           ties you with mysql... But well...
21:43 |Lupin|       hdl: yeah triggers are even nicr cause it's completely dynamic and ran exactl when it's needed, so that's cool! and I didn't know them so curlutally speaking it's great... so, thanks a lot !!
21:41 |Lupin|       hdl: you mean a script that would pass the whole query to mysql ? yeah, why not !
21:40 hdl           But you could look at http://dev.mysql.com/doc/refman/5.0/en/triggers.html
21:40 |Lupin|       hdl: anyway, thanks for havign shown, it confirms what I wanted to do can work
21:40 hdl           |Lupin|: i would use a shell cronjob for that.
21:40 pianohacker   hi wizzy
21:39 |Lupin|       hdl: the question ismore: is there a way in the db to have actions performed regularly, like a cron job but inside the db ?
21:39 hdl           |Lupin|: INSERT INTO virtualshelfcontents (shelfnumber, biblionumber) SELECT theshelfnumberyouneed,biblionumber from biblio
21:39 |Lupin|       hdl: yeah delete and then insert select the required things...
21:38 wizzyrea      ph, hello
21:37 hdl           |Lupin|: you could update a given virtualshelves content with : DELETE FROM virtualshelvescontent where shelfnumber=...
21:35 pianohacker   Good afternoon
21:34 Ropuch        ;>
21:32 |Lupin|       Ropuch: so am I, thanks for helping
21:31 Ropuch        Well, I'm sure it is
21:31 Ropuch        I think it's doable
21:28 |Lupin|       Ropuch: basically find out all the biblonumbers who have an item with a certain ccode and no item with another ccode
21:26 Ropuch        Describe what you the sql to do
21:23 |Lupin|       Ropuch: I was just wondering how far I could go in pure SQL
21:23 |Lupin|       Ropuch: doing it in Perl is an easy and acceptable fallback
21:22 |Lupin|       Ropuch: I am trying to create some kind of dynamic virtual shelves for my librarian
21:22 Ropuch        If you tell me what you are trying to do, I can ask some ppl [;
21:20 Ropuch        But
21:20 Ropuch        I can handle signle querry only in sql
21:20 |Lupin|       Ropuch: I tried but was not very successfull... tried googling I mean
21:20 |Lupin|       Ropuch: are you familiar enough with mysql to tell how one could regularly lookup a table and update another one ? is that doable inpure mysql ?
21:19 Ropuch        Np, googling things out is my my job ;>
21:19 |Lupin|       Ropuch: I'll check but it looks like that, yes ! thanks !
21:18 Ropuch        |Lupin|: is taht what you need?
21:18 Ropuch        http://dev.mysql.com/doc/refman/5.4/en/exists-and-not-exists-subqueries.html
21:17 Ropuch        select * from table where exist (select blabla)
21:13 |Lupin|       expressing something like "there exists at least one row in the table such that ..." in a where clause ?
21:13 |Lupin|       anybody knowshow to do a universal or existential quantification in mysql pls ?
20:52 |Lupin|       wow irssi is clever: lu<tab> completes correctly
20:51 |Lupin|       hey hdl :)
20:47 hdl           hi |Lupin|
20:47 hdl           hi |logbot_backup
20:40 brendan       bbiab
20:38 |Lupin|       hi there
20:36 brendan       rhcl, you could check to see what is listed for a username and group in koha-zebra-ctl.sh
20:32 chris         rhcl: if you did all of option 2, and its not starting, then you might not have the daemon package installed, or you koha-zebra-ctl.sh script isnt configured right
20:30 owen          jwagner: Then you can use OpacUserCSS to give them their color
20:30 pastebot      "chris" at 192.168.15.101 pasted "Option 1: run the Zebra proces" (29 lines) at http://paste.workbuffer.org/60
20:30 jwagner       owen, I need to set a color for my sites.  I can submit the patch with or without a color, I guess.
20:30 chris         im pasting directly from the file
20:29 rhcl          The install directions specifically show this as part of the "Option 1, command line", which is exactly how we are starting it. Even with setting up Option 2, and double checking, we have to login and run zebrasrv by hand.
20:29 owen          jwagner: Maybe we should leave the color alone and leave that up to each location?
20:28 pastebot      "chris" at 192.168.15.101 pasted "setting up start up processes" (12 lines) at http://paste.workbuffer.org/59
20:28 jwagner       owen, I got the css stuff figured out, I think.  How about a nice tasteful green for the shelving location? Blue is kind of overworked, and red is better suited to "pay attention!" things like Lost.
20:28 chris         yes it does :)
20:28 rhcl          Yea, I've got the directions here, and have been over them 1000 times, and nothing addresses this that I see.
20:28 brendan       http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=blob;f=INSTALL.debian-lenny;h=2d2997a7eacb6053980232a96cff5f04c190b52b;hb=HEAD
20:27 chris         ok look at the INSTALL.debian-lenny
20:27 rhcl          yes, lenny and 3.0.4_fixed
20:26 chris         are you running debian rhcl ?
20:26 chris         yes
20:26 rhcl          Right now we have to login to our koha server and start zebrasrv, using >/usr/bin/zebrasrv -f /etc/koha/koha0conf.xml, each time manually (after a reboot). How should this be started automatically without a usr login?
20:23 chris         ill email
20:23 chris         yeah
20:23 hdl           he sure is awake, but should not be near his computer atm
20:23 * chris       emails
20:22 * chris       is racing a deadline
20:22 chris         i wonder if he is still awake
20:22 chris         in part of my RFI response, they talk about discovery layer, im saying Koha doesnt need one, in fact other libraries have used Koha as discovery layer for their old LMS
20:22 hdl           mmm you had better ask paul for details.
20:22 chris         cool, do you have any details?
20:21 hdl           chris yes.
20:20 chris         anyone know of any libraries who are using the Koha Opac as a discovery layer, while using their old LMS in the background?
20:14 jwagner       hdl, does that mean the XSLT shouldn't use the staff viewISBD syspref?
20:06 hdl           jwagner: chris about ISBD for OPAC and intranet : There is the problem of links between intranet and opac which are different owed to the fact that authorities/detail.pl and catalogue/detail.pl refers to different scripts and opac has only one directory
20:03 jdavidb       If there wasn't already a "less" command, I'd lobby for that function to be done by mroe.
20:02 brendan       mroe sounds so morose
20:02 * jdavidb     gets out his Dark Arts of CSS book.  Probably oughta read it some mroe.
20:00 chris         i think since we have a way to do bulk modifications on items, probably can just do that for shelving locations too
19:59 owen          chris: I was picturing an interface just like transfers, only instead of setting a branch you set a shelving location.
19:58 jdavidb       Ah, by merely monkeying with the CSS.  I see.
19:57 owen          jdavidb: Adding the <BR> to the HTML means that it is forced onto a new line for any and all users. Doing it in the CSS means that libraries can choose.
19:57 jwagner       I've set up a span in the css, copying the term one, then called it in the tmpl.  Not sure I've got it right yet, but...
19:57 jdavidb       Why choose one over the other, owen?
19:57 owen          <span class="shelvingloc"><TMPL_VAR></span> ; .shelvingdoc { display: block }
19:55 owen          jdavidb: No, it should go in the CSS
19:54 jdavidb       <  TMPL_IF shelving_location is present> <BR><span foo><TMPL_VAR> </span> </TMPL_IF>  ?
19:53 chris         owen: http://librarian.koha.catalystdemo.net.nz/cgi-bin/koha/tools/batchMod.pl
19:53 owen          jwagner: Then what you need is to add "display:block" to the <span>'s CSS
19:53 chris         owen: like the bulk item edits interface?
19:53 jwagner       They also asked for the shelving location to go on a separate line.  There are a few cases where I think putting a <BR> in the template code might cause problems.  We have a single library site (single branch mode on, so it doesn't display library name) which doesn't use shelving locations.  I'll have to look at that a bit more.
19:52 * owen        is waiting for a transfers-like interface for setting shelving location
19:52 owen          I don't know how other libraries use shelving location--we don't use it at all
19:51 owen          I'd say it is potentially of general use
19:51 jwagner       (jdavidb, caramels work too....)
19:50 jwagner       OK, if this is something that would be of general use, I'll try to figure it out.  If not, I'll stick to this for my site :-)
19:50 * jdavidb     suggests chocolate for jwagner
19:50 * jwagner     whimpers
19:49 owen          Honestly, I wouldn't suggest anything but a new class name.
19:48 jwagner       owen, I was kind of hoping to avoid creating a new span, and "term" looked more usable than, say, "lost" -- any suggestions which other class might be better?
19:48 brendan       morning richard
19:48 richard       hey chris
19:48 chris         hiya richard
19:47 richard       hi
19:47 owen          jwagner: It should have its own span. "term" is very specific.
19:46 wizzyrea      k I will do that.
19:46 jwagner       owen and others, I've had a request from a couple of my sites to highlight the shelving location in the staff & OPAC display.  Right now it just immediately follows the library branch name, and if you have a wordy name the shelving location gets lost.  I'm applying one of the existing span classes to it ("term" which makes it yellow highlighted).  Would that be of general use?
19:46 wizzyrea      yea, that's what I was thinking
19:46 chris         the rest of us would need to go read the code
19:46 chris         he'll be able to answer fast
19:45 chris         id fire him an email wizzyrea
19:44 * wizzyrea    resists the urge to hunt down atz
19:44 wizzyrea      can anyone tell me, 3M self-check machines can use a PIN, is that equiv. to the OPAC password?
19:40 brendan       ok -- you win by a wide margin :)
19:40 wizzyrea      >.> at least in weather terms
19:40 wizzyrea      it's more like golf
19:40 wizzyrea      oh, this is the misery index
19:40 brendan       if not -- then I think I win
19:40 brendan       is this golf?
19:40 wizzyrea      I win. :)
19:40 munin         wizzyrea: The current temperature in Lawrence Live-Courtesy of the Khoury's, Lawrence, Kansas is 1.6�C (1:38 PM CST on November 16, 2009). Conditions: Light Rain. Humidity: 87%. Dew Point: -0.0�C. Windchill: 2.0�C. Pressure: 29.94 in 1013.8 hPa (Rising).  Winter Weather Advisory in effect until 6 am CST Tuesday... 
19:40 wizzyrea      @wunder 66047
19:37 munin         brendan: The current temperature in Northwest Goleta, Goleta, California is 17.4�C (11:35 AM PST on November 16, 2009). Conditions: Clear. Humidity: 44%. Dew Point: 5.0�C. Pressure: 30.14 in 1020.5 hPa (Falling).
19:37 brendan       @wunder 93117
19:13 brendan       :)
19:12 rhcl          and I see the file at that link has feedback instructions :)
19:12 brendan       also nice to browse code if you wanted to
19:12 brendan       ah ok...  I usually just use the git.koha.org versions
19:11 rhcl          Yea, that looks good, we were just using the install directions that came with the distro 3.0.4_fixed (or whatever)
19:11 brendan       ok -- try that link I just pasted
19:10 rhcl          OK, I can't see the line numbers and just have a printout at this computer.
19:10 brendan       http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=blob;f=INSTALL.debian-lenny;h=2d2997a7eacb6053980232a96cff5f04c190b52b;hb=HEAD
19:10 brendan       hmm....  line 207 -- explains {SCRIPT_DIR}
19:10 rhcl          OK, that sounds good. How can I feed you my input, and/or otherwise assist?
19:09 rhcl          The other thing is that in the instructions it mentions "${SCRIPT_DIR}, but never tells how to actually set it.
19:09 brendan       line 223 tells you to start the server
19:09 jdavidb       just so you know, I'm working on a big rewrite of INSTALL.debian-lenny for the Squeeze release.
19:09 jdavidb       That's why that section needs some love...structurally, it has some issues.
19:08 rhcl          OK, but when we did "Option 2", following the directions pretty exactly, nothing actually started the zebra process. We had to go back to Option 1 to start the daemon, which then worked fine.
19:08 jdavidb       I'm with Brendan.  If you find something that needs better wording, just do it.  Submit it as a patch, and get ++ a lot.
19:07 brendan       so you could make some changes and submit a patch for that
19:07 brendan       those doc's are part of git tree
19:06 jdavidb       The little section of code starting at line 210 "Zebra Server" tells how to, and that's what we do exclusively, here.
19:06 rhcl          Is there anything I can do to assist with the docs here?
19:06 brendan       rhcl -- what does "startup process" mean to you?
19:06 rhcl          Needs to be shot and replaced with a giraffe.
19:05 jdavidb       yup.  "running zebra" is one of the sections that needs some love, IMO."
19:05 rhcl          What is specifically ment by "startup process". I think that should be defined better.
19:05 rhcl          for example, when configuring zebra there is the line "Option 2: run the Zebra processes as daemons, and add to startup process:".
19:04 jdavidb       Probably more than a couple.
19:04 rhcl          I think there are a couple of things that need clarification...
19:04 jdavidb       rhcl:  I've done it a bunch, would be glad to help.
19:03 rhcl          Who might be the POC for the installation directions for debian lenny?
19:03 brendan       rhcl nengard should be back next week
19:03 rhcl          Italy? Oh, OK
19:02 brendan       nengard is in Italy at the moment
19:01 munin         rhcl: nengard was last seen in #koha 1 week, 3 days, 2 hours, 20 minutes, and 51 seconds ago: <nengard> I'm working with melanie on the problem i mentioned above
19:01 rhcl          @seen nengard
18:57 chris         but now its time to catch my bus
18:56 chris         i can think of no reason
18:55 jwagner       Can anyone think of a reason why sites would want ISBD view hidden in staff mode but available in OPAC?  XSLT doesn't obey the viewISBD syspref, which is in the Staff group of sysprefs, but I don't see any reason to create an OPAC syspref.
18:53 brendan       morning chris
18:52 chris         gonna be a nice day
18:52 munin         chris: The current temperature in Wellington, New Zealand is 12.0�C (7:00 AM NZDT on November 17, 2009). Conditions: Clear. Humidity: 47%. Dew Point: 1.0�C. Pressure: 29.62 in 1003 hPa (Rising).
18:52 chris         @wunder wellington, nz
18:07 wizzyrea      if they were in the pic then we might have grounds for that
18:06 wizzyrea      LOL
18:06 jdavidb       Imma tell your bosses you talk about 'em like that, wizzyrea.
18:05 brendan       huge flakes - heh ;)
18:04 wizzyrea      brendan, I just sent you a friend request so you can see my huge flakes :P
18:03 * jdavidb     isn't in California, and doesn't see snow, either.
18:03 brendan       :)
18:03 wizzyrea      ;)
18:03 wizzyrea      dude, you're in california
18:03 brendan       Sorry wizzyrea -- I don't see any snow outside
17:58 munin         brendan: The current temperature in Northwest Goleta, Goleta, California is 15.2�C (9:55 AM PST on November 16, 2009). Conditions: Clear. Humidity: 52%. Dew Point: 6.0�C. Pressure: 30.17 in 1021.6 hPa (Rising).
17:58 brendan       @wunder 93117
17:58 wizzyrea      huge flakes
17:58 wizzyrea      it's beautiful
17:58 wizzyrea      omg you should see the snow here
17:55 brendan       morning All
17:32 heupink       But category code ALL is defined in the database.
17:31 heupink       Because I'm getting this error: "Cannot add or update a child row: a foreign key constraint fails (`koha3/borrowers`, CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`)) at /usr/share/koha/lib/C4/Members.pm line 730"
17:28 heupink       (to set the code to "ALL"
17:28 heupink       Hi again! To set a fixed category code for all new users, should "<categorycode is="ALL"></categorycode>" in koha-xml.conf (with ldap) work..?
16:44 chris_n       lunch, bbiab
16:35 chris_n       lol
16:33 wizzyrea      chris_n thanks, that's very warm
16:33 wizzyrea      I'll try not to :)
16:32 chris_n       just don't drop it on your foot ;-)
16:32 * chris_n     hands wizzyrea his soap-stone wood stove
16:30 zico          wizzyrea: that`s koha log
16:28 wizzyrea      is that the apache log or the koha log?
16:28 wizzyrea      http://old.nabble.com/forum/Search.jtp?forum=14380&local=y&query=trapped+fatal+error+production
16:28 zico          nahuel: sorry man!
16:28 nahuel        don't take care about this
16:28 zico          :(
16:28 zico          owen: the log shows me this: "[Tue Nov 17 04:24:24 2009] [error] [client 127.0.1.1] File does not exist: /usr/share/koha/intranet/htdocs/favicon.ico [Tue Nov 17 04:24:27 2009] [error] [client 127.0.1.1] File does not exist: /usr/share/koha/intranet/htdocs/favicon.ico"
16:28 nahuel        zico, ?
16:28 kf            time to leave - bye #koha :)
16:27 zico          nahuel: owen
16:25 wizzyrea      error logs are a good suggestion as well
16:25 wizzyrea      zico: I'm pretty sure there has been discussion of that on the list, lemme get the link
16:25 owen          zico: You'll have to look in your error logs for more information
16:24 zico          is there anyone who can help me with "production mode - trapped fatal error" ??
16:24 * wizzyrea    goes off to look for a youtube vid of a fireplace
16:23 wizzyrea      and I have no fire to make it delightful
16:23 wizzyrea      yea, the weather here is frightful
16:23 zico          i hv just installed koha-3.0.4.. but when i go for http://127.0.1.1:8080/  ... it shows me the error "production mode - trapped fatal error"
16:22 jdavidb       Hm...Tenleytown is kinda the high ground in northwest DC.  Wonder what it's like down in Foggy Bottom?
16:22 zico          hi
16:21 magnusenger   [Bergen | Bodø] + 10 = Lyon :-)
16:21 magnusenger   :-)
16:20 nicomo        not bad
16:20 munin         magnusenger: The current temperature in Olsvik, Bergen, Norway is 8.3�C (5:19 PM CET on November 16, 2009). Conditions: Clear. Humidity: 51%. Dew Point: -1.0�C. Windchill: 7.0�C. Pressure: 29.59 in 1001.9 hPa (Steady).
16:20 magnusenger   @wunder bergen, norway
16:20 munin         nicomo: The current temperature in Lyon, France is 18.0�C (5:00 PM CET on November 16, 2009). Conditions: Clear. Humidity: 59%. Dew Point: 10.0�C. Pressure: 29.89 in 1012 hPa (Steady).
16:20 nicomo        @wunder Lyon, France
16:20 magnusenger   heh, i'm not the coldest!
16:19 paul_p        jdavidb: lol
16:19 * jdavidb     pouts a little.
16:19 owen          No offense jdavidb, Marseille still wins ;)
16:19 jdavidb       18.3.  :P
16:18 munin         jdavidb: The current temperature in WRC-Tenlytown, Washington, District of Columbia is 18.3�C (10:30 AM EST on November 16, 2009). Conditions: Scattered Clouds. Humidity: 74%. Dew Point: 14.0�C. Pressure: 30.18 in 1021.9 hPa (Falling).
16:18 jdavidb       @wunder Bethesda, md
16:18 paul_p        hehe... I win :D (18°C )
16:18 munin         paul_p: The current temperature in Marseille, France is 18.0�C (5:00 PM CET on November 16, 2009). Conditions: Scattered Clouds. Humidity: 77%. Dew Point: 14.0�C. Pressure: 29.95 in 1014 hPa (Steady).
16:18 paul_p        @wunder Marseille, France
16:17 munin         magnusenger: The current temperature in Bodo, Norway is 8.0�C (4:50 PM CET on November 16, 2009). Conditions: Mostly Cloudy. Humidity: 62%. Dew Point: 1.0�C. Windchill: 4.0�C. Pressure: 29.74 in 1007 hPa (Steady).
16:17 magnusenger   @wunder bodo, norway
16:15 munin         kf: The current temperature in Konstanz, Germany is 12.0�C (5:00 PM CET on November 16, 2009). Conditions: Mostly Cloudy. Humidity: 87%. Dew Point: 10.0�C. Pressure: 29.93 in 1013 hPa (Rising).
16:15 kf            @wunder konstanz
16:14 munin         owen: The current temperature in Athens, Ohio is 13.0�C (10:55 AM EST on November 16, 2009). Conditions: Clear. Humidity: 67%. Dew Point: 7.0�C. Pressure: 30.09 in 1019 hPa (Steady).
16:14 owen          @wunder 45701
16:14 munin         owen: An error has occurred and has been logged. Please contact this bot's administrator for more information.
16:14 owen          @wunder 45764
16:13 owen          Ouch!
16:13 munin         owen: The current temperature in Channel 6 Downtown, Lawrence, Kansas is 2.9�C (10:12 AM CST on November 16, 2009). Conditions: Overcast. Humidity: 91%. Dew Point: 2.0�C. Windchill: 3.0�C. Pressure: 30.06 in 1017.8 hPa (Rising).  Winter Weather Advisory in effect until 6 am CST Tuesday... 
16:13 owen          @wunder 66044
16:05 wizzyrea      that was my impression, I just wanted to make sure
16:05 wizzyrea      okies, ty
16:00 gmcharlt      yes, at that point it could be captured
15:58 wizzyrea      (with it's erroneous itype)
15:58 wizzyrea      if the mistakenly assigned item is scanned (checked in) is the hold assigned?
15:57 wizzyrea      gmcharlt: one more question
15:45 wizzyrea      :)
15:45 wizzyrea      ok, thanks
15:45 wizzyrea      right, we call the holds queue the pick list (sirsi holdover. Sigh.)
15:44 gmcharlt      at least, it generates the 'holds queue' version of the pick list
15:44 gmcharlt      same one
15:44 wizzyrea      that is a different script than the one that generates the pick list, or no?
15:43 gmcharlt      yes
15:43 owen          gmcharlt: the holdsqueue job?
15:43 gmcharlt      as there is an intermediate cronjob
15:43 gmcharlt      wizzyrea: no, it shouldn't be that fast
15:42 wizzyrea      gmcharlt: question, is the holds targeting immediate? example: staff catalogs an item, accidentally gives it a non restricted hold itype, clicks save. Staff member then realizes that the item should have a restricted (local hold, for example) itype and changes it. Is it too late? Has that item already become a target of the holds picking system?
15:31 heupink       .
15:31 heupink       I already wrote the ldap wiki page for 2.x series, and am now adding stuff for 3.x series,
15:31 chris_n       heupink++ # for taking time to write one
15:31 chris_n       wiki_pages++
15:31 chris_n       heupink: cool
15:30 munin         heupink: Error: "chris_n:" is not a valid command.
15:30 heupink       @chris_n: I found out why it didnt work, and I'm writing a wiki page now.
15:10 Ropuch        Hm, I added &order=biblio.title to basket showing url: it throwed 'ERROR: Illegal sort requested by "biblio.title".', but the items got sorted according to title anyway
14:22 munin         gmcharlt: 04Bug http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3785 normal, P3, ---, gmcharlt@gmail.com, NEW, New Install, no maxreserves setting, OPAC holds fail
14:22 gmcharlt      @bug 3785
14:21 jwagner       Where'd munin go?  Anyway, see http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3785
14:20 jwagner       I have a new holds-related bug, but I'm not quite sure how best to fix it.  Any ideas?  See Bug 3785.
14:13 heupink       thanks.
14:13 heupink       i just thought I'd ask here first. :-)
14:12 chris_n       heupink: you might want to post the the list as there are some there who have worked with the koha ldap stuff
14:04 heupink       Hope someone here has an idea..?
14:03 heupink       Koha takes userid from the user of course, but the rest to perform the bind with.
14:02 heupink       But I don't understand where tell koha in what form the bind should be (like: uid=from_login,ou=YY,dc=YY)
14:01 chris_n       DBD::mysql is a core module with Strawberry so differences could be there
14:01 heupink       Hi, I'm trying to authenticate with ldap, by using the bind as user option ( <auth_by_bind>1</auth_by_bind>)
14:00 chris_n       ahh.... hadn't thought of that, but it very well could be
14:00 gmcharlt      in Strawberry
14:00 gmcharlt      chris_n: I wouldn't be surprised if the behavior is controlled by a setting, possibly in DBD::mysql, which just happens to have a different default value
14:00 Eric_T        Ok I forget to export KOHA_CONF, now warnings are different. So I pregress... thanks !
14:00 chris_n       I plan on doing the installation again from scratch and will spend more time debugging it then
13:59 chris_n       I suppose there might be another plausible explanation, but I have not spent a lot of time on it
13:58 hdl           Eric_T: those are warnings only
13:58 chris_n       gmcharlt: I thought so, but very clearly these items failed to insert with DBD throwing an error
13:57 gmcharlt      odd - mysql auto-truncates if you try to insert a string that's too long into a varchar
13:57 chris_n       gmcharlt: a bib with 13 items fails to insert
13:56 Eric_T        So when I try to rebuild the (many) errors are [warn] Index 'tpubdate' not found in attset(s) , 'Modified-code' not found in attset(s), etc etc...
13:56 chris_n       the isbn field is varchar(30) currently
13:56 chris_n       gmcharlt: the 020 fields are concatenated and then inserted into the isbn field of biblioitems
13:55 chris_n       I ended up having to make those fields in the biblioitems table mediumtext types and remove the indexes
13:55 gmcharlt      chris_n: too long?  in what way/
13:54 chris_n       gmcharlt: when importing records exported from a Koha installation, the isbn and issn fields are too long, especially when the bib has multiple items attached
13:54 gmcharlt      hi hdl
13:54 hdl           hi gmcharlt
13:54 chris_n       gmcharlt: I did find an issue when "round tripping" marc records from one Koha to another
13:53 paul_p        (which requires PERL5LIB and KOHA_CONF to be defined on your shell)
13:53 paul_p        Eric_T: yes, you must rebuild_zebra
13:53 paul_p        Eric_T: :(((( welcome here, anyway. For tech questions, you'll get more answers !
13:52 Eric_T        Ok but I can't connect on 6667 port... didn' find any web interface for irc.freenod
13:52 chris_n       gmcharlt: with the January 2010 Strawberry release, Koha on win32 should be nearly as straight forward as on *nix
13:51 Eric_T        Donc en français, je patauge un peu au niveau de zebra. La recherche ne fonctionne pas. Si j'ai bien compris je dois contruire l'index avec un rebuild_zebra.pl
13:51 paul_p        Eric_T: we have a french channel on freenode #koha-fr. He's very quiet, but just FYI.
13:51 gmcharlt      chris_n++
13:51 paul_p        Eric_T: misc/migration_tools/rebuild_zebra
13:50 Eric_T        I think now i have to build the zebra index (Oui français Paul)
13:50 paul_p        ( in english, it's biblio ;-) )
13:50 paul_p        Eric_T: are u french ? (notice is the french term)
13:49 Eric_T        I installed Koha 3.0.4 and imported 1000 "notices"
13:49 chris_n       Eric_T: feel free to ask your question, someone here may have the answer :-)
13:47 Eric_T        I'm looking for help regarding zebra indexation
13:45 chris_n       hi Eric_T
13:45 Eric_T        Bonjour / Hello
13:45 chris_n       gmcharlt: I have koha running fine now on win32 (2+ years later)
13:43 owen          Hi gmcharlt, #koha
13:41 gmcharlt      good morning all
13:39 chris_n       g'morning #koha
13:39 chris_n       wb gmcharlt
13:00 jdavidb       Glad I could help.
13:00 heupink       ok, thanks!
13:00 heupink       (I come from suse, where things are a bit different)
12:59 jdavidb       If it works for you, roll with it.  I've done it nearly sixty times now, as documented, on both etch and lenny.
12:59 heupink       Ok then, I'll take a look at it again then.
12:59 heupink       hmm. it didn't seem to work when i tried it, and it did work when using koha.conf. Strange.
12:58 jdavidb       a2ensite creates a link from the sites-available to the sites-enabled, and that one, also, loads *all* files, not just .conf.
12:58 jdavidb       It loads everything under /etc/apache2/conf.   It specificially does *not* load everything under /etc/apache2/sites-available.
12:57 jdavidb       If you named it koha.conf, you'd need to do a2ensite koha.conf
12:57 heupink       but it should end on .conf, otherwise apache doesn't try to load it, right..?
12:57 heupink       because from apache configuration, it tries to load all .conf files, not just ALL files under /sitesenabled
12:57 jdavidb       The second parameter can be whatever you want, as long as it's in sites-available.  That, of course, is what your'e going to feed to a2ensite.
12:57 jwagner       paul_p, thanks!  That's what I needed to know.
12:56 paul_p        yes but no : when you create a fund, you can limit it to a branch or not. If you don't limit, then anyone can see it. If you limit, then it's only for your library.
12:56 jdavidb       Could be, heupink, but it doesn't have to be.
12:56 heupink       shouldn't this be "ln -s /etc/koha/koha-httpd.conf /etc/apache2/sites-available/koha.CONF"?
12:56 heupink       it says: "ln -s /etc/koha/koha-httpd.conf /etc/apache2/sites-available/koha"
12:55 jwagner       paul_p, sorry, they can still see each others' funds?
12:55 jwagner       OK, thanks -- that's promising news
12:55 heupink       Hi all. I'm installing koha on debian, and noticed something in the docs that I think is wrong:
12:54 paul_p        jwagner: for funds, I think so. For orders, not sure, but I don't think so (or, if it works, it's by mistake). This part should probably be improved
12:45 jwagner       Question for you -- does the new acquisitions code obey Independent Branches?  If that's on, can libraries see each others' funds/orders?
12:44 jwagner       Bonjour.
12:44 paul_p        yep. 'morning jwagner
12:44 jwagner       paul_p, online?
10:13 munin         paul_p: gmcharlt was last seen in #koha 5 days, 17 hours, 37 minutes, and 43 seconds ago: <gmcharlt> Nate: GPL v2 or later
10:13 paul_p        @seen gmcharlt
08:59 |Lupin|       bye
08:59 |Lupin|       till later, everybody, have to go now
08:56 kf            :)
08:56 |Lupin|       guten morgen kf :)
08:48 kf            hi lupin
08:48 |Lupin|       good day all
08:47 kf            good morning #koha
08:06 * chris       wanders off again
08:05 chris         zico: as chris nighswonger said its been fixed for 3.0.4, you can either try to find all the patches or upgrade to that (its probably a .pm change as well)
08:04 * chris       cant always answer right away as i have a family at home who demand my attention also :)
08:03 chris         in debian it would be apt-get install libxslt-dev
08:03 chris         i dont know SME Server at all
08:03 chris         its not the perl one ropuch its the main xslt dev libs
07:59 CGI420        i will try
07:58 Ropuch        There's some xslt-perl rpms for CentOS
07:57 Ropuch        CGI420: http://dag.wieers.com/rpm/packages/perl-XML-XSLT/
07:57 zico          Ropuch, nope! it don`t work :)
07:54 CGI420        pls chris help me
07:54 CGI420        any rpm for xlst
07:53 CGI420        using the command make, make test, make install
07:53 Ropuch        CGI420: sory, i 've overlooked this
07:53 paul_p        hello #koha, good morning
07:53 CGI420        SME Server 7.4
07:53 Ropuch        Morning, paul_p
07:52 Ropuch        CGI420: you didn't answer the chris question: what linux version are you using and how trying to install zoom
07:52 CGI420        chris pls help
07:51 CGI420        how to install xslt library
07:51 Ropuch        Upgrading to 3.0.4 seems to be the proper way ;>
07:50 Ropuch        zico: you can try replace intranet/cgi-bin/labels/label-item-search.pl but I'm not sure it will work
07:49 CGI420        wil sme server 7.4
07:49 zico          i mean.. if i tries to search with date ... or barcode... it don`t bring any result
07:49 CGI420        zoom 1.25
07:48 Ropuch        It was not a big deal - i just send one email  ;>
07:48 zico          but... it cannot search anything
07:48 zico          i can see the drop down menu now
07:48 zico          thnx man
07:48 zico          oh Ropuch ... :)
07:48 Ropuch        It was me
07:48 zico          nd... i pasted that in my  koha/intranet/htdocs/intranet-tmpl/prog/en/modules/labels/
07:48 Ropuch        Yup
07:47 zico          Piotr Wejman gave me the search.tmpl of koha 3.0.4
07:47 CGI420        yes
07:47 CGI420        pls help me to solve this problem'
07:47 CGI420        hello
07:47 zico          i am here with label printing drop down menu problem again! :)
07:46 zico          hi
07:46 chris         what version of linux are you using, and how are trying to install zoom
07:45 chris         sounds like you are missing the xslt library
07:40 CGI420        usr/bin/ld: cannot find -lxslt collect2: ld returned 1 exit status
07:40 CGI420        pls help me
07:40 CGI420        hi amith
07:39 CGI420        perl zoom module error
07:39 CGI420        plsd help me to solve
07:39 CGI420        usr/bin/ld: cannot find -lxslt collect2: ld returned 1 exit status
07:36 CGI420        pls help me any one ?
07:35 CGI420        cause I cant proced with my koha installtions
07:35 CGI420        pls help me to sovle this problem
07:35 CGI420        i am getting error : /usr/bin/ld: cannot find -lxslt
07:34 CGI420        when I tried to install the perl module zoom
07:34 CGI420        i need a help
07:34 CGI420        hi I am nithin
07:32 chris         excellent
07:13 magnusenger   nengard & nicomo did a great job!
07:13 magnusenger   hi chris! it went very well, i think! sounds like we will see some more Koha-libraries in Norway in the near future! ;-)
07:11 chris         heya magnusenger, how'd the conference go?
07:11 chris         cool
07:10 Ropuch        Really good pics of mandelbrot set in 3d
07:10 Ropuch        http://www.skytopia.com/project/fractal/mandelbulb.html
07:01 chris         http://of2minds.net/reflections/?p=41  <-- really good writeup about the sirsi dynix FUD
06:50 Ropuch        Good morning
05:07 brendan       hi Amit
04:22 chris_n2      g'night as well
04:18 pianohacker   good night
03:24 chris_n2      fine here too; getting ready to shut down for the night
03:23 Amit          chris_n2: Everything is fine here what about u?
03:23 chris_n2      hope things are well on your side of the big ball
03:23 chris_n2      howdy Amit
03:23 Amit          good morning #koha
03:23 Amit          hi chris, brendan, chris_n2, richard
03:00 chris_n2      heh
02:58 pianohacker   why is my ? key trying to take over my keyboard?
02:58 pianohacker   ah. it's rarely uplifting, is it?
02:58 chris_n2      "no news is good news" works two ways you know
02:57 chris_n2      just my general appraisal of the news in general
02:56 pianohacker   uh-oh?
02:53 chris_n2      reading no-good news
02:53 pianohacker   chris_n2: what are you up to ?
02:51 pianohacker   working on circ
02:51 pianohacker   alright
02:50 chris_n2      how's it going pianohacker?
02:50 pianohacker   hi, chris_n2
02:32 chris_n2      g'evening
00:42 chris         at least you tried :)
00:40 richard       couldn't convince them that it wasn't the brightest thing to do
00:40 * pianohacker goes back to working on circ, because it makes sense!
00:40 richard       someone asked me where they could grab a 2 version the other week - they had hosed their installation and wanted to replace it exactly
00:40 pianohacker   well, anyway. I'm more bitter than usual
00:38 chris         :(
00:37 pianohacker   not like we really have any _power_ over that
00:36 chris         imho
00:36 chris         have them somewhere sure, but you should really only have the current stable ones in the main download area
00:35 chris         thats the problem with having them all in download.koha.org
00:35 chris         yeah
00:35 pianohacker   ah well
00:35 pianohacker   Not even .2.9, but 2.8
00:34 * chris       asks as much
00:31 chris         why the hell is someone trying to install 2.2.8 ?????
00:01 chris         gonna duck out and grab somethign to eat, bbiab
00:01 chris         :)
00:01 pianohacker   well, at least you're not bored
00:00 chris         but otherwise ok
00:00 chris         busy, too much to do