Time Nick Message 11:49 fbcit kados:Do I understand right: mysql 'enum' type simply limits a column to one of several pre-defined options? 11:56 kados fbcit: yes 12:00 kados fbcit: just so you know, I think there have been a couple changes to the db since you started 12:00 kados fbcit: maybe just one ... but you should be able to rebase and catch those 12:01 kados fbcit: http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=summary 12:01 kados fbcit: http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=history;f=installer/kohastructure.sql;h=50d53c5f26980f8170cddae34f3edd32eceaa74f;hb=HEAD 12:02 kados hdl: are you here? 12:02 kados paul_away: ? 12:03 kados hdl: I'm having trouble with the patches to additem.pl/tmpl 12:05 fbcit kados: I'll take a look. tnx 12:11 hdl hi dados 12:11 hdl hi kados 12:11 kados hi hdl 12:11 hdl what problem fo you have ? 12:11 kados it's easiest to show you 12:12 kados try to edit or add an item at the URL I sent you 12:12 kados when you edit, all the fields will disappear 12:12 kados when you try to add, you won't be able to save the record 12:13 kados I attached a note to the bug specifying the specific patch it was 12:13 kados http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=commitdiff;h=8bdc7f83acaf471ac9e14c7c0a74e3a4d9a575ee 12:16 ansius hi there! 12:17 kados hi ani 12:17 kados ansius I mean :-) 12:19 ansius a dum question, wich distro of linux would be the best for koha, i have had trouble with all of them... :( 12:19 ansius a dum question, wich distro of linux would be the best for koha, i have had trouble with all of them... :( 12:20 ansius ok, debian how did you manage tu get mysql 4.1 runing, i have been triing that for 2 days 12:20 ansius ok, debian how did you manage tu get mysql 4.1 runing, i have been triing that for 2 days 12:20 kados well, I run Koha on mysql 5 12:21 kados the package maintainer hasn't released a 2.2.10 with all the mysql 5 support 12:21 kados but it's all there in CVS 12:22 ansius oho, so the 2.2.10 is in dev section? 12:22 ansius good news! :D 12:22 ansius good news! :D 12:22 kados 2.2.10 hasn't been released and the package maintainer has said he won't have time to create it 12:22 ansius good news! :D 12:23 kados but you can bug him :-) his name is Paul Poulain :-) 12:25 ansius dumer question, how to get it form there... 12:26 fbcit masonj: in z3950servers.position and type will a datatype of varchar(10) be sufficient? pg lacks an 'enum' type... 12:26 fbcit masonj: so I'm using a constraint to do the same thing. 12:27 kados fbcit: mason is in NZ, so probably asleep if he know's what's good for him :-) 12:28 kados fbcit: position is just a numeric value defining the order to search the server 12:28 kados fbcit: type varchar(10) will be fine 12:30 the_ansius ok now i can talk, git mIRC running 12:30 fbcit kados: so code referring to this field looks at the index rather than the value? 12:31 kados fbcit: hmmm, to be honest I'm not sure 12:32 the_ansius im no linux expert (except the typical LAMP setups), and have had trouble with getiing koha runing on various distributions. 12:32 the_ansius ubuntu was before my choice 12:33 fbcit kados: It will make a difference in how I handle it in pg. Reading in the mysql man indicates either value or index can be accessed w/SELECT. 12:33 the_ansius but no AMD64 didnt like mysql-4.1 12:33 fbcit kados: So, who to ask? 12:33 kados the_ansius: it's likely the trouble wasn't related to koha, but one of the dependencies 12:34 the_ansius jap i know, but i vasnt able to solve them :( 12:34 kados fbcit: hmmm 12:34 kados fbcit: value shuld be fine 12:36 fbcit kados: ok. I'll go that direction then. 12:39 fbcit kados: It appears that pg 8.3 will have enums. 12:39 kados sweet 12:43 ansius another dumb question what is 'http://download.savannah.nongnu.org/releases/koha/koha-2.3.0.tar.gz' and will it work with mySQL5 ? 12:43 kados ansius: no, that is a developer's pre-release 12:43 kados you don't want that :-) 12:44 ansius ok, so hwre can I get 2.2.10 12:45 kados ansius: you can bug the package maintainer to release it :-) 12:46 ansius i gues that i will not be able to bug him so much to get it asap, cos client want to see something by tomorrow morning (UTC +3) 12:47 kados ansius: ahh, you're doing this for a client? a library I suppose? 12:48 ansius a school one 12:49 kados cool 12:49 ansius they didn't want to pay for something like a software, good that they at least bought server 12:49 ansius mostly i work with web/php/ drupal cms stuff 12:59 ansius is ther any other way without bugging anyone too much to get a 2.2.10 version? 13:01 kados ansius: perhaps 13:01 kados ansius: http://www.kohadocs.org/Updating_Koha.html 13:02 kados ansius: you can run off of CVS 13:02 kados the rel_2_2 branch 13:08 ansius i'll try, thanks! 14:28 owen foxnorth, you around? 14:29 kados owen: he's on a call atm, should be back soon 14:34 kados owen: go learn javascript! :-) 14:35 owen No, that was the YUI guys ;) 14:35 kados heh 14:38 Frederic Hi, 14:38 Frederic circ/memberentry.pl is broken in git repository. 14:38 Frederic http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=blob;f=members/memberentry.pl;h=d1bde60b482165129ee2efd69a4940c03a2571e3;hb=HEAD 14:38 Frederic Lines: 44 50 115 etc 14:43 hdl Can you detail ? 14:45 Frederic Line 44, you get: 14:45 Frederic <<<<<<< HEAD:members/memberentry.pl 14:45 Frederic which isn't perlish. Etc. 14:54 hdl This looks like you had a merge problem 14:58 Frederic Yes. But the merging issue occurs into the git repository. 14:58 Frederic I've done a fresh 'git clone' and get the brocken circ/memberentry.pl file. 15:15 kados Frederic: you're right! 15:21 kados Frederic: OK, I pushed up a fix 15:21 kados sorry about that! 15:30 Frederic Great. It works! Thanks. A simple 'get pull' and I get back a working memberentry.pl. 15:30 Frederic Except that x right access wasn't set properly. Had to do chmod 755... 15:31 kados ahh, right 16:19 paul hello world 16:20 paul I have found git-send-email again. It's in a specific package on mandriva 2008 ;-) 16:20 paul sending 4 patches to chris now ! 16:23 kados paul: patches to additem? :-) 16:23 paul yep kados 16:23 kados w00t 16:23 kados paul: can you cc me, I'd like to test them 16:24 paul done 16:24 kados thx 16:25 kados paul: I'll test immediately 16:25 paul i'll leave soon (6:30 pm here) 16:28 kados paul: this patch doesnt' seem to fix the problems with additem that I'm experiencing 16:29 paul which one ? 16:29 paul (it fixes only duplicate barcode) 16:38 kados hdl, paul ... if we can't resolve the issues with additem today I'm going to revert patch 8bdc7f83acaf471ac9e14c7c0a74e3a4d9a575ee 16:38 kados just to ensure that additem works in mainline git 16:38 kados I just tested reverting and it works 'on the surface' 16:38 paul cant this just wait until monday ? 16:38 paul (update from .008 to .010 is very long for me...) 16:39 kados well, it's been 48 hours with additem broken so I think i should just revert it if there's not an easy fix 16:40 kados otherwise additem doesn't work at all in git :/ 16:40 kados monday is too long I'm afraid 16:42 kados it's my fault for not catching this _before_ it was pushed up :-) 16:42 paul the Check function is supposed to check that all existing mandatory fields are working. 16:42 paul it seems it uses the "old" marc editor structure (with field_values) 16:43 paul and not the new one. 16:43 paul just "return 1;" after the function declaration, and you should be able to validate an item (can't test, update still not finished on my computer) 16:44 paul sh...t "internalt server error" ... 16:44 paul the process was too long. 16:44 kados updatedatabase_over_http-- ;-) 16:44 paul this will probably be a major problem: if the update is too long, then Apache kill the process 16:45 paul I have to leave now, Nathan is back after 1 week away. 16:45 paul bye & good week end to everybody. 16:45 kados bye paul 16:56 hdl kados you reverted ? 17:15 kados hdl: haven't pushed it up to main git 17:15 kados hdl: why, have you solved the probs? :-) 17:15 hdl still working on it. 17:22 hdl damaged in field list (items table) Is this yours ? 17:22 hdl database structure not uptodate 17:29 kados maybe you didn't run updatedatabase? 17:32 hdl Yes I did. 17:32 hdl bbsoon 17:32 hdl lunch time 17:45 kados wow, late lunch :-) 18:03 hdl sorry dinner 18:44 fbcit Is there any particular reason that aqbudget.startdate is defaulted to 0? Since it is a date type could it be defaulted to the current date? 18:44 kados it should default to NULL 18:44 kados fbcit: thanks, I'll update kohastructure.sq 18:44 kados l 18:44 fbcit startdate date NOT NULL default 0 18:44 kados yea, that's just mental 18:45 kados should be startdate date default NULL 18:45 fbcit tnx 18:53 hdl kados : patch sent. 18:55 hdl There still is a little problem on duplicate subfield But it is more a display problem than and data 18:56 kados hdl: thanks, I'll take a look 20:09 fbcit I'm off for the weekend..... 20:34 kados hi rex 20:34 kados rex: how's the weather? :-) 20:35 rex 85 degrees and sunny... like every day :) 20:35 rex where in NZ are you? 20:35 kados what brings you to our temperate channel? :-) 20:35 kados oh, I'm actually based on Ohio 20:35 kados s/on/in/ 20:35 kados the NZers won't be here today, it's Saturday there :-) 20:36 rex Ah -- I was looking at the server address, not yours. 20:36 rex I'm a professor at UH Manoa and our department library is looking at Koha as a solution for our IT needs. 20:36 kados excellent 20:36 rex I have some tech background so I thought I'd lurk to get a sense of how active the community is, etc. 20:36 kados sure 20:36 kados it's pretty active 20:37 kados the commit log is always a useful metric too: 20:37 kados http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=summary 20:37 kados http://git.koha.org/gitstat/ 20:37 rex yeah. As the chair of the comittee that is looking at 'solutions' t our IT needs I can't be too partisan, but on the whole I'm sympathetic to F/OSS solutions 20:37 kados sure 20:38 rex I guess our main concern is that Koha is too Drupal like -- i.e. useful only if you already know how to write it from scratch ;P 20:39 kados well, I don't know much about your needs, a lot has to do with what you're planning to use it for, how large the collection is, who will be using it, etc. 20:40 rex yes. Actually we should figure out how large our collection is. 20:40 kados ie, if you're looking for a way to keep track of a couple hundred books, might be better off looking at something like librarything or something 20:40 rex I mean... the room its in is large... 20:40 kados koha is really designed for an active library 20:40 kados that has at least cursory understanding of the basic modules and standards in place 20:41 kados large_rooms++ :-) 20:41 rex yeah. people are afraid of LIbrary Thing for some reason. 20:41 kados hehe 20:41 kados well, Tim Spalding's a great guy 20:41 rex you know how it is -- people only trust solutions where they're paying someone something. Otherwise they think it is either 'broken' or 'stealing their information' 20:42 kados huh ... well that's an easy fix :-) 20:42 kados http://koha.org/support/pay.html 20:42 kados there are companies that will offer turnkey solutions, even hosting, for Koha 20:43 rex Yeah it will be nice to have a spectrum of pay/free options 20:43 rex At this point I think it looks like this: we have >5K books, I'd reckon. We want a searchable catalog online. 20:44 kados rex: http://liblime.com/products/koha/koha-classic 20:44 rex We want a proper database, populated hopefully w/MARC records we pull down 20:44 kados that's my recommendation :-) 20:44 kados </vendorbias> :-) 20:44 rex yes I think some other memebrs of the committee have been looking at that 20:45 rex we have an OSX box we can install Koha on, so hosting is probably not for us. 20:46 rex I guess this means if we were to go for a liblime solution it would be 'basic' eh? 20:46 kados yup 20:47 kados but not sure we'd support it on OSX 20:47 rex yeah. And we have no money, really. Might be better to just install ourselves. 20:47 kados yep 20:47 rex Since becoming a prof I feel a bit out of it techwise. 20:47 kados there is a guide somewhere for OSX install 20:47 kados did you run across that? 20:47 rex might be nice to keep my hand in. 20:47 kados someone posted to the list recently 20:48 rex yeah. THere's a lot of docs. Apaprently getting the Z3259 (or whatever the protocol is called) client up is a bit of a pain. 20:48 rex 39.50 20:49 rex kados: is LibLime's Keystone suite a flavor of Greenstone? 20:53 kados no ... it's an Index Data product 20:53 kados indexdata.dk/keystone i think 20:54 kados we're also going to be supporting Kete: http://horowhenua.kete.net.nz/ 20:54 kados which is another digital library system 20:56 rex heh. All these Polynesian names. 20:57 chris thats cos they come from Aotearoa :) 20:57 rex heh -- they all look like mispelled Hawai'ian to me :D 20:58 chris Hawai'ian looks like mispelled Maori to me :-) 20:58 rex we had different missionaries, apparently :) 20:58 chris ps, tell your football teams to stop stealing our haka :-) 20:58 rex don't get me started. 20:58 chris hehe 20:59 rex that is not only totally disrespectful to Maori but it is also totally clueless about kana 'oiwi people here as well. 20:59 rex *kanaka 21:00 chris yeah, im with you there 21:00 rex kados: just for the record, can you give me a ballpark on what the Koha classic woudl be costwise (you can msg me privately if you don't want to put it on channel). 21:00 rex oof. Don't get me started. Honestly. 21:03 chris my sister has been to Hawaii a bit, she works as a researcher for a school of medicine here, in the indigenous health area 21:03 chris ive yet to visit though ... maybe ud like some Koha training? :-) 21:03 rex we probably have some small world connections then 21:04 rex heh -- I'll let you know. 21:04 rex she may know Kalani Brady... but I think he might just be an indigenous doctor. 21:05 rex albeit a healthy one. 21:05 chris :-) 21:05 chris ill ask next time i see her, shes at some conference at the moment 21:05 chris donna cormack 21:05 chris is her name 21:06 rex they have a different campus than the one I'm on 21:06 chris http://www.nzma.org.nz/journal/119-1231/1917/ <--- she does this kinda stuff 21:08 rex ah. 21:08 chris annoying the government by pointing out disparities in funding .. and unequal outcomes etc :) 21:08 rex yeah. 21:09 rex I guess you have to keep doing that over and over again even if its already been demonstrated for like decades and decades 21:09 chris yeah 21:10 chris sad but true 21:11 chris ok, time to take the family out for some brunch, ttyl 21:14 rex cu 21:30 chris heh, i have no idea why i think i can make plans with an 11 month old ... while i was in the shower he has fallen asleep on his mum, who in turn has fallen asleep 21:30 chris so brunch is postponed 21:34 kados hehe 00:32 atz members/memberentry.pl still seems to be messed up in git repo. 01:59 thd ping kados 07:17 ansius hi again, i'm still in the same place. ok I got the cvs rel_2_2 koha, but i have no idea how to set it up, or i can use this one to fix installer so it would work with mysql5? 09:15 ansius bugging again, i'm still in the same place. ok I got the cvs rel_2_2 koha, but i have no idea how to set it up, or i can use this one to fix installer so it would work with mysql5? 09:34 ansius bugging again could anyone please help to get koha-2.2.10 or help to somehow set it up with mysql5 ? 10:59 ansius bugging again could anyone please help to get koha-2.2.10 or help to somehow set koha up with mysql5 ?