IRC log for #koha, 2012-03-03

All times shown according to UTC.

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

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary