Time  Nick         Message
00:01 jenkins_koha Starting build #28 for job Koha_3.18.x_U14 (previous build: FIXED)
00:02 eythian      you can have it fetch the data, and see what's actually there before the error occurs
00:03 dcook        I guess I'm not good enough with the "s", "n", "r", etc to figure that out ;)
00:03 dcook        I just dumped the database into a dev instance and now doing pretty much just that
00:04 dcook        the marc being returned from Zebra definitely looks weird
00:04 dcook        I'm thinking maybe the directory in the leader is messed up
00:04 dcook        As it's not creating a good Marc::Record object at all
00:05 eythian      that's quite possible
00:07 dcook        Hmm, yeah, I'm thinking it's the leader
00:07 dcook        Possibly has a space instead of a zero in there..
00:08 dcook        Actually, that leader is all kinds of issues..
00:08 dcook        I wonder why Zebra itself seems happy..
00:08 dcook        It should be annoyed by that..
00:09 dcook        Unless I have it set to marcxml and then it might not..
00:14 dcook        So here's the leader that Zebra has "07040nnama220079554a4450"
00:14 dcook        and here's what gets output " 0153nnam a22003854a 4500"
00:14 dcook        All sorts of nastiness
00:15 dcook        Anyway, thanks for the support, eythian :)
00:15 dcook        I should've figured this one out sooner..
00:21 Francesca    hello #koha!
00:21 cait         hi Francesca
00:48 Francesca    rangi are you around?
00:48 rangi        sorta
00:49 jenkins_koha Yippee, build fixed!
00:49 wahanui      o/ '`'`'`'`'`'`'`'`'`
00:49 jenkins_koha Project Koha_3.18.x_D7 build #32: FIXED in 41 min: http://jenkins.koha-community.org/job/Koha_3.18.x_D7/32/
00:49 jenkins_koha * Frédéric Demians: Bug 13167 Stage MARC for Import hangs for biblio containing invalid ISBN-13
00:49 jenkins_koha * Tomas Cohen Arazi: Bug 13167: (QA followup) regression tests
00:49 jenkins_koha * Jonathan Druart: Bug 13504: Remove the '----' marker for CHECKIN and CHECKOUT notices
00:49 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13167 minor, P5 - low, ---, frederic, Pushed to Stable , Stage MARC for Import hangs for biblio containing valid 979* ISBN-13
00:49 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13504 normal, P5 - low, ---, jonathan.druart, Pushed to Stable , The marker '----' is not removed for CHECKIN and CHECKOUT
00:50 Francesca    rangi I've got some changes ready to be pulled on the day.tmpl page
00:50 rangi        2 secs ill pull it
00:51 Francesca    ok
00:52 rangi        try that
00:52 Francesca    well it kinda worked
00:52 Francesca    the nav showed up but look weird
00:53 Francesca    also I think I'm gonna need to change its position on the page
01:01 Francesca    ok theres a css rule stuffing up the menu on this page
01:02 Francesca    only problem is if I remove it, then the other page I was working on, index.tmpl has a menu stuff up
01:05 Francesca    rangi: I've pushed something up which should hopefully fix the menu issue
01:11 rangi        k
01:11 rangi        try that
01:12 Francesca    that works
01:13 Francesca    Do you want me to turn the mini-menu at the bottom of the page into an actual menu that matches the top one?
01:14 rangi        hmm
01:14 rangi        naw i think leave that as it is
01:15 Francesca    ok
01:16 Francesca    I'm gonna try and get the styling I did for the other page to apply to the body links, or I could just leave it as is. Thoughts?
01:16 rangi        i think leave the body as is
01:16 Francesca    ok
01:16 Francesca    that page is done then
01:16 rangi        sweet
01:17 Francesca    can I do another one? I'm quite enjoying all this coding
01:18 rangi        http://irc.koha-community.org/koha/ maybe
01:18 jcamins      Francesca++ # volunteering!
01:19 Francesca    sweet! I'll go find that file
01:20 eythian      I have stuff you can do, I'd much rather go read a book today :D
01:22 jcamins      eythian: anything good?
01:22 jcamins      I need a new book.
01:22 eythian      I just started the Discworld series from the start
01:22 jcamins      Preferably well-written YA.
01:22 cait         oh cool
01:22 cait         guards guards?
01:22 jcamins      I don't feel like I need to re-read Discworld.
01:22 jcamins      cait?
01:22 wahanui      i guess cait is regretting a bit that we didn't offer this as an option first... or on a test system for people to see
01:22 jcamins      cait?
01:22 wahanui      cait is from germany. Ask me about germany.
01:22 jcamins      cait?
01:22 wahanui      i think cait is happy about some example opacs :)
01:22 jcamins      cait?
01:22 wahanui      it has been said that cait is from germany. Ask me about germany.
01:22 jcamins      cait?
01:22 wahanui      cait is probably from germany. Ask me about germany.
01:22 cait         :P
01:23 jcamins      cait?
01:23 wahanui      somebody said cait was regretting a bit that we didn't offer this as an option first... or on a test system for people to see
01:23 jcamins      cait?
01:23 wahanui      hmmm... cait is just silly on a train again
01:23 jcamins      cait?
01:23 wahanui      cait is, like, from germany. Ask me about germany
01:23 cait         go to bed!
01:23 cait         is that what you are looking for?
01:23 jcamins      Yes.
01:23 eythian      cait: colour of magic
01:23 cait         we got a holiday tomorrow and i am an adult :)
01:23 cait         aaah
01:23 eythian      Guards! Guards! is #8
01:24 cait         oh wow
01:24 cait         thought it was earlier :)
01:27 eythian      ik heb "een hoed van lucht", ook. ik moet proberen dat.
01:28 eythian      last I tried it was a headache inducing effort, might be easier now.
01:31 dcook        Hmm
01:31 * dcook      tried reading "Guards! Guards!" but just couldn't get into it
01:31 dcook        Not bad... just..
01:34 Francesca    rangi: found the file and have pushed some changes up now
01:38 rangi        righto
01:39 Francesca    woah I think I've made things worse...
01:39 rangi        hmm yeah
01:40 Francesca    I'll try and fix it
01:40 Francesca    theres something really weird with the way those calenders line up
01:41 eythian      jcamins: why YA specifically?
01:42 jcamins      eythian: I like YA books.
01:42 eythian      fair enough
01:43 Francesca    jcamins: if you like YA books have you tried anything like Divergent?
01:44 jcamins      Francesca: ooh, I have not read anything by Veronica Roth!
01:44 jcamins      Thanks!
01:45 Francesca    its really good, I'd recommend it
01:46 dcook        Francesa: which faction would you have chosen? :p
01:46 * dcook      read the Divergent series a couple months ago as they were some of the only English books he could find in Greece
01:46 Francesca    ohhh I dont know, I'd probably end up divergent
01:47 dcook        Huh... I never thought of that
01:47 dcook        I always figured Erudite or Dauntless
01:47 dcook        Probably Erudite
01:47 Francesca    yeah I'd be Erudite or Abnegation and maybe Dauntless. But more likely divergent
01:48 cait         people here starto make no sense... guess i should go to sleep? :)
01:49 eythian      cait: no, that won't help
01:49 cait         hmpf
01:50 eythian      well actually, I'm fairly sleepy too, so maybe that is it. Resumed training after a couple month hiatus last night, and everything aching didn't make for an easy sleep.
01:51 dcook        hehe
01:51 * dcook      always finds training makes it easier to sleep
01:51 * dcook      is dead tired today though..
01:52 eythian      it does usually, but not when it's the first time in a while :) also, it was a warmish night and I couldn't cool down.
01:55 dcook        Ugh, that's the worst
01:55 dcook        I think the other night was my second time in a while, and I was unbelievably hungry. Sooo hungry.
01:55 dcook        Stopped for a snack and had to wait behind 4 people. I was not impressed :p.
01:55 eythian      you're in Australia, isn't that Oven Central right now?
01:55 dcook        Mmm
01:56 dcook        Yeah, pretty much
01:56 dcook        Should go to the gym again tonight but still just a wee bit sore from overdoing it last time..
01:57 Francesca    If I consider it hot here in wellington I can't even imagine how hot it must be in australia right now
01:57 dcook        @wunder syd
01:57 huginn       dcook: The current temperature in Bardwell Park, Sydney, New South Wales is 29.3°C (12:57 PM AEDT on January 06, 2015). Conditions: Scattered Clouds. Humidity: 58%. Dew Point: 20.0°C. Pressure: 30.09 in 1019 hPa (Falling).
01:57 dcook        Hmm, glad the AC is working here in the office..
01:59 Francesca    hey rangi just pushed some stuff up, hopefully this at least sorts out part of the problem
02:00 eythian      @wunder nzwn
02:00 huginn       eythian: The current temperature in Wellington, New Zealand is 17.0°C (2:30 PM NZDT on January 06, 2015). Conditions: Overcast. Humidity: 88%. Dew Point: 15.0°C. Pressure: 30.06 in 1018 hPa (Steady).
02:00 eythian      but it's been overcast all day
02:00 dcook        Oh wow...
02:00 dcook        That's just a bit of a difference, eh?
02:01 Francesca    the humidty explains the heat. But nowhere as bad as australia right now
02:01 eythian      also: not on fire
02:01 Francesca    that is a very good thing
02:01 rangi        Francesca: try that
02:01 Francesca    trying now
02:02 Francesca    well the first row sorted itself out
02:02 Francesca    everything else is still weird
02:03 Francesca    also a couple of calenders appear to be missing dates, they get cut off at the edge of the page
02:04 Francesca    at least the favicon works
02:56 Francesca    rangi if you're there, I've pushed some chnages up now
02:58 rangi        2 secs
02:59 rangi        try that
03:01 Francesca    annd now they overlap
03:01 rangi        yup
03:01 rangi        want me to revert?
03:01 Francesca    that didnt work as well as I was hoping
03:01 rangi        :)
03:03 Francesca    uhh I'm just trying something
03:03 Francesca    try that
03:03 rangi        hows that?
03:03 rangi        still overlapping but not as bad
03:04 Francesca    bigger margin then
03:04 Francesca    hold on
03:05 Francesca    ok try that
03:08 Francesca    that seems better
03:09 Francesca    but we've lost the edges again
03:10 Francesca    hold on I have the fix for that
03:11 rangi        k
03:13 Francesca    ok pushed it up
03:16 rangi        try that
03:17 Francesca    yus it worked
03:17 Francesca    thoughts?
03:18 rangi        looks ok to me
03:18 rangi        maybe we need people to try it on a few different browsers
03:18 Francesca    sweet
03:18 Francesca    I can check chrome
03:19 Francesca    looks good on chrome
03:19 Francesca    I'll just fix up the heading spacing and style the link, then I think its done
03:22 rangi        cool
03:22 rangi        ill be back in a bit
03:22 Francesca    ok. Theres stuff ready to pull when you're back
03:55 dcook        eythian++
03:55 dcook        It really is a good email :)
03:58 eythian      :)
03:59 rangi        @later tell Francesca pulled your changes
03:59 huginn       rangi: The operation succeeded.
07:24 Francesca    rangi you there?
07:41 reiveune     hello
07:43 ashimema     morning #koha
07:57 alex_a       bonjour
07:57 wahanui      bidet, alex_a
08:12 gaetan_B     hello
08:13 Francesca    night #koha
08:16 rangi        evening
08:16 rangi        night Francesca, did you see i pushed your latest changes?
08:17 Francesca    yeah thanks for that, that page is now complete. I'll start work on another one tomorrow if thats ok?
08:17 fridolin     hie all
08:17 rangi        sounds good to me
08:18 Francesca    sweet
08:18 fridolin     happy new year 2015
08:18 rangi        hi fridolin, gaetan_B, ashimema, reiveune and alex_a
08:18 reiveune     hi rangi
08:18 Francesca    happy new year fridolin
08:24 alex_a       hello rangi
08:27 Francesca    night all
08:27 wahanui      goodnight Francesca. You'll be back.
09:27 StarseekR    Good morning.
11:06 cait         mornign #koha
11:09 cait         or mor happy lunch time #koha
12:01 * cait       waves at Joubu
12:01 * Joubu      waves at cait
12:03 cait         Joubu: is $date = $dbh->quote($date); even needed?
12:04 Joubu        cait: I'd say yes
12:04 cait         $date_to_run is set
12:05 Joubu        cait: $date is used in the sql query
12:05 * cait       has to look at the full file
12:06 cait         but.... why did it work then?
12:06 Joubu        cait: but! That means the date format should be YYYY-*
12:08 Joubu        cait: I tried with 01/02/2015 and 2015-01-02. I don't understand why it works with the XX/XX/YYYY syntax
12:08 Joubu        cait: anyway, your patch makes sense!
12:08 Joubu        sorry for the confusion
12:09 cait         no it's alright
12:09 cait         you are right too about the $date being used in the sql
12:09 cait         wish that whole file was less confusing
12:10 AmitG        heya cait
12:10 cait         i think it means that days_overdue is not correct - but i am not sure what that's used for
12:10 cait         the CSV?
12:10 wahanui      i think the csv is generally better to start with than Excel.
12:23 cait         Joubu: shall we wait for rangi/fail it? or fix it?
13:08 Joubu        cait: sorry, quite busy... I will try to have a look again but there is certainly something wrong with the $date var.
13:08 cait         yah - i will move it to failed until we got it cleared up
13:09 cait         hope it's just this line, then we can move it back
13:19 * cait       hopes not to cause too much chaos today
13:42 oleonard     Hi #koha
13:43 cait         hi oleonard :)
13:50 oleonard     The scene today: http://zivotdesign.com/p/uploads/big/27a51191ba28eb59993f98112f44837a.jpg
13:54 ashimema     wow
13:54 ashimema     nice and snowy
13:54 oleonard     The first real snow of the year.
13:55 cait         our snow got rained away
13:55 oleonard     Two days ago it was 15°C
13:56 cait         oleonard: looks peaceful
13:58 akafred      Re: the mysql-issue mentioned yesterday. mysql 5.6.22 has stricter defaults than 5.6.21, which breaks Koha when adding biblios (and perhaps other places, too, we don't know). We're registering a bug on Koha. Seems people have run into this with mariadb before and worked around it by changing the mariadb-settings, (which seems a bit dodgy).
13:59 akafred      For now we have pinned our local setup to 5.6.21.
14:00 cait         thx akafred
14:00 cait         i will look outfor the bug report
14:44 ashimema     oleonard.. did you ever get around to re-testing bug 12904 after I posted my alternative patches?
14:44 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12904 enhancement, P5 - low, ---, kyle, Needs Signoff , Force browser to load new javascript files after upgrade
14:44 ashimema     I'de really like to see that bug moving again ;)
14:45 oleonard     I don't think I did ashimema. I'll put it on my list.
14:45 ashimema     :).. love you long time oleonard :)
15:17 cait         can i get a little hint?
15:18 cait         fixed a problem using C4::Dates->new($datefrom)->output('iso')
15:18 cait         copying the oslution from another similar page
15:18 cait         but i think we should not be using C4:Dates
15:18 cait         right?
16:00 fridolin     bye
16:18 gaetan_B     bye
16:41 gerundio     hi
16:41 gerundio     upgrading from 3.14.10 to 3.16.5 using packages I got the following errors: http://paste.koha-community.org/341
16:41 gerundio     any hints?
16:48 mtompset     Greetings, #koha.
16:48 mtompset     Who is responsible and/or able to regenerate the schema.koha-community.org?
16:48 mtompset     @seen cait
16:49 huginn       mtompset: cait was last seen in #koha 1 hour, 30 minutes, and 33 seconds ago: <cait> right?
16:49 cait         hi
16:49 cait         i think rangi might be running htat
16:49 mtompset     Greetings, cait. I just noticed your comments on 6874.
16:50 cait         hi gerundio - one sec
16:50 mtompset     So I thought to go look at the schema page, and misc_files isn't there. :)
16:50 cait         gerundio: bug 13443 - but not sure if that's good
16:50 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13443 enhancement, P5 - low, ---, gmcharlt, In Discussion , DBD::mysql::db do failed: Table 'koha_library.roadtype' doesn't exist
16:50 cait         the root of the problem is bug 7372
16:50 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7372 enhancement, P5 - low, ---, jonathan.druart, Pushed to Master , RoadTypes should be folded into Authorised Values
16:51 cait         it should be fixed with 3.16.6 if you can wait a bit longer
16:52 cait         mtompset: I was working from an updated database - had to update our documentation recently
16:52 cait         well... still working on it
16:52 cait         it shoudl be in your 3.18/master installation, also in kohastructure.sql
16:52 * mtompset   cringes hearing, "roadtype".
16:52 gerundio     cait, this also affects upgrades to 3.18.x, right?
16:53 mtompset     That cursed table gave me upgrade problems. :)
16:53 cait         i think 3.18 should be ok
16:53 cait         because tomas pushed the follow-up
16:54 cait         and we successfully updated a test installation from 3.12 to 3.18
16:55 gerundio     ok, I'll try upgrading to 3.18.x directly then and see how it goes
17:15 jenkins_koha Yippee, build fixed!
17:15 wahanui      o/ '`'`'`'`'`'`'`'`'`
17:15 jenkins_koha Project Koha_Master_U12_MariaDB build #209: FIXED in 1 hr 4 min: http://jenkins.koha-community.org/job/Koha_Master_U12_MariaDB/209/
17:15 jenkins_koha * Chris Cormack: Bug 1861: There is a problem introduced with an earlier patch, on this patchset
17:15 jenkins_koha * Jonathan Druart: Bug 1861: Add 1 test to AddMember
17:15 jenkins_koha * Chris Cormack: Bug 13502: Code introcduced in 1861 wrongly assumes a null userid is unique
17:15 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1861 normal, P4, ---, kyle, Pushed to Master , Unique patrons logins not (totally) enforced
17:15 jenkins_koha * Jonathan Druart: Bug 13502: Add tests to highlight the problem
17:15 jenkins_koha * Tomas Cohen Arazi: Bug 1861: (RM followup) DNIx updates
17:15 jenkins_koha * Marcel de Rooy: Bug 12823: Add some hints for Host and Database
17:15 jenkins_koha * Marcel de Rooy: Bug 12823: Alert about defining the SRU search field mappings
17:15 jenkins_koha * Jonathan Druart: Bug 12896: Move the bookseller-related code into Koha::Acquisition::Bookseller
17:15 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13502 normal, P5 - low, ---, koha-bugs, Pushed to Master , A bug was introduced by 1861 - meaning borrowers sometimes cant be added
17:15 jenkins_koha * Jonathan Druart: Bug 12896: Remove 2 occurrences in comments
17:15 jenkins_koha * Tomas Cohen Arazi: Bug 12896: (QA followup) use C4::Bookseller in t/db_dependent/Serials/Claims.t
17:15 jenkins_koha * Tomas Cohen Arazi: Bug 13167: (QA followup) regression tests
17:15 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12823 minor, P5 - low, ---, m.de.rooy, Pushed to Stable , Add some hints for Host, Database and SRU search fields mappings
17:15 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12896 normal, P5 - low, ---, jonathan.druart, Pushed to Master , Move the bookseller-related code into its own module
17:15 jenkins_koha * Frédéric Demians: Bug 13167 Stage MARC for Import hangs for biblio containing invalid ISBN-13
17:15 jenkins_koha * Jonathan Druart: Bug 13504: Remove the '----' marker for CHECKIN and CHECKOUT notices
17:15 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13167 minor, P5 - low, ---, frederic, Pushed to Stable , Stage MARC for Import hangs for biblio containing valid 979* ISBN-13
17:15 jenkins_koha * Katrin.Fischer.83@web.de: Bug 9124: Remove non-existing field mapping and auth value for 942$e
17:15 jenkins_koha * Katrin.Fischer.83@web.de: Bug 13495: Use "checked in" instead of "returned" in circulation
17:15 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13504 normal, P5 - low, ---, jonathan.druart, Pushed to Stable , The marker '----' is not removed for CHECKIN and CHECKOUT
17:15 jenkins_koha * Kyle M Hall: Bug 13495 [QA Followup] - Re-word "Renew or return" button as well
17:15 jenkins_koha * Tomas Cohen Arazi: Bug 13496: add a method for the templates to print Koha version as desired
17:15 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9124 normal, P5 - low, ---, katrin.fischer, Pushed to Master , 942e tied to undefined CN_EDITION in default MARC21 framework
17:15 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13495 minor, P5 - low, ---, katrin.fischer, Pushed to Master , Use "Checked in" instead of "Returned" in circulation
17:15 jenkins_koha * Tomas Cohen Arazi: Bug 13496: make auth.tt use a template plugin to get the Koha version
17:15 jenkins_koha * Owen Leonard: Bug 13119 - Use XSLT to display tagged titles in the OPAC
17:16 jenkins_koha * Katrin.Fischer.83@web.de: Bug 8909: MARC21 240$a (Uniform title) is not a URL
17:16 jenkins_koha * Jonathan Druart: Bug 13346: OpacExportOptions becomes multiple
17:16 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13496 enhancement, P5 - low, ---, tomascohen, Pushed to Master , Wrong Koha version on installer title
17:16 jenkins_koha * Tomas Cohen Arazi: Bug 13346: DBRev 3.19.00.004
17:16 jenkins_koha * Jonathan Druart: Bug 12969: Add a subroutine to calculate VAT and prices
17:16 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13119 enhancement, P5 - low, ---, oleonard, Pushed to Master , Use XSLT to display tagged titles in the OPAC
17:16 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8909 minor, P5 - low, ---, katrin.fischer, Pushed to Master , MARC21 240$a (Uniform title) is not a URL
17:16 jenkins_koha * Jonathan Druart: Bug 12969: Fix typo
17:16 jenkins_koha * Jonathan Druart: Bug 13379: Extends authorised_values.category to varchar(32)
17:16 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13346 enhancement, P5 - low, ---, jonathan.druart, Pushed to Master , The type of the OpacExportOptions pref should be multiple
17:16 jenkins_koha * Tomas Cohen Arazi: Bug 13379: DBRev 3.19.00.005
17:16 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12969 enhancement, P5 - low, ---, jonathan.druart, Pushed to Master , VAT and price calculation should be done in a subroutine
17:16 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13379 major, P5 - low, ---, jonathan.druart, Pushed to Master , authorised_values.category is varchar(16)
17:40 reiveune     bye
18:33 chris_n      6 years and ll still haunts us :-\
18:47 cait         chris_n: referring to the bug you commented on?
18:47 cait         sorry if my bug hunt stirs up ghosts
19:38 cait         chris_n: could you take a look at bug 8951 maybe?
19:38 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8951 enhancement, P4, ---, cnighswonger, NEW , Patron Card Creator_How many words for a text field
19:44 cait         oleonard: around still?
19:44 oleonard     Not for long
19:45 cait         do you remember bug 9099?
19:45 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9099 normal, P5 - low, ---, koha-bugs, NEW , Checked-in barcode export should not send empty file
19:45 cait         aah fond the feature, still valid
20:59 cait         eythian: bug 10517- still valid for master?
20:59 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10517 major, P5 - low, ---, koha-bugs, NEW , kohe-restore fails to create mysqluser@mysql_hostname so zebra update fails
21:00 rangi        hi tcohen
21:00 tcohen       hi rangi
21:00 cait         hi tcohen
21:43 chris_n      cait: I fixed bug 2635 long ago, in a galaxy far, far away
21:43 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2635 normal, P5 - low, ---, cnighswonger, NEW , Adding non-digit chars to cost fields in items causes data corruption
21:44 eythian      cait: yeah, I think so. I really don't think that it's major though.
21:44 cait         so downgrade it :)
21:45 chris_n      cait: I'll try to have a look at 8951 in the next week
21:46 cait         bug 8951
21:46 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8951 enhancement, P4, ---, cnighswonger, NEW , Patron Card Creator_How many words for a text field
21:46 cait         thx :)
21:46 cait         i am kind of trying to tidy up a bit today
21:46 chris_n      cait++
21:46 * chris_n    noticed the dust flying :-)
21:47 cait         heh :)
21:50 tcohen       we have a situation
21:50 tcohen       regarding Perl 5.20
21:51 tcohen       is anyone aware of any problem besides CGI and other dependencies being removed?
21:53 eythian      This is perl 5, version 20, subversion 1 (v5.20.1) built for x86_64-linux-gnu-thread-multi
21:53 eythian      I've not noticed anything
21:53 rangi        yeah me either
21:54 rangi        ive been running 5.20 on my laptop for months now, and have not noticed any issues with Koha
21:58 tcohen       did you have to install CGI by your own?
21:58 rangi        dont remember having to
21:58 tcohen       are you both on jesee?
21:58 rangi        nope
21:58 rangi        im on sid on my desktop
21:58 cait         bug 11229 - meh
21:58 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11229 normal, P5 - low, ---, koha-bugs, NEW , Payments wrongly saved in Statistics table by C4::Accounts::makepartialpayment and makepayment
21:58 rangi        utopic on my laptop
21:59 eythian      perl-modules: /usr/share/perl/5.20.1/CGI.pm
21:59 tcohen       we are struggling with UTF-8 regression tests that run fine up to 5.18 and fail on 5.20
22:00 rangi        what errors are you getting?
22:02 tcohen       bug 13264
22:02 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13264 enhancement, P5 - low, ---, z.tajoli, Needs Signoff , Test about UTF-8 (bug 11944)
22:03 tcohen       zeno explains what happens if we fix jonathan's problems (jessie)
22:03 tcohen       it looks like a double encoding problem
22:03 tcohen       when we fix it in 5.14 / 5.18 it breaks in 5.20
22:04 rangi        right
22:05 rangi        im suspecting then that these utf8 fixes will break in 5.20 then
22:05 tcohen       so, there's a change in how perl handles encodings, or something similar, and we are doomed
22:05 rangi        well not so much
22:05 tcohen       it fails without having applied the UTF-8 patches
22:06 rangi        yep
22:06 rangi        it just means those patches are probably not the right way to fix the utf8 issues
22:07 tcohen       ah
22:07 tcohen       that'd be correct, but this patches just create the boilerplate to full-stack test encoding issues
22:07 rangi        at least not if we want the fixes to work in the future
22:09 tcohen       rangi eythian: can you $ git bz apply 13264
22:09 rangi        perl 5.20 uses unicode 6.3
22:09 tcohen       and run $ KOHA_USER=kohaadmin KOHA_PASS=katikoan KOHA_INTRANET_URL=http://koha-dev.biblioadmin KOHA_OPAC_URL=http://koha-dev.biblio prove -v t/db_dependent/www/search_utf8.t
22:09 tcohen       with your own urls?
22:11 eythian      k
22:11 tcohen       Joubu is our 5.20 tester
22:12 tcohen       eythian: it is a bit slow, it sleeps 10 sec to let the indexer process the sample data
22:12 david        Hi
22:13 eythian      oh. I don't have the zebra indexing set up, does it need that?
22:13 david        We are having a problem with our biblios being skipped one upgrade
22:13 tcohen       it creates all the needed stuff
22:14 david        We upgraded to Koha 3.18.2. Our search was down so we added those four lines that we saw on the troubleshooting area. Are searching is now working but we are getting no titles. Our catalog and you showing no titles.
22:15 david        Our patron records are fine
22:16 eythian      david: what do you mean by "those four lines"? Also, how have you installed Koha (packages, tarball, etc)?
22:16 david        Can anyone help us please? We are desperate and not sure what is happening.. We did notice that when we did the rebuild biblios was not included. BiblioS was skipped
22:17 david        We used packages.
22:17 eythian      OK. But what four lines are you referring to?
22:17 cait         can you paste the lines you added to the koha-conf.xml?
22:18 david        The four lines were found on troubleshooting - googke search for biblios not found after reindexing.  It appears to be a common problem with the last release. I can send a link if you want
22:18 rangi        and exactly how you are you reindexing?
22:18 eythian      please do, otherwise we can't know what you're meaning.
22:18 david        Yes stand by
22:20 eythian      and you say that biblios were skipped, what command did you run and what did it say?
22:20 eythian      tcohen: this may take me a minute, I didn't have a database set up for master.
22:21 david        Here is the link to error and four lines to fix:
22:22 david        https://www.marshut.net/ktshsn/search-biblios-not-found-after-reindexing.html
22:23 david        The command was Koha-rebuild-zebra -v -f library
22:24 david        the four line fix is in the link I provided but it would not allow me to cut in paste. sorry
22:24 rangi        and what exactly is the line you added for
22:24 rangi        <zebra_lockdir>/var/lock/koha/__KOHASITE__</zebra_lockdir>
22:24 rangi        you did change __KOHASITE__
22:24 rangi        to a real thing eh?
22:25 rangi        if your instance name is library it should be
22:25 rangi        <zebra_lockdir>/var/lock/koha/library</zebra_lockdir>
22:25 david        Rangi you may have found the problem. We did not change that.
22:26 rangi        it might not be, but it's certainly a problem
22:26 david        I believe we should change that to our name which is simply library
22:26 eythian      you still haven't told us what actually happens when it doesn't work though, so we can't tell for sure.
22:28 rangi        tcohen: running it now
22:29 * dcook      was wondering if the upgrade script took care of automatically changing people over to DOM indexing... guess not
22:30 david        Url coming so you can see errors
22:30 dcook        You can also use this: http://paste.koha-community.org/
22:31 dcook        david ^
22:32 david        http://disneykoha.cloudapp.net
22:32 david        Try any search and you will get thousands of no title
22:33 david        Thanks all for any help
22:34 rangi        tcohen: tests 27 and 59 fail (2 out of 64 fail)
22:34 rangi        david: thats because there are no biblionumbers
22:34 david        eythian did that url help?
22:34 rangi        where did you used to store your biblionumbers 999$c
22:34 dcook        rangi: Yeah I've had that happen before... probably just needs a re-index
22:35 rangi        dcook: or the bib numbers are in the wrong place old koha sometimes have in 090
22:35 tcohen       rangi, yes, that's the symptom
22:35 eythian      david: somewhat. Do you get any errors when you do a koha-rebuild-zebra?
22:35 dcook        rangi: Could be. I've had this happen on systems where it was in 999$c and 999$d though
22:35 * dcook      would definitely be more interested in output from koha-rebuild-zebra or rebuild_zebra.pl
22:36 rangi        dcook: not rebuild_zebra.pl
22:36 rangi        never ever run that on a package install
22:36 dcook        rangi: You can't do that with packages?
22:36 david        E. It runs but skips biblios
22:36 rangi        you'll mess up all your permissions
22:36 rangi        use koha-rebuild-zebra
22:36 dcook        rangi: Ahh, right, I guess so.
22:36 eythian      david: you need to copy-past to us exactly what you see.
22:36 david        999$c. Not sure
22:37 eythian      (using paste.koha-community.org)
22:37 rangi        tcohen: did that help?
22:37 tcohen       i'm sure 5.20 is the problem, and not Jonathan's setup :-P
22:37 david        sorry working of cel phone. Cannot paste can we email?
22:37 tcohen       what should we do?
22:38 david        our helpdesk would not allow us to put the IRC chat on our company workstations I'm working off my cell phone. Sorry guys
22:38 eythian      david: ah
22:38 eythian      that will make things harder.
22:38 dcook        What about the web IRC chat?
22:38 eythian      david: there is a web chat client, that might be easier.
22:39 rangi        tcohen: need to read up on the changes to unicode in 5.20 (the major one is it now supports unicode 6.3) and check if the Encode modules have changed too
22:39 tcohen       we need to suppose so
22:39 david        thanks - what is web url?
22:39 tcohen       should we put the tests on hold?
22:39 tcohen       until we make them run on 5.20?
22:40 tcohen       it that was not the case, I'd push the UTF-8 patches right away
22:40 rangi        thats up to you, what i would probably want to do
22:40 eythian      http://koha-community.org/get-involved/irc/ <-- david
22:40 rangi        is apply the utf8 patches and actually test koha
22:40 rangi        not just the unit tests
22:40 rangi        in 5.20
22:41 rangi        and if its not hideously broken
22:41 tcohen       the patches have been consistently tested by people, I think the only one on 5.20 was jonathan
22:41 rangi        then id probably push them for the next release, with a note that they break things in 5.20
22:41 rangi        because someone will definitely install koha on utopic
22:42 tcohen       the patches are not the problem (11944) but the tests
22:42 rangi        are we sure of that?
22:42 david        Eythian. Thanks for url - gave to developer.
22:43 tcohen       my guess is that as the tests follow what we know about how to deal with unicode, we might have some other glitches to deal with
22:43 Francesca    hello #koha
22:43 rangi        tcohen: if we have had people testing running koha under 5.20 with those patches then thats fine, i think id probably want to test that a bit first
22:44 david        he is rebuilding biblio. 999$c is biblionumbr in.
22:44 rangi        id push them to a branch, and then merge that, perhaps with a --squash
22:44 rangi        then we have until the release to test 5.20
22:44 david        Ok developer is joining now. He is D David
22:44 rangi        and can revert that commit if its broken
22:45 cait         david: maybe an idea for pasting -  use paste.koha-community.org (be careful no passwords) from your workstation and give us the number of the paste
22:45 rangi        tcohen: does that make sense ?
22:47 David_       The 4 lines we pasted were from the websites noting that the searches had trouble with this version.  Pasted into koha-conf.xml, just before the end config tag ("</config>")
22:47 rangi        yes did you fix it tho
22:47 rangi        <zebra_lockdir>/var/lock/koha/__KOHASITE__</zebra_lockdir>
22:48 David_       I changed the directory in the 3rd line from the variable to the word "library"
22:48 David_       <zebra_bib_index_mode>__BIBLIOS_INDEXING_MODE__</zebra_bib_index_mode>  <zebra_auth_index_mode>__AUTHORITIES_INDEXING_MODE__</zebra_auth_index_mode>  <zebra_lockdir>/var/lock/koha/library</zebra_lockdir>  <use_zebra_facets>1</use_zebra_facets>
22:48 eythian      err
22:48 rangi        cool, thats one problem, but i doubt its your main one
22:48 eythian      you still have variables in there
22:48 rangi        yeah
22:48 rangi        anything __something__
22:48 rangi        should be changed to a real thing
22:48 rangi        so __BIBLIOS_INDEXING_MODE__
22:49 rangi        try changing that to grs1
22:49 tcohen       rangi, it does make sense
22:49 David_       not so sure...they work fine in all other cases.  There are variables all over the file...I don't know that changing them here are going to make a difference
22:49 rangi        i think you are editing the wrong file then
22:50 rangi        is the file you are editing /etc/koha/sites/library/koha-conf.xml ?
22:50 David_       yes
22:51 rangi        well those variables there will definitely not work
22:51 David_       so what do I need to use for replacement values for __AUTHORITIES_INDEXING_MODE__ and __BIBLIOS_INDEXING_MODE__?
22:51 rangi        grs1
22:51 eythian      there are variables in other parts of the file, but those parts are generally unused.
22:51 eythian      there shouldn't be variables in the parts that are used.
22:52 david        Replacing with GRs1  in both cases
22:53 rangi        grs1
22:53 rangi        no capitals
22:53 tcohen       edit ; sudo koha-restart-zebra ; sudo koha-rebuild-zebra-library
22:53 rangi        -f -v :)
22:53 david        sorry yes grs1
22:53 rangi        cool
22:54 David_       using -f -v is referenced in the code to explicitly skip biblio.  Is that what we want?
22:55 eythian      that's not what it does, -f means do a full reindex, -v means be verbose about it.
22:55 rangi        try man koha-rebuild-zebra
22:55 david        Do we need to rerun – F – V?
22:55 rangi        it will tell you what they mean (hint it's what eythian said)
22:55 rangi        yes
22:55 David_       I was in the code...it says if -f then turn off biblio
22:55 rangi        but f and v
22:56 rangi        must be reading the wrong code
22:56 david        Running now f and v
22:56 rangi        cos the code of koha-rebuild-zebra certainly doesnt do that
22:56 eythian      I'm in the code now, that's not what it says :)
22:56 eythian      --full|-f         Does a reindex of the whole collection.
22:56 david        reindexing now
22:56 rangi        did you do the koha-restart-zebra first ?
22:57 david        No
22:57 rangi        ahh you must have missed tcohen saying that
22:58 rangi        < tcohen> edit ; sudo koha-restart-zebra ; sudo koha-rebuild-zebra-library
22:58 david        Should we kill rebuild
22:58 rangi        if the index doesnt work, try restarting zebra first and try it again
23:03 david        thanks again to you all for your time and patience.
23:03 david        still indexing.
23:03 wahanui      i guess indexing is done by Zebra.
23:03 david        :)
23:05 Francesca    hey rangi are there any more webpages that need work?
23:06 rangi        i cant think of any
23:07 Francesca    ok
23:07 Francesca    I checked all the pages that the irc index page linked off to and they're all fine now as well
23:10 rangi        david: http://disneykoha.cloudapp.net/cgi-bin/koha/opac-search.pl?q=a&branch_group_limit=
23:10 rangi        i can see titles
23:11 rangi        Francesca: yeah, they look ok
23:12 Francesca    if there isn't anything for me to do I might disappear for a bit, thanks for letting me work on the webpages though, it was fun
23:12 cait         Francesca++
23:13 rangi        thanks for working on them :)
23:14 Francesca    rangi: no worries, I'll email you about times I could come back this year to do more work once I've got my uni schedule?
23:15 rangi        excellent sounds good to me
23:16 Francesca    sweet bye!
23:17 david        Still reindexing - will check titles when it stops
23:19 david        No results found. Tried searching under Java
23:20 david        47842 records exported; zebra reindexing
23:21 rangi        i had results showing just before
23:21 rangi        when i pasted the link in
23:21 david        Ok so reindexing must affect it while running live?
23:21 david        great!!!
23:22 david        will confirm when it stops
23:28 david        We see titles
23:28 david        Thank you all. Have a great night!
23:29 david        If any if you come to orlando Florida please let me know seriously
23:29 david        we owe you!!!!
23:29 eythian      awesome :)
23:29 rangi        :)
23:30 rangi        we should have a kohacon at disney one year ;-)
23:30 eythian      ...was just going to suggest that...:)
23:30 david        Please do.
23:33 rangi        http://disneykoha.cloudapp.net/cgi-bin/koha/opac-search.pl?q=perl&branch_group_limit=   pretty decent perl selection
23:36 eythian      david: well, it'd require someone on the inside to organise it...:)
23:45 dcook        david: That's cool that you're in Orlando
23:45 dcook        I have family in Tampa :)
23:45 * dcook      needs a good excuse to make a trip for rollercoasters...
23:48 eythian      the excuse kinda makes itself
23:50 dcook        Well, a subsidized trip to Florida then :p
23:55 cait         hm someone an idea about what duplicate card means in this context?
23:55 cait         Log duplicate card issuance
23:56 cait         also ... eythian bug 11000? :)
23:56 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11000 normal, P3, ---, koha-bugs, NEW , koha-restore not working: Koha username error
23:58 eythian      yes.
23:58 eythian      no.
23:58 eythian      maybe.
23:58 eythian      I don't know.
23:58 eythian      Can you repeat the question?
23:58 cait         bug 6780
23:58 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6780 enhancement, P5 - low, ---, meenakshi.r, ASSIGNED , Log duplicate card issuance