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