Time  Nick         Message
22:48 druthb       :D
22:47 jcamins      \o
22:46 druthb       o/
22:18 huginn       bag: The current temperature in Wellington, New Zealand is 13.0°C (11:00 AM NZDT on March 04, 2012). Conditions: Mostly Cloudy. Humidity: 82%. Dew Point: 10.0°C. Pressure: 29.98 in 1015 hPa (Steady).
22:18 bag          @wunder wellington, nz
22:18 huginn       bag: The current temperature in K6LCM-Westside/Mesa, Santa Barbara, California is 23.9°C (2:16 PM PST on March 03, 2012). Conditions: Clear. Humidity: 10%. Dew Point: -10.0°C. Pressure: 30.17 in 1021.6 hPa (Falling).
22:18 bag          @wunder 93109
19:55 jcamins      Never mind. I'm not quite sure how to.
19:50 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7248 enhancement, P3, ---, chrish, Patch doesn't apply , Caching for services
19:50 jcamins      Sorry. bug 7248
19:49 jcamins      Not 7284.
19:49 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7284 major, P3, ---, jcamins, Passed QA , Authority matching algorithm improvements
19:49 jcamins      rangi: any objection to my redoing bug 7284 to use the environment variable?
19:23 cait         rangi++ :)
19:16 jcamins      lol
19:16 cait         heh
19:15 rangi        http://www.youtube.com/watch?v=R6Mj1Us13Yk
19:15 * jcamins    works on condensing this into something short.
19:14 rangi        short answer
19:12 rangi        optimize reserves
19:12 rangi        if mysql
19:12 rangi        the classy thing to do would be to do
19:11 jcamins      Ah.
19:11 rangi        you just tell it to optimize the table
19:10 rangi        thats easy to fix
19:10 jcamins      At least, as far as I can tell, adding a primary key leaves the InnoDB indexes incorrect.
19:10 rangi        dont use auto_increment to number them, just select all, set the reservenumber
19:10 cait         lol
19:10 cait         jcamins: why not?
19:10 rangi        why not?
19:10 jcamins      That won't work either.
19:09 rangi        and id also make the column unique
19:09 cait         makes sense
19:09 rangi        old_reserves first, then reserves
19:09 rangi        personally id renumber them with with a loop
19:08 jcamins      It's weird.
19:08 jcamins      Somehow.
19:08 rangi        yup
19:08 jcamins      It breaks the index.
19:08 rangi        yeah
19:08 jcamins      It also doesn't work properly.
19:08 rangi        thats def a mysqlism
19:08 rangi        hmm, that should definitely not do that
19:07 jcamins      Using the ALTER TABLE.
19:07 jcamins      *renumbers
19:07 jcamins      It renumberes old_reserves at the beginning.
19:07 rangi        that would work
19:07 cait         so renumber them manually, first oldreserves then reserves?
19:07 rangi        but it doesnt change old_reserves
19:06 jcamins      The numbering seems to work.
19:06 cait         hm
19:06 * rangi      hopes he is making sense
19:06 rangi        and then you make mess for the future
19:05 rangi        you run the risk of having the same numbers in both
19:05 jcamins      I think the comments are all wrong.
19:05 rangi        if you dont renumber them both, contiguiously
19:05 jcamins      But I think one of those is entirely extraneous.
19:05 rangi        but im saying if it did renumber them independently like it says its trying to do
19:05 jcamins      Oh, it certainly is.
19:05 rangi        no its doing reserves twice
19:04 jcamins      No, I don't think that's what's going on.
19:04 cait         eek
19:03 rangi        or the insert would simply fail
19:03 rangi        youd overwrite a reserve
19:03 rangi        so that when you updated (shifted one from reserves to old_reserves) later
19:03 rangi        or at least have some collisions
19:02 rangi        and even if it did there is a chance that you would renumber them both to the same numbers
19:02 cait         ouch
19:02 rangi        doesnt renumber old_reserves at all
19:02 jcamins      I think you are correct.
19:02 rangi        so it just renumbers reserves twice
19:02 rangi        then it runs that updated_sth twice
19:02 jcamins      Oh, I see.
19:02 rangi        +    my $update_sth = $dbh->prepare( $query );
19:02 rangi        +    my $query = "UPDATE reserves SET reservenumber = ? WHERE reservenumber = ?";
19:01 rangi        or am i missing something
19:01 rangi        not changing renumbering old_reserves
19:01 rangi        the 2 whiles
19:01 rangi        it does the same one twice
19:01 rangi        the update_sth
19:00 rangi        no
19:00 jcamins      At the very end.
19:00 rangi        and also, im not seeing where it changes the old_reserves
19:00 rangi        yes
18:59 jcamins      I guess the proper way to do it is create a temporary table?
18:58 rangi        yeah i dont like it
18:57 rangi        hmmm
18:57 jcamins      Yeah, it's removed after the update.
18:56 rangi        you dont want auto_increment on old_reserves
18:56 rangi        well theres one issue
18:56 jcamins      I guess when you do an ALTER TABLE the table isn't resorted by primary key?
18:55 jcamins      This is odd.
18:55 rangi        ;)
18:55 jcamins      Wait, no there isn't.
18:54 jcamins      There is a gap between old_reserves and reserves.
18:53 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7065 enhancement, P5 - low, ---, kyle.m.hall, Needs Signoff , reserves table needs a primary key
18:53 jcamins      I'm looking at bug 7065.
18:53 rangi        yep, for a little bit longer
18:53 jcamins      rangi: around?
18:41 cait         not for the poodle skirts.... jcamins++
18:41 cait         jcamins++
18:40 jcamins      http://en.wikipedia.org/wiki/Poodle_skirt
18:40 cait         photos?
18:40 cait         lol
18:40 jcamins      I learned earlier today that "poodle skirts" (from the 1950s) were skirts with pictures of poodles on them. Four hours later, I still can't get over that fact.
18:17 cait         hm not sure i get it
18:16 * cait       goes to read
18:16 cait         oh
18:15 jcamins      I was just thinking that.
18:14 rangi        heh marcelr skirts trouble with that email
18:11 wahanui      Cookies are delicious delicacies
18:11 cait         cookies?
18:11 jcamins      :)
18:09 cait         jcamins is here  - yay :)
18:09 cait         heh
18:07 shiv         ok
18:06 jcamins_away shiv: it doesn't matter.
18:06 shiv         debian or ubuntu - what is the best
18:05 shiv         ok
18:04 cait         a live cd is not always recommendable
18:04 cait         but dpeending on what you want to do
18:04 cait         google should find it
18:03 cait         I think there is an updated live cd from kyle hall somewhere
18:03 jcamins_away This is the most recent I know of, but it's *very* old: http://sourceforge.net/projects/kohalivecd/files/release-8/
18:03 shiv         with ubuntu
18:03 cait         germany
18:02 shiv         any latest live cd
18:02 shiv         and u
18:02 shiv         india
18:01 cait         where are you from shiv?
18:01 shiv         ok
18:00 jcamins_away shiv: no, you will need to install Ubuntu, then Koha.
18:00 shiv         is there any site where i can get ubuntu with koha
17:59 wahanui      package info is at http://wiki.koha-community.org/wiki/Koha_3.4_on_Debian_Squeeze
17:59 cait         packages?
17:59 cait         or you can install debian and use the packages
17:59 shiv         ok
17:59 shiv         ok
17:59 cait         you can find installation instructions in koha itself, the files start with INSTALL
17:59 cait         and from there it's a standard koha installation
17:58 cait         you install virtualbox, then install linux in it
17:58 cait         it depends on what you install as os in vitualbox
17:58 shiv         can i get the manual of koha installation with vitualbox
17:57 shiv         ok
17:57 shiv         ok
17:57 shiv         ok
17:57 cait         and if you have to run it in a windows environment, using somthing like virtualbox
17:56 jcamins_away shiv: you need a Linux server. You could run Debian under VirtualBox.
17:56 cait         debian has packages, ubuntu is also easy
17:56 cait         linux
17:56 shiv         then what is the best option
17:55 shiv         ok
17:55 jcamins_away shiv: no you cannot.
17:54 shiv         can i install koha in windows vista
17:40 mib_4jbh1v   good evening
17:39 wahanui      bonjour, mib_4jbh1v
17:39 mib_4jbh1v   hi
07:09 huginn       cait: The operation succeeded.
07:09 cait         @later tell JesseM Happy birthday!
07:08 cait         a new birthday
07:08 cait         oh
03:06 druthb       o/