← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 12:27 | slef | Fallor: ow. No control over the internet connection? |
| 12:27 | (I'd've replaced that router for doing that silliness.) | |
| 12:36 | Fallor | the router is replaced now |
| 12:37 | but the internet is a problem | |
| 12:38 | we're in an island | |
| 12:38 | on? | |
| 12:38 | hmm... on island i think | |
| 12:59 | slef | on an island |
| 13:34 | Fallor | yep :) |
| 14:08 | atz | Fallor: a router that requires netbios needs to die. |
| 15:12 | slef | Should the patron import and printing move from Tools to Patrons in intranet? |
| 15:16 | pianohacker | Someone on the list seems to want to remove the default Koha username/password (kohaadmin). Is this even possible? |
| 15:18 | acmoore | that's the one that's also the mysql login information, right? |
| 15:18 | pianohacker | I believe so |
| 15:18 | slef | I don't think so, but you can rename it easy enough, either at install or runtime. Need to do several places almost all at once. |
| 15:19 | acmoore | I think you can make mysql accept logins with no password. but, koha would still prompt, woudn't it? I think that's the crux. |
| 15:20 | pianohacker | Yeah |
| 15:20 | slef | I've not seen the list Q yet. |
| 15:21 | pianohacker | Neeraj kumar and Morium Morshed asked at about the same time |
| 15:22 | acmoore | I'm probably missing the question, too. they seem to want to change it, not remove it. |
| 15:23 | pianohacker | Yeah |
| 15:23 | And they'd probably still like their db to be password protected ;) | |
| 15:24 | acmoore | I'd hope so! |
| 15:30 | rhcl | acmore: are you located in the KC area? |
| 15:30 | moore :) | |
| 15:30 | slef | rhcl: try acmoore |
| 15:30 | I don't know if acmoore uses nickname-alarms though ;-) | |
| 15:30 | acmoore | I do! |
| 15:30 | rhcl, yes, I am. | |
| 15:31 | pianohacker | /ping -f acmoore |
| 15:31 | acmoore | ack! |
| 15:31 | rhcl | OK, just wondering. We're in St. Joseph |
| 15:31 | acmoore | rhcl, yeah, I think I noticed that. there are a few kohanians around us here in the area. some kansas libraries, too, I think. |
| 15:33 | rhcl | NW Kansas area libraries were supposed to transition to Koha earlier this month; we are on somebody's schedule to go do a "look see" when they get smoothed out. |
| 15:33 | NE Kansas I mean. | |
| 15:33 | acmoore | ah. |
| 15:34 | Looks like that hasn't happened yet, I guess. http://kcmo.sirsi.net/uhtbin/c[…]3720913/60/1180/X | |
| 15:35 | owen | rhcl, is that NEKLS? |
| 15:36 | It hasn't happened yet, but they're in the process | |
| 15:36 | rhcl | Hummm, interesting. Maybe I'll have somebody give somebody a call. Our director came from a NEKLS library and she knows everyone. |
| 15:36 | owen | http://liblime.com/news-items/[…]selects-koha-zoom |
| 15:37 | pianohacker | They went with ZOOM this close to 3.0? Odd. |
| 15:38 | owen | I think the "zoom" is just Liblime's branding. They're going with 3.0. |
| 15:38 | pianohacker | Ah |
| 15:39 | rhcl | I see from the PR that they are using LibLime's hosted service. |
| 16:07 | mlasater | join #kohanews |
| 16:11 | acmoore | mlasater, it's over on freenode. |
| 16:21 | mlasater | acmore, Thank you. |
| 16:21 | slef | acmoore: yeah, why is that and where have the connection bots gone? |
| 16:22 | acmoore | I put it on freenode since I didn't think we wanted it in here in #koha, I wasn't sure of the bot policy on irc.katipo.co.nz, because I understand the stuff at freenode better, and I already hang out there a lot. |
| 16:22 | and, what connection bots? | |
| 16:23 | slef | there was bot(s) connecting freenode #koha to here at one point |
| 16:24 | acmoore | slef, oh, I have no idea about that stuff. I notice #koha over there is registered, but unused. I don't recognize the person listed as the owner, either. |
| 16:25 | slef | no, me neither... ahmuck? |
| 16:29 | pianohacker | Hmm. lastreneweddate in the issues table seems to be unused |
| 16:29 | Has anyone seen this? | |
| 16:35 | slef | http://comments.gmane.org/gman[…]h=lastreneweddate |
| 16:36 | pianohacker | Huh |
| 16:39 | atz | pianohacker: i'm sure those empty lines in their report are just the result of JOINs that don't ensure the keys are NOT NULL |
| 16:40 | pianohacker | Oh, not that |
| 16:40 | atz | probably not relevant to lastreneweddate |
| 16:40 | pianohacker | I'm just wondering whether I should have Circ::AddRenewal update it, since it should to fix bug 1551 |
| 16:41 | atz | good question |
| 16:41 | acmoore | pianohacker, That looks like a completely reasonable thing to do. |
| 16:41 | that field isn't referenced at all in the rest of the perl code, though. weird. I'll check around and see if I can find more history about it. | |
| 16:42 | pianohacker | The only other place it's referenced is in catalogue/issuehistory.tmpl |
| 16:42 | I'll work on that patch, in the meantime | |
| 16:43 | atz | acmoore: sounds fairly useless |
| 16:43 | the lastseen date should already get updated on a renewal | |
| 16:43 | acmoore | I can't find any problem with it at all. |
| 16:43 | go for it. | |
| 16:43 | pianohacker | acmoore: Cool, thanks |
| 16:44 | atz | certainly won't hurt anything, anyway |
| 16:44 | pianohacker | I know you guys were talking about timezone issues; is it safe to assume that Koha's "real" time and the mysql server time will agree ("UPDATE issues set lastreneweddate = current_date WHERE ...")? |
| 16:45 | acmoore | no idea. that's what i'd use, though. I think that behavior might be unspecified as of yet. |
| 16:45 | pianohacker | Ah well |
| 16:48 | The convention in Circulation.pm seems to be not to trust the mysql clock | |
| 16:49 | atz | pianohacker: we have plenty of code that inserts NOW() and similar mysql date/times |
| 16:49 | pianohacker | Okay |
| 17:34 | acmoore | so, the three current misc/cronjobs/fines*pl scripts use Date::Manup::Date_DaysSince1BC to get a numeral to use in their output filenames. I think we're trying to phase out Date::Manip. Is there any accepted replacement for this? Shall I use a 'YYYYMMDD' type of number in the filename? |
| 18:02 | kados | acmoore: Date::Manip was only being phaseed out for stuff that's time-sensitive like circulation |
| 18:02 | acmoore: it's fine to use it for cron jobs | |
| 18:03 | acmoore | hrm, OK. thanks |
| 18:06 | kados | acmoore: Date::Manip is a really great module, it's just dog slow to load into memory, so we avoid it for stuff like circulation where it was consuming about 90% of the time for a given transaction |
| 18:06 | but in a cron job it's not really an issue | |
| 18:06 | acmoore | yeah, I'm with you. that makes sense. thanks |
| 19:12 | atz | acmoore: for that case, see also the (largely undocumented) support for "sql" format from C4::Dates |
| 19:12 | aka "German" format | |
| 19:12 | %Y%m%d %H%M%S | |
| 19:12 | acmoore | thanks, atz. I'm just going to leave Date::Manip in misc/cronjobs/fines.pl |
| 19:13 | atz | yeah, not much reason to change that up |
| 19:13 | acmoore | in the accountlines table, what's the diffeernce between the 'amount' and the 'amountoutstanding'? |
| 19:14 | from what I can tell, they're usually the same. | |
| 19:14 | atz | amount should just be that transactions' worth |
| 19:14 | so fine a guy twice for two different things | |
| 19:15 | 5 bucks each time, and on both lines amount = 5. Then amountoutstanding = 5 (in the first one) and 10 (in the second) | |
| 19:15 | afaiui | |
| 19:16 | acmoore | so, if I want to levy a fine against a patron, I find his previous amountoutstanding, add my fine to it, and put that in the amountoutstanding in the new entry in the accountlines table? |
| 19:17 | that feels pretty weird, I'm aftraid I'm misunderstanding something. | |
| 19:18 | atz | yeah, i think that's it, basically. the rationale is fairly sound, since it prevents you from having to sum up all the users positive and negative accountlines |
| 19:20 | acmoore | Every instalnce of a call to CreateItemAccountLine puts the same value in both fields. |
| 19:20 | I guess the rational is sound. It seems like something we could use a database trigger for, though, or at least it should be wrapped up in C4::Overdues::CreateItemAccountLine somehow. | |
| 19:21 | atz | oh? nice. maybe it only gets adjusted when it is paid down |
| 19:21 | like i paid 2 bucks of the 5. 3 outstanding. | |
| 19:22 | not sure why you'd want to itemize it like that (i.e., pay one fine, but not another) | |
| 19:25 | acmoore | sounds like this bug was getting there http://bugs.koha.org/cgi-bin/b[…]w_bug.cgi?id=1730 but closed. I wish I could find cormack's new bug. |
| 19:26 | nengard | atz you can't do that ... at least not the way it is now |
| 19:27 | you have to pay the entire account line - so if you have a fine on one overdue item for $5 you have to pay $5 | |
| 19:27 | if you have one line for $2 an done for $3 then you can pay just 2 or 3 | |
| 19:27 | it's kind of annoying | |
| 19:27 | as for why you'd way to pay one fine and not another - mayb eyou only have $# in your wallet :) | |
| 19:28 | acmoore | aha. here's a bug that looks to be caused by the misuse of the amountoutstanding field: http://bugs.koha.org/cgi-bin/b[…]w_bug.cgi?id=1729 |
| 19:28 | nengard | $# was supposed to be $3 |
| 19:47 | acmoore | atz, I notice there's a C4::Overdues::GetFine method that sums up the amountoutstanding fields, so that makes me think that it's not supposed to be a running total for a particular patron. |
| 19:50 | atz | yeah, seems true. |
| 19:51 | nengard | a developer may want to answer the comment on this post: http://blogs.liblime.com/open-sesame/archives/110 |
| 19:53 | acmoore | don't feed the trolls. |
| 19:53 | owen | What is it with people saying, "maybe next time you'll switch to X?" |
| 19:54 | Sure, next time an underfunded library somewhere pays us to rewrite every line of code because they like X better | |
| 19:54 | And we'll re-do the interface in Flash while we're at it. | |
| 19:54 | atz | lol, yeah dude, we're going to go Java. |
| 19:54 | for what? | |
| 19:58 | nengard | hehe - no idea |
| 19:58 | just thought you'd all appreciate that comment and could make a more educated response than i could | |
| 19:58 | mc | owen, someone seriously asked for it ? |
| 19:59 | atz | mc: hard to judge their seriousness, but somebody asked. |
| 19:59 | (for java, not flash) | |
| 19:59 | mc | nengard, i read only one "head first" (this one about design pattern). this was the best book i read on this subject |
| 20:00 | pretty stupid! | |
| 20:00 | nengard | mc awesome! |
| 20:00 | i'd love to see you all comment :) | |
| 20:01 | mc | but it sounds logical as java is the leading langage for ... |
| 20:01 | well i don't know how to tell it in english | |
| 20:01 | managers who has no contact with technical reality | |
| 20:01 | atz | ... expensive development projects that never have to get anything done. |
| 20:02 | mc | we're talking about the same guys :) |
| 20:02 | atz | yeah. should reply "what, no Oracle support?" |
| 20:03 | mc | nengard, i agreed with acmoore: don't fill the troll and continue to buy o'reilly :) |
| 20:03 | :)) | |
| 20:03 | nengard | :) |
| 20:03 | owen | Didn't someone just suggest we switch to Python? Was that on one of the lists? |
| 20:04 | mc | maybe we have to rewrite koha in php ... even python ! |
| 20:04 | atz | i think the idea was that google app. engine supports only python |
| 20:04 | mc | ahah ! |
| 20:04 | owen | Yeah, and then atz promised to have a php version ready by Monday. |
| 20:04 | mc | owen, yeeaah ! |
| 20:05 | the only way for koha is C! | |
| 20:05 | ;) | |
| 20:05 | owen | I was thinking maybe ActionScript in one giant Flash file |
| 20:06 | mc | nengard, another point to not comment: as i said, i just read 1 book. Perhaps every others are awfull :) |
| 20:11 | nengard | owen and atz - i'm on board for a PHP version :) that's my area of expertice ;) hehe |
| 20:29 | acmoore | anyone know why there's both a date and a timestamp field in the accountlines table? |
| 20:29 | it seems a bit redundant, but perhaps I'm missing something. | |
| 20:39 | eric | hi guys. How often rebuild_zebra.pl is launched on koha.liblime.com? |
| 20:41 | chris | acmoore: timestamps are a special mysql thing, they are updated everytime the row is changed, (by mysql) |
| 20:41 | so it might be that they dont want the date to change | |
| 20:42 | acmoore | chris, good point, thanks. |
| 20:42 | now then, why are we setting it instead of letting mysql do it? aaargh! | |
| 20:42 | chris | :) |
| 20:42 | acmoore | Also, I'm going to lobby that we start calling these things "last_modified" or something instead of timestamp. |
| 20:43 | but perhaps I'm way off on that one. (again) | |
| 20:43 | pianohacker | I think the timestamps are only updated if the column was set to ON UPDATE CURRENT_TIMESTAMP |
| 20:43 | slef | nengard: I tried to comment "Yippee! The only times I've noticed Spam Karma 2, I've been left hoping that its user gets reincarnated as tinned chopped meat. Maybe I only notice it when it malfunctions, but it doesn't seem a good way to fight spam." on your Spam Karma post, but Spam Karma blocked it! |
| 20:43 | nengard | slef - i'll go approve it |
| 20:43 | slef | nengard: I don't think it reached your queue because SK2 blocked it. |
| 20:44 | acmoore | pianohacker, yeah, I know what you mean. I thinkmysql automaticall updates the first one or something during some operations. Anyway, it's set to update automatically. |
| 20:45 | nengard | slef - comment is there: http://www.web2learning.net/archives/1857 |
| 20:47 | slef | Warning: Cannot modify header information - headers already sent by (output started at /home/nengard/public_html/wp-content/plugins/SK2/sk2_second_chance.php:2) in /home/nengard/public_html/wp-content/plugins/wp-postratings/wp-postratings.php on line 691 |
| 20:47 | ||
| 20:47 | nengard | slef - thanks for the error - i used to get that - i fixed it - guess it's back!!!! |
| 20:50 | slef second comment approved | |
| 20:51 | and i may have fixed the error | |
| 20:52 | slef - what kind of spam do you get on your blog? I have over 1000 blocked by akismet and another 500 stopped by SK2 - very few real comments get stopped by SK2 - i'm wondering why yours keep getting hit | |
| 21:10 | slef | nengard: I get the usual viagra and so on on our blogs, but most get blocked by typepad. I deleted one spam today. I think my comments get blocked for four reasons: NoScript, no cookies, I fail eyetests and I criticise Spam Karma 2. |
| 21:10 | nengard | hehe |
| 21:11 | pianohacker | slef: NoScript and no cookies? The grocery store probably has a special on foil hats too ;) |
| 21:38 | Huh | |
| 21:38 | Koha has very odd capitalization around the members entry screen | |
| 22:31 | ryan | pianohacker: i think that's a french thing. they always capitalize surnames. |
| 22:31 | pianohacker | Not so much that |
| 22:32 | Zip/Postal Code but Email address, last name some places but surname others | |
| 22:32 | Firstname without a space | |
| 07:03 | chris | evening |
| 07:39 | paul_koha | hi chris |
| 07:43 | chris | hi paul |
| 07:45 | :-) | |
| 07:45 | one of those solved a quite nasty issue, if you had the wrong password for mysql ..or the server was down or anything like that, the error handling would loop forever | |
| 07:46 | the other one was just a tiny one | |
| 07:48 | paul | 1st meeting before 1 month of vacation for universities. |
| 07:50 | chris | ahh |
| 11:57 | nengard | sys pref OpacBrowser says it needs build_browser cron - but there isn't a build_browser cron - there is a build_browser_and_cloud.pl is this the same? if so we need to update the description for this sys pref |
← Previous day | Today | Next day → | Search | Index