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 :)