Time  Nick          Message
06:55 ashimema      Oh, thanks rangi
07:24 fridolin      hohoho
07:24 fridolin      wahanui: you like XMas ?
07:24 wahanui       i haven't a clue, fridolin
07:49 reiveune      hello
07:49 wahanui       hello, reiveune
08:06 Archie^       hey guys! How does one fix DBMS auto increment in deleted biblio table?
09:29 josef_moravec Archie^: Have you read this? https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix
09:29 Archie^       yes i went trough it
09:29 Archie^       The Koha community has not completed a way to deal with corrupted data yet, but a script is being worked on to fix this in the future.
09:29 Archie^       that's why i'm asking
09:32 ashimema      erm.. I thought you were loading fresh data Archie^  How have you corrupted it if your loading it to start with
09:33 Archie^       ashimema: well i'm testing data i'm loading in and some of it sometimes is corrupted, so i delete it and start again
09:34 ashimema      basically it's juts a matter of making sure your primary key are unique throughout
09:35 * ashimema    goes to read the page you linked..it's been a while since I've looked at it.
09:47 magnuse       https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix hs some SQL you should put in a file and then adjust the mysql config
09:47 magnuse       that solution is not working 100% for me, though
09:48 ashimema      ?
09:54 magnuse       i sometimes get duplicate ids one some sites, even if i have the fix in place
09:55 ashimema      interesting
09:55 ashimema      we've not experienced that
09:57 magnuse       ashimema: lucky you ;-)
09:57 ashimema      mmm
09:57 ashimema      sorry.. that wasn't meant to rub salt into the wound..
09:57 ashimema      more show confusion..
09:58 magnuse       np!
10:02 Archie^       magnuse: that solution only works for "from now on"
10:02 Archie^       but does not fix corrupted records
10:14 magnuse       Archie^: that is true, yes
10:20 Archie^       but how does one fixes corupted data tho?
10:20 Archie^       :D
10:21 ashimema      the reason there's no script to fix it is that you need to make a decision
10:21 ashimema      you could either delete the bad users from delete_* tables
10:21 ashimema      or.. you could give them new ID's carefully incrementing the autoinc value
10:25 Archie^       ye but im talking about deleted biblio records
10:25 Archie^       and you can't delete them from that table
10:52 * andreashm   waves
11:39 * cait        waves
11:39 cait          someone a minute to take a look at bug 22017?
11:39 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22017 blocker, P1 - high, ---, koha-bugs, NEW , Cannot start the web installer
11:40 cait          lots of information there, but installation is not my strong point
11:55 shaakir       Hi. Any suggestions on alternatives to maintaining the patron list to manual CSV imports? I saw a script to update patrons based on some Norwegian database. The other option seems to be going to the DB tables directly...
11:56 ashimema      @later tell kidclamp you didn't fancy pushing the blocker before our release window did you? Bug 21065
11:56 huginn        ashimema: The operation succeeded.
11:56 shaakir       Most of our own patrons don't log in themselves, but have library staff do their borrowing for them at the service desk. (K-12 school), so LDAP-based patron updates is a bit useless, unless we can invoke the thing for each patron from outside.
11:57 kidclamp      naw, that doesn't seem fun
11:57 cait          depending on your koha version there is an import script and a REST API
11:57 cait          for patrons
11:58 ashimema      lol
11:58 kidclamp      will look that over shortly
11:58 cait          but LDAP, Shibboleth etc. won't update the patrons automatically without a login from the patron, so I tihnk they won't work as you said
11:58 ashimema      hugs
11:59 ashimema      it'll make cait happy kidclamp.. always good to keep cait happy ;)
11:59 cait          hm where is wahanui
11:59 wahanui       i think i am a political leader
11:59 cait          bug 21065
11:59 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21065 blocker, P5 - low, 19.05, jonathan.druart, Passed QA , Data in account_offsets and accountlines is deleted with the patron leaving gaps in financial reports
11:59 cait          i hope others too
11:59 cait          did you want to rename the fk?
12:00 ashimema      oh.. silly me
12:01 ashimema      I said i'd play with it a bit more to try and prevent it getting re-applied for each koha version
12:01 ashimema      hmm..
12:01 ashimema      hold off kidclamp  I'll try and work out a cleaner approach after lunch
12:01 ashimema      my bad
12:07 kidclamp      kk, let me know when you have it ready
12:08 kidclamp      I might call it critical and not blocker, it has been going on for some time
12:08 cait          it helped to get it omving finally :)
12:08 cait          and we defined blocker as data loss bugs... so it seemed to qualify
12:09 shaakir       cait: thanks for the pointers
12:10 shaakir       cait: I can see import_patrons.pl under misc, and there seems to be a few interesting things re Koha::REST::V1
12:10 kidclamp      fair enough
12:11 cait          shaakir: yep, those are the 2 :)
12:13 shaakir       rtfm-ing time. ta da.
12:32 oleonard      Hi #koha
12:35 calire        hi oleonard
12:35 wahanui       hi oleopard
12:46 oleonard      So uh, what's up everybuddy?
12:57 magnuse       gah! Getting "No items are available to be placed on hold." when items should be perfectly holdable. Sound familiar to anyone? 17.11.11
13:00 magnuse       Holds allowed (count) = 10, Holds per record (count) = 1
13:02 magnuse       never mind, had "On shelf holds allowed = No", and no items on loan... *facepalm*
13:45 Joubu         cait: Hi
13:46 Joubu         Anybody familiar with the auth "identifier-standard" zebra index?
13:50 cait          hi
13:50 cait          in which way?
13:54 caroline      Good morning!
14:02 ashimema      Joubu still there?
14:02 ashimema      happy with this as my followup for bug 21065 https://bugs.koha-community.org/bugzilla3/page.cgi?id=splinter.html&bug=21065&attachment=83366
14:02 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21065 blocker, P5 - low, 19.05, jonathan.druart, Passed QA , Data in account_offsets and accountlines is deleted with the patron leaving gaps in financial reports
14:03 ashimema      in all my testing it seems to nicely sidestep the whole re-application of the update on different branches
14:06 ashimema      I'm pretty confident we're good to go now kidclamp.. but I wouldn't mind a second pair of eyes on my followup from anyone with mysql background
14:07 ashimema      it works for me (and I've tested backporting and resetting my db a few times for various combinations)
14:10 Joubu         ok, will take a look later
14:23 ashimema      ta
14:25 koha-jenkins  Project Koha_18.05_D8 build #141: UNSTABLE in 24 min: https://jenkins.koha-community.org/job/Koha_18.05_D8/141/
14:29 koha-jenkins  Project Koha_18.05_D9 build #138: UNSTABLE in 30 min: https://jenkins.koha-community.org/job/Koha_18.05_D9/138/
14:53 koha-jenkins  Project Koha_18.05_U18 build #142: STILL UNSTABLE in 27 min: https://jenkins.koha-community.org/job/Koha_18.05_U18/142/
15:48 Margaret      Good Morning Koha!
15:48 oleonard      Hi Margaret
16:08 oleonard      Love this new message from the translate script, "Completely confused parametrizing"
16:12 reiveune      bye
16:16 ashimema      lol
16:27 oleonard      https://zivotdesign.com/p/view.php?p=15451502866644
16:34 ashimema      very nice
16:39 cait          nice!
17:10 oleonard      Me today = this mug: https://zivotdesign.com/p/view.php?p=15451530125926
17:20 caroline      lol!
18:00 * cait        sends cookies
18:22 caroline      Is there a way to remove field 520 from the keyword search? Or the keyword search searches everything and that's that?
18:22 cait          that's that
18:22 cait          the any index is the whole record since we shifted to DOM
18:22 cait          any = keyword
18:22 cait          there are some bugs with discussion of it, but no active work
18:24 caroline      ok
18:25 cait          i want to remove the internal notes from opac... but meh
18:25 cait          :)
18:25 cait          from search
18:26 caroline      I noticed the material type is also indexed for the search. Kind of annoying
19:28 * oleonard    is excited about Bug 22023
19:28 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22023 enhancement, P5 - low, ---, oleonard, ASSIGNED , Further improve responsive layout handling of staff client menu bar
19:29 * oleonard    obviously gets excited about weird things
19:31 oleonard      Don't forget to like and subscribe
19:55 koha-jenkins  Project Koha_18.05_D8 build #142: STILL UNSTABLE in 29 min: https://jenkins.koha-community.org/job/Koha_18.05_D8/142/
19:58 koha-jenkins  Project Koha_18.05_D9 build #139: STILL UNSTABLE in 29 min: https://jenkins.koha-community.org/job/Koha_18.05_D9/139/
19:59 oleonard      See y'all tomorrow
19:59 magnuse       have fun oleonard-away
20:14 magnuse       hiya alexbuckley
20:14 alexbuckley   hi magnuse :)
20:16 alexbuckley   how are you going? Are you looking forward to Christmas?
20:22 magnuse       a bit too busy, but definitely looking forward to the holidays :-)
20:22 magnuse       max number of days off this year too
20:23 magnuse       and looking like it will be a white xmas
20:23 alexbuckley   oh lovely!
20:23 * magnuse     suspects xmas in nz will be green this year
20:23 alexbuckley   yup green and warm :)
20:24 magnuse       hehe, nice
20:24 * magnuse     has spent xmas in bali and tanzania, so is not completely unfamiliar with the concept ;-)
20:26 ashimema      white xmas or green and warm xmas.. both sound good to me
20:26 ashimema      we have decidedly grey and miserable ones here
20:26 magnuse       ouch
20:26 ashimema      hehe
20:26 alexbuckley   hi ashimema  :)
20:27 ashimema      hi alex
20:27 alexbuckley   Last year I had christmas in Egypt so it was dry and warm :)
20:27 ashimema      sorry I've not got back to your email... as ever rather busy.. I'm hoping to really pick things up again after xmas
20:27 alexbuckley   not a problem yeah it does get very busy in run up to xmas
20:27 magnuse       ashimema: did you decide on when to do 18.11.01?
20:28 koha-jenkins  Project Koha_18.05_U18 build #143: STILL UNSTABLE in 32 min: https://jenkins.koha-community.org/job/Koha_18.05_U18/143/
20:28 ashimema      my kids would love a proper white xmas I think.. that's what they dream of
20:28 alexbuckley   :)
20:28 ashimema      20th is release day magnus.. to give drojf a day or two this week for packaging without eating into xmas week
20:28 magnuse       @wunder bodø, norway
20:28 huginn        magnuse: Error: I could not find a valid location for: bodø, norway
20:28 magnuse       @wunder bodo, norway
20:28 huginn        magnuse: Bodo, Norway :: Clear :: 32F/0C | Wind Chill: 20F/-7C | Tuesday: Clear and windy. Lows overnight in the upper 20s. Tuesday Night: Clear. Gusty winds diminishing after midnight. Low 27F. Winds E at 20 to 30 mph.
20:28 ashimema      I sent an email.. ah.. but only to the translations list to anounce string freeze
20:29 magnuse       ashimema: excellent
20:29 wahanui       darn tootin' it is.
20:29 * magnuse     is not keeping up with the lists...
20:29 ashimema      :)
20:29 * ashimema    contemplates the 18.05.x failures.. looks like caching issues again to me
20:37 kidclamp      think it is code or docker causing it ashimema
20:39 * magnuse     thinks it is the elf on the shelf
20:42 ashimema      code or docker.. lol
20:42 ashimema      that narrows it down ;)
20:42 kidclamp      well, in one case we blame Joubu, in the other tcohen
20:43 ashimema      i think it's the remaval of Cache::Memory and the docker image not having memcached enabled
20:43 ashimema      hehe
20:43 ashimema      can we blame both ;)
20:43 kidclamp      that was my suspicion
20:43 kidclamp      we can, they are both gone
20:43 ashimema      lol
20:43 kidclamp      Joubu also didn't do the dishes at my house, his fault, not mine
20:44 ashimema      want me to run it again a local docker using master docker to test our hypothesis?
20:44 * cait        waves
20:44 cait          i am here, don't blame me!
20:44 kidclamp      sure
20:44 kidclamp      they pass on my devbox it seems too
20:45 kidclamp      ones I tested so far
20:45 kidclamp      cait's fault
20:45 cait          hmpf
20:45 cait          i don't know how this game works
20:46 kidclamp      you just blame other people, it is not a helpful game
20:48 ashimema      yup: https://gitlab.com/koha-community/koha-testing-docker/issues/103
20:48 kidclamp      hrm, actually reset all is giving me problems on 18.05?
20:49 kidclamp      maybe I need a pull somewhere
20:49 kidclamp      my fault this time
20:50 * ashimema    get docker going on laptop
20:53 cait          hm
20:53 cait          i think i found a bug... 5 minutes into touching koha code for the first time in weeks
20:54 ashimema      sorry.. gotta dissapear.. daughter's woken up not very well
20:54 ashimema      nighty night koha
20:54 cait          night ashimema
20:58 koha-jenkins  Project Koha_18.05_D9 build #140: STILL UNSTABLE in 28 min: https://jenkins.koha-community.org/job/Koha_18.05_D9/140/
21:00 koha-jenkins  Project Koha_18.05_D8 build #143: STILL UNSTABLE in 29 min: https://jenkins.koha-community.org/job/Koha_18.05_D8/143/
21:14 * cait        blames Joubu
21:27 koha-jenkins  Project Koha_18.05_U18 build #144: STILL UNSTABLE in 29 min: https://jenkins.koha-community.org/job/Koha_18.05_U18/144/
22:11 cait          someone still around?
22:11 cait          i am working on a database update using the skeleton perl but it doesn't seem to be executed when I run updatedatabase in kohadevbox
22:25 cait          found it: has to be .perl not .pl
22:25 ashimema      That'll do it
22:25 cait          fixing bug 22024
22:25 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22024 major, P5 - low, ---, katrin.fischer, NEW , Update translated web installer files with new class splitting rules
22:26 cait          intersting for you too ashimema
22:26 cait          no translations and it woudl hurt new installations
22:28 cait          ashimema: all girls back to sleep?
22:31 ashimema      Yup... Poor Millie isn't well though, she's got terrible ear ache so keeps waking up
22:32 cait          :(
22:32 cait          ear ache is mean, hope she feels better fast
22:40 * cait        blames ashimema
22:40 cait          making rounds tonight ;)
22:41 cait          for not adding the stock rotation slip to tranlsated installers
22:44 cait          i take it back
22:56 caroline      good night everyone!
23:36 cait          ashimema: it's all good with the stock rotation notices, just fixed some capitalization while translating :)