Time  Nick           Message
00:04 mtj            everyone - please excuse my trolly email to koha-dev
00:15 BobB           why do you say that, mtj?  seems a good idea to me
00:17 mtj            i was being sarcastic :)
00:18 mtj            its a perfectly good idea, that some people will find offensive
00:21 BobB           :)
00:29 jcamins_away   [off] But why can't you just rewrite Koha in PSQL?
00:40 wizzyrea       the first page, download.k-c.org is managed by.... I think gmcharlt has a hand in that
00:41 wizzyrea       I might have a login technically, but I've long since forgotten/lost what it is
00:41 wizzyrea       plus I don't work at nekls anymore :)
00:41 wizzyrea       BUT the other, the k-c.org/download
00:41 wizzyrea       that I can fix
00:44 jcamins_away   I can edit the download.k-c.org page.
00:51 BobB           hi wizzyrea : welcome to the southern hemisphere :)
00:52 mtj            cool.. so after some +1's replies for my email on koha-dev, we are good to go
00:52 wizzyrea       cool, thanks bobb :)
00:52 wizzyrea       and thanks jcamins
00:53 mtj            you settling in ok, liz?
00:53 BobB           First day at Catalyst?  Enjoy!!
00:58 wizzyrea       so far so good - lots to do :)
00:58 wizzyrea       thanks, yep it's my first day here, pretty exciting.
01:05 wizzyrea       version control using git?
01:05 wahanui        version control using git is at http://wiki.koha-community.org/wiki/Version_Control_Using_Git
01:05 wizzyrea       thanks wahanui ;)
01:06 wizzyrea       I knew there was a reason I put all of those links in your memory
01:07 wizzyrea       mysql library?
01:07 wizzyrea       report library
01:07 wahanui        i guess report library is at http://wiki.koha-community.org/wiki/3.2_SQL_Reports_Library
01:10 rangi          mtj: the +1 offlist replies?
01:12 mtj            no, onlist replies please
01:13 rangi          yeah i just havent seen any
01:14 mtj            lol, yeap - me neither...
01:14 mtj            hey chris, start that ball rollin'
01:15 rangi          i thougth you said you got some?
01:16 mtj            no, i said we are good to go… *after* i get some
01:17 rangi          ah right
01:22 mtj            wizzyrea, is there a new person at NEKLS now, that handles kc.org/wordpress stuff
01:23 mtj            … that i should bug, instead of you
01:23 wizzyrea       no, I still handle that stuff
01:23 wizzyrea       :)
01:23 wizzyrea       (and that's totally ok and by design)
01:23 mtj            cool, good to hear
01:47 eythian        http://javadoc.bugaco.com/com/sun/java/swing/plaf/nimbus/InternalFrameInternalFrameTitlePaneInternalFrameTitlePaneMaximizeButtonPainter.html <-- java
01:47 wizzyrea       jcamins, when you have a minute we should chat about things you want to put in 3.6.(next)
03:08 wizzyrea       does anyone have a favorite screenshotting tool for linux?
03:09 eythian        wizzyrea: I press printscreen usually
03:09 eythian        although, gimp has a screenshotting function
03:09 wizzyrea       utilitarian :)
03:10 eythian        it's not something I do a lot of :)
03:11 eythian        you can use alt-printscreen if you want to be fancy ;)
03:11 wizzyrea       is there a known weirdness in the header of the intranet? I'll grant you I've not been looking much at koha for the last couple of weeks - but there used to be tabs up there?
03:11 wizzyrea       well 3 weeks
03:12 eythian        wizzyrea: tabs?
03:12 wahanui        tabs are different
03:12 wizzyrea       lol yea
03:12 eythian        also, "shutter" looks good for screenshots
03:12 wizzyrea       for check out, check in
03:12 wizzyrea       search patrons
03:12 eythian        ah
03:12 wizzyrea       under the search bar
03:13 eythian        make sure you do a force refresh, I've had old CSS stuck in cache before
03:13 wizzyrea       hrm noo it's not that
03:13 mtj            hmm, same bug for me wiz ?!
03:14 wizzyrea       !!
03:14 wizzyrea       phew, I thought I had lost my mind or done something strange
03:14 mtj            me wonky in chrome , but ok in safari
03:14 wizzyrea       mine is broken in firefox and chromium
03:15 mtj            ok in ff-osx for me
03:16 wizzyrea       this is ff-ubuntu
03:16 eythian        ah, it was clearly broken by someone using OSX! :)
03:16 mtj            meh, some refresh fixed it on chrome too
03:16 wizzyrea       hrmmm tjat
03:17 wizzyrea       is not working for me :/
03:17 eythian        are you getting 404s from any of the stylesheets?
03:17 mtj            whats a quick/dirty image-upload website?
03:17 eythian        imgur
03:18 jcamins_away   Is it a package install?
03:18 wizzyrea       yep
03:18 wizzyrea       package converted to dev
03:18 wizzyrea       following reed's instructions - I don't see any 404's let me double check
03:19 wizzyrea       TypeError: $("#header_search").tabs is not a function
03:19 jcamins_away   We just noticed problems with yui stylesheets.
03:19 jcamins_away   Okay, that's not it.
03:19 wizzyrea       AHA
03:19 eythian        also make sure that you don't have different versions of things, e.g. running package libs with git templates
03:19 wizzyrea       well I probably do have that
03:19 mtj            ta eythian++
03:20 mtj            wizzyrea, like that? -> http://imgur.com/x9Jlc
03:20 wizzyrea       no, mine is even a bit more silly than that
03:20 wizzyrea       1s
03:20 eythian        basically, if you miss a path either in the apache config, or in the koha-conf.xml, then you can get crazy things happening.
03:20 wizzyrea       k I'm going to double check my koha-conf
03:20 wizzyrea       bc I think I did not do much in there.
03:20 eythian        search for 'share'
03:20 eythian        that catches everything in there I think
03:20 wizzyrea       eythian++ thanks I will look for that
03:21 wizzyrea       and I will add that to the instructions on the wiki
03:21 * wizzyrea     pats wahanui
03:21 eythian        that wiki page is pretty old
03:21 wizzyrea       it needs a bit of help I think
03:22 jcamins_away   Wait, I'm confused.
03:22 jcamins_away   What did you do?
03:22 jcamins_away   And... why?
03:22 jcamins_away   Why not just use koha-perldeps?
03:23 wizzyrea       i converted a package install to a dev install
03:23 wizzyrea       no, that part is ok
03:23 wizzyrea       I think
03:23 jcamins_away   Right, koha-perldeps is a new package.
03:23 jcamins_away   eythian++ # for making it
03:23 wizzyrea       I've been away for a month I have some catching up to do :)
03:24 jcamins_away   I pushed it last week, I think.
03:25 wizzyrea       http://imgur.com/9mAh7
03:25 wizzyrea       is what mine looks like
03:25 jcamins_away   What version?
03:25 wizzyrea       TypeError: YAHOO.widget.DS_XHR is not a constructor is also a problem
03:25 wizzyrea       master
03:26 jcamins_away   Hmmm... could you confirm that?
03:26 wizzyrea       that looks like a path problem let me do some digging about
03:26 wizzyrea       so put that aside for now ;)
03:26 jcamins_away   I've seen that when checking out 3.6.x on an installation that previously had master running.
03:27 jcamins_away   On a Mac it requires _Alt_+refresh.
03:27 * wizzyrea     is on ubuntu now :)
03:27 wizzyrea       no more mac for me
03:27 jcamins_away   Ah.
03:29 wizzyrea       well that didn't change anything, but I will go back and look for more things that I possibly missed
03:29 jcamins_away   wizzyrea: I'll look at recent commits that need cherry-picking tomorrow.
03:30 wizzyrea       it's np - I'm not ready to start cherry-picking yet, I'm still at the talking phase atm
03:30 jcamins_away   :)
03:30 wizzyrea       bc you see I don't have a proper installation to work from yet :)
03:30 jcamins_away   Right.
03:32 eythian        jcamins_away: thing is, perldeps requires you to do a lot more, whereas starting from a complete install means you have to change a few paths and it works.
03:32 eythian        (usually)
03:33 rgbv           hi all
03:33 jcamins_away   eythian: I haven't tried koha-perldeps, I just read the debian/control file.
03:33 eythian        yeah, all it does is pull in the deps for you (which is useful)
03:33 eythian        however, koha-common will give you a working installation.
03:35 rgbv           we have run a report that has made mysql hog 99% of the cpu, any idea how I can stop it?
03:35 jcamins_away   rgbv: kill the query?
03:36 eythian        show processlist;
03:36 eythian        and then kill the query number
03:36 rgbv           so PID from top and then kill?
03:36 jcamins_away   No.
03:36 eythian        these are mysql commands
03:37 jcamins_away   In MySQL, run show processlist;
03:37 jcamins_away   Then kill querynumber;
03:37 jcamins_away   As root.
03:37 jcamins_away   (MySQL root)
03:37 eythian        I don't think you have to be root, you an also be the same user that's running the query (I'm somewhat sure)
03:38 jcamins_away   eythian: oh, right grant all privileges. Right. :)
03:38 * jcamins_away is kinda sleepy.
03:39 rgbv           the query number the Id  like 427347
03:39 rgbv           then kill 427347 at mysql prompt?
03:40 jcamins_away   eythian: BTW, http://git.cpbibliography.com/?p=koha.git;a=commit;h=0dc0745a3793d420ac6be1a6767803b308b46cb2
03:40 eythian        yeah
03:40 jcamins_away   rgbv: right.
03:40 eythian        jcamins_away: oh, good :)
03:41 jcamins_away   eythian: it doesn't entirely work at all.
03:41 eythian        oh, bad
03:42 jcamins_away   The Recommends field doesn't seem to show up in the packages I build.
03:43 eythian        do you have No-Recommends enabled on your apt config?
03:43 jcamins_away   Ummm...
03:43 eythian        (it isn't by default)
03:43 jcamins_away   I don't know? How would I find out?
03:44 eythian        $ cat apt.conf.d/90install-recommends
03:44 eythian        APT::Install-Recommends "0";
03:44 eythian        something like that
03:44 rgbv           Brilliant, Thanks you both :)
03:46 jcamins_away   eythian: the bug_9051 branch on git.cpbibliography.com has all my work on that.
03:47 eythian        OK. Maybe I'll grab it and take a look
03:47 wizzyrea       eythian: it was almost certainly the paths - i'm still getting that sorted but thanks for the gentle nudge in the right direction
03:47 jcamins_away   You should regenerate the control file, though.
03:47 eythian        yep
03:49 jcamins_away   eythian: the update-control scripts would require further refinement to make it work properly under Precise.
03:50 eythian        what's special about precise?
03:51 jcamins_away   Ubuntu redid the way Perl modules are packaged.
03:51 eythian        oh. that's a strange thing to do.
03:55 jcamins_away   Yeah. I added a couple of overrides, but I'll need to review all the packages or the koha packages won't install on any other OS version or flavor.
03:55 eythian        oh good. I'll have to figure out what they're doing there.
03:56 eythian        also, this affects building on precise, not deploying on it?
03:56 jcamins_away   Right.
03:56 jcamins_away   Precise has shim packages.
03:56 jcamins_away   Apparently.
03:56 eythian        ah.
03:57 jcamins_away   But I was unable to build packages at all without changing the libwww packages, and the results aren't installable on Squeeze.
03:57 eythian        how weird
03:58 eythian        I wonder what they're thinking
03:58 wizzyrea       alright friends, I'm outtie :)
03:58 eythian        I don't recall anything along those lines happening in debian
03:58 jcamins_away   I think they're not, most likely.
04:00 eythian        also, I build in wheezy a lot of the time, so would have noticed it there.
04:00 jcamins_away   Good night, wizzyrea. :)
04:01 eythian        too late, she's gone :)
04:10 eythian        http://youtu.be/LJvM3m2hVzo <-- this is an explanation of the current state of bugzilla
04:10 eythian        the Koha bugzilla that is
04:12 * eythian      doesn't have permissions to fix it :(
04:14 rangi          any ideas when it stopped?
04:14 eythian        recently, but not sure exactly
04:14 eythian        some time before 17:07
04:20 jcamins_away   Oh, right... when bugzilla is down I can't use it.
04:20 eythian        yeah, it's a common misconception that you actually can.
04:21 jcamins_away   Probably this is a hint that I shouldn't be bugzilla-ing anyway.
04:21 * jcamins_away heads to bed.
04:21 eythian        later
04:23 rangi          should be all back
04:23 eythian        jcamins_away: you can avoid bed now
04:26 rangi          Nov 12 03:48:54 li105-217 kernel: Out of memory: Kill process 29246 (mysqld) score 259 or sacrifice child
04:26 rangi          Nov 12 03:48:54 li105-217 kernel: Killed process 29246 (mysqld) total-vm:336088kB, anon-rss:80288kB, file-rss:0kB
04:26 rangi          that will do it
04:51 rangi          @wunder nzwn
04:51 huginn         rangi: The current temperature in Wellington, New Zealand is 12.0°C (5:00 PM NZDT on November 12, 2012). Conditions: Scattered Clouds. Humidity: 58%. Dew Point: 4.0°C. Pressure: 30.06 in 1018 hPa (Steady).
05:12 mtj            oooh, koha-plack start/stop script for the deb packages
05:12 mtj            -> http://www.generalthreat.com/2012/09/serving-the-koha-common-opac-with-plack/
05:13 eythian        http://wiki.koha-community.org/wiki/Building_Debian_Packages#Build_The_Packages <-- /me has finally updated the instructions to account for annoying (but sensible) changes in Debian.
05:18 mtj            woah, lots of gpg addition
05:18 mtj            additions
05:20 mtj            eythian++ awesome stuff
05:25 mtj            i think im finally gonna switch my dev koha over to plack (or starman?) today
05:26 mtj            i might as well kill *3* birds with one stone, after the successful mariadb switch
05:29 eythian        yeah, a while back they changed how pbuilder worked to make it more strict about checking certs
05:29 eythian        should make a koha-community signing key at some point so it's not using my personal one.
05:33 eythian        @wunder nzwn
05:33 huginn         eythian: The current temperature in Wellington, New Zealand is 12.0°C (6:00 PM NZDT on November 12, 2012). Conditions: Scattered Clouds. Humidity: 58%. Dew Point: 4.0°C. Pressure: 30.06 in 1018 hPa (Steady).
05:57 eythian        new packages from master published
05:57 mtj            hmm, did we/magnus forget to activate the gbsd tweets this time
06:15 magnuse        the tweets were rubbish last time, and i did not get around to figuring out why
06:15 magnuse        ...and kia ora #koha
06:16 francharb      hi #koha
06:16 magnuse        hiya francharb
06:16 * magnuse      takes the dogs out
06:30 rangi          magnuse: how much left of the bug weekend?
06:54 magnuse        rangi: short answer: depends on where you are :-)
06:55 rangi          :)
06:55 magnuse        according to http://www.timeanddate.com/worldclock/fixedtime.html?msg=Global+bug+squashing+day+2012-11-12+-+stop&iso=20121112T2355&p1=103 it ends at 11 pm on tuesday for you
06:56 magnuse        and 11 am on tuesday for me
06:56 cait           ah
06:56 rangi          righto
06:56 cait           that#s good
06:56 cait           so we still got time!
06:56 magnuse        yup
06:58 magnuse        http://div.libriotech.no/kohamisc/gbsd/gbsd11/hourlystatus-gbsd11.txt
06:59 cait           hm one major waiting for sign-off currently
07:00 rangi          yep
07:00 magnuse        which one?
07:00 wahanui        which one is 3.6.x?
07:00 magnuse        oog, good one wahanui
07:00 rangi          bug 8746
07:00 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8746 major, P5 - low, ---, julian.maurice, Needs Signoff , rebuild_zebra_sliced.sh don't work where Record length of 106041 is larger than the MARC spec allows
07:01 magnuse        @arewethereyet
07:01 huginn         magnuse: Not yet - wait 10 days
07:03 cait           hmm
07:03 cait           is it possible bugzilla doesn't let you sort by severity on saved searches? (by default?)
07:04 rangi          it depends how the person saved it
07:04 rangi          if they didnt save it with the severity column, then no, you have to click change columns
07:04 rangi          and add itt
07:04 rangi          then you can sort on it
07:05 * magnuse      looks for breakfast
07:05 cait           aah
07:05 cait           maybe that was the reason then
07:06 cait           thx :)
07:26 alex_a         bonjour
07:27 rangi          hi alex_a
07:56 sophie_m       hi#koha
07:58 magnuse        bonjour france
08:00 reiveune       hello
08:04 paul_p         good morning #koha
08:05 paul_p         rangi do you have seen France-Australie 2 days ago ? great match from froggies, aussies strangely poorly playing (was it because frenchies were really better ? not completly sure...)
08:15 magnuse        gah, lots of french strings in the nb-NO syspref translation
08:15 gaetan_B       hello
08:20 marcelr        hi #koha
08:21 wizzyrea       really ought to fix that. tomorrow.
08:24 * magnuse      waves to wizzyrea
08:25 wizzyrea       hi :)
08:25 magnuse        first day at work done?
08:26 wizzyrea       yep, first day of work for me, and first day of school for spud.
08:26 wizzyrea       well half day for him
08:27 magnuse        yay
08:27 magnuse        preschool?
08:28 wizzyrea       yep :)
08:39 drojf          good morning #koha
08:40 kf             hi drojf
08:40 kf             you are back too? :)
08:42 drojf          hi kf
08:42 drojf          not much koha-time ATM
08:49 magnuse        kia ora trea
08:49 magnuse        ...and kf and drojf
08:50 drojf          good morning magnuse
08:59 trea           hi magnuse
09:11 WaylonR        hiya all. wheres an example of a enhancement bug in bugs.koha-community.org?
09:12 magnuse        WaylonR: tried the advanced search?
09:13 kf             hi all
09:14 magnuse        [off] http://bugs.koha-community.org/bugzilla3/buglist.cgi?list_id=46117&bug_severity=enhancement&query_format=advanced&bug_status=NEW&bug_status=REOPENED&bug_status=ASSIGNED <-- for WaylonR
09:14 magnuse        it's... the return of kf!
09:14 kf             yay :)
09:15 magnuse        :-)
09:28 wizzyrea       squee! kf!
09:28 magnuse        hehe
09:34 magnuse        back to work after 3 weeks holiday - probably rather busy
09:42 kf             hi wizzyrea :)
09:42 kf             squeee! how was your first day?
09:42 wizzyrea       it went well :)
09:43 kf             :)
10:11 WaylonR        bug 9055:  The jQuery plugin and its associated assets need to go in koha-tmpl/opac-tmpl/lib/jquery/plugins .... does that mean that I put the js in there, and the css in a subdir inside plugins, images in a subdir?
10:11 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9055 enhancement, P5 - low, ---, wrobertson1981, ASSIGNED , Mandumah.com's multiple branch search, multiple branch security mod
10:11 WaylonR        or have it all in plugins?
10:12 kf             WaylonR: maybe talk to oleonard about that - I am not sure how they get added
10:13 magnuse        kf: mind if i add a patch for nb-NO to Bug 9020, after signing off your patch?
10:13 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9020 trivial, P5 - low, ---, katrin.fischer, Needs Signoff , Translate new permissions for 3.10
10:13 kf             magnuse: not add all
10:13 kf             that's why I kept the German out of hte subject I think :)
10:14 WaylonR        why oleonard, kf?
10:14 kf             because I think he knows about those things best :)
10:14 WaylonR        ah
10:14 WaylonR        hmm.
10:14 kf             he is looking after the gui in general
10:14 kf             and doing things like moving us to jquery ui
10:15 WaylonR        well.. i can always be told later, for now, ill just fix according to what i think jcamins wants... and yeah. Do something, even though i feel.. ah... wierd..
10:17 WaylonR        ah.. i need more monitors..
10:18 WaylonR        out of interest, how many monitors you use, kf?
10:19 kf             2 at work, one at home
10:19 * WaylonR      nods. "two here,ah.. was a time when i used three.
10:20 WaylonR        when i had 3.
10:33 WaylonR        okay, jcamins comment 1. solved.
10:34 WaylonR        database changes.. don't I need a update number for that? or .... do i just use next one in the sequence and if it goes into master, RM will change it accordingly?
10:35 kf             you make it say XXX
10:35 kf             just look at another patch with a database update
10:50 WaylonR        why am i updating sysprefs.sql when its largely irrelevant now, anyway?
10:51 WaylonR        just for the defaults?
11:04 magnuse        kf: your patch on bug 9020 is signed off
11:04 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9020 trivial, P5 - low, ---, katrin.fischer, Needs Signoff , Translate new permissions for 3.10
11:09 WaylonR2D2     haha
11:10 WaylonR2D2     okay, comment 3, halfdone.. moving on to the updatedatabase stanza.... time to find a database change patch, and see what it does.
11:10 WaylonR2D2     +$DBversion = "3.06.XX.XXX"; #FIXME
11:10 WaylonR2D2     ahhh!!!!!
11:17 Oak            kia ora #koha
11:17 Oak            magnuse
11:19 magnuse        Oak
11:19 magnuse        yay!
11:19 Oak            :)
11:32 WaylonR2D2     every new database insert, requires a new version?
11:33 kf             it increases the last part of the version number, yes
11:33 WaylonR2D2     (in updatedatabase)
11:33 WaylonR2D2     right.. so.. okay.. three updatedatabase stanzas for three new prefs.
11:33 kf             hm no
11:34 kf             you can do those in 1 version
11:34 kf             sorry, I might have misunderstood your question
11:34 kf             not for each insert, but for each update/feature
12:48 tcohen         morning #koha
12:50 drojf          hi tcohen
12:59 oleonard       Hi #koha
13:02 tcohen         hi oleonard
13:03 * oleonard     is sorry we didn't get the GBSD Twitter bot running for GBSW :(
13:09 kf             oh
13:23 jcamins_away   kf: that was the bug I fixed in the fishsoup branch.
13:27 * oleonard     wonders "Fishsoup branch?!"
13:27 jcamins_away   oleonard: git-bz.
13:27 drojf          oleonard: i did not dare to ask :)
13:28 kf             jcamins: hm checked out the latest version - and it didn't work there for me
13:28 kf             jcamins: maybe I need to do something else
13:29 jcamins        kf: Hm.
13:34 oleonard       Does anyone have a bug in the signoff queue that they'd like to lobby for?
13:35 drojf          omg free signoffs and i'm not prepared ;)
13:35 * drojf        wanders off
13:36 jcamins        oleonard: bug 4481
13:36 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4481 normal, PATCH-Sent (DO NOT USE), ---, koha.sekjal, Needs Signoff , Search's Limit to Available filters out many available items
13:36 kf             oleonard: I think anything marked bug and not enhancement would be great
13:36 kf             this one looks good
13:37 oleonard       No test plan :(
13:37 * oleonard     will try
13:41 oleonard       I always hope that during GBSD someone with a patch awaiting signoff will take the time to walk me (or anyone) through testing it, especially for the patches that are getting old
13:41 oleonard       Seems like a great opportunity to rescue patches from obsolescence
13:44 jcamins        More patches to push already.
13:44 jcamins        Oy.
13:46 oleonard       The non-enh list of needs-signoff is quite short, I didn't realize.
13:46 jcamins        oleonard: yeah, there are...
13:47 jcamins        14 patches for 3.10 that need signoff.
13:47 jcamins        Down from 16 on Friday, even though about a dozen were signed off.
13:47 jcamins        Sorry, guys.
13:48 jcamins        15.
13:48 jcamins        The typo one doesn't involve string changes.
13:58 jenkins_koha   Starting build #11 for job Koha_3.10.x (previous build: SUCCESS)
14:40 jenkins_koha   Project Koha_3.10.x build #11: SUCCESS in 42 min: http://jenkins.koha-community.org/job/Koha_3.10.x/11/
14:40 jenkins_koha   * magnus: Bug 8805 - Add a biblio-zebra-indexdefs.xsl for NORMARC
14:40 jenkins_koha   * mtompset: Bug 8784 - Missing files in debian.packages list
14:40 jenkins_koha   * jcamins: Bug 9005: Allow user to disable syspref cache
14:40 jenkins_koha   * dpavlin: Bug 8919 - ExtendedPatronAttributes not populated from LDAP
14:40 jenkins_koha   * oleonard: Bug 8989 - Availability facet needs an id
14:40 jenkins_koha   * jonathan.druart: Bug 8832: Update the gist pref and hide the tax rate value if not needed
14:40 jenkins_koha   * oleonard: Bug 8972 - Due Date set to 100 years ago
14:40 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8805 major, P5 - low, ---, magnus, Pushed to Master , Add a biblio-zebra-indexdefs.xsl for NORMARC
14:40 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8784 major, P5 - low, ---, mtompset, Pushed to Master , Missing files in debian.packages list
14:40 jenkins_koha   * oleonard: Bug 8972 - Due Date set to 100 years ago
14:40 jenkins_koha   * oleonard: Bug 8989 - Availability facet needs an id
14:40 jenkins_koha   * jcamins: Bug 8832: Increment version number
14:40 jenkins_koha   * serhijdubyk: Bug 9010 - Quote of the day: Umlauts do not display correctly Added utf8-encoding in json-header for correct view quotes in quotes editor.
14:40 jenkins_koha   * veron: Bug 9010 - Follou up Quote of the day: Umlauts do not display correctly
14:40 jenkins_koha   * oleonard: Bug 8931 [Follow-up] submit buttons have blue background
14:40 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9005 major, P5 - low, ---, jcamins, Pushed to Master , Changing sysprefs requires restart under Plack
14:40 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8919 critical, P1 - high, ---, dpavlin, Pushed to Master , ExtendedPatronAttributes not populated from LDAP
14:40 jenkins_koha   * fridolyn.somers: Bug 8988: item status uses authorized value description for intranet
14:40 jenkins_koha   * fridolyn.somers: Bug 7921: Software error while placing order
14:40 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8989 enhancement, P5 - low, ---, oleonard, Pushed to Master , Availability facet needs an id
14:40 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8832 critical, P5 - low, ---, jonathan.druart, Pushed to Master , can't enter a tax rate on vendor or when ordering
14:40 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8972 normal, P5 - low, ---, oleonard, Pushed to Master , Due Date set to 100 years ago.
14:40 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9010 blocker, P5 - low, ---, dubyk, Pushed to Master , Quote of the day: diacritics & other utf8 chars not displayed correctly
14:40 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8931 normal, P5 - low, ---, oleonard, Pushed to Master , submit buttons have blue background
14:40 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8988 minor, P5 - low, ---, fridolyn.somers, Pushed to Stable , item status uses authorized value description for intranet
14:40 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7921 major, P3, ---, fridolyn.somers, Pushed to Stable , Software error while placing order
14:42 magnuse        success! \o/
14:43 jcamins        Guess I ought to push some patches.
14:44 * magnuse      does not think anyone will be complaining :-)
14:45 * dracolin1    complains for no reason
14:46 jcamins        If any QAers are around, bug 9036 and bug 7119 are in need of attention.
14:46 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9036 normal, P5 - low, ---, cnighswonger, Signed Off , 00-load.t checks Koha::Cache::Memcached when it should not
14:46 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7119 enhancement, P5 - low, ---, paul.poulain, Signed Off , general code-cleaning, tidy/whitespace omnibus
14:55 * oleonard     wonders why Bug 7932 is so hard to fix
14:55 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7932 normal, P5 - low, ---, oleonard, ASSIGNED , twitter share doesn't work with socialnetworks
14:57 jcamins        bug 8435
14:57 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8435 enhancement, P5 - low, ---, jonathan.druart, Needs Signoff , new permissions on subscriptions "superserials"
15:10 huginn         New commit(s) kohagit: Merge branch 'bug_8915' into 3.12-master <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=bc9c8c4124e6fe61ce0b3afe3b2d37c00fc7268a> / Bug 8915: Followup FIX QA issues <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=58e1ea91a192ae73ab26607d1a73a00a1619f591> / Bug 8915 A script fixing missing MySQL contraints <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=0e8b11ac07febd883b95
15:13 jenkins_koha   Starting build #940 for job Koha_master (previous build: STILL UNSTABLE -- last SUCCESS #936 3 days 10 hr ago)
15:36 * chris_n      stops in for a moment
15:53 chris_n        LOL => "I have never written bad code. There are merely unanticipated features."
15:53 jcamins        chris_n: where did you see that?
15:53 chris_n        someone's perlmonks tag line
15:54 jcamins        lol
16:04 * kf           waves at chris_n
16:08 tweetbot`      [off] twitter: @kohails: "#kohails  Merging Bib Records in Koha 3.4 http://t.co/6O0Bblwp"
16:10 reiveune       bye
16:17 chris_n        heya kf
16:21 jenkins_koha   Yippie, build fixed!
16:21 jenkins_koha   Project Koha_master build #940: FIXED in 1 hr 8 min: http://jenkins.koha-community.org/job/Koha_master/940/
16:21 jenkins_koha   * jcamins: Bug 9053: Test::MockModule and DBD::Mock should be required
16:21 jenkins_koha   * f.demians: Bug 8915 A script fixing missing MySQL contraints
16:21 jenkins_koha   * jonathan.druart: Bug 8915: Followup FIX QA issues
16:21 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9053 critical, P5 - low, ---, jcamins, Pushed to Master , Test::MockModule and DBD::Mock should be required
16:21 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8915 normal, P5 - low, ---, frederic, Pushed to Master , Referential integrity constraints and InnoDB vs MyISAM storage engine
16:30 oleonard       If I add an item and fill in 952f, the data should appear in items.coded_location_qualifier?
16:31 jcamins        oleonard: yes.
16:33 oleonard       Weird, if I "select * from items where itemnumber = 11341" I see the information in coded_location_qualifier, but if I "select coded_location_qualifier from items where coded_location_qualifier IS NOT NULL;" I get nothing.
16:34 jcamins        oleonard: really?
16:34 jcamins        That's very strange.
16:35 * jcamins      did the former to test it.
16:35 jcamins        Didn't occur to me to try the latter.
16:37 oleonard       Oh wait I think I'm misreading the columns in my select *
16:37 oleonard       The data I put in 952f is in more_subfields_xml
16:38 jcamins        oleonard: really? It wasn't for me.
16:39 oleonard       what is coded_location_qualifier used for anyway?
16:39 jcamins        oleonard: no idea.
16:39 oleonard       Heh.
16:39 jcamins        However, prior to the patch you couldn't use it at all, period.
16:40 pastebot       "jcamins" at 127.0.0.1 pasted "oleonard: on current Master" (7 lines) at http://paste.koha-community.org/268
16:40 jcamins        That's what I get.
16:41 oleonard       did you have to manually update your framework to set up the link?
16:42 jcamins        No, it's in the default frameworks.
16:42 jcamins        That's why it's a bug.
16:43 oleonard       Must be a glitch with my default framework.
16:43 jcamins        Perhaps you customized your framework?
16:43 jcamins        I made no changes at all.
16:54 oleonard       Yeah who knows what abuses my default framework has suffered.
17:30 paul_p         jcamins_away = some patches just passed QA.
17:30 paul_p         time to go back home for me !
17:35 jcamins_away   paul_p: I'll push later.
17:37 oleonard       Hackfest, woooo!
17:37 * oleonard     goes to shake his piggy-bank
18:32 rangi          Morning
18:32 wahanui        Morning is a state of mind. or whenever the cat wants breakfast.
18:32 bag            morning rangi
18:36 cait           morning rangi
18:41 drojf          mariadb being a "drop-in replacement" means i install mariadb, it kicks out mysql and everything just works?
18:41 drojf          morning rangi
18:41 rangi          In theory yes
18:41 rangi          That's what are testing
18:42 bag            test faster ;)
18:42 bag            heh
18:43 drojf          cool, gotta try that sometime. more virtual machines ftw :D
18:44 rangi          So far it seems to work fine
18:44 rangi          The plan is to test now before we have to
18:46 rangi          Cos all of trust Oracle to do is screw stuff up.
18:46 rangi          It sure as hell won't get better on their watch
18:47 drojf          true
18:47 rangi          And it would be nice to test before we are forced to
18:47 gaetan_B       bye
18:49 bag            yeah no kidding those are good points rangi
18:53 rangi          Bbl off to do some training
18:54 cait           rangi: have fun :)
18:57 tweetbot`      [off] twitter: @ranginui: "Off to do some #kohails training, told the kids atarau says "daddy do you get to drive the train?" #slightlyinterestingworkstories"
18:57 tcohen         rangi, our DBA told me there is another mysql fork around
18:59 tcohen         'Percona'
18:59 jcamins_away   tcohen: Percona isn't quite a fork, as I understand it.
18:59 jcamins_away   I think you can use MariaDB + Percona.
19:00 rangi          theirs drizzle too
19:00 rangi          but maria is the only one designed to be a drop in, basically i want to test and make sure we have an option to switch if we need to
19:00 chris_n        for some reason I seem to recall MariaDB being the better choice
19:01 chris_n        what rangi said :)
19:01 * jcamins_away votes that we get all those working.
19:01 rangi          im not proposing people switch now, but its better to be prepared :)
19:01 chris_n        exactly
19:01 chris_n        oracle--
19:01 rangi          right now, i really need to prepare my training plan
19:01 tcohen         i'm reading that percona is the company that developed XtraDB
19:01 tcohen         the drop-in replacement for InnoDB that is included in MarizDB
19:02 tcohen         i guess their own fork is not community governed
19:02 jcamins_away   tcohen: yeah, Percona supports MariaDB too.
19:02 mtj            #moarning #koha
19:02 chris_n        heya mtj
19:03 tcohen         Drizzle seems to be a stripped version of MySQL
19:03 rangi          yep, its super fast
19:03 rangi          but a different goal
19:03 jcamins_away   Getting Koha working on Drizzle would be really cool.
19:03 rangi          so 2 parallels streams of work i can see, keep on the dbix::class (and ::schema)
19:04 rangi          meanwhile investigate a dropin for mysql if we have to use that
19:04 jcamins_away   rangi: go prepare your training plan, or no one will be driving the train!
19:04 tcohen         is it acid compliant at least?
19:04 rangi          (ie debian pull mysql)
19:04 rangi          tcohen: its designed to be more compliant than mysql
19:04 tcohen         (was talking about drizzle)
19:04 rangi          the drizzle team want to fix some of the design flaws
19:05 rangi          jcamins_away: printing now
19:06 jcamins_away   tcohen: yeah, Drizzle is intended to be ACID-compliant.
19:06 ibeardslee     .. postgresql?
19:06 jcamins_away   ibeardslee: once we have DBIx::Class.
19:06 * chris_n      ducks
19:07 chris_n        expecting mbalmer to appear any second now :)
19:07 ibeardslee     heh
19:07 tcohen         do libsysguy need more beer to work on DBIx::Class?
19:08 oleonard       biab
19:09 jcamins_away   tcohen: probably.
19:12 tcohen         jcamins_away: do u have pointers to a supported db engine list for dbix::class?
19:12 jcamins_away   tcohen: I do not.
19:13 jcamins_away   tcohen: "It has auto-increment support for SQLite, MySQL, PostgreSQL, Oracle, SQL Server and DB2 and is known to be used in production on at least the first four, and is fork- and thread-safe out of the box (although your DBD may not be).
19:14 tcohen         jcamins_away: sounds good
19:14 tcohen         there's  dbd::drizzle library
19:14 tcohen         i guess is just a matter of time
19:14 jcamins_away   And I think it just uses DBI internally, so any database with a mature DBD should work, I think.
19:15 rangi          yep
19:15 rangi          have now printed off all the notes :)
19:15 jcamins_away   But if we never get it working with MSSQL, don't expect me to be sad. :P
19:17 drojf          aaaw. what did MS ever do to you?
19:17 mtj            hmmm, it looks like my innodb tables are now ariadb tables, in mariadb
19:17 mtj            -> https://kb.askmonty.org/en/aria-faq/
19:18 mtj            aria being the default storage type in maria
19:18 mtj            TRANSACTIONAL= 0 or  1 , i am not sure…
19:19 mtj            https://kb.askmonty.org/en/aria-storage-engine/
19:20 jcamins_away   mtj: InnoDB uses transactions.
19:20 bag            heya mtj
19:20 bag            mtj?
19:20 wahanui        hmmm... mtj is a danger to bots everywhere.
19:20 bag            boooo boooooo boooooooooo
19:20 mtj            looks like aria is non-transactional by default, until enabled
19:21 jcamins_away   mtj: well that'd be something important to know.
19:21 * oleonard     wonders if his ability to connect to git is affected by the weather
19:21 * oleonard     adjusts the rabbit ears on his monitor
19:22 mtj            heya brendan
19:24 mtj            jcamins_away, i havent confirmed the above … still poking
19:28 oleonard       At least we're down to double digits: http://bugs.koha-community.org/cgi-bin/bug_status.pl
19:45 maximep        hey everyone. We juste updated 1 koha installation fromn 3.6 to 3.8 and with it, to DOM indexing
19:45 maximep        but it seems right now if I edit a biblio and do a misc/migration_tools/rebuild_zebra.pl -z -b -x
19:45 maximep        I get duplicate results when I search for that biblio
19:46 maximep        doing a /home/koha/kohagit/misc/migration_tools/rebuild_zebra.pl -b -r -v -x --where biblionumber=x
19:46 maximep        fixes it
19:46 jcamins_away   maximep: yes, rangi is going to put a big note about that in the release notes.
19:47 maximep        huh, ok :S
19:47 cait           jcamins_away: what is the solution? complete reindex? or do you have to do something else?
19:48 cait           oleonard++
19:48 jcamins_away   cait: complete reindex.
19:49 cait           ah ok, not too bad then
19:49 maximep        well we do a complete reindex every night
19:49 maximep        but still, duplicates for a day :/
19:49 jcamins_away   The only way to avoid it is not to ever install Koha 3.8.1-3.8.6.
19:49 maximep        we installed 3.8.5 -_-
19:50 maximep        so it's fixed in 3.8,7 ?
19:50 jcamins_away   Yes.
19:51 maximep        ok. Do you remember the bz number or something I could search ?
19:51 jcamins_away   @search dom
19:51 huginn         jcamins_away: There were no matching configuration variables.
19:51 jcamins_away   @query dom
19:51 huginn         jcamins_away: 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8802 minor, P4, ---, koha-bugs, NEW , Library group records - category type reverts to "searchdomain" when editing group record
19:51 huginn         jcamins_away: 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8507 enhancement, P5 - low, ---, koha-bugs, NEW , koha-create should be updated to use DOM indexing for bib
19:51 huginn         jcamins_away: 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8115 enhancement, P5 - low, ---, jcamins, ASSIGNED , DOM indexing configuration should compute totalissues from items.issues
19:51 huginn         jcamins_away: 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8252 critical, P5 - low, ---, paul.poulain, ASSIGNED , Error in DOM biblio for UNIMARC (no range for fields 1xx)
19:51 huginn         jcamins_away: 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8562 minor, P5 - low, ---, kyle, Needs Signoff , RandomizeHoldsQueueWeight ignored if StaticHoldsQueueWeight is empty.
19:52 cait           oh, we will get spared then I guess :)
19:52 maximep        only thing I found is bug 8665
19:52 jcamins_away   maximep: however, you should always reindex when doing an upgrade anyway.
19:52 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8665 critical, P5 - low, ---, jcamins, Pushed to Stable , DOM indexing fails to index some bib records
19:52 jcamins_away   That's the one.
19:53 jcamins_away   Always.
19:53 jcamins_away   There is absolutely no situation in which an upgrade should not be followed immediately by a reindex.
19:53 maximep        we do a -b -r -v -x every night
19:54 maximep        unless I have to really delete the index
19:54 jcamins_away   Yes, but indexes are not stable between versions of Koha.
19:54 jcamins_away   Period.
19:54 jcamins_away   rebuild_zebra -r will work fine.
19:54 maximep        well then it has to be something else :/
19:55 jcamins_away   So this problem occurred *after* rebuilding Zebra?
19:55 cait           oleonard: trying to reproduce bug 8614
19:55 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8614 minor, P5 - low, ---, oleonard, NEW , Icon for scores on OPAC detail page broken
19:56 maximep        yes, we updated 4 days ago
19:56 maximep        so at least 5 full rebuilds
19:57 cait           [off] oleonard: https://seminar-weingarten.bsz-bw.de/cgi-bin/koha/opac-detail.pl?biblionumber=7584 - now loading that on einto master :)
19:58 jcamins_away   maximep: and you haven't changed the 001?
19:59 mtj            maximep, so the dupes are still happening after a full-reindex?
20:00 maximep        good question... I may have changed the 001. Testing.
20:03 maximep        aaaaah you were right
20:03 maximep        yeah, it's the 001
20:03 maximep        changing it requires a full rebuild
20:04 jcamins_away   Between 3.8.1 and 3.8.6, yes.
20:04 maximep        ok, will apply your patch
20:04 maximep        thanks
20:04 maximep        jcamins++
20:07 jcamins_away   Okay, I switched to MariaDB.
20:08 jcamins_away   Other than a touchy bit where MySQL tried to reassert itself, it went completely smoothly.
20:09 maximep        MariaDB is really amazing =)
20:09 jcamins_away   maximep: you've used it?
20:10 maximep        we use it in a few projects, but I have not worked on those
20:28 chris_n        jcamins_away++
20:29 chris_n        are you really away? :-)
20:29 jcamins_away   chris_n: sort of.
20:39 oleonard       did something weird happen in 3.8.x when moving the famfamfam icons out of prog? I see three icons in opac-tmpl/lib/famfamfam and all the rest in opac-tmpl/prog/famfamfam
20:39 jcamins_away   Right, hit upon the NOT NULL issue you patched.
20:39 jcamins_away   oleonard: ummm...
20:40 * jcamins_away is going to have to go with "yes," cause that's really weird.
20:40 * cait         agrees it sounds weird
20:41 cait           oleonard: are you looking at the scores?
20:41 oleonard       Yes, this seems to be the cause
20:41 cait           oh cool - thx!
20:41 * cait         was still setting up a 3.8.x :)
20:44 oleonard       I gotta go, but I should be able to finish a patch tomorrow.
20:45 cait           oleonard: thank you :)
20:45 cait           have a nice evening
20:47 chris_n        jcamins_away: iirc MariaDB enforces stricter SQL syntax than MySQL
20:48 jcamins_away   chris_n: that's a good thing. :)
20:48 jcamins_away   And your patch almost applies.
20:48 chris_n        exactly
20:48 Guest5372      morning
20:48 chris_n        it sure does not look good for MySQL based on the homework mtj sent along to the list
20:48 chris_n        heya wizzyrea
20:48 wahanui        well, wizzyrea is a Cylon, and they all have plans.
20:50 cait           yay :)
20:50 cait           hi wizzyrea :)
20:51 jcamins_away   wizzyrea!
20:51 wahanui        well, wizzyrea is a Cylon, and they all have plans.
20:51 wizzyrea       jcamins!
20:51 wahanui        jcamins is too young to be the President of the United States.  Which is a pity, because he had the votes at the 3.12 election.
20:51 cait           wizzyrea: I am not sure I agree with you hving moved to another timezone, I was missing you this afternoon!
20:51 chris_n        well, upgrading from Koha 3.08.04.000 to 3.09.00.062 went largely without incident
20:51 wizzyrea       awwwwwwww
20:52 * jcamins_away is apparently a bit behind on the list of patches for 3.6.x.
20:52 wizzyrea       it's ok, I'm still working on sorting out my computer her
20:52 wizzyrea       here*
20:52 * wizzyrea     hates unfamiliar keyboards.
20:52 jcamins_away   wizzyrea: is your keyboard mushy?
20:52 * jcamins_away hates that.
20:53 wizzyrea       no, it's not mushy. But it is quiet
20:53 jcamins_away   Who wants to feel like they're typing in applesauce?
20:53 wizzyrea       mmm applesauce
20:53 mtj            chris_n, i imagine oracle's thinking was 'hey, those other guys are using our test-suite to make their software better - lets stop that'
20:53 chris_n        oops... spoke too soon
20:53 jcamins_away   chris_n: uh-oh?
20:53 chris_n        yup
20:53 chris_n        it blows up at 3.09.00.011
20:54 chris_n        om, I'll post the error
20:54 pastebot       "chris_n" at 127.0.0.1 pasted "Updating database structure Up" (18 lines) at http://paste.koha-community.org/269
20:54 chris_n        not sure what all is wrong
20:54 jcamins_away   I need a script that takes a version number and gives me the commit message for the patch responsible for the following line.
20:54 chris_n        the db I started with has zero customizations
20:55 chris_n        exactly
20:55 chris_n        mtj: probably so
20:55 jcamins_away   chris_n: a bugfix that was backported to 3.8.x?
20:55 jcamins_away   Probably nothing to worry about.
20:55 * chris_n      guesses updatedatabase is trying to due duplicate
20:56 chris_n        except that it prevents a full upgrade
20:56 jcamins_away   It prevents a full upgrade?
20:56 chris_n        which is a blocker if it is true bug
20:57 jcamins_away   Are you sure that updatedatabase didn't just time out at that point?
20:57 chris_n        can't get past 3.09.00.011 and on to 3.09.00.062
20:57 chris_n        perhaps
20:57 chris_n        I'll take a look tomorrow
20:57 jcamins_away   My guess is if you leave it running overnight, it'll be done by morning.
20:57 chris_n        web install won't let it run that long
20:58 chris_n        it dies instantly
20:58 jcamins_away   Oh.
20:58 jcamins_away   Uh... that's a problem.
21:01 eythian        hi
21:03 cait           hi eythian
21:04 drojf          hi eythian
21:05 cait           hey drojf
21:07 chris_n        the problem is the patch for 7951 made it into the latest 3.08
21:07 jcamins_away   bug 7951
21:07 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7951 normal, P5 - low, ---, koha.sekjal, RESOLVED FIXED, Suspending holds needs a system preference
21:07 chris_n        and updatedatabase tries to create the field again
21:07 chris_n        when it should check for existence and act accordingly
21:07 jcamins_away   But that shouldn't be a fatal error.
21:07 chris_n        badly behaved
21:07 chris_n        yes, one would think that
21:07 jcamins_away   Unless you have DEBUG set to 1.
21:07 chris_n        still digging
21:08 jcamins_away   Do you?
21:08 chris_n        ahh, I do as this is a dev box
21:08 chris_n        good catch
21:08 jcamins_away   :)
21:08 chris_n        what should happen is an offer to continue
21:08 jcamins_away   No, it should just keep going.
21:08 chris_n        rather than an outright death
21:09 chris_n        either way its a bugarooo
21:09 jcamins_away   Agreed.
21:09 chris_n        really updatedatabase should check for existence
21:09 jcamins_away   Agreed.
21:09 chris_n        that heads off a bunch of needless warnings, etc.
21:09 jcamins_away   And I prefer INSERT IGNORE for sysprefs.
21:09 jcamins_away   I should tell koha-devel that.
21:09 chris_n        *nod*
21:10 chris_n        and reject patches written otherwise :)
21:10 jcamins_away   Right.
21:11 * chris_n      brute forces it from the command line
21:12 chris_n        I'll fix it tomorrow
21:29 cait           jcamins_away: you should tell koha-devel that :P
21:29 jcamins_away   cait: yes, I will.
21:29 jcamins_away   Ooooh.
21:29 * jcamins_away has an inspiration.
21:30 jcamins_away   This really seems like a Quality thing.
21:30 jcamins_away   :P
21:31 jcamins_away   On the other hand, there is also an argument for me being the one to change all the INSERTs to INSERT IGNOREs... with INSERT IGNORE people signing off are less likely to spot errors.
21:32 * jcamins_away will have to consider this.
21:34 cait           jcamins_away:  :)
21:34 * cait         is busy filing minor acq bugs while configuring her new installation
21:34 rangi          its ansi compliant sql right?
21:35 rangi          afaik it isnt
21:35 jcamins_away   rangi: I believe so.
21:35 rangi          hmm you sure, im pretty sure its a mysqlism
21:35 jcamins_away   I thought it was INSERT UPDATE that was a MySQL extension.
21:35 jcamins_away   Nope. I'm not sure.
21:36 rangi          i may be misremembering
21:36 rangi          we'll need to check that
21:36 jcamins_away   The best option, of course, would be to use the add_syspref function.
21:36 rangi          if its ansi sql, then all good
21:36 rangi          yep
21:36 jcamins_away   Which I previously suggested and got shot down over for some reason.
21:36 jcamins_away   However, at that point I wasn't RM.
21:36 * jcamins_away rubs his hands together and cackles gleefully.
21:37 jcamins_away   On second thought, forget INSERT IGNORE.
21:37 jcamins_away   I am going to reject any INSERTs to the systempreferences table.
21:38 cait           i don't care really, as long as we avoid people wondering about red error messages :)
21:39 eythian        it would be nicer to avoid more of those "duplicate something something" messages.
21:39 eythian        they look a bit scary
21:39 jcamins_away   eythian: yeah, that's why I originally suggested using add_syspref.
21:40 eythian        yeah, it seems reasonable.
21:41 mtj            oh good news, my dev database is all innodb on maria, not aria
21:41 * jcamins_away heads home, where he will send an e-mail announcing the new syspref policy.
21:41 jcamins_away   mtj: XtraDB, actually.
21:41 mtj            yep, that too
22:08 drojf          mtj: what version of mariadb are you using? 5.5?
22:09 mtj            5.5.27-MariaDB-mariadb1~squeeze
22:10 drojf          thanks
22:19 eythian        wahanui: patch workflow?
22:19 wahanui        it has been said that patch workflow is at http://wiki.koha-community.org/wiki/Bug-enhancement-patch_Workflow
23:48 jcamins        Ugh.
23:48 jcamins        We need to find a better way to generate the help files, don't we?
23:58 wizzyrea       ^^
23:58 wizzyrea       yep