Time Nick Message 00:10 druthb o/ 02:06 schnydszch good morning koha users, where do i change the meta tag of my koha website? 02:07 eythian "meta tag"? 02:08 schnydszch yap 02:08 eythian as in, in the HTML header? 02:08 schnydszch yap 02:08 schnydszch is it in the opac header 02:08 eythian you'd have to modify the template, I guess. 02:08 schnydszch in the global references? so that crawlers can properly index my site 02:08 schnydszch where and what to modify? 02:09 eythian I didn't think crawlers paid much attention to meta headers these days. 02:09 eythian it depends how you installed Koha, and keep in mind that customisations are likely to go away when you upgrade. 02:10 eythian but, it looks like it's defined in doc-head-close.inc. 02:10 schnydszch that's what i'm thinking, as much as possible, i don't want to customize codes (e.g. CSS codes), if it can be work out in the database, much better 02:11 schnydszch installed koha in /usr/share/koha 02:11 eythian In that case, I'd look into making a system preference to allow custom HTML to be included in the header, or something along those lines. 02:11 schnydszch where's that doc-head-close.inc? 02:11 eythian dunno, depends how you installed things. 02:11 eythian I'd use the 'locate' command to find it. 02:13 jcamins_away schnydszch: what crawlers are you concerned about? 02:15 schnydszch google :) 02:16 schnydszch so when search <insert name of institution> online public access catalog, 1st in the search result is our library's opac 02:16 schnydszch or are there other ways to do this? 02:17 eythian nobody searches for "online public access catalog" 02:17 eythian they search for "<name> library" I think. 02:18 rangi make sure you libraryName systempreference is set 02:18 jcamins_away schnydszch: I'm 99% sure that Google ignores all meta headers at this point. 02:18 rangi yep 02:18 rangi title it looks at 02:18 rangi and if LibraryName is set, that's in title 02:18 eythian yeah, in the late 90's everyone filled the meta headers up with crap, making them largely useless. 02:18 rangi and then you just need time and people linking to it, to make it move up the rankings 02:18 schnydszch yeah, it's set to our library name 02:21 schnydszch so i won't concern myself with the meta thing then.. 02:43 eythian Symphony seems to call issues "charges." Is this a real thing, or just it being weird? 02:44 eythian (i.e. is the funny naming actually a name some people use for issues?) 02:48 jcamins_away eythian: I've heard it. 02:49 eythian OK cool. 02:49 eythian I can see how it could make sense, just never heard of it in this context before. 03:48 horiveira what's up koha! 03:49 rangi hi horiveira 03:49 horiveira I'm having an issue with installation on Ubuntu Server 12.04 - I'm not able to access the administration website to install the software 04:07 tweetbot` [off] twitter: @ffkp: "FFKP Weekly is out! http://t.co/1X6YRE4O â–¸ Top stories today via @kohails @womensday @creativecommons" 04:07 horiveira Would someone be able to help me with an installation issue? 04:08 eythian that entirely depends if someone knows the answer to your question. 04:09 eythian wahanui: ask 04:09 wahanui Don't ask to ask, just ask. 04:09 horiveira i did, no one replied 04:09 eythian oh, you did too 04:09 eythian I might just be blind. 04:10 eythian how are you installing it? 04:10 eythian Why aren't you able to access the administration page? 04:11 horiveira i got stuck on the step right before the web installer 04:11 horiveira I can't access http://library-intra.framisdooby.org:80 04:11 eythian How are you installing koha? 04:11 eythian sounds like using the packages? 04:11 horiveira yeah, i'm using the packages 04:12 eythian you have no DNS set up for that hostname 04:12 horiveira would i fix that in the koha-sites.conf? 04:13 horiveira I'm not intending for folks to use it outside of the network just yet. 04:13 horiveira if that matters at all... 04:13 eythian Well, for real life, you'd need to get whoever does the DNS for framisdooby.org to set it up for you. 04:14 eythian For local purposes, you can edit your hosts file so your local computer pretends like it's set up, keeping in mind that it'll only work on that one computer. 04:16 horiveira I've edited the host files, but I still can't access it. 04:16 eythian what happens when you try? 04:19 horiveira I get the system maintenance message 04:20 eythian which one? 04:20 wahanui hmmm... which one is 3.6.x? 04:20 eythian does running "sudo koha-enable <instancename>" make a difference? 04:20 horiveira System maintance: The Koha online catalog is offline for system maintenance. We'll be back soon 04:21 eythian oh right 04:21 eythian you're hitting the OPAC. 04:21 eythian Most likely you didn't have koha-sites.conf configured correctly when you ran koha-create 04:22 eythian you should check your /etc/apache2/sites/<instancename> file and correct the ServerName directives. 04:22 eythian (remember to restart apache when you're done) 04:30 horiveira I edited the ServerName lines under the OPAC and Intranet sections 04:30 eythian yep 04:30 eythian hi cait-m 04:31 horiveira restarted apache, and pointed to http://library-intra.framisdooby.org/ (with replacing the names i applied) and still get the same message 04:32 horiveira well, get presented with the same system maintenance page 04:32 eythian can you put your apache config in a pastebin? 04:32 eythian wahanui: paste 04:32 wahanui paste is found at http://paste.koha-community.org 05:05 horiveira i'm not able to copy apache config at the moment 05:05 horiveira would you help me look for what could be the problem in the apache config? 05:06 eythian as far as I can tell, you have your ServerName for your intranet client incorrect, or you are accessing it with the wrong URL. Because they don't match up, you are getting the first virtual host in apache, which is the OPAC. 05:06 eythian I can't look at it without seeing your config. 05:18 horiveira is there anyway to access the admin/setup using IP instead? 05:20 eythian No, it's managed by cirtual hosts. 05:20 eythian *virtual 05:23 horiveira alright. It's rather late where I am - I appreciate the help. Do you think I would be able to come back and get a response from someone? Or is there a way to stay in contact with you regarding this issue when I have more time? 05:23 eythian my time zone doesn't suit that, but I expect Europe to be waking up in not too long. 05:25 horiveira cool. many thanks! 05:26 eythian np 05:43 yesan Hello Folks 05:44 yesan i have a problem in koha cataloguing, holding details are not shown although items details are entered. 05:45 yesan can someone out there to help me. 05:46 yesan Hello 05:48 yesan hello folks, i have a problem in cataloguing, holding details are not shown, even though I have the item details are entered in the 952tags 05:49 yesan i do not know if this question has been asked by someone. 05:49 yesan hello gmcharlt 05:58 yesan bye 05:58 yesan all busy 06:08 magnuse kia ora #koha! 06:33 alex_a bonjour 06:33 wahanui privet, alex_a 06:34 marcelr hi #koha 06:58 * cait waves 06:59 reiveune hello 07:01 cait bonjour reiveune 07:01 reiveune slut cait :) 07:01 sophie_m hello #koha 07:01 cait reiveune: that was not exactly nice ;) 07:02 reiveune SALUT cait ;) 07:02 * cait guesses you meant salut 07:02 cait ;) 07:04 gaetan_B hello 07:21 cait bug 3652 07:21 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3652 critical, P1 - high, ---, oleonard, ASSIGNED , XSS vulnerabilities 07:21 cait bug 3652 07:22 magnuse nastiness 07:26 rangi evening 07:26 cait t 07:29 magnuse kia ora rangi! 07:31 cait evening rangi 07:51 * cait waves again 07:51 WaqarAzeem hello 07:52 WaqarAzeem any with regular expressions? 07:52 WaqarAzeem me looking for the meaing of this 07:52 WaqarAzeem m/^.*(\s.*\s*|\s&|\<.*\>)$/; 07:55 WaqarAzeem This is the line i found at pdf creation. when long text is arranged in multiple lines to adjust in textbox. 07:59 WaqarAzeem I need to change it little bit, if pipe sign i.e. | in text then break it from this point as well. 08:01 magnuse hehe, cait is busy today :-) 08:02 cait-m_ hm? 08:02 magnuse lots of coming and going 08:03 cait-m_ ah sorry 08:18 francharb hello 08:20 rangi hi francharb 08:20 magnuse bug 3652 08:20 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3652 critical, P1 - high, ---, oleonard, Signed Off , XSS vulnerabilities 08:20 rangi yay 08:20 magnuse :-) 08:20 rangi http://git.koha-community.org/gitweb/?p=koha.git;a=shortlog;h=refs/heads/3.8.x <-- all on 3.8.x already 08:21 rangi but that last patch is needed on master still 08:21 magnuse the one i just signed off too? 08:21 rangi yep 08:21 magnuse ah 08:22 magnuse that's what i call quick! :-) 08:42 mtompset Greetings, #koha. 08:42 mtompset I'm glad I had an extra pair of eyes look over my instructions... found a couple typos and an instruction or two that wasn't clear. 10:11 huginn New commit(s) kohagit: Bug 8791: OPAC UNIMARC XSLT details: subject with subfield 3 <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=b48615dda50342ab7a50efdac4d5177d9657f266> / Bug 8873 - JavaScript error in Opac displaying tag cloud <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=b83050efab9e4a3b4f2ed8ad8d29311c6d5d0cd9> / Bug 8793 - Fix materialTypeCode/typeOf008 icons for NORMARC XSLT <http://git.koha-community 10:14 jenkins_koha Project Koha_master build #879: FAILURE in 31 sec: http://jenkins.koha-community.org/job/Koha_master/879/ 10:18 gerundio hi, can anyone help me setup LDAP authentication in koha? 10:19 gerundio I've followed the available documentation but it seems I've reached an dead-end 10:19 mtompset Sadly, I have never done it, so I can't help. :( 10:20 gerundio thanks anyway mtompset 10:22 gerundio I'll wait until someone who does has time to reply :) 10:29 jenkins_koha Project Koha_master build #880: STILL FAILING in 31 sec: http://jenkins.koha-community.org/job/Koha_master/880/ 10:43 jenkins_koha Project Koha_master build #881: STILL FAILING in 9.8 sec: http://jenkins.koha-community.org/job/Koha_master/881/ 10:58 jenkins_koha Project Koha_master build #882: STILL FAILING in 9.8 sec: http://jenkins.koha-community.org/job/Koha_master/882/ 11:01 mtompset Poor, Jenkins. I think something about the build environment must have changed and broken the process. :( Of course, I could be wrong. 11:13 jenkins_koha Project Koha_master build #883: STILL FAILING in 8.9 sec: http://jenkins.koha-community.org/job/Koha_master/883/ 11:20 gerundio got another problem at hands 11:21 gerundio how can I set koha to send mails via a given SMTP server? 11:28 jenkins_koha Project Koha_master build #884: STILL FAILING in 8.6 sec: http://jenkins.koha-community.org/job/Koha_master/884/ 11:33 mtompset I have yet to succeed at configuring mail. :( Though, there was an interesting link to do it via gmail on the list a while back. 11:43 jenkins_koha Project Koha_master build #885: STILL FAILING in 8.3 sec: http://jenkins.koha-community.org/job/Koha_master/885/ 11:58 jenkins_koha Project Koha_master build #886: STILL FAILING in 9.2 sec: http://jenkins.koha-community.org/job/Koha_master/886/ 12:01 balin Hi. Started Playing with Koha. Have some conceptional issues: imported throug z3950 something from LOC and now it's not showing in the catalogue!? When exporting the entry shows up in the resulting marc text file ... confused. 12:13 jenkins_koha Project Koha_master build #887: STILL FAILING in 8.9 sec: http://jenkins.koha-community.org/job/Koha_master/887/ 12:18 nengard balin you probably don't have your search engine running 12:19 nengard you need to have the reindexer running so that you can find the records you've added 12:20 oleonard Hi #koha 12:20 nengard morning oleonard 12:20 balin nengard: Switchable on where 12:21 nengard it's a server thing 12:21 nengard which gets a bit out of my area of expertise 12:21 nengard you need to have the indexer running on a cron job 12:21 mtompset What does "ps aux | grep zebra" give you? 12:21 nengard ^^ 12:21 nengard :) 12:22 balin http://mibpaste.com/aYce3V 12:22 mtompset Okay, your zebra server is running. You did a packages-based install? 12:23 balin yes. 12:23 balin Debian 12:23 mtompset are you using UNIMARC or MARC21? 12:23 balin MARC21 12:24 mtompset I'm out of ideas. 12:24 mtompset Oh... how about "ps aux | grep cron"? 12:24 balin ps aux | grep cron root 1900 0.0 0.0 7596 808 pts/0 S+ 12:21 0:00 grep cron 12:24 mtompset If cron isn't running, the reindexer won't run. :) 12:24 mtompset That's all?! 12:24 mtompset The problem is your cron daemon isn't running. 12:25 slef first question? 12:25 wahanui "What are you trying to do?" "What is the goal?" or "What problem are you experiencing?" 12:25 slef second question? 12:25 wahanui it has been said that second question is "What is the exact error message?" 12:25 slef third question? 12:25 wahanui i heard third question was "What version of Koha are you using?" http://koha-community.org/faq/find-version-koha-running/ 12:25 slef fourth question? 12:25 wahanui it has been said that fourth question is "Are we there yet?" 12:25 mtompset slef: He's added records. 12:25 mtompset They aren't showing up in the search 12:25 mtompset He did a packages install on Debian. 12:26 slef mtompset: don't mind me. I was replying to email from Yesan Sellan 12:26 mtompset I don't know why cron wouldn't be running though. 12:26 mtompset Ah... yes, okay. :) 12:26 mtompset I believe cron is a service, so I think, "sudo service cron start" should work. 12:27 mtompset Then wait 5 minutes. 12:27 balin Ha! You put me on the right track ... ps aux | grep cron root 1900 0.0 0.0 7596 808 pts/0 S+ 12:21 0:00 grep cron --> so it's running ... 12:27 slef no, that's the grep 12:27 slef it's better to say "pgrep cron" 12:27 slef if it's running, it will return a number 12:27 slef if it is not, it will return nothing 12:27 slef if pgrep isn't installed, it will show an error :) 12:28 balin Right - me stupid. 12:28 slef dpkg -l '*cron*' 12:28 slef see if it's even installed 12:28 slef but I would expect the koha-common package to depend on it 12:28 slef but I've not checked that 12:28 jenkins_koha Project Koha_master build #888: STILL FAILING in 9.1 sec: http://jenkins.koha-community.org/job/Koha_master/888/ 12:28 balin BUT: You put me on the right track: this is a lxc install and does NOT have corn installed by default ... so triggering the cron script made the entry show up ... cron installed now, so I should be peachy (in this respect). 12:29 mtompset you'll know in 5 minuts. 12:29 mtompset you'll know in 5 minutes. 12:29 balin no. already know as I triggered the job cron-independently ... 12:29 mtompset Okay... glad to help. :) 12:29 mtompset Thanks for the improved answer, slef. :) 12:30 balin Where do I report bugs? deb's should be dependent on cron! 12:30 mtompset bugs? 12:30 wahanui i think bugs is found at http://bugs.koha-community.org. Please fix any bugs you find. :) or reporting them is helpful, too. 12:31 slef mtompset: no worries, pgrep and pkill are underknown tools. 12:33 * Oak waves 12:34 mtompset Greetings, Oak. Bonjour, reiveune et reiveune1?! 12:34 Oak hello mtompset. 12:34 Oak magnuse 12:34 Oak hello rangi 12:35 Oak Bonjour alex_a 12:35 alex_a Oak: coucou 12:43 jenkins_koha Project Koha_master build #889: STILL FAILING in 9.3 sec: http://jenkins.koha-community.org/job/Koha_master/889/ 12:54 * paul_p feel we will have a lot of jenkins builts that fail in the next hours, until rangi is awake :( 12:54 jcamins Good morning, #koha. 12:54 marcelr hi jcamins 12:54 oleonard Hi paul_p and jcamins 12:54 paul_p FATAL: hudson.plugins.git.GitSCM$4.<init>(Lhudson/plugins/git/GitSCM;Ljava/lang/String;Lhudson/model/BuildListener;Lhudson/EnvVars;Lhudson/plugins/git/Revision;Ljava/lang/String;Ljava/util/List;Ljava/lang/String;ILhudson/plugins/git/util/BuildData;Lhudson/FilePath;)V 12:54 paul_p java.lang.NoSuchMethodError: hudson.plugins.git.GitSCM$4.<init>(Lhudson/plugins/git/GitSCM;Ljava/lang/String;Lhudson/model/BuildListener;Lhudson/EnvVars;Lhudson/plugins/git/Revision;Ljava/lang/String;Ljava/util/List;Ljava/lang/String;ILhudson/plugins/git/util/BuildData;Lhudson/FilePath;)V 12:54 paul_p at hudson.plugins.git.GitSCM.checkout(GitSCM.java:1269) 12:54 paul_p at hudson.model.AbstractProject.checkout(AbstractProject.java:1308) 12:54 paul_p at hudson.model.AbstractBuild$AbstractBuildExecution.defaultCheckout(AbstractBuild.java:679) 12:54 paul_p at jenkins.scm.SCMCheckoutStrategy.checkout(SCMCheckoutStrategy.java:88) 12:54 paul_p at hudson.model.AbstractBuild$AbstractBuildExecution.run(AbstractBuild.java:584) 12:54 paul_p at hudson.model.Run.execute(Run.java:1516) 12:54 paul_p at hudson.model.FreeStyleBuild.run(FreeStyleBuild.java:46) 12:55 paul_p at hudson.model.ResourceController.execute(ResourceController.java:88) 12:55 paul_p at hudson.model.Executor.run(Executor.java:236) 12:55 jcamins Yikes. 12:55 paul_p :(((((((((((( 12:55 paul_p hi marcelr & jcamins & oleonard & others 12:55 marcelr hi paul_p oleonard 12:55 mtompset Greetings, jcamins paul_p and oleonard. 12:56 jcamins String freeze is going to be a bit late this month. 12:56 mtompset How so? 12:57 jcamins Instead of starting tonight it'll start tomorrow. 12:58 mtompset Oh, a bit delayed meant two or three days in my mind. One isn't so bad. :) 12:58 jcamins For two reasons. 1) I need gmcharlt's help so that I can push to git.k-c.org, and 2) I found a bunch of XSS vulnerabilities in Koha, and the string freeze is waiting until I determine that they won't affect strings. 12:58 jenkins_koha Project Koha_master build #890: STILL FAILING in 10 sec: http://jenkins.koha-community.org/job/Koha_master/890/ 12:59 paul_p jcamins = what are you talking about (string freeze) ? 12:59 paul_p jcamins are you talking to me ? 12:59 jcamins paul_p: 3.6.10. 13:00 paul_p ok, gotcha 13:00 jcamins It's my last release of 3.6.x, so the XSS vulnerabilities take priority over the planned string freeze date. 13:01 mtompset Does the same vunerabilities exist on 3.8.x and master? 13:01 jcamins Yes. 13:01 jcamins Patch forthcoming. 13:02 oleonard More template filter issues jcamins? 13:03 jcamins oleonard: yup. 13:04 * oleonard had a great fix pending approval for that... under HTML::Template::Pro :P 13:13 jenkins_koha Project Koha_master build #891: STILL FAILING in 10 sec: http://jenkins.koha-community.org/job/Koha_master/891/ 13:16 jcamins !jenkins pause 13:16 jenkins_koha jcamins did you mean me? Unknown command 'pause' 13:16 jenkins_koha Use '!jenkins help' to get help! 13:16 jcamins !jenkins help 13:16 jenkins_koha Available commands: 13:16 jenkins_koha abort <job> - specify which job to abort 13:16 jenkins_koha alias [<alias> [<command>]] - defines a new alias, deletes one or lists all existing aliases 13:16 jenkins_koha botsnack [<snack>] - om nom nom 13:16 jenkins_koha build <job> [now|<delay>[s|m|h]] [<parameterkey>=<value>]* - schedule a job build, with standard, custom or no quiet period 13:16 jenkins_koha cb - list jobs which are currently in progress 13:16 jenkins_koha comment <job> <build-#> <comment> - adds a description to a build 13:16 jenkins_koha currentlyBuilding - list jobs which are currently in progress 13:16 jenkins_koha h [<job>|-v <view>] - show the health of a specific job, jobs in a view or all jobs 13:16 jenkins_koha health [<job>|-v <view>] - show the health of a specific job, jobs in a view or all jobs 13:16 jenkins_koha jobs [<job>|-v <view>] - show the status of a specific job, jobs in a view or all jobs 13:16 jenkins_koha q - show the state of the build queue 13:16 jenkins_koha queue - show the state of the build queue 13:16 jenkins_koha s [<job>|-v <view>] - show the status of a specific job, jobs in a view or all jobs 13:16 jenkins_koha schedule <job> [now|<delay>[s|m|h]] [<parameterkey>=<value>]* - schedule a job build, with standard, custom or no quiet period 13:16 jenkins_koha status [<job>|-v <view>] - show the status of a specific job, jobs in a view or all jobs 13:16 jenkins_koha testresult [<job>|-v <view>] - show the test results of a specific job, jobs in a view or all jobs 13:16 jenkins_koha userstat <username> - prints information about a Jenkins user 13:25 gerundio mtompset, I was out for lunch just saw your answer regarding email configuration now 13:26 gerundio can you give the direct URL for the list archive were that topic is discussed? 13:26 mtompset Perhaps one of the folks that showed up recently have a better answer regarding configuring the mailing stuff. 13:27 gerundio ok, I'll just paste the question again 13:27 gerundio how can I set koha to send mails via a given SMTP server? 13:28 jcamins gerundio: you have to set up a mail server on the Koha machine that forwards through the mail server you're interested in forwarding through. 13:28 jcamins I prefer postfix for my mail. 13:28 jcamins Other people prefer exim. 13:28 jcamins I have never met anyone who preferred sendmail. ;) 13:28 gerundio that was the answer I was afraid :p 13:28 jenkins_koha Project Koha_master build #892: STILL FAILING in 9.2 sec: http://jenkins.koha-community.org/job/Koha_master/892/ 13:28 gerundio thanks anyway 13:29 gerundio postfix it is then 13:29 jcamins postfix? 13:29 wahanui postfix is probably found at https://help.ubuntu.com/community/Postfix (but you probably can skip the SASL stuff) or at http://www.postfix.org/documentation.html 13:29 jcamins ^^ that first link will have you ready to go in about ten minutes. 13:29 jcamins oleonard: you did opac-showmarc, right? 13:31 jcamins Oh, never mind. I figured it out. 13:31 gerundio jcamins, btw, do you know how to setup LDAP auth? 13:31 jcamins gerundio: no. 13:31 gerundio too bad 13:31 jcamins There was a blog post about that on ByWater's blog not long ago. 13:32 nengard http://bywatersolutions.com/2012/07/09/koha-ldap/ 13:32 nengard and/or http://bywatersolutions.com/2011/09/08/how-ldap-connections-work-in-koha-3-4/ 13:32 gerundio thanks 13:33 gerundio I found this one too http://bywatersolutions.com/2012/07/09/koha-ldap/ 13:33 oleonard jcamins: I didn't write opac-showmarc.pl, but I made the template work the way it does now 13:34 jcamins oleonard: I was getting weird XSLT errors, but I figured them out. 13:35 tcohen greetings mtompset 13:35 mtompset Greetings, tcohen. 13:36 tcohen been out for a week almost 13:36 tcohen how is #koha going? 13:37 mtompset Well, today a nasty build glitch developed in Jenkins. 13:37 jcamins tcohen: 3.6.10 will have a late string freeze. 13:37 tcohen hi jcamins, so we're not on string freeze yet 13:39 jcamins Nope. I expect I will announce the 3.6.x freeze tomorrow. 13:39 gerundio jcamins, I came to the same conclusion regading LDAP 13:40 jcamins gerundio: what conclusion? I haven't come to any conclusions about LDAP. 13:40 jcamins Well, I suppose I've concluded that I'd prefer not to use it. 13:40 gerundio the C4::Auth module assumes that binding is done with uid 13:40 gerundio in my case I think our LDAP server binds with user's CN 13:41 gerundio basically the post on Bywater solutions' blog states that for these cases: "(...) you should contact your closest developer to help you patch C4::Auth_with_ldap.pm to fit your situation." 13:41 jcamins Ah. 13:42 * jcamins recuses himself from this development, pleading blind hatred of C4::Auth* 13:43 gerundio I've already looked into that code last Friday :) 13:43 gerundio always a bad sign when we have to change source code like that 13:43 jenkins_koha Project Koha_master build #893: STILL FAILING in 11 sec: http://jenkins.koha-community.org/job/Koha_master/893/ 13:44 jcamins gerundio: why do you think I have a blind hatred of C4::Auth*? :P 13:44 gerundio I'm still going to look for a workaround 13:50 balin Something entirely different: How does one conceptually go about implementing a field like media type with defined terminology (hard cover, soft cover, boardbook, ...) ... ? 13:51 jcamins balin: you link a MARC field to an authorized value list. 13:52 jcamins balin: it's under "more constraints." 13:56 balin Ok. Will try that. Can those things be constraint by item type (may "Book" have a different authorized value list than "Music")? 13:58 jenkins_koha Project Koha_master build #894: STILL FAILING in 13 sec: http://jenkins.koha-community.org/job/Koha_master/894/ 14:01 tweetbot` [off] twitter: @ByWaterSolution: "Going to Internet Librarian? http://t.co/xWA5H0eF #kohails" 14:04 gerundio I have 2 languages available on the I18N/L10N preferences 14:05 gerundio I chose both for users to select which they want on the admin interface 14:05 gerundio but still I only see English a no language selector 14:05 gerundio I've logged out and back in and everything still remains unchanged 14:05 gerundio any idea? 14:15 jenkins_koha Project Koha_master build #895: STILL FAILING in 23 sec: http://jenkins.koha-community.org/job/Koha_master/895/ 14:27 rambutan does everybody else see those ping timeouts? What causes the disconnect, something on the oftc server or something on the client side? 14:28 jenkins_koha Project Koha_master build #896: STILL FAILING in 13 sec: http://jenkins.koha-community.org/job/Koha_master/896/ 14:29 jcamins rambutan: client side. You can tell because it was all of BibLibre. 14:43 jenkins_koha Project Koha_master build #897: STILL FAILING in 11 sec: http://jenkins.koha-community.org/job/Koha_master/897/ 14:44 jcamins !jenkins abort Koha_master 14:44 jenkins_koha jcamins: how do you intend to abort a build that isn't building? 14:44 jcamins !jenkins abort 497 14:44 jenkins_koha jcamins: unknown job '497' 14:44 jcamins !jenkins abort Koha_master/497 14:44 jenkins_koha jcamins: unknown job 'Koha_master/497' 14:44 jcamins !jenkins abort 897 14:44 jenkins_koha jcamins: unknown job '897' 14:44 mtompset Have a good day (24 hour period), #koha. 14:44 mtompset 898 now, perhaps, jcamins? 14:45 jcamins !jenkins abort 898 14:45 jenkins_koha jcamins: unknown job '898' 14:45 * jcamins shrugs. 14:46 nengard sam75 this might help: http://stackoverflow.com/questions/8348576/mysql-copy-value-of-field-in-one-column-to-another-field-in-the-same-column-of-t 14:46 nengard or easier http://lists.mysql.com/mysql/196038 14:48 nengard can anyone tell me how i should document the new search engine preference - is this still experimental? does it require changes on the server - or is it as simple as changing the preference and ta da! you have solr? 14:48 jcamins nengard: it is still highly experimental, and should not be used in production. 14:49 jcamins I know that much. 14:49 nengard okey dokey 14:49 nengard I'll add the preference to the manual with that IMPORTANT note 14:49 nengard and then we can expand upon it as things change 14:49 jcamins It requires that you install solr, and probably requires some configuration on that end, too. 14:54 jcamins nengard: you might want to note that if you _do_ enable it, authorities won't work at all. 14:54 nengard good to know 14:56 nengard next doc question - can someone show me how to use the 'field separator' in csv profiles? the rest I understand - but i need to see a sample of the field separate in a profile 14:56 jcamins I think you documented CSV profiles somewhere already. 14:56 nengard I did 14:57 nengard but not the field separator - not with an example 14:57 jcamins Ah. 14:57 nengard I'm looking at the manual :) 14:57 nengard I'm updating this section to make it clearer 14:57 jcamins Ah. 14:57 jcamins I only know what the manual says about CSV profiles. 14:57 nengard there are 2 new preferences that effect this section so I wanted to update the section first 14:57 nengard :) no prob 14:58 jenkins_koha Project Koha_master build #898: STILL FAILING in 8.5 sec: http://jenkins.koha-community.org/job/Koha_master/898/ 14:59 jcamins !jenkins q 14:59 jenkins_koha build queue is empty 14:59 jcamins !jenkins s 14:59 jenkins_koha status of all projects: 14:59 jenkins_koha 3_6_Packages: last build: 21 (1 mo 1 day ago): SUCCESS: http://jenkins.koha-community.org/job/3_6_Packages/21/ 14:59 jenkins_koha 3_8_packages: last build: 133 (1 day 6 hr ago): SUCCESS: http://jenkins.koha-community.org/job/3_8_packages/133/ 14:59 jenkins_koha Koha_3.2.x(disabled) : last build: 36 (10 mo ago): UNSTABLE: http://jenkins.koha-community.org/job/Koha_3.2.x/36/ 14:59 jenkins_koha Koha_3.4.x(disabled) : last build: 80 (7 mo 27 days ago): UNSTABLE: http://jenkins.koha-community.org/job/Koha_3.4.x/80/ 14:59 jenkins_koha Koha_3.6.x: last build: 59 (23 days ago): UNSTABLE: http://jenkins.koha-community.org/job/Koha_3.6.x/59/ 14:59 jenkins_koha Koha_3.8.x: last build: 203 (1 day 6 hr ago): SUCCESS: http://jenkins.koha-community.org/job/Koha_3.8.x/203/ 14:59 jenkins_koha Koha_Docs: last build: 207 (2 days 22 hr ago): FAILURE: http://jenkins.koha-community.org/job/Koha_Docs/207/ 14:59 jenkins_koha Koha_master: last build: 898 (25 sec ago): FAILURE: http://jenkins.koha-community.org/job/Koha_master/898/ 14:59 jenkins_koha Master_Packages: last build: 97 (2 days 16 hr ago): SUCCESS: http://jenkins.koha-community.org/job/Master_Packages/97/ 15:02 nengard I think I get it 15:08 gerundio I've downloaded the latest available translations files for pt-PT 15:08 gerundio is it normal for the source text to contain Norwegian strings? 15:11 jcamins Yes, that's from the NORMARC file. 15:13 jenkins_koha Project Koha_master build #899: STILL FAILING in 8.3 sec: http://jenkins.koha-community.org/job/Koha_master/899/ 15:21 tweetbot` [off] twitter: @ByWaterSolution: "Day 2 at the Annual NELA Conference. Come by and visit us at booth 204. #kohails #NELA" 15:28 jenkins_koha Project Koha_master build #900: STILL FAILING in 9.4 sec: http://jenkins.koha-community.org/job/Koha_master/900/ 15:33 nengard jcamins you signed off on bug 7986 - i'm trying to find where on the circulation page this option to export is and i don't see it ? what page and I looking on? and where do I look for the export option? 15:34 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7986 enhancement, P5 - low, ---, jonathan.druart, Pushed to Master , Export issues 15:34 nengard I looked at circ history on the patron record, the checkout tab and the details tab ? I'm not seeing it 15:34 jcamins When I tested it, it was right on the checkout tab. 15:35 oleonard "If at least one of both sysprefs (ExportRemoveFields and ExportWithCsvProfile) is filled, the export link is displayed" 15:35 oleonard Is that the case nengard? 15:35 nengard oh 15:35 nengard well duh 15:35 nengard :) 15:35 nengard trying agian 15:35 nengard trying again 15:36 nengard okay, I see it now - going to update those preferences to explain a bit more what they do - patch coming 15:36 jcamins This is weird. 15:36 jcamins Can anyone get an error message out of opac-export.pl by giving it invalid formats? 15:36 nengard does anyone know why the Tools tab was added to the preferences? 15:37 oleonard ? 15:37 nengard cgi-bin/koha/admin/preferences.pl?tab=tools 15:37 nengard it has one preference on it - and it's really just a circ preference, not a Tools preference 15:38 oleonard Yeah that doesn't seem useful 15:38 nengard okay i'm gonna update it 15:38 nengard along with the preference description 15:38 jcamins @marc 502 15:38 huginn jcamins: The designation of an academic dissertation or thesis and the institution to which it was presented. (A note that describes the relationship of a work to a dissertation or thesis is recorded in field 500). (Repeatable) [a,6,8] 15:43 jenkins_koha Project Koha_master build #901: STILL FAILING in 9.2 sec: http://jenkins.koha-community.org/job/Koha_master/901/ 15:46 mib_1zx3qr Hello - is there anyone around who has implemented CAS with Koha? 15:53 tweetbot` [off] twitter: @kohails: "#kohails Specify Due Date in Koha 3.4 http://t.co/VPpxuxgr" 15:58 jenkins_koha Project Koha_master build #902: STILL FAILING in 8.2 sec: http://jenkins.koha-community.org/job/Koha_master/902/ 16:09 jcamins Okay, the only remaining XSS vulnerabilities that I have identified are in the Javascript on opac-search.pl. 16:10 jcamins Unfortunately, I can't figure out how to solve them. 16:10 oleonard What's the issue? 16:10 wahanui i think the issue is the one described in bug 6997. 16:10 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6997 normal, PATCH-Sent (DO NOT USE), ---, jcamins, RESOLVED FIXED, koha-remove leaves system in inconsistent state if there is an error 16:13 oleonard wizzyrea: is Bug 8922 specific to 3.6.x? 16:13 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8922 minor, P5 - low, ---, gmcharlt, NEW , Can't sort Holds to Pull report on any field besides title 16:13 jenkins_koha Project Koha_master build #903: STILL FAILING in 9.6 sec: http://jenkins.koha-community.org/job/Koha_master/903/ 16:15 jcamins oleonard: I think the problem is that I don't understand how the vulnerability works. 16:15 * jcamins is trying to figure that out. 16:15 wizzyrea I have only observed it in 3.6 16:16 jcamins wizzyrea: in what version of 3.6 did it appear? 16:16 jcamins I'll revert whatever commit caused it. 16:19 * oleonard growls "You give da woid sugar and that commit sleeps with da fishes" 16:19 jcamins Hehe. 16:20 wizzyrea 3.6.4 16:20 wizzyrea lol. 16:20 jcamins It worked in 3.6.3? 16:20 jcamins Okay, that might be long enough ago that I can't just revert the commit. 16:20 wizzyrea i'm not sure, what I know is that it is currently not working on 3.6.4 16:22 jcamins So it's actually possible that the sorting never worked in 3.6.x. 16:22 wizzyrea yea, could be 16:23 wizzyrea there was a patch that fixed the sorting by title 16:23 drojf good evening #koha 16:23 wizzyrea hi :) 16:24 * drojf drowns in a flood of emails 16:24 drojf i've only been away for 3 days :/ 16:24 slef drojf: checked the wiki for vector logo? I think someone found a better one that we remade, in the end. I can upload ours and calyx's if you want them for some reason. 16:25 jcamins Okay, figured out the problem. 16:25 slef drojf: http://wiki.koha-community.org/wiki/The_Koha_Logo_:_Origins_and_Explanation 16:25 jcamins Do a search for "something';[javascript]" 16:25 drojf slef: there was a svg in the koha sources that will do i think 16:25 cait drojf: you have been away? 16:25 cait slef: I would like to see the others somewhere 16:25 slef drojf: hrm, the SVG is missing from that page. Could you link across to it, please? 16:26 drojf cait: looks like you missed me a lot :P 16:26 cait drojf: how do you figure? 16:26 drojf slef: will do later 16:26 slef cait: ok... it'll happen during the kohacon12 cleanup (ongoing... :-/ ) unless you need it for a particular date. 16:27 oleonard jcamins: Can you be more specific? 16:27 cait slef: no hurry - but I think it will be great to finally have one :) 16:28 jcamins oleonard: it allows you to inject Javascript. 16:28 jcamins I'm patching it. 16:28 jenkins_koha Project Koha_master build #904: STILL FAILING in 9.1 sec: http://jenkins.koha-community.org/job/Koha_master/904/ 16:29 jcamins I just couldn't find the XSS vulnerability before. 16:29 oleonard jcamins: Can you give an example of a search string with javascript that demonstrates the problem? 16:29 jcamins oleonard: I'm working on getting the javascript to actually work. 16:31 wizzyrea oh there's actually quite a bit wrong with that, now that I poke at it 16:32 jcamins Ooh, good news! 16:32 wahanui good news is it looks like it's running properly. 16:32 jcamins It looks like you can't run arbitrary javascript directly. 16:32 jcamins The worst you can do is cause a syntax error. 16:36 jcamins How serious is a syntax error? 16:36 wizzyrea it looks like someone intended to put a branch filter on this as well, but didn't get to it? 16:36 jcamins I'm thinking not that serious. 16:37 oleonard It does interrupt the parsing of the rest of the JavaScript for the page 16:37 jcamins oleonard: yeah, but the solution I have adds a new dependency, so I'm thinking the fix can be held for 3.8 and master. 16:38 gerundio I have 2 languages available on the I18N/L10N preferences 16:38 gerundio I chose both for users to select which they want on the admin interface 16:38 gerundio but still I only see English and no language selector 16:39 gerundio I've logged out and back in and everything still remains unchanged 16:39 wizzyrea the second question? 16:39 wahanui the second question is "What is the exact error message?" 16:39 gerundio any ideas? 16:39 wahanui any ideas are welcome :) 16:39 wizzyrea the third question 16:39 wahanui the third question is, like, "What version of Koha are you using?" http://koha-community.org/faq/find-version-koha-running/ 16:39 wizzyrea that's what I was looking for. 16:43 jenkins_koha Project Koha_master build #905: STILL FAILING in 9 sec: http://jenkins.koha-community.org/job/Koha_master/905/ 16:58 jenkins_koha Project Koha_master build #906: STILL FAILING in 8.8 sec: http://jenkins.koha-community.org/job/Koha_master/906/ 17:07 * magnuse waves 17:09 magnuse wassup, jenkins? failing in 9 seconds, eh? 17:09 oleonard jcamins: After Bug 8678, <img> tags are no longer self-closed, resulting in non-standard-compliant markup 17:09 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8678 major, P5 - low, ---, jcamins, Pushed to Master , XSLT stylesheets output XML, but HTML is needed 17:10 oleonard What non-standard-compliant markup was fixed by the bug? That weird Firefox one the multiple spans? 17:14 YoungPublicLibrarian Good morning everyone (or evening if you are in another part of the world...) 17:22 jcamins oleonard: the self-closed spans. 17:22 jcamins Yes. 17:26 oleonard I guess having the page work is a reasonable trade-off for making the template invalid :( 17:27 oleonard Not that we win any prize for validity 17:28 jcamins oleonard: it's possible there's an xhtml target, somewhere. 17:28 jenkins_koha Starting build #60 for job Koha_3.6.x (previous build: UNSTABLE -- last SUCCESS #58 1 mo 1 day ago) 17:28 jenkins_koha Starting build #204 for job Koha_3.8.x (previous build: SUCCESS) 17:29 jcamins But- I still haven't managed to push to 3.6.x. 17:31 YoungPublicLibrarian Anyone have a moment and is willing to take a look at a report and tell me what I screwed up on it? :/ 17:32 magnuse YoungPublicLibrarian: just ask - don't ask to ask :-) 17:33 YoungPublicLibrarian Lol, okay. The report is the one I'm posting now... 17:33 pastebot "YoungPublicLibrarian" at 127.0.0.1 pasted "SELECT b.surname, b.firstname," (12 lines) at http://paste.koha-community.org/232 17:33 gaetan_B bye 17:34 YoungPublicLibrarian Its a mash up of two different reports, so may have multiple problems because I don't have the greatest grasp of SQL... 17:41 koyauni hi guys, my Liberian asking for tag 805 for shelf number which is not seen in our koha, how can we get this to appear 17:43 slef isn't shelf number an item-level thing? 17:45 koyauni why it does not apear in our record 17:46 koyauni how do I make it apear 17:59 YoungPublicLibrarian So should I take the silence as no one having ideas for the report? lol 18:01 koyauni no one is here I guess 18:02 YoungPublicLibrarian lol, oh well. I will try again later in the day... 18:06 koyauni it is night here :) 18:06 koyauni Do you know how to add tag 805 to the system 18:12 YoungPublicLibrarian I don't unfortunately. I'm merely a circulation assistant at my library. I know nothing about cataloging or the programming of the Koha system... 18:15 koyauni it does not seams I can find any source on line 18:21 drojf koyauni: i would assume it is in the koha manual 18:23 YoungPublicLibrarian The people here are usually really great at helping. I think we just hit a time when everyone's busy or not one... 18:23 YoungPublicLibrarian *on 18:23 slef koyauni: you could change the stylesheet, you could change the Koha-MARC mapping, you could do it multiple ways. But it is hard to know what is the correct one for your situation. 18:24 slef YoungPublicLibrarian: what happens when you run that report? 18:25 slef YoungPublicLibrarian: you've an extra , after ni.date_due which might break it. 18:25 YoungPublicLibrarian Slef: Nothing, it returns no results at all. Just shows the report text above where the results would normally be... 18:26 slef YoungPublicLibrarian: if you have access to a mysql command-line, then testing the report there may give more informative errors. 18:26 cait if you can only test it in the reports interface you will not get the mysql errors 18:26 slef cait: is there any reason for that (security?), or just that no-one has coded an error display for the reports yet? 18:26 YoungPublicLibrarian Hmm...I'll look into getting a MySQL command-line program then 18:26 slef YoungPublicLibrarian: try removing that extra , first? 18:27 cait i am ont sure if there is a good reason, I don't know one 18:27 YoungPublicLibrarian Okay, one moment... 18:27 cait slef: maybe security, not sure 18:28 slef cait: but really, if someone evil has access to the reports creation interface, you're probably dead. 18:28 slef cait: yet another thing to ask some time :) 18:28 cait lol 18:28 cait I don't think it has to get that far 18:28 slef bbl 18:29 YoungPublicLibrarian okay, removing the "," didn't help... 18:29 rangi Morning 18:29 wahanui hmmm... Morning is a state of mind. or whenever the cat wants breakfast. 18:30 rambutan afternoon rangi 18:32 rangi Slef only reason is it's tricky to get useful error messages but definitely not impossible I'd sign off your patch :) 18:34 rangi I may have fixed Jenkins 18:34 rangi It got confused by git 18:35 magnuse rangi++ 18:36 rangi We'll see 18:37 rangi If anyone is using chromium 18:37 rangi There is a Jenkins notifier 18:39 YoungPublicLibrarian Does anyone know a good mysql command line tool that I could install on a USB stick to test my reports and see what errors they give? 18:41 cait hm 18:41 cait I think the problem is you don't have that kind of access to the server 18:41 oleonard Wouldn't that require that you have MySQL and your database installed on the memory stick YoungPublicLibrarian ? 18:41 libsysguy ^^ 18:41 cait and I can't think of a tool that will test for mysql errors without having a database to run it against 18:43 YoungPublicLibrarian I was actually wondering about those too, but was hoping they could be worked around. I just want something to be able to test the syntax on... 18:43 libsysguy what I would do is dump the db and import it on something else 18:43 libsysguy if you want to just test things on it 18:44 wizzyrea well plus, you'd have to have a database because without the tables and fields, how would your tool know what valid syntax even is? 18:44 YoungPublicLibrarian Libsysguy: Great idea, unfortunately I don't know how to do that and I doubt I have permissions to do that... 18:45 rangi I think that's the crux of your problem 18:45 rangi Your boss needs to give you permission 18:46 drojf the point where the reports module is not enough is when you have grown up to play with the real sql ;) 18:46 rangi Tech solutions to politics problems = mess 18:46 YoungPublicLibrarian yeah, i can't get permissions...I've already requested it a dozen times... 18:47 libsysguy what is your library YoungPublicLibrarian? 18:48 YoungPublicLibrarian Because of the politics involved I'd rather not say. The upper management of my library is very illiterate and already thinks I'm insubordinate because of how well I work with the computers... 18:48 drojf YoungPublicLibrarian: escalate your unsolvable reports to somebody who has permission until they give in? 18:49 jcamins [off] YoungPublicLibrarian: not to ask a stupid question, but at this point wouldn't it be better to just say "I don't know, I can't do any more than what I've already done"? 18:49 wizzyrea YoungPublicLibrarian: isn't that why they have a support company? 18:50 oleonard Using [off] allows your comment to be left out of the IRC log 18:50 jcamins [off] Has to go at the beginning. 18:50 libsysguy [off] this ^^ 18:50 rangi 2 weeks wizzyrea! 18:50 wizzyrea oh yes oh yes 18:50 wizzyrea last week at NEKLS 18:50 * libsysguy puts on his jealous eyes and looks at wizzyrea 18:51 * jcamins gives wizzyrea the same jealous look. 18:51 rangi We are rearranging level 7 18:51 * wizzyrea drowns in a sea of green 18:51 YoungPublicLibrarian Drojf: I've tried that, nothing happens until I pick up the slack again. We didn't send out Overdues for 6 weeks... Jcamins: I would love to do that, but then its grounds for termination... 18:51 oleonard @later tell gmcharlt If you can configure the wiki to allow it I can upload an svg version of the Koha logo 18:51 huginn oleonard: The operation succeeded. 18:51 wizzyrea oooo 18:51 rangi Not sure where you will end up, somewhere near me of Kathryn 18:52 wizzyrea it's all good :) 18:52 rangi And kristina will be on 7 too 18:52 wizzyrea WOOT. All of these people I like. :) 18:52 YoungPublicLibrarian Wizzyrea: We have a support company, but the library consortium is too cheap to let us use it unless its a huge emergency... 18:52 * oleonard cheers wizzyrea's exciting move even though he's jealous too 18:53 melia yay wizzyrea! :) 18:54 rangi Maybe you will be at media's old desk 18:54 rangi Hehe 18:54 wizzyrea hehe 18:54 jcamins rangi: is it full of CDs, DVDs, and VHSes now? :) 18:54 melia it was a good desk. in the corner, with a window. :) 18:54 rangi Actually telecom team are moving 18:54 drojf [off] YoungPublicLibrarian: that sounds like a weird place, sorry for your problems 18:54 rangi To 4 I think 18:55 YoungPublicLibrarian Drojf: Thanks for the thoughts...I've been meddling through okay. But the fines and fees notices have got me stumped... 18:55 rangi Lol 18:56 rangi Stupid autocorrect 18:56 rangi Melia knew what I meant 18:56 * jcamins did too. 18:56 melia yep :) 18:56 jcamins But it was too great an autocorrect error to leave uncommented-on. :) 18:56 oleonard Under what circumstances is bug 6976 fixed? 18:56 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6976 major, P1 - high, ---, colin.campbell, RESOLVED FIXED, User hold limit can be avoided by users in OPAC 18:57 rangi Ok my stop bbiab 18:57 oleonard I can go to the OPAC, select a whole page of search results, and place 20 holds on something which has a 5-hold limit 18:57 oleonard That is, 20 holds on DVDs when there is a 5-hold limit on DVDs 18:58 jcamins oleonard: I think that's the maxholds bug, and there's another for circ rules. 18:58 tweetbot` [off] twitter: @ByWaterSolution: "Nate taking a brake after a rush of customers. #NELA #kohails http://t.co/ipwcC6vY" 18:58 oleonard Isn't Bug 4045 the maxholds bug? 18:58 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4045 critical, P5 - low, ---, gmcharlt, In Discussion , No check for maximum number of allowed holds. 18:58 * wizzyrea wonders where he took the brake. 18:59 jcamins oleonard: oh, never mind, then. 19:01 drojf wizzyrea: he took it outside of the picture i think 19:01 magnuse hehe 19:04 oleonard This is America wizzyrea, we spell how we want. This is your last chance to enjoy it. 19:04 jcamins lol 19:05 cait lol 19:06 rangi back 19:06 wizzyrea ha. 19:18 nengard other than the tables that start with 'aq' - if i wanted to wipe out all acq data from my system and start fresh what tables do i have to clear? I dont' want to mess things up 19:20 rangi hey trea 19:20 trea hi rangi 19:21 tcohen hi rangi 19:22 rangi hi tcohen 19:29 rangi nengard: that should be it 19:29 nengard thanks rangi 19:30 tweetbot` [off] twitter: @ByWaterSolution: "Nate taking a "break" after a rush of awesome librarians visiting the booth!! #kohails #nela12 http://t.co/0pjXTS7w" 19:32 oleonard Either way, Nate looks very dapper 19:32 rangi he does dapper well 19:32 jenkins_koha Project Koha_3.8.x build #204: SUCCESS in 2 hr 3 min: http://jenkins.koha-community.org/job/Koha_3.8.x/204/ 19:32 rangi w00t 19:32 wizzyrea heyyyyy 19:32 wizzyrea good stuff! 19:33 cait yay :) 19:34 cjh morning ) 19:34 cjh did that build take 2 hours and 3 minutes? :o 19:34 gmcharlt oleonard: should be set up for you now 19:34 nengard rangi how do i drop those tables with all the links they have to other tables? 19:35 oleonard Thanks gmcharlt 19:35 nengard aqbooksellers and aqbaskets for example 19:35 nengard is there a - drop cause i know best clause? :) 19:35 jcamins gmcharlt: any chance you could add an SSH key for me? 19:35 jcamins Also, hello. 19:36 cjh nengard: if you use `DROP tablename CASCADE;` it will also delete any row in another table that references this one, is that what you want? 19:36 * wizzyrea waves enthusiastically to gmcharlt 19:36 nengard yes i think i do 19:36 cjh nengard: if the data is important, please back it up :) 19:36 nengard already backed up :) 19:37 rangi cjh: it got jammed, 3 builds running at once 19:37 cjh nengard++ 19:38 rangi bug 3652 19:38 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3652 critical, P1 - high, ---, oleonard, Needs Signoff , XSS vulnerabilities 19:38 magnuse again? :-) 19:39 gmcharlt jcamins: sure -- please try now 19:39 jcamins rangi: if you want to take a stab at the Javascript vulnerabilities, please be my guest. 19:39 rangi i was gonna ask cjh to do that 19:39 jcamins gmcharlt++ 19:40 jcamins Worked perfectly. 19:40 rangi i was gonna sign off the patches there, and then get cjh too try to fix the javascript one 19:40 rangi its in the logs eh? 19:41 jcamins What's in the logs? 19:41 jenkins_koha Project Koha_3.6.x build #60: STILL UNSTABLE in 2 hr 12 min: http://jenkins.koha-community.org/job/Koha_3.6.x/60/ 19:41 jcamins Still unstable? 19:41 wahanui unstable is sid 19:41 jenkins_koha Starting build #61 for job Koha_3.6.x (previous build: STILL UNSTABLE -- last SUCCESS #58 1 mo 1 day ago) 19:41 nengard cjh for some reason the booksellers just won't delet 19:41 nengard delete 19:41 jcamins How did it get unstable? 19:41 cjh nengard: are you getting an error message? 19:42 rangi jcamins: its a test failing because the db is in a master state, false positive 19:42 nengard checking now 19:42 jcamins Oh, okay. 19:42 nengard ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails 19:43 magnuse poor jenkins getting all confused 19:43 rangi jcamins: can you ping cjh in a pm and let him know where the js xss problem is 19:43 jcamins Will do. 19:43 cjh ty :) 19:57 rangi ahh smart fix for the opac-export jcamins 19:57 jcamins rangi: thanks. That was a tough one. 19:57 rangi that xss was a great example of how trying to save time typing, bites you in the ass 20:01 jcamins I suspect we'll have the same problem elsewhere, but I haven't found it yet. 20:01 cjh oh wow, in mysql CASCADE does nothing :( 20:02 rangi *nod* 20:03 nengard cjh i got it sorted out 20:03 nengard turned off warnings - it's my own local install so i wasn't too worried about bad practices :) 20:04 jcamins nengard: then you just have to make sure you get all the aq tables, since MySQL won't catch it for you. 20:04 nengard looks like i idid 20:04 oleonard rangi: Did you ponder how Bug 8917 could be made to work with OPACSearchForTitleIn? 20:05 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8917 enhancement, P5 - low, ---, oleonard, Needs Signoff , Track clicks to links external to Koha 20:05 cjh nengard: heh, what was the command you used? `set FOREIGN_KEY_CHECKS=0` ? 20:05 reiveune bye 20:05 rangi oleonard: nope 20:05 nengard yeah 20:05 jcamins oleonard: TT filter? 20:06 cjh awesome, glad you got it working. Sorry I wasnt more help, I know postgres better than mysql. 20:07 rangi oleonard: the feature is only for 856u (under xslt) and any links in the biblio or item in normal view.. ill do the xslt for normac and unimarc too when i figure it out 20:07 rangi so it does links in the biblio and the item 20:07 nengard no problem cjh, you got me pointed in the right direction 20:07 rangi the use case is to track the usage of catalogued electronic items 20:07 jenkins_koha Yippie, build fixed! 20:07 jenkins_koha Project Koha_master build #907: FIXED in 2 hr 53 min: http://jenkins.koha-community.org/job/Koha_master/907/ 20:08 rangi (it logs the biblionumber and itemnumber (if applicable)) 20:08 oleonard rangi, it sounds very useful. I was just curious about the other searches because that was the first external link that came to mind 20:08 rangi i guess it could be extended for other links 20:08 rangi *nod* 20:08 rangi it could track that too 20:08 rangi but not for the amount i quoted the client :-) 20:09 oleonard In fact it would be nice to have the feature NOW because we debating whether it's worth it to have MARC records in the catalog for our ebooks from OverDrive. 20:09 rangi oleonard: thats exactly the use case 20:09 rangi and external databases 20:09 rangi cataloguing them then you can see if ppl actually visit them 20:10 wizzyrea cataloging your databases is a cool idea 20:10 wizzyrea i kind of wonder if you can't get similar metrics from piwik or GA though? 20:10 wizzyrea don't they usually measure clickthroughs? 20:10 wizzyrea maybe harder to find. 20:11 jcamins wizzyrea: that's what I told Waylon to do- just use piwik. 20:11 jcamins He wanted scads of analytics. 20:12 wizzyrea seems silly to build analytics into koha 20:12 wizzyrea where there are such fab tools for that 20:13 oleonard See ya #koha 20:15 rangi no piwik cant track that 20:15 rangi what if i click on a link to the db from the results page 20:16 rangi it has no idea what biblionumber that link was from 20:16 rangi also piwik has opt out features 20:16 wizzyrea true 20:16 rangi which is great 20:17 rangi and it cant track link clicks without js either 20:17 rangi its a different beast, for a totally different use case 20:17 rangi maybe for what waylon wanted, but not for tracking usage of catalogued materials 20:21 wizzyrea right, makes sense like that 20:22 rangi also, piwik and GA get blocked by firewalls/proxies sometimes 20:22 rangi for an approximation, they are good tools 20:29 rangi coffee time 20:30 rambutan its always coffee time 20:38 jenkins_koha Project Koha_3.6.x build #61: STILL UNSTABLE in 57 min: http://jenkins.koha-community.org/job/Koha_3.6.x/61/ 20:38 jenkins_koha * meenakshi.r: Bug 6655 - Sorting order of serial issues in OPAC 20:38 jenkins_koha * elliott: Bug 8421 : Added a URI filter to encode a cardnumber for borrowers as to not break patronimage.pl 20:38 jenkins_koha * dcook: Bug 8455 - Check ins processed through "Check Out" tab of the Patron Record ignore Circulation System Preferences 20:38 jenkins_koha * veron: Bug 7628 - Required format is not enforced for Patron Categories 20:38 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6655 trivial, P5 - low, ---, meenakshi.r, RESOLVED FIXED, Sorting order of serial issues in OPAC 20:38 jenkins_koha * jonathan.druart: Bug 7628: Escape '+' characters for categorycode 20:38 jenkins_koha * mtompset: Bug 8172 - Missing dereference marker for buildQuery parameter in addbooks.pl Added a dereference to an array parameter of buildQuery. 20:38 jenkins_koha * fridolyn.somers: Bug 8576: Software error on authority edition when using merge 20:38 jenkins_koha * robin: Bug 8162: allow packages to work on Ubuntu Precise 20:38 jenkins_koha * kyle: Bug 8533 - Non-numeric cardnumbers screw up autoMemberNum 20:38 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8421 minor, P5 - low, ---, elliott, RESOLVED FIXED, patron images fail when barcode for patron has a + 20:38 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8455 normal, P5 - low, ---, dcook, RESOLVED FIXED, Check ins processed through "Check Out" tab of the Patron Record ignore Circulation System Preferences 20:38 jenkins_koha * robin: Bug 8646 - prevent the highlighter from going infinite loop 20:38 jenkins_koha * ruth: Bug 8012: default values for defaultSortField/defaultSortOrder NULL on install 20:38 jenkins_koha * mtompset: Bug 4064 - Uninitialized variable errors in opac-search.pl 20:38 jenkins_koha * robin: Bug 8594 - prevent the report system from breaking some subqueries 20:38 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7628 normal, P3, ---, veron, RESOLVED FIXED, Required format is not enforced for Patron Categories 20:38 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8172 major, P5 - low, ---, gmcharlt, RESOLVED FIXED, Missing dereference marker for buildQuery parameter in addbooks.pl 20:38 jenkins_koha * jcamins: Bug 8678: XSLT stylesheets output XML, but HTML is needed 20:38 jenkins_koha * melia: Bug 7143: Adding Kathryn Tyree to the history and About page. 20:38 jenkins_koha * mjr: Bug 7068 - autobarcode not working when duplicating patrons 20:38 jenkins_koha * robin: Bug 8716 - make the routing list reordering function work 20:38 jenkins_koha * oleonard: Bug 8677 - table overlapping to the right on holds waiting 20:38 jenkins_koha * mtompset: Bug 8339 - div id="login" should be id="login_controls" in header.inc 20:38 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8576 critical, P2, ---, fridolyn.somers, RESOLVED FIXED, Software error on authority edition when using merge 20:38 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8162 critical, P3, ---, robin, RESOLVED FIXED, packaging scripts create user incorrectly 20:38 jenkins_koha * oleonard: Bug 8730 - browse overlaying powered by 20:38 jenkins_koha * fridolyn.somers: Bug 8071: link between bib and authorities with the authid 20:38 jenkins_koha * jcamins: Bug 8447: Make sure we have enough subfields for broader_headings 20:38 jenkins_koha * colin.campbell: Bug 6976 Close loophole allowing borrowers extra holds via opac 20:39 jenkins_koha * jcamins: Bug 8743: ZOOM error when merging authority change to biblios 20:39 jenkins_koha * Paul Poulain: Bug 8743 follow-up, throw a more explanatory error message 20:39 jenkins_koha * fridolyn.somers: Bug 8705: Software error on help of main page 20:39 jenkins_koha * mtompset: Bug 8714 - Poorly ordered and triggers warning in marctagstructure.pl 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8533 minor, P5 - low, ---, koha-bugs, RESOLVED FIXED, Non-numeric cardnumbers screw up autoMemberNum 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8646 minor, P5 - low, ---, robin, RESOLVED FIXED, Certain search terms cause browser "script taking too long" error 20:39 jenkins_koha * fridolyn.somers: Bug 7690: hidelostitems not working in Normal Display 20:39 jenkins_koha * mtompset: Bug 8713 - Warning message triggered by clicking Keywords to MARC mapping 20:39 jenkins_koha * fridolyn.somers: Bug 8275: xml parsing error when the webservice GetPatronInfo/show_loans is called 20:39 jenkins_koha * Katrin.Fischer.83: Bug 3782: Remove broken z39.50 targets from sample files 20:39 jenkins_koha * nengard: Bug 8721: Fixes minor typo in AllowItemsOnHoldCheckout 20:39 jenkins_koha * fridolyn.somers: Bug 8702: System preferences search does not allow accented letters 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8012 trivial, P5 - low, ---, ruth, RESOLVED FIXED, defaultSortOrder and OPACdefaultSortOrder are set to "ascending" on install 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4064 normal, P5 - low, ---, mtompset, RESOLVED FIXED, Uninitialized variable errors in opac-search.pl 20:39 jenkins_koha * maxime.pelletier: Bug 8659 Remove and readd the inactive funds in javascript to make it work in all browsers 20:39 jenkins_koha * mtompset: Bug 8350: warning in logs when searching for nonexistent ISBN 20:39 jenkins_koha * jcamins: Bug 8744: Thesaurus in authorities should not lock fields 20:39 jenkins_koha * mtj: Bug 7589 - tinymce editor broken in .deb packages - in 'en' templates 20:39 jenkins_koha * veron: Bug 8810 - Opac: Cart should display branchname instead of branchcode 20:39 jenkins_koha * fridolyn.somers: Bug 8497: Strange behavior when modifying the timeout system preference 20:39 jenkins_koha * veron: Bug 8796 - patron cards not starting on designated card 20:39 jenkins_koha * oleonard: Bug 6037 [Follow-up] Invalid markup, missing breadcrumbs on Keyword to MARC Mapping page 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8594 normal, P5 - low, ---, robin, Pushed to Master , A report containing a subquery that has a 'limit' will have that limit stripped out 20:39 jenkins_koha * mtompset: Bug 8772 - Uninitialized variable triggers error log entry in smart_rules.pl 20:39 jenkins_koha * Chris Cormack: Bug 3652 : [SIGNED-OFF] [SECURITY] XSS vulnerability 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8678 major, P5 - low, ---, jcamins, Pushed to Master , XSLT stylesheets output XML, but HTML is needed 20:39 jenkins_koha * Chris Cormack: Bug 3652: XSS vulnerability in page numbering 20:39 jenkins_koha * Chris Cormack: Bug 3652 XSS vulnerability in facets 20:39 jenkins_koha * robin: Bug 8806 - [3.6.x] Update changelog for 3.6.5-3.6.9, dependencies. 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7143 trivial, P5 - low, ---, katrin.fischer, Passed QA , Bug for tracking changes to the about page 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7068 major, P5 - low, ---, mjr, RESOLVED FIXED, autobarcode not working when duplicating patrons 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8716 normal, P4, ---, robin, RESOLVED FIXED, Reordering of routing list entries doesn't work 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8677 minor, P5 - low, ---, oleonard, RESOLVED FIXED, table overlapping to the right on holds waiting 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8339 minor, P5 - low, ---, mtompset, RESOLVED FIXED, div id="login" should be id="login_controls" in header.inc 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8730 minor, P5 - low, ---, oleonard, RESOLVED FIXED, browse overlaying powered by 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8071 blocker, P1 - high, ---, fridolyn.somers, RESOLVED FIXED, link beween bib and authorities with the authid 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8447 critical, P1 - high, ---, gmcharlt, RESOLVED FIXED, can't save new records / indicator error 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6976 major, P1 - high, ---, colin.campbell, REOPENED , User hold limit can be avoided by users in OPAC 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8743 critical, P3, ---, jcamins, RESOLVED FIXED, ZOOM error when merging authority change to biblios 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8705 normal, P5 - low, ---, fridolyn.somers, RESOLVED FIXED, Software error on help of main page 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8714 trivial, P5 - low, ---, mtompset, RESOLVED FIXED, Poorly ordered and triggers warning in marctagstructure.pl 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7690 minor, P5 - low, ---, fridolyn.somers, RESOLVED FIXED, hidelostitems not working in Normal Display 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8713 trivial, P5 - low, ---, mtompset, RESOLVED FIXED, Warning message triggered by clicking keyword to marc mapping. 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8275 normal, P5 - low, ---, fridolyn.somers, RESOLVED FIXED, xml parsing error when the webservice GetPatronInfo/show_loans is called 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3782 normal, P5 - low, ---, katrin.fischer, RESOLVED FIXED, delivered z39.50 targets wrong for NY Public Library and NY University Library 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8721 minor, P5 - low, ---, nengard, Pushed to Stable , typo in AllowItemsOnHoldCheckout 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8702 normal, P5 - low, ---, fridolyn.somers, Pushed to Stable , System preferences search does not allow accented letters 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8659 normal, P5 - low, ---, pelletiermaxime, Pushed to Stable , Inactive funds in neworderempty not disabled in IE/Opera 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8350 normal, P5 - low, ---, mtompset, Pushed to Stable , Searching for a 10 or 13 digit string (with a number in it) that does not exist in one's catalog will fail to affect SQL statement correctly in C4::Breeding 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8744 normal, P5 - low, ---, jcamins, Pushed to Stable , Thesaurus in authorities should not lock fields 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7589 blocker, P1 - high, ---, robin, Pushed to Stable , tinymce editor broken in .deb packages - in 'en' templates 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8810 normal, P3, ---, veron, Pushed to Stable , Opac: Cart should display branchname instead of branchcode 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8497 critical, P5 - low, ---, fridolyn.somers, Pushed to Stable , Strange behavior when modifying the 'timeout' system preference. 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8796 normal, P5 - low, ---, veron, Pushed to Stable , patron cards not starting on designated card 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6037 normal, P5 - low, ---, oleonard, Pushed to Stable , Invalid markup, missing breadcrumbs on Keyword to MARC Mapping page 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8772 trivial, P5 - low, ---, mtompset, Pushed to Stable , Uninitialized variable triggers error log entry in smart_rules.pl 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3652 critical, P1 - high, ---, oleonard, Signed Off , XSS vulnerabilities 20:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8806 enhancement, P5 - low, ---, robin, Needs Signoff , Debian packaging updates 20:40 jcamins Sorry, folks. 20:40 jcamins 3.6.10 is a pretty big release. 20:40 jcamins It contains everything that would've been a candidate for 3.6.11, too. 20:42 rangi :) 20:46 maximep o_O 20:49 rangi jcamins: don't forget to string freeze 20:53 jcamins rangi: yeah, I'm announcing it once I'm sure I'm not breaking it again with additional XSS fixes. 20:53 jcamins I'm pretty sure I will not be. 20:55 rangi yeah 20:57 jcamins Lucky libsysguy. 20:58 libsysguy_phone_with_paychex heh yeah i know right :-/ 20:59 wizzyrea oof. 21:16 eythian @later tell tcohen most likely yes. 21:16 huginn eythian: The operation succeeded. 22:30 rangi bug 8890 really needs a sign off 22:30 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8890 blocker, P5 - low, ---, koha-bugs, Needs Signoff , Packages can't be built on master, db dependent test