IRC log for #koha, 2009-08-17

All times shown according to UTC.

Time S Nick Message
01:01 andy .win move 15
01:02 andy heh :)
01:02 andy is now known as pit
01:02 pit is now known as pie
01:02 pie typing fail :(
01:02 chris hehe
01:02 chris i like pit
01:03 pie 't' is two chars away from 'e' - not sure how that happened :)
01:34 brendan joined #koha
01:35 brendan good evening #koha
01:35 chris heya brendan
01:35 chris how was the weekend?
01:35 brendan good - but my baseball team just lost in the semifinals
01:35 brendan so no more baseball till next year
01:35 chris ahh crappy
01:35 brendan how was your weekend
01:36 chris good, quiet
01:36 brendan :)
01:36 brendan we got spanked -- 14 to 5
01:36 brendan more like an american football score
01:36 chris ouch
01:37 brendan district9 was good -- although no too many hero's in it
01:38 chris yeah its not your typical hollywood movie
01:38 chris where everything is black and white and clear cut
01:39 brendan off to find some dinner :)
01:40 chris @seen pianohacker
01:40 munin chris: pianohacker was last seen in #koha 4 hours, 7 minutes, and 47 seconds ago: <pianohacker> nengard: Yes
01:41 chris @later tell pianohacker http://groups.fsf.org/wiki/Group:GNU_Generation
01:41 munin chris: The operation succeeded.
01:43 chris i think he squeaks in there, and he certainly deserves a free FSF membership
01:59 gmcharlt evening #koha
02:34 Jo joined #koha
02:34 Jo afternoon all
03:12 chris hi Jo and gmcharlt
03:23 brendan left #koha
03:29 Amit joined #koha
03:29 Amit hi chris, Jo
03:29 Amit good morning #koha
03:32 Amit @wunder Delhi India
03:32 munin Amit: Error: No such location could be found.
03:33 Amit @weather Delhi
03:33 munin Amit: Error: HTTP Error 500: Server Error
03:48 brendan joined #koha
03:48 brendan heya Ammit
04:06 chris brendan: http://www.stuff.co.nz/enterta[…]film-opens-at-No1
04:07 brendan yup should clean up here - Jackson's a smart one
04:08 kmkale joined #koha
04:13 Amit heya brendan
04:14 Amit hi kmkale
04:14 kmkale hi amit
04:14 kmkale good morning all
04:15 Amit kmkale: any new?
04:15 kmkale nope
04:15 Jo left #koha
04:25 greenmang0 joined #koha
04:28 brendan night all
04:28 brendan see you tomorrow
04:28 brendan left #koha
04:53 Amit hi greenmang0
04:53 greenmang0 Amit: hey
04:59 kmkale bye all have a nice day..
04:59 kmkale left #koha
05:20 indradg_ joined #koha
05:22 CGI140 joined #koha
05:24 CGI140 left #koha
05:31 richard left #koha
05:33 Amit hi indradg_
05:33 indradg_ Amit, hey!
05:37 Elven_Thief joined #koha
06:06 hdl_laptop joined #koha
06:20 Amit hi hdl, elven
06:20 * Elven_Thief waves
06:20 kf joined #koha
06:22 Amit hi kf
06:22 kf hi Amit and good morning #koha
06:23 hdl_laptop hi
06:55 kf hi hdl
07:05 nahuel joined #koha
07:26 magnusenger joined #koha
08:11 chris evening
08:20 magnusenger morning
08:22 hdl_laptop hi
09:25 eiro joined #koha
09:25 eiro left #koha
10:01 chris wth
10:01 chris http://sourceforge.net/projects/koha-plus/
10:02 * chris wonders why kyle did that
10:19 gmcharlt hi folks
10:21 chris heya galen
10:23 indradg joined #koha
10:24 hdl_laptop hi gmcharlt
10:24 gmcharlt hi hdl_laptop
10:25 hdl_laptop lunch time
10:25 gmcharlt nom nom nom
10:28 indradg_ left #koha
10:32 gmcharlt nengard++
10:33 indradg left #koha
10:42 slef anyone seen code 400 from a new koha installation?
10:42 chris 400? nope
10:43 slef 400 is Bad Request... I think I'll look at proxies now because it happens from multiple clients
10:43 slef have a bit of a problem searching the koha lists for it because Mumbai's postcodes start 400 ;-)
10:45 gmcharlt slef: confirm I haven't been seeing 400s either
10:45 slef also seems that the 400.pl (or 400.tmpl?) wording is misleading
10:46 gmcharlt 400.tmpl
10:47 gmcharlt "This error means that the Koha is pointed an invalid link" ?
10:48 slef 400 is Bad Request - client sent a request that the server can't understand
10:49 gmcharlt yeah, which by itself isn't necessarily informative either, if the 'client' turns out to be a proxy
10:54 slef does clearly say "not necessarily the server's fault" though ;-)
10:55 slef => customers will check clients first
10:55 slef I'll patch it Real Soon Now.
11:06 chris thats the new round tuit eh
11:07 chris http://www.stosyth.gov.uk/imag[…]a-round-tuit.jpeg
11:07 chris my dad has one of these on the fridge
11:08 gmcharlt heh
11:11 slef chris: yep. http://foldoc.org/RSN
11:12 chris :)
11:17 gmcharlt left #koha
11:19 slef I think I found the code 400 problem.  Not a koha bug.
11:19 chris cool
11:33 jwagner joined #koha
11:35 chris hi jwagner
11:45 jdavidb joined #koha
11:48 chris hi jdavidb
11:48 jdavidb Howdy, chris! :)
11:54 gmcharlt joined #koha
12:06 indradg joined #koha
12:11 Amit left #koha
12:20 jdavidb left #koha
12:21 indradg left #koha
12:31 indradg joined #koha
12:38 jwagner Hi chris -- sorry, been off on another screen.
12:40 jdavidb joined #koha
12:45 brendan joined #koha
12:47 gmcharlt jwagner: re your patch for 3532, it appears to be dependant on a prior patch not yet submitted - not seeing where the itemlostloop referred to in the template is coming from
12:48 gmcharlt that, or there's some copy-and-paste stuff from cataloge/detail.tmpl that needs to be trimmed from the patron version
12:50 chris_n joined #koha
12:51 chris_n g'morning koha
12:52 brendan left #koha
12:52 gmcharlt hi chris_n
12:55 slef can a koha-admin mark Mahalya_Havard@ssss.gouv.qc.ca nomail please?
12:56 owen joined #koha
12:56 hdl_laptop koha or koha-devel ?
13:05 jwagner gmcharlt, yes, I did copy from the detail.tmpl -- is it just the loop part that needs to come out?  FWIW, the patch does work fine on my devel system -- the moremember.tmpl displays correctly.
13:09 slef hdl_laptop: koha
13:11 jwagner gmcharlt, just experimented, and most of the loop stuff can come out of the tmpl file.  Works with just                 <!-- TMPL_IF NAME="itemlost" -->
13:11 jwagner <span class="lost"><!-- TMPL_VAR NAME="itemlost" --></span>
13:11 jwagner <!-- /TMPL_IF -->
13:11 jwagner <!-- TMPL_IF NAME="damaged" -->
13:11 jwagner <span class="dmg"><!-- TMPL_VAR NAME="itemdamaged" --></span>
13:11 jwagner <!-- /TMPL_IF -->
13:11 jwagner Do you want me to resubmit?
13:20 gmcharlt jwagner: please
13:21 jwagner OK, will do a bit later -- got a meeting right now.
13:28 greenmang0 left #koha
13:31 jdavidb left #koha
13:31 brendan joined #koha
13:43 jdavidb joined #koha
14:04 indradg left #koha
14:07 rhcl joined #koha
14:12 Sharon joined #koha
14:14 jwagner gmcharlt, just sent revised patch -- hope everthing made it through the commit process :-)
14:22 gmcharlt jwagner: cool
14:40 jwagner Got another one in the works for you too, gmcharlt :-)
14:43 indradg joined #koha
14:48 jwagner nahuel, online?
14:48 nahuel jwagner, of course
14:48 nahuel :)
14:48 hdl_laptop back from holidays today
14:48 jwagner Could I get a translation?  I'm adding a syspref to control display of the my messaging tab in the OPAC?
14:50 jwagner Syspref definition is: If on, enables display of My Messaging tab in OPAC patron account and the email/text message settings in OPAC user update tab
14:50 schuster joined #koha
14:50 schuster Galen here?
14:52 owen schuster: use his nick in case his IRC client beeps him when he's mentioned: gmcharlt
14:53 nahuel hdl_laptop, jwagner, Si activé, affiche l'onglet "Mes Messages" dans le compte de l'adhérent à l'OPAC, et la configuration de l'e-mail et du message dans les préférences de l'utilisateur à l'OPAC.
14:53 nahuel hdl_laptop, t'en pense quoi ?
14:54 hdl_laptop jwagner: go with nahuel translation
14:54 jwagner nahuel, merci beaucoup!
14:54 nahuel héhé
14:54 nahuel you're welcome !
15:04 gmcharlt hi schuster
15:11 jwagner nahuel, it's Bug 3535 -- hope the translated string goes through.
15:12 munin Bug http://bugs.koha.org/cgi-bin/b[…]w_bug.cgi?id=3535 enhancement, PATCH-Sent, ---, jwagner@ptfs.com, ASSIGNED, Add syspref to control display of My Messaging tab in OPAC
15:12 nahuel ok
15:12 kf hi nahuel - I saw that renewals can be defined in circ matrix in biblibre's Koha - will this feature be in 3.2? I think its not on the road map
15:13 nahuel kf, Hi, it should, but ask to gmcharlt :)
15:13 gmcharlt kf: it will be added, albeit with a little refactoring
15:13 kf great!
15:55 joetho joined #koha
16:20 meliss joined #koha
16:44 owen left #koha
17:00 meliss left #koha
17:01 jwagner left #koha
17:01 jdavidb left #koha
17:04 joetho It's Monday here in Mondayville.
17:07 magnusenger left #koha
17:23 jwagner joined #koha
17:28 kf bye #koha
17:28 kf left #koha
17:44 pianohacker joined #koha
17:52 jdavidb joined #koha
17:52 fredericd joined #koha
17:59 fredericd Anyone knows what's the difference between tests places in t directory and those found in xt directory?
18:00 pianohacker fredericd: xt seems to be mostly code-correctness related tests
18:00 gmcharlt xt - primarily author tests
18:00 gmcharlt t - functinal and unit tests
18:01 fredericd thks
18:01 fredericd I'm diving into Koha test cases...
18:01 fredericd It's a world...
18:02 fredericd Where would you put a test verifying syspref coherence between languages?
18:02 gmcharlt xt
18:02 gmcharlt fredericd++ # test cases
18:02 owen joined #koha
18:06 fredericd gmcharlt: It's related to my attempt to deal with your 3 weeks old demand of a test case on bug 3226...
18:06 munin Bug http://bugs.koha.org/cgi-bin/b[…]w_bug.cgi?id=3226 major, PATCH-Sent, ---, jmf@liblime.com, RESOLVED FIXED, Extended characters aren't always properly displayed on resultat page when XSLT is on
18:06 fredericd I have first to understand test cases :-)
19:07 wizzyrea left #koha
19:09 Sharon left #koha
19:12 Sharon joined #koha
19:17 pianohacker left #koha
19:18 pianohacker joined #koha
19:33 jdavidb left #koha
19:34 chris morning
19:36 gmcharlt hi chris
19:37 jwagner morning, chris
19:43 jwagner left #koha
19:44 indradg left #koha
19:51 chris off to catch the bus
20:12 gmc_mob joined #koha
20:22 gmc_mob left #koha
20:30 Sharon left #koha
20:32 Sharon joined #koha
20:41 richard joined #koha
20:41 richard hi
20:41 pianohacker Hello
20:43 chris back at work
20:44 pianohacker Good morning
20:44 pianohacker chris++ # by the way, like the new About page
20:44 chris cool
20:46 wizzyrea joined #koha
20:55 * chris_n greets chris
20:55 chris_n and pianohacker
20:55 pianohacker Hi, chris_n
20:56 chris heya chris_n
20:56 chris and wizzyrea
20:58 Jo joined #koha
20:59 Jo Morning all
21:00 chris hi Jo
21:01 schuster left #koha
21:10 wizzyrea hi everybody :)
21:10 pianohacker Hello
21:10 owen What's up wizzyrea?
21:11 wizzyrea oh, just wishing that today were more weekend
21:11 wizzyrea there was not enough to go around this time
21:19 rhcl labor day coming up
21:20 chris our labour day is october
21:20 CGI028 joined #koha
21:20 owen This weather has me saying "winter coming up!"
21:20 chris i think thats our next public holiday?
21:21 wizzyrea is it chilly and rainy (in august!) in Ohio too?
21:21 owen For the past couple of days it has felt like August in Kansas.
21:21 owen I look forward to the chilly and rainy, send it my way
21:21 wizzyrea it's 77 and cloudy here :P
21:22 owen :P indeed
21:23 CGI028 Just going to jump in with a question - I was using the demo sites hosted by liblime and noticed that any searches I do using Z39.50 by ISBN just return connection failures to the resources... Is there a better way to lookup by ISBN to start the cataloging?
21:32 owen CGI028: I'll see if I get the same error
21:34 owen Yup. Hunh.
21:37 wizzyrea we've been having trouble with LOC today
21:42 brendan @wunder 93117
21:42 munin brendan: The current temperature in Northwest Goleta, Goleta, California is 18.1�C (2:39 PM PDT on August 17, 2009). Conditions: Mostly Cloudy. Humidity: 78%. Dew Point: 14.0�C. Pressure: 29.90 in 1012.4 hPa (Falling).
21:42 brendan well at least it's not listing smoke anymore
21:43 owen CGI028: Did you try your search using one of the other search targets? Only LOC is checked by default in the demo
21:46 wizzyrea yes, sorry I got sidetracked: we were having trouble with LOC today, but our other ztargets were working fine
21:47 wizzyrea so that's probably the issue you're seeing CGI028
21:48 brendan later #koha - time to ride my bike home :)
21:49 brendan left #koha
21:52 CGI028 actually if I select them all - still fails.
21:52 owen CGI028: What if you deselect LOC?
21:54 CGI028 Connection failed to bobcat.nyu.edu Connection failed to catnyp.nypl.org
21:56 CGI028 and on the remaining  - just no results... with an isbn i've tested in isbndb.com and works fine.
21:56 owen left #koha
21:58 CGI028 left #koha
22:00 Sharon left #koha
22:04 joetho google koha
22:04 joetho @google koha
22:04 munin joetho: Welcome to koha.org! — Koha - Open Source ILS - Integrated Library ...: <http://www.koha.org/>; Download — Koha - Open Source ILS - Integrated Library System: <http://koha.org/download>; KOHA Hockey | Home: <http://www.koha.com/>; Koha Integrated Library System — LibLime: <http://liblime.com/koha>; Koha (software) - Wikipedia, the free encyclopedia: (1 more message)
22:05 joetho @google hot club of cowtown
22:05 munin joetho: Hot Club of Cowtown :: Home: <http://hotclubofcowtown.musiccitynetworks.com/>; Hot Club of Cowtown on MySpace Music - Free Streaming MP3s ...: <http://www.myspace.com/hotclubofcowtown>; YouTube - Hot Club of Cowtown - Jools Hogmanay show, turn of 2003/4: <http://www.youtube.com/watch?v=Jr8My5Uo0gE>; YouTube - The Hot Club Of Cowtown: (2 more messages)
22:05 joetho ha. it works.
22:05 joetho left #koha
22:24 gmcharlt left #koha
22:27 brendan joined #koha
12:54 jdavidb @seen jwagner
12:54 munin jdavidb: jwagner was last seen in #koha 1 day, 13 hours, 22 minutes, and 1 second ago: <jwagner> Hi all, sorry, been off on another screen
16:19 |Lupin| good evening
16:56 |Lupin| bye all !
20:34 richard hi
20:38 pianohacker Hello
20:48 chris morning
21:11 chris hey nengard
21:11 chris so http://bugs.koha.org/cgi-bin/b[…]w_bug.cgi?id=2046 you say?
21:11 munin Bug 2046: normal, P3, ---, rch@liblime.com, NEW, Suggestions: Title Field too small
21:13 nengard changed my mind the comments on bug 2046 imply there may be more than a db issue
21:13 munin Bug http://bugs.koha.org/cgi-bin/b[…]w_bug.cgi?id=2046 normal, P3, ---, rch@liblime.com, NEW, Suggestions: Title Field too small
21:13 nengard let's do this: http://bugs.koha.org/cgi-bin/b[…]w_bug.cgi?id=2761
21:13 munin Bug 2761: major, P3, ---, gmcharlt@gmail.com, NEW, Call Number Field Too Few Characters
21:13 chris k
21:14 chris oh yeah we can do that
21:14 nengard cool
21:14 chris so when making db changes you need to do a few things
21:15 chris the first is make the change locally and check it works
21:15 chris so in this case we would get into our koha db
21:15 chris then run
21:16 nengard by 'get into our koha db' do you mean musing mysql - or just get into the directory where we have our git branch
21:16 chris ahh sorry by using mysql
21:16 nengard no prob - if we're documenting this i want to be very very specific
21:16 nengard :)
21:17 chris so once we are in mysql we can run some sql to alter the items table
21:17 chris ill let you figure that one out :-)
21:18 nengard i forgot what i set as my username on mysql :)
21:18 chris kohaadmin probably
21:18 pianohacker nengard: Try hitting Ctrl-R, then typing in mysql -u
21:18 nengard you are right ;)
21:18 nengard okay so now i want to update the table in question
21:19 chris yep
21:19 nengard UPDATE items SET itemcallnumber ....
21:19 nengard bleh - off to read the manual - be right back :) soooo out of practice
21:20 chris hint, it starts with ALTER
21:20 nengard don't tell me ... i'll get it :)
21:23 nengard ALTER items MODIFY itemnumber varchar(255);
21:24 chris that oughta do it, at least for modern versions of mysql
21:24 chris its itemcallnumber tho
21:24 chris making itemnumber a varchar would be bad :)
21:24 nengard hehe
21:24 nengard oops
21:24 lamiette w
21:25 chris thats why we try it locally before we send a patch ;)
21:25 nengard mysql> ALTER items MODIFY itemcallnumber varchar(255);
21:25 nengard ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'items MODIFY itemcallnumber varchar(255)' at line 1
21:25 chris ALTER TABLE items
21:25 nengard ahh - i thought TABLE was supposed to be the table name
21:25 chris w to you too lamiette
21:26 lamiette chris: morning getting to my ability to identify what window I am in
21:26 chris heh, monday's will do that
21:26 lamiette trying to :w irc instead of a buffer in vim
21:26 nengard ah - i forgot to pick a database first - now this i need help with
21:26 chris use koha;
21:26 nengard i've only ever used phpmyadmin :)
21:26 nengard okay
21:26 nengard change made
21:26 chris sweet
21:27 chris and koha still mostly works (it should but it never hurts to click around a bit)
21:27 chris (for something this benign checking isnt super nessecary but its a good habit to get into)
21:28 nengard clicking done
21:28 chris cool
21:29 chris so we know it works
21:29 nengard well - we know it doesn't break anything :)
21:30 chris the next step is to edit installer/data/mysql/kohastructure.sql
21:30 chris what i would do is vim installer/data/mysql/kohastructure.sql
21:30 nengard chris - in this instance shouldn't we also change the other tables with call numbers?
21:30 nengard biblio or biblioitems - i need to check and see where else there is a call number
21:31 chris probably not, if they are using itemlevelcallnumbers it doesnt store it elsewhere
21:32 nengard okay
21:32 nengard okay i'm in kohastructure.sql
21:32 chris i would type /itemcallnumber
21:32 nengard am i looking for the items table and itemcallnumber field i assume
21:33 chris that will jump you right to it
21:33 pianohacker nengard: Yes
21:33 chris ack i have a meeting in 10 mins
21:34 nengard done
21:34 chris but once you find that, you want to change the varchar(30) to varchar(255)
21:34 nengard done
21:34 chris cool
21:34 chris save and quit that file
21:34 nengard now create patch? or is there more?
21:34 nengard done
21:34 chris more
21:35 chris now we get to edit updatedatabase.pl
21:35 nengard same directory?
21:35 chris  vim installer/data/mysql/updatedatabase.pl
21:35 chris yep
21:35 nengard okay found the line and changed it
21:35 nengard and saved it
21:35 nengard next
21:35 chris there is no changing
21:36 chris :)
21:36 nengard changed from 30 to 255
21:36 nengard no??
21:36 chris you cant change in updatedatabase.pl
21:36 nengard hehe
21:36 nengard bleh
21:36 chris no cos that won't get run
21:36 nengard k
21:36 nengard what do i do?
21:36 nengard sorry
21:36 nengard was rushing cause you had to go
21:36 chris ahh sweet
21:37 chris meeting pushed back to 11
21:37 nengard yippe
21:37 chris so i have an hour
21:37 nengard okay i have updatedatabase open
21:37 chris what you want do do is come down in the file to just before sub DropAllForeignKeys
21:37 chris so /sub DropAllForeignKeys
21:38 chris will jump you there
21:38 nengard k
21:38 nengard there
21:38 chris now scroll up a bit
21:38 chris there is an if block
21:38 chris and a $DBversion= 'some number';
21:38 chris before that?
21:38 nengard uh huh
21:38 chris what number is it?
21:39 nengard .041
21:39 nengard or longer 3.01.00.041
21:39 chris right
21:39 chris in that case ours will be 3.01.00.042
21:39 chris so copy that line and the line below it, and paste it after the if block
21:40 chris then change the 41 to 42
21:40 nengard confused
21:40 nengard paste after this:
21:40 nengard $DBversion = '3.01.00.041';
21:40 nengard if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
21:40 nengard    $dbh->do("INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AWSPrivateKey','','See:  http://aws.amazon.com.  Note that this is required after 2009/08/15 in order to retrieve any enhanced content other than book covers from Amazon.','','free')");
21:40 nengard    SetVersion ($DBversion);
21:40 nengard    print "Upgrade to $DBversion done (added AWSPrivateKey syspref - note that if you use enhanced content from Amazon, this should be set right away.)";
21:40 nengard }
21:40 chris yes
21:41 nengard andcopy this:
21:41 nengard $DBversion = '3.01.00.041';
21:41 nengard if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
21:41 nengard    $dbh->do("INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AWSPrivateKey','','See:  http://aws.amazon.com.  Note that this is required after 2009/08/15 in order to retrieve any enhanced content other than book covers from Amazon.','','free')");
21:41 chris just the first 2 lines
21:41 nengard $DBversion = '3.01.00.041';
21:41 nengard if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
21:41 chris ye
21:41 chris s
21:41 chris and then change 41 to 42
21:41 nengard k
21:41 nengard done
21:42 chris now we want to add a line after the if to do our db change
21:42 nengard which is the alter line
21:42 chris so $dbh->do("That sql we tested before");
21:42 chris *nod*
21:42 nengard $dbh->do("ALTER TABLE items MODIFY itemcallnumber varchar(255);");
21:42 chris thats it
21:43 nengard done
21:43 nengard close IF?
21:44 chris now you want the last 2 lines from above
21:44 chris the SetVersion one
21:45 chris and the print
21:45 chris then close the if
21:45 chris and we want the print to say something meaningful
21:45 chris like changing itemcallnumber to varchar(255) or something
21:45 nengard $DBversion = '3.01.00.042';
21:45 nengard if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
21:45 nengard    $dbh->do("ALTER TABLE items MODIFY itemcallnumber varchar(255);");
21:45 nengard    SetVersion ($DBversion);
21:45 nengard    print "Change max length of itemcallnumber to 255 from 30.";
21:45 nengard $DBversion = '3.01.00.042';
21:45 nengard if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
21:45 nengard    $dbh->do("ALTER TABLE items MODIFY itemcallnumber varchar(255);");
21:46 nengard    SetVersion ($DBversion);
21:46 nengard    print "Change max length of itemcallnumber to 255 from 30.";
21:46 nengard $DBversion = '3.01.00.042';
21:46 nengard if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
21:46 nengard    $dbh->do("ALTER TABLE items MODIFY itemcallnumber varchar(255);");
21:46 nengard    SetVersion ($DBversion);
21:46 nengard    print "Change max length of itemcallnumber to 255 from 30.";
21:46 nengard $DBversion = '3.01.00.042';
21:46 nengard if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
21:46 nengard    $dbh->do("ALTER TABLE items MODIFY itemcallnumber varchar(255);");
21:46 nengard    SetVersion ($DBversion);
21:46 nengard    print "Change max length of itemcallnumber to 255 from 30.";
21:46 chris yeah just once will do tho
21:46 nengard }
21:46 nengard ooops!!!
21:46 nengard sorry
21:46 chris :)
21:46 nengard hehe
21:46 nengard sticky fingers
21:46 chris maybe add
21:46 chris Upgrade to $DBversion done
21:46 chris to your print
21:46 chris and end it with \n
21:47 chris (before the ";)
21:47 chris \n = newline
21:47 chris other than that, looks great
21:47 chris and a trick is http://koha.pastebin.com/
21:48 chris for pasting stuff
21:48 chris (thats longer than a few lines anyway)
21:48 nengard there is no new line in the past version upgrade
21:48 chris well can you fix that while you are there :)
21:48 chris there is in 39 :)
21:48 chris and previous
21:49 nengard okay
21:49 chris cool
21:49 nengard $DBversion = '3.01.00.041';
21:49 nengard if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
21:49 nengard    $dbh->do("INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AWSPrivateKey','','See:  http://aws.amazon.com.  Note that this is required after 2009/08/15 in order to retrieve any enhanced content other than book covers from Amazon.','','free')");
21:49 nengard    SetVersion ($DBversion);
21:49 nengard    print "Upgrade to $DBversion done (added AWSPrivateKey syspref - note that if you use enhanced content from Amazon, this should be set right away.)\n";
21:49 nengard }
21:49 nengard $DBversion = '3.01.00.042';
21:49 nengard if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
21:49 nengard    $dbh->do("ALTER TABLE items MODIFY itemcallnumber varchar(255);");
21:49 nengard    SetVersion ($DBversion);
21:49 nengard    print " Upgrade to $DBversion done (change max length of itemcallnumber to 255 from 30.)\n";
21:49 nengard }
21:49 chris awesome
21:49 chris save and quit
21:50 nengard sone
21:50 nengard done
21:50 chris and just 1 last file to g
21:50 nengard :)
21:50 chris kohaversion.pl
21:50 chris in the base dir of your git checkout
21:50 nengard change to .042
21:50 chris you want to change the number there to be 42 too
21:50 chris *snap*
21:51 nengard done
21:51 nengard :)
21:51 chris right, that's how we make a db change
21:51 nengard so much fun :) hehe
21:51 nengard yipppppeeeeeee
21:51 nengard i'll clean this up and put it on the tutorials page
21:51 nengard and i'll submit my first db patch :)
21:51 chris now before sending a patch you always want to fetch and rebase
21:51 chris but you know that eh?
21:51 nengard i always do that before creating my patch
21:52 nengard why after?
21:52 chris sorry before creating
21:52 nengard k
21:52 nengard :)
21:52 nengard i meant before i start writing my changes i pulled it
21:52 nengard you did say before
21:52 chris yep, then just before i do my patch
21:52 chris i fetch and rebase again
21:53 chris in case someone else has sent and had one accepted in the meantime
21:53 chris then create patch
21:53 chris and send
21:53 chris http://stats.workbuffer.org/irclog/koha/today
21:53 chris dunno if its easier to take from there
21:53 chris http://stats.workbuffer.org/ir[…]a;date=2009-08-16 even
21:54 nengard okay i'm confused - this screen for committing is diff than the one i'm used to seeing
21:54 nengard usually i hit esc and then type ZZ
21:54 nengard but that's not working
21:54 chris it will be vim
21:54 chris so just edit it as if it was vim
21:55 chris save and quit
21:55 nengard never used vim :)
21:55 chris its vi improved
21:55 nengard nope
21:55 nengard it's typing my :wq
21:55 chris did you hit esc ?
21:55 nengard yes
21:55 chris ok, control-z
21:55 nengard esc not working - at the buttom it says ^0 WRITEOUT
21:55 chris to background it
21:56 nengard no - what the heck is this
21:56 nengard i can't stop it from typing
21:56 chris ctrl-c ?
21:57 nengard that's cursor position
21:57 nengard according tot he bottom
21:57 nengard didn't do anything
21:57 chris ctrl-x  ?
21:57 chris ahh you are in nano
21:57 nengard that goe me out
21:57 chris i hate nano
21:57 chris ok
21:57 nengard what the hell is nano???
21:57 nengard and how did i get in there?
21:57 chris sudo apt-get remove nano
21:58 chris its a copy of pico .. which used to come with pine, lightweight editor
21:58 chris pine was my first email client
21:58 chris back in the day
21:58 nengard okay
21:59 chris ok try your commit again
21:59 nengard hmm
21:59 nengard it seems to have created my patch
21:59 chris and you should be in vi
21:59 nengard but i'm not sure where it went
21:59 nengard cause now it says there is nothing to commit
21:59 chris ahh created your commit you mean?
21:59 nengard yes
21:59 nengard sorry
22:00 nengard or not
22:00 nengard i did status and there isn't anything there
22:00 nengard .....
22:00 chris git commit --amend
22:00 chris yeah if you committed there wont be
22:00 nengard okay scary blue screen with my commit info
22:00 nengard this is not vim
22:00 nengard or vi
22:00 chris ctrl-c
22:00 nengard that got me out
22:01 chris export EDITOR=vi
22:01 chris git commit --amend
22:01 nengard THANK YOU
22:01 nengard this I know :)
22:01 nengard nengard@debian:~/kohaclone$ export EDITOR=vi
22:01 nengard nengard@debian:~/kohaclone$ git commit --amend
22:01 nengard Created commit 2e9b904: BUG 2761 Fix max length of itemcallnumber to 255
22:01 nengard 3 files changed, 10 insertions(+), 3 deletions(-)
22:01 nengard nengard@debian:~/kohaclone$
22:01 munin Bug http://bugs.koha.org/cgi-bin/b[…]w_bug.cgi?id=2761 major, P3, ---, gmcharlt@gmail.com, NEW, Call Number Field Too Few Characters
22:01 chris sweet
22:02 chris and you are ready to create and send your patch
22:03 nengard sent :)
22:04 nengard i will not edit this transcript for others to benefit from
22:04 chris :)
22:07 nengard patch submitted and attached to bug: http://bugs.koha.org/cgi-bin/b[…]w_bug.cgi?id=2761
22:07 munin Bug 2761: major, PATCH-Sent, ---, nengard@gmail.com, NEW, Call Number Field Too Few Characters
22:07 chris coolio
22:16 nengard hey gmcharlt put his tutorial on his blog
22:16 nengard can i put mine natively on the wiki?
22:16 chris sure you can
22:18 nengard k
22:18 nengard doing that
22:18 nengard don't htink people on my blog care too much :)
22:18 nengard can we do colored font on the wiki?
22:19 chris pass
22:19 nengard hehe
22:20 nengard okay will edit tutorial more than gmcharlt did :)
22:24 chris :)
22:25 chris your email just hit the list
22:40 nengard chris what's the syntax to have the wiki not turn all words with multi caps into links?
22:40 nengard http://wiki.koha.org/doku.php?[…]:dbupdatetutorial
22:41 chris no idea
22:41 nengard hehe
22:41 nengard k
22:42 nengard how about how do i make my link look right?
22:42 nengard http://wiki.koha.org/doku.php?[…]ntation:tutorials
22:42 nengard i want it to have the title of the page and i want the page under tutorials
22:42 nengard not under documentation
22:42 chris right you have to change the link to it
22:43 chris ill fix the title
22:43 nengard i thought just by putting it on tutorials it would use that page as the parent
22:43 chris http://wiki.koha.org/doku.php?[…]:dbupdatetutorial
22:43 chris nope
22:43 chris fixed the title 2 secs
22:47 chris http://wiki.koha.org/doku.php?[…]:dbupdatetutorial
22:49 nengard thanks
22:50 chris ok meeting time
23:04 nengard hey does anyone know where the koha news is stored? it's not in the db like i thought
23:04 nengard does it create a text file?
23:10 nengard nevermind - found it - it is in the db
23:20 nengard chris - thought of something we didn't cover what if you don't want to change the structure of a table - but the data in it - the you wouldn't have to edit kohastructure.sql - right?
23:20 nengard is there something you do have to edit?
23:25 nengard example - for this: http://bugs.koha.org/cgi-bin/b[…]w_bug.cgi?id=2611
23:25 munin Bug 2611: normal, P3, ---, gmcharlt@gmail.com, NEW, Language Issue: Patron Permissions
23:26 nengard i looked at the contents of the permissions table but I don't see the permissions I see when I got to edit a patron's permissions
23:26 nengard but once I figure out which table - I want to edit the text in the table, not the table itself
01:02 andy .win move 15
01:02 andy heh :)
01:02 pie typing fail :(
01:03 chris hehe
01:03 chris i like pit
01:03 pie 't' is two chars away from 'e' - not sure how that happened :)
01:35 brendan good evening #koha
01:35 chris heya brendan
01:35 chris how was the weekend?
01:36 brendan good - but my baseball team just lost in the semifinals
01:36 brendan so no more baseball till next year
01:36 chris ahh crappy
01:36 brendan how was your weekend
01:36 chris good, quiet
01:36 brendan :)
01:37 brendan we got spanked -- 14 to 5
01:37 brendan more like an american football score
01:37 chris ouch
01:38 brendan district9 was good -- although no too many hero's in it
01:38 chris yeah its not your typical hollywood movie
01:38 chris where everything is black and white and clear cut
01:40 brendan off to find some dinner :)
01:41 chris @seen pianohacker
01:41 munin chris: pianohacker was last seen in #koha 4 hours, 7 minutes, and 47 seconds ago: <pianohacker> nengard: Yes
01:42 chris @later tell pianohacker http://groups.fsf.org/wiki/Group:GNU_Generation
01:42 munin chris: The operation succeeded.
01:43 chris i think he squeaks in there, and he certainly deserves a free FSF membership
02:00 gmcharlt evening #koha
02:35 Jo afternoon all
03:12 chris hi Jo and gmcharlt
03:30 Amit hi chris, Jo
03:30 Amit good morning #koha
03:33 Amit @wunder Delhi India
03:33 munin Amit: Error: No such location could be found.
03:33 Amit @weather Delhi
03:33 munin Amit: Error: HTTP Error 500: Server Error
03:49 brendan heya Ammit
04:06 chris brendan: http://www.stuff.co.nz/enterta[…]film-opens-at-No1
04:07 brendan yup should clean up here - Jackson's a smart one
04:14 Amit heya brendan
04:14 Amit hi kmkale
04:15 kmkale hi amit
04:15 kmkale good morning all
04:15 Amit kmkale: any new?
04:15 kmkale nope
04:29 brendan night all
04:29 brendan see you tomorrow
04:53 Amit hi greenmang0
04:53 greenmang0 Amit: hey
05:00 kmkale bye all have a nice day..
05:33 Amit hi indradg_
05:34 indradg_ Amit, hey!
06:20 Amit hi hdl, elven
06:22 Amit hi kf
06:23 kf hi Amit and good morning #koha
06:24 hdl_laptop hi
06:56 kf hi hdl
08:12 chris evening
08:20 magnusenger morning
08:23 hdl_laptop hi
10:01 chris wth
10:01 chris http://sourceforge.net/projects/koha-plus/
10:20 gmcharlt hi folks
10:21 chris heya galen
10:24 hdl_laptop hi gmcharlt
10:25 gmcharlt hi hdl_laptop
10:26 hdl_laptop lunch time
10:26 gmcharlt nom nom nom
10:32 gmcharlt nengard++
10:43 slef anyone seen code 400 from a new koha installation?
10:43 chris 400? nope
10:43 slef 400 is Bad Request... I think I'll look at proxies now because it happens from multiple clients
10:44 slef have a bit of a problem searching the koha lists for it because Mumbai's postcodes start 400 ;-)
10:45 gmcharlt slef: confirm I haven't been seeing 400s either
10:46 slef also seems that the 400.pl (or 400.tmpl?) wording is misleading
10:47 gmcharlt 400.tmpl
10:47 gmcharlt "This error means that the Koha is pointed an invalid link" ?
10:49 slef 400 is Bad Request - client sent a request that the server can't understand
10:50 gmcharlt yeah, which by itself isn't necessarily informative either, if the 'client' turns out to be a proxy
10:55 slef does clearly say "not necessarily the server's fault" though ;-)
10:55 slef => customers will check clients first
10:56 slef I'll patch it Real Soon Now.
11:06 chris thats the new round tuit eh
11:08 chris http://www.stosyth.gov.uk/imag[…]a-round-tuit.jpeg
11:08 chris my dad has one of these on the fridge
11:08 gmcharlt heh
11:12 slef chris: yep. http://foldoc.org/RSN
11:12 chris :)
11:19 slef I think I found the code 400 problem.  Not a koha bug.
11:20 chris cool
11:36 chris hi jwagner
11:48 chris hi jdavidb
11:48 jdavidb Howdy, chris! :)
23:58 pianohacker brb, off to the deadlands of VPN
23:59 pianohacker left #koha

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