Time  Nick           Message
21:45 cait           i mean I did :)
21:43 ashimema       😭
21:39 cait           ok.. still missed it tho
21:32 ashimema       Just one
21:32 ashimema       Phone corrected meeting to meetings.. sorry
21:20 andreashm      wasn't one postponed?
21:17 cait           i thought i msised one.. more?
21:17 cait           ohohmeetings?
21:12 ashimema       Brain fix, I thought it was an entirely different day
21:11 ashimema       Sorry guys..
21:11 ashimema       Oh boo..  I totally missed the meetings
21:09 andreashm      poorly written, but perhaps someone else understands what it's about. =)
21:06 huginn`        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23487 normal, P5 - low, ---, koha-bugs, NEW , Utf8mb4 collation causes problems with missing tables when upgrading the database
21:06 andreashm      Finally submitted the bug for the collation - uppgrade issue. Bug 23487
20:42 cait           hi andreashm :)
20:39 andreashm      hi cait
20:16 * cait         waves
19:28 greenjimll     OK, night all!
19:23 davidnind      plus koha-testing-docker is really fast to spin up (bearing i mind I only use for documenting and testing the occasional bug)
19:22 davidnind      with kohadevbox I never managed to get the repo syncing to work (something NFS, permissions, something, something...)
19:21 wizzyrea       or more-permanent
19:21 wizzyrea       like, impermanence (yes, I know it can be fixed to be permanent)
19:20 wizzyrea       i like it too, but it has it's own quirks
19:20 davidnind      koha-testing-docker is the bees knees! (https://gitlab.com/koha-community/koha-testing-docker)
19:20 wizzyrea       good luck
19:20 wizzyrea       can relate :)
19:19 greenjimll     OK, I'll try the sync repo thing and have a look at docker too. Thanks. I was spending more of my scant time trying to fix kohadevbox/git than actually developing/testing.
19:18 wizzyrea       rofl
19:18 greenjimll     Knowing me, both would poop on my laptop. :-) :-)
19:17 wizzyrea       it's like a great dane vs a shih tzu
19:17 wizzyrea       well not altogether
19:17 wizzyrea       it's a different animal altogether
19:17 wizzyrea       you might have better luck with the testing docker thing?
19:17 greenjimll     Hence not wanting to go too far down the rabbit hole if there's a better solution such as your repo syncing. Thanks.
19:16 greenjimll     Got as far as cloning vmdk to a vdi image, expanding and reattaching today, but then would need ansible to expand filesystem on guest.
19:16 kidclamp       that would be cool
19:15 greenjimll     Yes, that's why I was looking to script it.
19:15 wizzyrea       I thought we had a wiki page about that
19:15 wizzyrea       yeah it's not a trivial thing really
19:15 kidclamp       you can expand your devbox, but it takes some doing
19:15 greenjimll     It sounds like a good idea - git pull often runs out of disc otherwise now and breaks even vagrant up sometimes.
19:15 huginn`        Log:            http://meetings.koha-community.org/2019/development_irc_meeting_21_august_2019.2019-08-21-19.04.log.html
19:15 huginn`        Minutes (text): http://meetings.koha-community.org/2019/development_irc_meeting_21_august_2019.2019-08-21-19.04.txt
19:15 huginn`        Minutes:        http://meetings.koha-community.org/2019/development_irc_meeting_21_august_2019.2019-08-21-19.04.html
19:15 huginn`        Meeting ended Wed Aug 21 19:15:11 2019 UTC.  Information about MeetBot at http://wiki.debian.org/MeetBot . (v 0.1.4)
19:15 kidclamp       #endmeeting
19:15 kidclamp       #info Next meeting: 4 September 2019, 13 UTC
19:14 wizzyrea       :D
19:14 wizzyrea       it could probably *BE* a recommendation
19:14 greenjimll     :-)
19:14 wizzyrea       I mean *I* recommend it
19:14 wizzyrea       but it is listed as an option there
19:14 wizzyrea       I don't know if it's recommended
19:14 greenjimll     Ah, right. Is that recommended in the docs? Must have missed it.
19:14 davidnind      kidclamp++
19:14 wizzyrea       bonus you don't lose anything when you inevitably destroy your vagrant box for one reason or another
19:13 wizzyrea       don't keep the repo inside the devbox
19:13 wizzyrea       my way round it is to use SYNC_REPO
19:13 wizzyrea       yes
19:13 wizzyrea       right
19:13 greenjimll     Well, I have repeatedly broken kohadevbox's by running out of disc space whilst doing "git pull" to update them. I've started to work on a Perl script to resize the VM, but wonder if others had same problem.
19:13 kidclamp       September 4? 13 UTC?
19:12 kidclamp       #topic Set time of next meeting
19:12 davidnind      agree!
19:12 wizzyrea       kidclamp++
19:12 kidclamp       #info Meeting tabled due ot low attendance
19:12 kidclamp       #infoo Meeting tabled due ot low attendance
19:12 wizzyrea       no this isn't enough people to have a meeting I reckon
19:11 wizzyrea       so what about the devbox question?
19:09 greenjimll     Er, or "general discussion" according the agenda. :-)
19:09 kidclamp       even if not meeting
19:09 kidclamp       we can all still disucsss :-)
19:08 greenjimll     Any Other Business
19:08 kidclamp       AOB?
19:08 wizzyrea       You are CHEEKY
19:08 greenjimll     Fine. Only thing I want to talk about was kohadevbox resizing under AOB.
19:08 davidnind      sounds good to me!
19:08 huginn`        Current chairs: kidclamp wizzyrea
19:08 kidclamp       #chair wizzyrea
19:07 kidclamp       I will sugest waiting a few and skipping if no new comers?
19:07 wizzyrea       #info Liz Rea
19:07 greenjimll     "Select" I like to think.
19:07 kidclamp       and a blank agenda
19:06 kidclamp       sparse crowd
19:05 davidnind      #info David Nind, New Zealand
19:04 kidclamp       #link https://wiki.koha-community.org/wiki/Development_IRC_meeting_21_August_2019 Agenda
19:04 greenjimll     #info Jon Knight, Loughborough University
19:04 kidclamp       #info Nick Clemens, ByWater Solutions
19:04 kidclamp       #topic Introductions
19:04 huginn`        The meeting name has been set to 'development_irc_meeting_21_august_2019'
19:04 huginn`        Useful Commands: #action #agreed #help #info #idea #link #topic #startvote.
19:04 huginn`        Meeting started Wed Aug 21 19:04:22 2019 UTC.  The chair is kidclamp. Information about MeetBot at http://wiki.debian.org/MeetBot.
19:04 kidclamp       #startmeeting Development IRC meeting 21 August 2019
19:03 greenjimll     Yep.
19:03 kidclamp       dev meeting?
18:58 oleonard       kidclamp: Working on it. More tomorrow.
18:55 oleonard       https://www.timeanddate.com/countdown/generic?p0=1440&iso=20190821T19&msg=Koha%20Developers%20IRC%20Meeting
18:54 greenjimll     Dev meeting in five minutes or so?
18:28 kidclamp       if it could not be a link that would be ideal on wide display
18:27 oleonard       The "refine" link I mean
18:27 oleonard       It probably shouldn't do anything at all if the layout isn't narrow
18:27 kidclamp       on a browser search it is confusing, clicking to hide really isn't helpful when not no mobile
18:26 kidclamp       I still think the plus minus would help
18:26 kidclamp       oleonard: looking from mobile, yes it makes much more sense
17:32 oleonard       A new bug, with the old bug as a dependency
17:29 phasefx_       hi guys, if a bug fix broke something, do you report a new bug or re-open the bug associated with the commit that broke things?
17:11 huginn`        tcohen: The operation succeeded.
17:11 tcohen         the table, but crafting the query so the (added) library_id parameter is used to filter the results based on the configured limits
17:11 tcohen         @later tell cait those classes are used to add superpowers to Koha::Object(s)-based classes. Specifically, Koha::Object::Limits::Library adds a Koha::Object based class the ability to define library constraints to the object (i.e. it adds methods so those limits can be added). Then Koha::Objects::Limits::Library adds plural classes a new method: search_with_library_limits that does what we would expect from it, perform a regular search on
15:33 * Nemo_bis     updated https://en.wikipedia.org/wiki/Koha_(software)#Current_status
15:23 cait           hm or maybe not... heh, it's confusing, but might be not good right now to get more confsued
15:22 cait           in this case (I know we need both)
15:22 cait           i mean why we need both...
15:22 cait           can you explain?
15:22 cait           tcohen: ok?
14:52 Nemo_bis       There's a Koha discussion room now at Skövde
14:23 ashimema       I couldn't work it out oleonard :(
14:23 tcohen         Koha::Object::Limit::Library <> Koha::ObjectS::Limit::Library
14:22 tcohen         ^^ cait
14:22 tcohen         it doesn't
14:22 oleonard       ashimema: I was afk for a while... Does your finding suggest a fix I can do on my end?
14:21 huginn`        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23281 enhancement, P5 - low, ---, tomascohen, Pushed to master , Add Koha::Objects::Limit::Library
14:21 cait           I think it depens on bug 23281, correct? (I've added it, but want to make sure)
14:20 cait           tcohen: can you please have a loo at 15497?
13:47 cait           morning tcohen
13:47 huginn`        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23484 enhancement, P5 - low, ---, koha-bugs, Needs Signoff , Holds to pull (pendingreserves.pl) uses removed default_branch_item_rules table
13:47 cait           bug 23484 ouch
13:46 tcohen         morning all
13:33 ashimema       Needs thought
13:33 ashimema       Hmm, I think I remember some of the reasoning behind not using _bin now.. it was to do with not wanting to require exact character (including accents) for searching or something
13:18 andreashm      But I'll try to add a bug for that later today (tonight)
13:16 andreashm      But I should start with writing that bug. It's high on my todo list (unfortunately, so are a lot of other things)
13:16 * ashimema     takes dog for a quick walk whilst he ponders
13:16 ashimema       hugs :)
13:16 ashimema       any chance you could write that up.. it does sound like something I'd like to pursue
13:16 andreashm      Yeah, don't know the best way around this.
13:15 ashimema       though as you've shown earlier.. such a change for upgrades is just painful
13:15 andreashm      This creates duplicates. Especially bad in foreign keys (for us, mostly user.id)
13:15 * ashimema     is more than happy for a bug to be submitted to suggest such a change..
13:15 andreashm      The letters O and Ö are both treated as O
13:15 ashimema       in what way?
13:15 andreashm      ashimema: _bin seems to make a difference for diacritics and case
13:15 ashimema       bad for nordic?
13:14 * ashimema     also can't remember if it was around when we first moved to utf8mb4
13:14 andreashm      ashimema: yes, good for korean, japanese etc., bad for nordic countries and eastern europe.
13:14 * ashimema     can't remember the difference..
13:14 ashimema       mm.. perhaps..
13:14 andreashm      yes, but utf8mb4_bin would have been better from what I understand
13:13 andreashm      ashimema: maybe not so many customers that have weird diacritics/different letters?
13:13 ashimema       it's the 'safest' to ensure utf8 compatability for all
13:13 ashimema       hmm.. we've had it as default for years longer than community have here..
13:12 cait           well... translate actually, they have been updated
13:12 * andreashm    is not a fan of the choice to have that collation as default
13:12 * cait         realized she shoudl update translatoins
13:12 ashimema       a vague recollection he had mentioned something similar
13:12 andreashm      https://stackoverflow.com/questions/47119794/mysql-mariadb-unable-to-handle-unique-keys-with-when-using-utf8mb4
13:12 ashimema       haha.. that may have well been what made me just think of him
13:12 andreashm      it delayed us upgrading from june to august
13:11 andreashm      cait: yes, it was
13:11 andreashm      josef had seen similar
13:11 ashimema       is josef_moravec still lurking.. not seen him around in ages
13:10 cait           that sounds awful
13:10 andreashm      I really need to write down that bug
13:10 andreashm      oleonard: that looks kind of like the errors we where getting because of utf8mb4 and duplicates on foreign keys. When running updatedatabase.pl the tablespace got messed up and we had tables that both existed and didn't.
12:39 oleonard       Hi wizzyrea
11:59 ashimema       wow
11:59 ashimema       oh.. no.. no it cant have as the next line populating the table also fails because the table doens't exist yet!
11:58 ashimema       did you test this patch before.. does your db already have the table?
11:58 ashimema       * `duplicate key on write or update`.. when creating the table in the first place
11:58 ashimema       `duplicate key on write or update`.. when creating the table in the first palce
11:57 ashimema       that's a really wierd error
11:57 cait           :)
11:57 ashimema       lol
11:57 oleonard       This did not help me get that job as gourmet chocolate tester
11:51 cait           which makes you a great tester
11:50 oleonard       it is not uncommon for me to have updatedatabase errors because I have crufty data
11:49 oleonard       http://paste.koha-community.org/8450
11:48 ashimema       I must have missed a case
11:48 ashimema       what's the error.. I thought I'd tested it pretty well with all sorts of wierd data issues
11:47 ashimema       poop
11:47 huginn`        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14570 enhancement, P5 - low, ---, kyle, Pushed to master , Make it possible to add multiple guarantors to a record
11:47 oleonard       ashimema: I'm getting an error when running the db update for Bug 14570
11:46 wahanui        hello, ashimema
11:46 ashimema       hi
11:44 oleonard       ashimema around?
11:34 oleonard       Hi #koha
10:59 magnuse        bit slow, but works for me
10:47 eythian        yep, not responding
10:46 eythian        it's looking slow/not responding from here
10:35 calire         seems to be back, but slow
10:10 calire         anyone else got issues accessing bugs.koha-community.org?
09:36 cait           eythian++
09:34 ashimema       nice
09:34 eythian        "this then improves the availability of freely distributable, modifiable, and customisable library systems for local organisations such as community centres and schools (etc.)"
09:30 ashimema       Indeed.. except they add the local factor again..
09:30 eythian        ashimema: it should totally be easy to waffle on about how contributions to free software library systems go towards improving literacy of people in disadvantaged areas etc.
09:28 ashimema       those sorts of things..
09:28 ashimema       tracking of mobile libraries on a map perhaps
09:28 ashimema       accessability seems a good one..
09:28 ashimema       hense I was looking for new features or improvements to koha we could code do probono that would help the whole community in this sort of respect but could also be sold as great locally
09:26 ashimema       indeed
09:26 ashimema       problem is.. it all has the caveat of it has to help their local population.. and none of us are based there..
09:25 cait           as you are pretty spread out it's hard to apply i guess
09:25 cait           internships?
09:25 ashimema       general 'how will your product help make the area a better place to live'
09:25 cait           accessibility might be good too yes
09:25 cait           maybe somethign about company policy for personal development?
09:25 ashimema       sorta relates to accessability too
09:25 cait           ah ok... not the same wording
09:25 ashimema       so in this context really it's about finding ways to help people help themselves to better themselves..
09:24 cait           that didn't come through
09:24 ashimema       social mobility: the upward movement of population through the class system
09:23 cait           which description?
09:22 ashimema       did my description help at all cait ?
09:21 cait           ashimema: i've looked up social mobility and still have no clue...
09:20 cait           as you are testing first (i hope) things should work out :)
09:19 cait           but you don#t want it to create a 19.05 db first
09:19 KeithS         THANKS LOADS!
09:19 cait           it shoudl then trigger that yep
09:19 KeithS         After loading then run the web installer?
09:19 cait           load the db
09:19 cait           and don't run the web installer on your new server
09:19 cait           yes
09:18 cait           if you look at the files, there should be "create table" statements in it
09:18 KeithS         SO... mysqldump on existing server, then rebuild on new system and allow new system to read and update it
09:18 cait           KeithS: mysqldump is easy to use -if you look it up i'd try that
09:18 cait           yeah it's what i have used too
09:18 ashimema       afraid we don't use the backup tools either.. we just mysqldump
09:17 cait           you don't want to load data into a 19.05 db - you want your 17.11 db as it is now so the update works smootly
09:17 cait           KeithS: wondering if the backups /restore contain just the data or also the statements to create the tables
09:17 cait           not sure what the restore does... ashimema do you know?
09:17 KeithS         mysqldump?
09:17 ashimema       loosely relates to accessability too
09:17 cait           not load into an existing one
09:16 cait           you will need to create the db with the dump
09:16 ashimema       moving up the social/class ladder
09:16 cait           maybe you want to do a dump instead
09:16 ashimema       erm.. ways to help people help themselves..
09:16 cait           hm
09:16 cait           KeithS: i think in theory yes - haven't used the back up tools myself yet
09:16 cait           ashimema: i am looking it up right now :P
09:16 ashimema       ermm..
09:15 KeithS         Just for my personal clarity: (1) run koha-backups on existing server (2) install latest version on new server (3) copy gz files to new server (4) run koha-restore (5) Koha updates db
09:15 cait           ashimema: what is social mobility?
09:13 cait           the application detects the mismatch between the versoin in the db and the koha version and starts an update process
09:13 cait           KeithS: yes
09:12 ashimema       wierd tender question.. how will your product/company improve the social mobility of the local area..
09:12 huginn`        KeithS: I suck
09:12 KeithS         @cait, so if I install latest version (19.x), I can I do a restore from a koha backup made on a version 17.11?
09:12 ashimema       anyone got any ideas for new features or enhancements that would 'improve social mobility' ?
09:12 cait           or maybe 17.11 woudl still work - does someone else know?
09:11 cait           https://wiki.koha-community.org/wiki/Koha_on_Debian here is some information about the setup - you can see ther eis no codename for 17.11 anymore
09:10 cait           you can load your db into a newer version to trigger an update (I asusme you can install older manually, but that might be a way to avoid that)
09:09 cait           may i ask why you want to install the old version first?
09:08 cait           KeithS: I think you woudl have to go differently as the 17.11 is no longer maintained
09:05 KeithS         What is the apt-get command to install koha 17.11. I am migrating servers and need to install the older version before updating. I assume apt-get install koka-core will install the latest version.
08:55 koha-jenkins   Project Koha_Master_D8 build #365: STILL UNSTABLE in 43 min: https://jenkins.koha-community.org/job/Koha_Master_D8/365/
08:11 ashimema       oops
08:11 ashimema       dang.. typo in my own commit message..
08:11 koha-jenkins   Project Koha_Master_D8 build #364: STILL UNSTABLE in 43 min: https://jenkins.koha-community.org/job/Koha_Master_D8/364/
08:11 ashimema       woop, woop
08:05 koha-jenkins   Project Koha_Master_U18 build #339: FIXED in 39 min: https://jenkins.koha-community.org/job/Koha_Master_U18/339/
08:04 wahanui        Congratulations!
08:04 koha-jenkins   Yippee, build fixed!
08:00 magnuse        woohoo!
07:58 koha-jenkins   Project Koha_Master_D9 build #854: FIXED in 29 min: https://jenkins.koha-community.org/job/Koha_Master_D9/854/
07:58 wahanui        Congratulations!
07:58 koha-jenkins   Yippee, build fixed!
07:44 cait           ansible++ :)
07:36 magnuse        andreashm: ansible all the things! ;-)
07:25 huginn`        News from kohagit: Bug 14570: (RM follow-up) Add class relatinship to BorrowerRelationship <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=12f583dd2c580cad046605531c79c1a90bf91436>
07:22 cait           andreashm: :)
07:20 koha-jenkins   Project Koha_Master_D8 build #363: STILL UNSTABLE in 42 min: https://jenkins.koha-community.org/job/Koha_Master_D8/363/
07:20 andreashm      hi magnuse
07:20 andreashm      most things we've had issues with is our own fault basically. Koha has been behaving well. =)
07:16 cait           nothing bad tho, but good to keep an eye on the files
07:16 cait           ah yeah... i had some merge error there too in the past :)
07:16 * magnuse      waves
07:14 andreashm      cait: ^
07:13 andreashm      it went well. had some issues with automatic renewals and fines as cronjobs didn't run in the correct order when we started them again. but that was our fault, we should schedule them better.
07:12 cait           but great to hear :)
07:12 cait           andreashm: let me know how it goes!
07:11 liliputech_asu morning :)
07:11 andreashm      upgrade to 18.11 completed. yay!
07:11 andreashm      hey cait
07:11 cait           good morning #koha!
07:10 andreashm      salut
07:03 wahanui        hello, alex_a
07:03 alex_a         Bonjour
04:04 KeithS         I am looking for guidance on updating the authorities file based on biblio data. In transition from another system that did not use authorities, I imported the biblio data into Koha (17.11). Now when I want to edit the subject tracings of a manually imported biblio, it doesn't allow me to edit. I assume this is because the new subject tracing is not in the Authorities. Are there any shortcuts on this?