Time Nick Message
05:41 drojf good morning #koha
05:47 huginn New commit(s) kohagit: Bug 8617 - Problem with display of comments waiting for moderation in OPAC <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=ce038936d1b45ba8799e9ce740d573048b36a2fa> / Merge remote-tracking branch 'origin/new/bug_7671' <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=f32be62ef6c9fae1099b38b9a4441dcd2bfb3231> / Bug 7671 follow-up DBRev number <http://git.koha-community.org/gitweb/?p=koha.git;a
05:48 tweetbot` [off] twitter: @paul_poulain: "believe me or not, but I wake up early, pushed some patches, went again to "passed QA" list and found ... 19 patches ! #kohails"
05:51 mtompset Greetings, #koha. Is anyone here?
05:51 mtompset I have a *DEBIAN* repository question.
05:52 mtompset "E: Release file expired, ignoring {url} (invalid since 9h 28min 23s)"
05:53 mtompset I wasn't expecting this from a sudo apt-get update.
05:56 jenkins_koha Starting build #835 for job Koha_master (previous build: STILL UNSTABLE -- last SUCCESS #773 2 mo 12 days ago)
06:19 mtompset ls
06:19 mtompset Oops... wrong window. :)
07:02 jenkins_koha Project Koha_master build #835: STILL UNSTABLE in 1 hr 5 min: http://jenkins.koha-community.org/job/Koha_master/835/
07:02 jenkins_koha * matted-34813: Bug 8378 - <fine> syntax not working on overdues anymore
07:02 jenkins_koha * dcook: Bug 8764 - Template change "Authors" to "Additional authors" in OPAC
07:02 jenkins_koha * colin.campbell: bug 8768 correct an error in ItemType.t
07:02 jenkins_koha * colin.campbell: bug 8768 correct an error in ItemType.t
07:02 jenkins_koha * stephane.delaune: Bug 7671 : add a real primary key accountlines_id in accountlines
07:02 jenkins_koha * Paul Poulain: Bug 7671 follow-up DBRev number
07:02 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8378 critical, P5 - low, ---, koha-bugs, Pushed to Master , <fine> syntax not working on overdues anymore
07:02 jenkins_koha * oleonard: Bug 8617 - Problem with display of comments waiting for moderation in OPAC
07:02 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8764 trivial, P5 - low, ---, dcook, Pushed to Master , Template change "Authors" to "Additional authors" in OPAC
07:02 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8768 enhancement, P5 - low, ---, colin.campbell, Pushed to Master , t/ItemType.t fails because DBD::Mock has no empty result set
07:02 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7671 enhancement, P5 - low, ---, stephane.delaune, Pushed to Master , add a real primary key "accountlinesid" in accountlines
07:02 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8617 normal, P5 - low, ---, oleonard, Pushed to Master , Problem with display of comments waiting for moderation in OPAC
11:27 mtompset Greetings, #koha.
16:58 jcamins_away Wow. Word of advice for anyone thinking of following that suggestion: don't.
17:04 mbalmer which suggestion?
17:08 jcamins_away mbalmer: switching the order of tabs in the header by changing the order of lines in the file rather than by using jQuery.
17:09 jcamins_away On a production machine, without any version control. If you're using version control which will allow you to merge your changes in, that's one thing.
18:56 YoungPublicLibrarian Hello everyone!
18:59 rangi hi YoungPublicLibrarian
19:06 YoungPublicLibrarian how is everyone this weekend?
19:06 jcamins_away Quiet, it would seem.
19:06 jcamins_away Hello, YoungPublicLibrarian.
19:07 rangi yep :) was a busy friday for a lot of people it seems
19:07 YoungPublicLibrarian Well I'll stir up some activity, if anyone wants to give me a hand.
19:08 jcamins We can try. :)
19:10 YoungPublicLibrarian I created a report to give me a specific libraries fines and fees (I know, you've heard that line before...) The problem is that it only gives me part of the patron's fines.
19:10 jcamins What does the report look like? You can use paste.koha-community.org to share it.
19:11 YoungPublicLibrarian Say the patron has 10 instances of .20 cents each, the report may only show 5 - 6 instances of the fines...
19:11 jcamins I mean, what does the SQL look like, not the results, sorry. :)
19:11 pastebot "YoungPublicLibrarian" at 127.0.0.1 pasted "SELECT b.surname, b.firstname," (17 lines) at http://paste.koha-community.org/174
19:13 jcamins What was your thinking when you chose that GROUP BY?
19:14 YoungPublicLibrarian I actually just modified a report from the report library. So I don't know why that GROUP BY is used...
19:15 jcamins Which report did you use?
19:15 jcamins I guess I can search on that group by, which is quite... unusual.
19:16 jcamins Right... I have absolutely no idea why that group by is used, and I'm pretty sure it'll give you wrong results.
19:16 jcamins Change the GROUP BY to "GROUP BY b.borrowernumber"
19:16 wahanui jcamins: that doesn't look right
19:17 YoungPublicLibrarian Okay let me try that...give me a few minutes
19:21 drojf good evening #koha
19:21 rangi hi drojf
19:21 drojf hey rangi :)
19:21 YoungPublicLibrarian Okay, that definitely didn't work. Now it only gives me one fine for each patron...
19:21 * drojf just returns from a local library event
19:22 drojf there is more interest in koha hera than i anticipated :)
19:22 rangi excellent!
19:23 drojf and for some reason a lot of people thought i belong to the bsz (katrin's employer)
19:24 YoungPublicLibrarian Any other ideas Jcamins? I've tried several different modifications and they all have the same problem...
19:24 YoungPublicLibrarian The report is by Kyle M Hall btw.
19:24 jcamins YoungPublicLibrarian: yeah, I'm trying to figure out what it is you're trying to do with that report.
19:24 jcamins Could you please explain to me in words what you want?
19:24 drojf cait: erster :P
19:25 cait pf
19:25 rangi hey cait
19:25 cait hey rangi hey drojf
19:25 jcamins Hello.
19:25 cait drojf: long time no see...
19:25 rangi drojf: ppl have trouble with software that no one and everyone owns
19:25 drojf yes, it's a pity
19:25 rangi drojf: doesn't help that some vendors market it as if they owned it
19:25 cait oh
19:25 YoungPublicLibrarian I want the report to print out a line for each fine on a patron's account. I want be able to select patron's from one specific library.
19:25 cait talking about today?
19:26 YoungPublicLibrarian hello cait!
19:26 cait hi YoungPublicLibrarian
19:26 jcamins YoungPublicLibrarian: okay, so you want one line for each line, not one line for each patron?
19:26 drojf rangi: yup. and she was standing next to me ;) the concept of three people from different employers talking about the same software as kind of their own seems to be confusing
19:26 drojf cait: yes
19:26 jenkins_koha Starting build #171 for job Koha_3.8.x (previous build: SUCCESS)
19:27 rangi drojf: yes we found that at VALA in australia too, when it was us and Calyx sharing a stand
19:27 YoungPublicLibrarian correct. One line per fine in each patron's account. As many lines per account as needed to cover all fines for that particular patron
19:27 * cait felt a bit like the evil vendor
19:27 rangi lol
19:27 jcamins YoungPublicLibrarian: okay, in that case take out the GROUP BY entirely.
19:28 jcamins I thought you wanted a list of accounts at each library.
19:28 cait drojf: do I have to read the logs? :)
19:28 drojf cait: i came a minute before you
19:28 cait my feet are killing me
19:29 YoungPublicLibrarian Okay, so just take out the GROUP BY?
19:30 jcamins Right.
19:30 YoungPublicLibrarian Okay, give me a few minutes and I'll try that
19:36 YoungPublicLibrarian Okay, that looks like it fixed the problem. I'll check more in depth and get back to you. But the initial test seems to have worked. Thank you so much!
19:36 jcamins You're welcome.
19:36 YoungPublicLibrarian I've been fighting with that report for the last 6 weeks!
19:37 cait rangi: yeah, lots of people getting confused by free but not gratis too I think :(
19:37 cait but apart from that, lots of interest
19:37 rangi jcamins: bug 8071
19:37 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8071 blocker, P1 - high, ---, fridolyn.somers, Pushed to Master , link beween bib and authorities with the authid
19:37 rangi needed in 3.8.x?
19:37 jcamins You probably know this, but you can open a ticket with ByWater for that sort of thing. That's what you're paying them for! (ByWater is supporting you, right? I used to think you were being supported by Libeo, but I think someone said you were a ByWater partner)
19:37 cait and was great to be 2 people talking about Koha :)
19:37 jcamins Let me check.
19:37 cait drojf++
19:37 rangi cait: that happens the world over
19:38 drojf heh
19:38 drojf cait++
19:38 rangi do they have presentations and stuff there?
19:39 * rangi works on a plan to be able to visit berlin sometime
19:39 cait heh
19:39 jcamins Yes.
19:39 cait there was talk about having a workshop here ;)
19:39 rangi jcamins: thanks
19:40 cait rangi: where is there? :)
19:40 YoungPublicLibrarian Jcamins, Bywater is supporting us. But our library consortium does not want us to submit too many tickets because they don't like spending money...
19:40 drojf rangi: how good is your german? :)
19:40 rangi drojf: as good as your maori :)
19:40 drojf rangi: i'm afraid english seems to quite frightening to more people than i thought
19:40 drojf but maybe maori will work
19:41 rangi ahh there goes that plan :)
19:41 rangi maybe cait could interpret
19:41 * cait volunteers to be your simultan translator
19:41 rangi hehe
19:41 drojf :)
19:41 rangi yep, irma did that for me when i spoke in paris
19:41 cait i will make up something for the maori parts tho ;)
19:42 drojf cait: something swabian
19:42 cait ah
19:42 cait i am afraid, I don't talk dialect
19:42 drojf why?
19:43 cait don#t know
19:43 jcamins YoungPublicLibrarian: I was under the impression that ByWater offered unlimited support, but I'm glad I could help.
19:43 cait ask my parents
19:44 YoungPublicLibrarian Well that's what I understood...but the board of directors seem to think differntly, so we have to ask a couple IT technicians within the consortium for help first. If, after several attempts (and weeks), they can't figure it out then we're allowed to contact Bywater...
19:45 drojf rangi: but seriously i hope we will see some positive developments here, so maybe importing you for some kind of event is not something that could actually happen one day. i would certainly like that
19:46 drojf err. IS something that could happen. long day
19:46 rangi :)
19:47 YoungPublicLibrarian Okay, Jcamins...there is another problem with the report that I just found. It is only printing out "system" added fines. Any fines/fees that were manually added are not being picked up by the report...
19:47 cait importing_rangi++ :)
19:48 jcamins YoungPublicLibrarian: not sure what that's about, sorry.
19:48 drojf cait: i am really thinking of doing hands-on installation at that workshop if there are people considering self-hosting.
19:48 drojf or is that too crazy?
19:48 rangi not crazy at all
19:48 drojf i'm not really sure of what a timeframe he was thinking
19:48 cait drojf: maybe have 2 sessions
19:49 cait for some it might be hard... although ti would be fun
19:49 cait but not sure everyone can bring a laptop/computer
19:49 rangi one thing we did once at katipo, was say bring your laptop to our stand, we'll get a running koha on it for you
19:49 rangi that was in 2002
19:49 cait he said this winter
19:49 drojf cait: the bsz could provide 20 testservers :P
19:49 rangi install was both easier and harder then
19:49 cait I said maybe better push it next year
19:49 rangi but my record was 8 minutes
19:49 cait but he said better not wait too long because we got it started now
19:49 cait so should continue soon
19:49 jcamins drojf: not crazy, but you need to make sure that everyone has a computer, and that you have backup plans for those people who finish in five minutes with a two hour session.
19:50 cait drojf: you can try and sell uli on that ;)
19:50 drojf cait: yes, this winter... i meant how long the workshop would be ;)
19:50 cait oh
19:50 cait not usre
19:50 cait depends on te progamme I gues
19:50 cait s
19:51 drojf jcamins: yes, i guess it could only be an addon for those really interested. like "stay a second day, get a koha to go"
19:51 cait koha to go
19:51 cait nice
19:51 cait can I get that on a cup? :)
19:51 rangi a fun thing to do
19:51 rangi also
19:51 drojf rangi: that is cool
19:51 rangi is you know how lots of the crappy vendors do
19:51 rangi 'give us your details and go in a draw to win an ipad'
19:51 rangi type things?
19:52 YoungPublicLibrarian Okay, no problem Jcamins...I'll continue working on it...
19:52 rangi we once did
19:52 rangi 'you don't need to give us anything, we'll still give you an ILS'
19:52 rangi promotion
19:53 * rangi likes annoying the other vendors
19:53 * drojf likes rangi's approach
19:53 jcamins rangi: that's pretty awesome.
19:53 rangi i also had a 'who owns your data' tshirt
19:53 drojf that would be something for the german librarian day. lots of commercial craziness
19:54 rangi that was fun to go stand by sirsi/dynix stand
19:54 rangi wearing it
19:54 drojf hahahaha
19:54 magnuse rangi++
19:54 mbalmer drojf, when is that?
19:55 drojf mbalmer: don't know, next year somewhen. i've only been there last year when it was in berlin. ex libris was main sponsor
19:57 drojf mbalmer: thanks a lot for the sweets from switzerland by the way! cait gave them to me
19:58 mbalmer heh, I hope you like them!
19:58 cait rangi
19:58 cait rangi++
19:59 drojf mbalmer: very tasty actually!
20:03 rangi ok 10 more bugs to check and maybe push, but thats enough for a sunday morning
20:03 jcamins rangi++
20:04 rangi a blocker and 2 criticals fixed
20:04 cait nice
20:04 cait mbalmer: march
20:04 cait in leipzig next year
20:04 rangi oh
20:04 rangi kristina was just there
20:05 mbalmer mmm, leipzig, that is a very beatiful location
20:05 * cait hopes there will be a koha presentation...
20:05 * mbalmer could do one ;)
20:05 rangi 3.8.5 will contain at least 2 blocker fixes and 6 critical fixes, maybe more
20:06 drojf leipzig is conveniently close. i'll come to cheer if somebody talks about koha. and brings sweets
20:07 cait :)
20:07 mbalmer I can do a nice talk (it was very well received in constance), but I have no clue where to submit it.
20:08 drojf i think there is no call for papers yet
20:08 jcamins mbalmer: what was your talk on? (Koha, of course, but what aspect?)
20:09 mbalmer open source, what that is and what it means wrt Koha
20:11 mbalmer so not a Koha sales talk, neither what Koha has to offer, but about the community, the process, etc.
20:12 jcamins Ah.
20:13 jcamins The important stuff. :)
20:13 mbalmer yes, what makes Koha different from other ILSs
20:20 YoungPublicLibrarian Anyone else wanna take a stab at helping me with this report?
20:29 jenkins_koha Project Koha_3.8.x build #171: SUCCESS in 1 hr 2 min: http://jenkins.koha-community.org/job/Koha_3.8.x/171/
20:29 jenkins_koha colin.campbell: Bug 8017 reduce manipulation of GetAllIssues return
20:29 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8017 minor, P4, ---, colin.campbell, Pushed to Stable , Remove unnecessary processing on return of GetAllIssues
20:30 jenkins_koha Starting build #172 for job Koha_3.8.x (previous build: SUCCESS)
20:31 cait drojf++ for good measure
20:32 drojf ?? what did i do?
20:32 cait lots today
20:46 YoungPublicLibrarian Okay, signing off to get to work on this here report. By all!
21:24 cait time to sleep :)
21:31 jenkins_koha Project Koha_3.8.x build #172: SUCCESS in 1 hr 1 min: http://jenkins.koha-community.org/job/Koha_3.8.x/172/
21:31 jenkins_koha * oleonard: Bug 8730 - browse overlaying powered by
21:31 jenkins_koha * adrien.saurat: Bug 8719: Private lists always sorted by title
21:31 jenkins_koha * fridolyn.somers: Bug 8071: link between bib and authorities with the authid
21:31 jenkins_koha * colin.campbell: Bug 8656 Calendar needs to load both exception and nonexception dates
21:32 jenkins_koha * colin.campbell: Bug 8418: load repeating holidays hash correctly
21:32 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8730 minor, P5 - low, ---, oleonard, Pushed to Stable , browse overlaying powered by
21:32 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8719 normal, P5 - low, ---, adrien.saurat, Pushed to Stable , Private lists always sorted by title (even when author or date is selected)
21:32 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8071 blocker, P1 - high, ---, fridolyn.somers, Pushed to Stable , link beween bib and authorities with the authid
21:32 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8656 major, P1 - high, ---, colin.campbell, Pushed to Stable , Koha::Calendar not loading both sets of special dates
21:32 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8418 critical, P1 - high, ---, koha-bugs, Pushed to Stable , Koha::Calendar is_holiday ignores all user data