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?