IRC log for #koha, 2018-12-18

All times shown according to UTC.

Time S Nick Message
00:18 papa joined #koha
00:40 aleisha joined #koha
01:43 cait1 joined #koha
05:47 alexbuckley joined #koha
06:13 chris1 joined #koha
06:30 calire joined #koha
06:39 calire1 joined #koha
06:42 josef_moravec joined #koha
06:48 calire joined #koha
06:54 alexbuckley joined #koha
06:55 ashimema Oh, thanks rangi
07:18 sophie_m joined #koha
07:23 fridolin joined #koha
07:24 fridolin hohoho
07:24 fridolin wahanui: you like XMas ?
07:24 wahanui i haven't a clue, fridolin
07:27 HomerunDiva joined #koha
07:40 AndrewIsh joined #koha
07:49 reiveune joined #koha
07:49 reiveune hello
07:49 wahanui hello, reiveune
07:52 paul_p joined #koha
07:53 laurence joined #koha
07:57 alex_a joined #koha
08:00 Archie^ joined #koha
08:06 Archie^ hey guys! How does one fix DBMS auto increment in deleted biblio table?
09:24 alex_a joined #koha
09:29 josef_moravec Archie^: Have you read this? https://wiki.koha-community.or[…]uto_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:44 alex_a joined #koha
09:47 magnuse https://wiki.koha-community.or[…]uto_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:54 alex_a_ joined #koha
09:55 ashimema interesting
09:55 ashimema we've not experienced that
09:56 fridolin1 joined #koha
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:15 alex_a joined #koha
10:19 lari joined #koha
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:38 cait joined #koha
10:50 andreashm joined #koha
10:52 * andreashm waves
11:30 kohaputti joined #koha
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[…]_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:48 fridolin joined #koha
11:49 fridolin left #koha
11:51 fridolin joined #koha
11:54 shaakir joined #koha
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[…]_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:29 fridolin joined #koha
12:30 oleonard joined #koha
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:13 josef_moravec joined #koha
13:20 Dyrcona joined #koha
13:27 laurence joined #koha
13:35 kohaputti joined #koha
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:52 caroline joined #koha
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.or[…]&attachment=83366
14:02 huginn Bug http://bugs.koha-community.org[…]_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[…]oha_18.05_D8/141/
14:29 koha-jenkins Project Koha_18.05_D9 build #138: UNSTABLE in 30 min: https://jenkins.koha-community[…]oha_18.05_D9/138/
14:43 calire left #koha
14:53 koha-jenkins Project Koha_18.05_U18 build #142: STILL UNSTABLE in 27 min: https://jenkins.koha-community[…]ha_18.05_U18/142/
15:48 Margaret joined #koha
15:48 Margaret Good Morning Koha!
15:48 oleonard Hi Margaret
16:04 alex_a_ joined #koha
16:05 alex_a_ joined #koha
16:08 oleonard Love this new message from the translate script, "Completely confused parametrizing"
16:12 reiveune bye
16:12 reiveune left #koha
16:12 chris_n joined #koha
16:16 ashimema lol
16:27 oleonard https://zivotdesign.com/p/view[…]?p=15451502866644
16:34 ashimema very nice
16:39 laurence left #koha
16:39 cait nice!
16:48 fridolin left #koha
16:49 Margaret joined #koha
17:10 oleonard Me today = this mug: https://zivotdesign.com/p/view[…]?p=15451530125926
17:14 Boost joined #koha
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[…]_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[…]oha_18.05_D8/142/
19:58 koha-jenkins Project Koha_18.05_D9 build #139: STILL UNSTABLE in 29 min: https://jenkins.koha-community[…]oha_18.05_D9/139/
19:59 oleonard See y'all tomorrow
19:59 magnuse have fun oleonard-away
20:11 alexbuckley joined #koha
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[…]ha_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 sonOfRa joined #koha
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-commun[…]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:54 Dyrcona joined #koha
20:58 koha-jenkins Project Koha_18.05_D9 build #140: STILL UNSTABLE in 28 min: https://jenkins.koha-community[…]oha_18.05_D9/140/
21:00 koha-jenkins Project Koha_18.05_D8 build #143: STILL UNSTABLE in 29 min: https://jenkins.koha-community[…]oha_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[…]ha_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[…]_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 :)
23:48 alexbuckley joined #koha
23:52 papa joined #koha

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary