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/