| 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 |
