IRC log for #koha, 2019-03-07

All times shown according to UTC.

Time S Nick Message
00:00 koha-jenkins Project Koha_18.05_D8 build #225: SUCCESS in 19 min: https://jenkins.koha-community[…]oha_18.05_D8/225/
00:02 jancis_ joined #koha
00:05 koha-jenkins Project Koha_18.05_D9 build #222: UNSTABLE in 26 min: https://jenkins.koha-community[…]oha_18.05_D9/222/
00:24 koha-jenkins Project Koha_18.05_U18 build #222: SUCCESS in 42 min: https://jenkins.koha-community[…]ha_18.05_U18/222/
00:36 AnnaBoten joined #koha
00:36 matts joined #koha
00:43 AnnaBoten joined #koha
05:57 magnuse \o/
06:05 chris1 joined #koha
06:29 cait joined #koha
06:31 calire joined #koha
06:47 fridolin joined #koha
06:48 fridolin hi there
06:48 wahanui hello, fridolin
06:48 alexbuckley hi all
07:05 andreashm joined #koha
07:08 remy_prebs joined #koha
07:15 liliputech_asu hello :)
07:16 andreashm joined #koha
07:29 marcelr joined #koha
07:30 marcelr hi #koha
07:33 * cait waves
07:33 cait bbiab
07:34 calire morning #koha
07:34 calire hi marcelr
07:34 andreash_ joined #koha
07:34 marcelr hi cait calire
07:34 marcelr and andreashm
07:34 wahanui andreashm is this the ppt from last kohacon?
07:34 josef_moravec joined #koha
07:34 marcelr and josef_moravec
07:34 wahanui rumour has it josef_moravec is using this "manual" when building packages: https://wiki.koha-community.or[…]es_-_The_Easy_Way
07:35 josef_moravec hi marcelr
07:35 josef_moravec what were you speaking about?
07:35 marcelr greetings :)
07:35 marcelr check the logs..
07:36 josef_moravec ok ;)
07:36 josef_moravec ;)
07:36 josef_moravec morning #koha
07:37 josef_moravec marcelr: you were quick ;)
07:37 calire hey josef_moravec
07:37 wahanui josef_moravec is using this "manual" when building packages: https://wiki.koha-community.or[…]es_-_The_Easy_Way
07:37 josef_moravec hi calire
07:38 AndrewIsh joined #koha
07:38 josef_moravec Hi AndrewIsh
07:38 josef_moravec AndrewIsh: I have a feeling I wanted continue on testing some ILL bug, maybe the unemdiated ILL one? ;)
07:39 josef_moravec right after bug 21683, which I am looking again into
07:39 huginn` Bug http://bugs.koha-community.org[…]_bug.cgi?id=21683 enhancement, P5 - low, ---, josef.moravec, Failed QA , Remove accountlines.accountno
07:39 ashimema Thanks josef_moravec
07:40 josef_moravec ashimema: hope i can do anything with that...
07:40 josef_moravec something ;)
07:41 ashimema What do you think on that one.. we weren't sure whether to remove proccode completely, re-use it populating it with accountline_id or replace it with a new more appropriately named field.. I'm not close enough to how stats are used to really comment
07:41 ashimema Maybe we need caits or someone to input?  The coding shouldn't be too involved really I shouldn't think
07:42 josef_moravec I thought about it, i remember, we had problem to create useful accounting reports before account_offsets and never made it working on top of statistics and accountlines
07:43 josef_moravec now we are using accountlines and account_offsets, and it works great, especially when there is branchcode in accountlines
07:43 josef_moravec so I don't think proccode is really useful
07:44 andreashm joined #koha
07:44 reiveune joined #koha
07:45 reiveune hello
07:51 AndrewIsh josef_moravec:  Awesome, thanks. I rebased after your request, so it should be good to go now :)
07:51 andreashm joined #koha
07:51 AndrewIsh josef_moravec:  It was bug 18837 in case you forgot ;-)
07:51 huginn` Bug http://bugs.koha-community.org[…]_bug.cgi?id=18837 enhancement, P5 - low, ---, andrew.isherwood, Signed Off , Add an unmediated Interlibrary Loans workflow
07:52 josef_moravec AndrewIsh: thanks
07:53 laurence joined #koha
07:58 alex_a joined #koha
07:59 alex_a bonjour
07:59 * ashimema takes a quick scan of the reports library to see if proccode is used in any of them
07:59 josef_moravec ashimema++
08:01 josef_moravec ashimema: i thought of some kind of db update, but the combination of proccode and borrowernumber is not unique in statistics table on our production system
08:01 ashimema I'm going to comment
08:01 ashimema I've just fixed my bad rebase and uploaded the results so the tests should now all pass
08:02 josef_moravec ok, i thought it was as you pointed aout in comment 23
08:02 josef_moravec but the question of what to do with statistics.proccode is sill valid
08:02 josef_moravec s/sill/still/
08:03 ashimema yeah.. but I think I'm in agreement with you that removing is sensible now
08:03 ashimema proccode isn't mentioned in any of the reports in the wiki which makes me think no-one has ever made it work nicely
08:04 ashimema I don't think we could migrate it to accountline_id (for the reasons you outline above)
08:04 josef_moravec ashimema: yes, it is imposible to migrate here
08:04 josef_moravec i think we should remove the statistics.proccode field too
08:04 ashimema and adding accountline_id going forward may be useful, but could go into it's own bug in my opinion.. and I'm not sure how usefull it will be.. you've already got other data which you could use to work backwards to accounts maybe?
08:05 ashimema I agree.. that is missing still
08:05 josef_moravec yes, we could do it on separate bug
08:08 ashimema want me to add the db update to nuke it from the table?
08:08 josef_moravec I could do it
08:08 ashimema I'm happy to do so whilst I have the branch checked out.. then you can switch back to ILL..
08:09 josef_moravec ok, ashimema, so do it, thanks!
08:09 ashimema :)
08:09 ashimema thanks for the chat.. certainly helped clarify it in my head :)
08:10 josef_moravec ashimema: it is always great to disscus such things
08:12 josef_moravec ashimema++
08:13 magnuse well this is weird. i upgraded a site from 3.18.x to 18.11.03. between 16.06.00.013 and 16.06.00.014 the upgrade process lost contact with the db and the server was unresponsive for a while, but then i mnaged a reboot, and the db upgrade seemed to pick up where it left off, without any errors.
08:13 magnuse but now search does not work
08:13 magnuse reindexing happens without any complaints
08:13 ashimema odd
08:14 ashimema even more odd
08:14 magnuse in the intranet it shows the number of hits and the facets, but not the actual records
08:14 cait joined #koha
08:14 magnuse errors are:
08:14 magnuse ERROR DECODING RECORD - Empty String at /usr/share/perl5/MARC/File/XML.pm line 448.: /usr/share/koha/intranet/c​gi-bin/catalogue/search.pl
08:14 ashimema that worries me.. hope I've not introduced a bug in 18.11.03 of that magnitude
08:14 cait left #koha
08:14 magnuse search.pl: :  at /usr/share/koha/lib/C4/Search.pm line 1934.: /usr/share/koha/intranet/c​gi-bin/catalogue/search.pl
08:15 paul_p joined #koha
08:15 magnuse i have other 18.11.03 without that problem
08:15 magnuse marcflavour is normarc (shudder) and all configs seem to be for normarc, so it's not that
08:16 * ashimema sighs in relief..
08:16 magnuse biblio_metadata.metadata has the records as expected
08:16 ashimema but that doesn't help you.. sorry
08:16 magnuse hehe
08:16 ashimema that's really wierd.. I wonder what's going on
08:17 ashimema I would have expected the rebuild to complain if there was some data corruption
08:18 magnuse yup, me too
08:19 magnuse and different searches show different number of hits
08:19 magnuse ...and facets
08:19 magnuse so it seems the indexer gets the records and prcesses them, but does not return them
08:20 magnuse detail view works, but that is from the db
08:21 ere magnuse: Zebra?
08:21 magnuse yup, not es
08:21 * ere sighs in relief..
08:21 ashimema hehe
08:21 ashimema lots of that going around ere ;)
08:21 ere :D
08:28 Stompro joined #koha
08:40 magnuse when i try to do "yaz-client -c /etc/koha/zebradb/ccl.properties unix:/var/run/koha/$instance/bibliosocket" i get "Connecting...OK." and then "Segmentation fault"
08:41 ribasushi joined #koha
08:45 magnuse /var/log/koha/koha/zebra-output.log has lots of "zebrasrv(138) [warn] ir_session (exception)"
08:48 cait joined #koha
08:49 magnuse reboot the server and now it works...
08:50 ashimema what...
08:50 ashimema how strange
08:50 ashimema glad it's working again though
08:52 magnuse yeah
08:52 koha-jenkins Project Koha_17.11_D8 build #151: SUCCESS in 29 min: https://jenkins.koha-community[…]oha_17.11_D8/151/
08:53 * cait waves
08:53 tuxayo o/
08:53 josef_moravec hi cait
08:54 cait hi josef_moravec :)
08:54 cait also josef_moravec++ and ashimema++ and fridolin++
08:54 magnuse yeah josef_moravec++ and ashimema++ fridolin++
08:54 * ashimema will be jumping back on the qa train later today
08:55 gveranis joined #koha
08:55 fridolin thanks a lot
08:55 gveranis hi koha
08:55 fridolin hi gveranis
08:56 gveranis I would like to ask something for misc/migration_tools/switch_marc21_series_info.pl
08:56 alexbuckley joined #koha
08:56 gveranis when running this script change kohafield to seriestitle
08:56 * fridolin i did not know this script exists
08:56 gveranis maybe the right one is biblio.seriestitle
08:56 gveranis oh ok!
08:57 gveranis this script it to change 440 to 490
08:57 gveranis because 440 is obsolete from 2008..
08:57 gveranis but it is on default installation on Koha
08:57 cait josef_moravec: the first patch for bug 18837 doesn't look right - has the other pref in it.
08:57 huginn` Bug http://bugs.koha-community.org[…]_bug.cgi?id=18837 enhancement, P5 - low, ---, andrew.isherwood, Failed QA , Add an unmediated Interlibrary Loans workflow
08:58 cait gveranis: which version of Koha re you using?
08:58 gveranis 18.05
08:58 gveranis and 18.11 also
08:59 gveranis Marc21
08:59 josef_moravec cait: I know, I asked Andrewish to do something with that ;)
08:59 cait ah sorry, just took a quick look :)
08:59 cait not much in the patch, i guess most is in the backend
08:59 AndrewIsh Looking into it now
08:59 AndrewIsh It's somehow leaked in from another bug, I'm digging!
09:00 cait gveranis: it looks like the script was updated to the new db structure at least
09:00 cait using biblio_metadata
09:00 cait but i have also never used it
09:00 gveranis yes it use the new db structure but the kohafield is not the new one..
09:01 cait what do you mean?
09:01 wahanui hmmm... do you mean is reserves.tt the only place where a hold gets placed?
09:01 gveranis it should update to biblio.seriestitle and not to seriestitle
09:02 josef_moravec cait, AndrewIsh: so it is from bug 20639, which is pushed for 19.05, but "git grep ILLOpacbackends" on master does not return anything...
09:02 huginn` Bug http://bugs.koha-community.org[…]_bug.cgi?id=20639 enhancement, P5 - low, ---, andrew.isherwood, RESOLVED FIXED, Allow setting a default/single backend for OPAC driven requests
09:02 AndrewIsh josef_moravec:  I just found that too, there's no sign of the 20639 patches in master :-/
09:03 cait ugh
09:03 cait kidclamp: ?
09:03 josef_moravec git log --oneline | grep "Bug 20639" return only: 986d551ac4 Bug 20639: DBRev 18.12.00.016
09:03 AndrewIsh josef_moravec:  Yep
09:04 AndrewIsh In the meantime, I'll remove the offending bits from 18837, they shouldn't be there anyway
09:04 cait gveranis: you are right
09:04 gveranis thanks cait
09:04 cait UPDATE marc_subfield_structure SET kohafield='seriestitle' - it's missing the table name
09:04 cait could you file a bug for that?
09:05 josef_moravec @later tell kidclamp: There is something wrong with Bug 20639, should be in master, but it is not
09:05 huginn` josef_moravec: The operation succeeded.
09:05 gveranis I will try it
09:06 AndrewIsh josef_moravec:  I can't believe I didn't notice this when I was rebasing yesterday, sorry :(
09:07 josef_moravec AndrewIsh: no problem, that's why we are team, nobody can notice everything by self ;)
09:07 AndrewIsh josef_moravec:  :)
09:10 cait josef_moravec++ :)
09:10 gveranis https://bugs.koha-community.or[…]_bug.cgi?id=22470
09:10 huginn` Bug 22470: minor, P5 - low, ---, koha-bugs, NEW , Missing the table name on misc/migration_tools/switch_marc21_series_info.pl
09:10 cait if i knew how to add quotes, I'd add that one
09:11 ashimema sure I saw eythian this morning
09:11 ashimema he could tell us how to add quotes
09:11 ashimema huginn`: help
09:11 huginn` ashimema: (help [<plugin>] [<command>]) -- This command gives a useful description of what <command> does. <plugin> is only necessary if the command is in more than one plugin. You may also want to use the 'list' command to list all available plugins and commands.
09:14 calire1 joined #koha
09:16 ashimema we can't cait.. we need to be registered with huggin
09:16 ashimema I just tried
09:16 ashimema pm huggin` with `list quote` and it'll tell you how the command works
09:16 eythian yeah, you need to register
09:17 * ashimema now asks huggin how to register..
09:17 eythian if you poke huginn` in the right way, he'll give you help about how to do things.
09:17 cait i used to... but i think i forgot my password
09:17 cait how do you sign in with huginn?
09:18 * ashimema is pm'ing huggin to save on channel chatter
09:19 indradg_ joined #koha
09:21 ashimema Quote #335
09:21 ashimema quote #335
09:22 cait quote add  josef_moravec: ... no problem, that's why we are team, nobody can notice everything by self ;)
09:22 ashimema hmm..
09:22 ashimema well I've registered and added the quote
09:22 cait quote #336
09:22 cait @quote #366
09:22 huginn` cait: I've exhausted my database of quotes
09:22 ashimema but how do I retrieve it
09:22 cait @quote get 336
09:22 huginn` cait: Quote #336: "josef_moravec: ... no problem, that's why we are team, nobody can notice everything by self ;)" (added by cait at 09:22 AM, March 07, 2019)
09:22 cait muahahaha
09:23 ashimema lol
09:23 tuxayo @quote get 336
09:23 huginn` tuxayo: Quote #336: "josef_moravec: ... no problem, that's why we are team, nobody can notice everything by self ;)" (added by cait at 09:22 AM, March 07, 2019)
09:23 ashimema ok.. it's in there twice
09:23 cait sorry, it got into my head a little :)
09:23 josef_moravec O:-)
09:23 ashimema how come we have huggin` and huggin btw?
09:23 cait ah.... doesn't hurt
09:24 cait gveranis++
09:24 gveranis ;)
09:26 indradg joined #koha
09:27 mohammed joined #koha
09:31 tuxayo oh you had it cait , thanks, I was searching in the IRC logs ^^"
09:32 tuxayo (how to use quotes)
09:32 cait the difficult part was remembering the right password
09:44 andreashm joined #koha
09:45 indradg joined #koha
10:02 indradg_ joined #koha
10:10 indradg joined #koha
10:13 laurence joined #koha
10:17 indradg_ joined #koha
10:23 indradg joined #koha
10:24 ribasushi joined #koha
10:29 indradg_ joined #koha
10:38 marcelr joined #koha
10:40 indradg joined #koha
10:49 indradg_ joined #koha
10:52 gveranis_ joined #koha
11:06 indradg joined #koha
11:12 indradg_ joined #koha
11:17 rkrimme1 joined #koha
11:19 khall joined #koha
11:23 remy_prebs joined #koha
11:26 rkrimme1 Hi, I followed this documentation to get ILL working https://wiki.koha-community.org/wiki/ILL_backends. I configured the koha-conf.xml regarding to the documentation (also adding a <branch></branch> tag but koha insists that there is no branch entry present.
11:26 rkrimme1 Any ideass?
11:28 andreashm joined #koha
11:29 * andreashm waves
11:35 ribasushi joined #koha
11:56 magnuse rkrimme1: i *think* it should be <branch><code></code></branch>
11:57 magnuse at least that is what AndrewIsh told me a while back. but i did not get around to investigate further
11:59 fridolin rkrimme1: did you flush memcached ?
12:03 magnuse can't hurt :-)
12:04 magnuse and yeah, i think you have to, for changes to koha-conf.xml to be picked up
12:12 * eythian thinks that a cached koha-conf should be keyed with the modification time of the actual file, so that if it is altered, the cache is automatically invalidated.
12:12 ashimema nice idea
12:13 ashimema fancy adding a bug for it and if you don't have time to do anything on it adding me to the cc list or as assignee eythian?
12:13 * ashimema is right in the middle of something himself
12:14 eythian there is pretty much no chance I'll be able to do anything about it myself, can make you a bug though :)
12:15 ashimema thanks.. didn't think you'd have much OSS tuits, but a bug report with the idea would be awesome.. i'll try and attack it as soon as I get a moment.. it's a great idea
12:17 Joubu I do not think Koha should access the file to know if it has been modified (which should be needed for each request)
12:17 eythian Joubu: why?
12:17 eythian (also, it wouldn't have to.)
12:17 eythian it would just check the inode
12:17 eythian which is super cheap as it'll be in OS disk cache.
12:18 Joubu better would be to use inotify
12:18 eythian that's a lot more plumbing for very little gain I'd expect.
12:19 eythian running a stat() on a file should be very quick
12:20 Joubu I do not think it's that trivial :) When do you do that? in psgi?
12:20 eythian it's much, much cheaper than, say, accessing a database.
12:21 eythian which has to do all of that anyway, and more.
12:22 eythian I'd expect that it totals up to significantly less time than admin confusion delays caused by not doing it.
12:22 Joubu I think it's a great idea to automatize the restart, but sounds easier to do it outside of Koha
12:22 Joubu sounds like a sysop task
12:23 eythian you don't need to restart anything, you're just invalidating a small part of your cache.
12:23 eythian this way, you're doing it with no extra processes needed.
12:24 rkrimme1 fridolin: after enabling? no. Thank you, nice hint.
12:24 fridolin all koha-conf.xml is in memcached
12:24 josef_moravec https://superuser.com/question[…]nges-any-file-ins
12:24 rkrimme1 magnuse: yes, after reading config.pm in the Illrequests dir it looks like it's missing a <code> tag in the documentation
12:25 Joubu eythian: maybe, we should give it a go and try it. However it seems a good habit for people to restart the cache when something is going wrong. Where are caching other things that would need a restart
12:25 Joubu xslt, syspref modified in DB, etc.
12:26 eythian Joubu: I think it's better to have your caching be better so that it's invalidated correctly more often.
12:26 eythian caches should be as transparent as possible.
12:26 ashimema db modifications shuold invalidate the cache key too though
12:26 ashimema that's also a bug in my opinion
12:26 ashimema eythian++
12:26 ashimema I totally agree
12:26 eythian well, a direct db modification I can see not being picked up. But that can be eased by having cache values expire after a few minutes.
12:26 Joubu ashimema: how do you do that?
12:27 eythian so at least it'll be eventually consistent.
12:27 ashimema so the files that are cached are a little harder to invalidate
12:27 ashimema how do we do what>
12:27 ashimema invalidate a cache key when a syspref is changed?
12:28 Joubu "db modifications shuold invalidate the cache key"
12:28 * ashimema hasn't recently enough looked at our caching code.. but always found it super easy when he was developing rebus:list with CHI
12:28 Joubu ours is not super easy
12:29 ashimema well if someone goes ahead and changes it behind the scenes on the server without going via the koha UI (or api when that becomes available) we can't easily.. which is what eythian just got at
12:29 ashimema but if they're changing sysprefs 'the normal way' then it should be trivial
12:29 ashimema if it's not then it's a bug in our caching code in my opinion
12:29 Joubu we do that already
12:29 rkrimme1 magnuse: the <code></code> tag seems not to be necessary, although i don't understand why
12:30 Joubu ashimema: will you open a bug report? I'd like to investigate eythian's idea
12:32 ashimema as I say.. I've not read our caching code recently
12:33 eythian Joubu: I already made one and CCed you on it
12:33 ashimema brill, tanks
12:33 Joubu eythian: thanks!
12:35 ashimema so when I used CHI I pretty much always used 'compute' so I could combined get and set automagically and I used the 'expire($key)' call whenever I needed to on db updates for example
12:35 oleonard joined #koha
12:35 ashimema that way the next call to 'get' (or in my case compute) would always either refetch it and set the cache or get from the cache if there had been no expire.. I also set my expire times to never
12:36 ashimema that's kinda just how I expected koha to work having not looked at the code ;0
12:36 oleonard Hi all
12:36 eythian I'm always sceptical of setting anything cache to 'never expire'
12:36 ashimema yeah.. I kinda agree
12:36 eythian I think that never should really mean "random time between 15 and 45 minutes" or similar.
12:37 oleonard "Keep these cookies forever, I would like to build a lifelong relationship with your brand!"
12:37 ashimema as you say.. things can change in ways you're not expecting.. but a long cache lifetime isn't terrible if you're catching it 99% of the time
12:37 ashimema sounds fair to me eythian
12:38 * ashimema gets back to fixing his failing tests
12:38 Joubu I have to run, see you later #koha
12:41 calire hi oleonard
12:41 wahanui hi oleopard
12:47 andreashm joined #koha
12:48 eythian https://github.com/nerdgeneration/www.sh time for you all to rewrite Koha ... in bash.
12:53 alex_a joined #koha
13:05 magnuse great idea, eythian!
13:06 eythian the bash one? No it's not, it's terrible!
13:07 andreashm joined #koha
13:09 oleonard Slow down y'all I'm *almost* done with my rewrite of Koha in ColdFusion
13:10 magnuse oleonard++
13:11 magnuse eythian: the second commit says it's just a stupid idea, not terrible?
13:12 josef_moravec Next step is to rewrite Koha into Whitespace language :D
13:14 josef_moravec or this: https://esolangs.org/wiki/ook!
13:16 * oleonard wonders how many flamewars are being carried out in the history of the "Joke language list" page
13:16 * andreashm wonders what discussion he just stepped into... slowly backs away.
13:17 eythian josef_moravec: doable already: https://metacpan.org/pod/Acme::Bleach
13:18 josef_moravec eythian: I didn't expect thad :D
13:25 josef_moravec I have to go, by all
13:26 oleonard See ya josef_moravec
13:31 oleonard cait: I had an in-progress branch where I was working on Bug 7133, so I'll get back to it
13:31 huginn` Bug http://bugs.koha-community.org[…]w_bug.cgi?id=7133 enhancement, P5 - low, ---, oleonard, NEW , Received items should stand out more
13:32 oleonard cait: I probably asked this before: Would it make sense to have "received" in its own column?
13:33 oleonard https://screenshots.firefox.co[…]f.mylocalkoha.org
13:36 oleonard Or anyone else with acquisitions opinions? ^^
13:39 Dyrcona joined #koha
14:01 Freddy_Enrique joined #koha
14:14 kidclamp morning
14:14 andreashm hi kidclamp
14:14 oleonard Hi kidclamp
14:15 calire hullo kidclamp
14:45 oleonard Is there a reason why the patron entry form doesn't use the French address format include files?
14:47 oleonard Maybe a regression...
14:55 oleonard @later tell Joubu Ping me when you get a moment please
14:55 huginn` oleonard: The operation succeeded.
14:56 gveranis joined #koha
14:56 alex_a joined #koha
15:01 wizzyrea joined #koha
15:02 oleonard Hi wizzyrea
15:11 fridolin1 joined #koha
15:12 wizzyrea hallo
15:12 Scott-CSPL joined #koha
15:12 wizzyrea how are we this fine morning
15:12 deb-CSPL joined #koha
15:13 * oleonard whispers very quiet
15:13 calire left #koha
15:14 eythian ah, oleopard is hungover eh.
15:15 oleonard It wasn't a request, it was a description!
15:16 wizzyrea hehehehehehe
15:16 wizzyrea oleonard, you have any pets you're keen for signoff on?
15:16 wizzyrea pet bugs
15:16 wizzyrea (afk coffee)
15:16 kidclamp poor oleonard, he sees our bad design in developments, he has no choice but to drink
15:16 wizzyrea (to give you time to think)
15:16 wizzyrea (and/or drink)
15:17 * cait feels like she missed out on lots toda
15:17 cait y
15:18 oleonard wizzyrea: How can I choose one from all my precious children?
15:18 andreashm =)
15:19 oleonard wizzyrea: How about Bug 21943?
15:19 huginn` Bug http://bugs.koha-community.org[…]_bug.cgi?id=21943 enhancement, P5 - low, ---, oleonard, Needs Signoff , Clean up holds template
15:20 oleonard wizzyrea++
15:21 mifantrax joined #koha
15:24 mifantrax Hi all, i could benefit from some help, i am pretty new to koha administration, i updated a koha installation from 3.2 to 16.05, then 17.05 then 18.11, it was not working another way. Everything seems to be working however i have my first error that i have no clue how to deal with
15:24 mifantrax DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column 'created_on' in 'field list' at /usr/share/koha/lib/Koha/Object.pm line 155
15:24 mifantrax could anyone point me in the correct direction?
15:25 mifantrax The error shows up when i want to create a list
15:26 wizzyrea mifantrax, you may want to rerun the updatedatabase
15:26 wizzyrea but maybe not
15:26 oleonard That was my first thought as well wizzyrea
15:26 mifantrax i did rerun  koha-upgrade-schema tcmii
15:27 mifantrax koha-upgrade-schema
15:27 wizzyrea hm
15:27 wizzyrea an error like that is almost always that there is a slip up in the upgrade chain somewhere
15:28 ashimema fancy taking a look at bug 7088 at any point oleonard.. could do with a UX eye on it as everyone involved seems to just want something different
15:28 huginn` Bug http://bugs.koha-community.org[…]w_bug.cgi?id=7088 enhancement, P5 - low, ---, andrew.isherwood, Failed QA , Cannot renew items on hold even with override
15:28 ashimema we can't rework it any more in reality.. we're already over spent
15:28 wizzyrea right
15:28 wizzyrea that one
15:30 oleonard I'd be happy to take a look ashimema
15:30 wizzyrea I think it could go in the way it is but I stand by how ambiguous the 2nd date picker is.
15:31 ashimema I 'think' at this point it's just the UX side that people are not in total agreement with.. hense my asking
15:31 wizzyrea it is :)
15:31 wizzyrea mifantrax, you could have a look at the schema for 18.11 for the table lists
15:31 wizzyrea or virtualshelves I guess it is
15:32 wizzyrea and compare it to what you've got in your DB
15:32 wizzyrea or you could go look through the updatedatabase.pl script
15:32 wizzyrea find the update that was supposed to run it
15:32 wizzyrea supposed to insert that column
15:32 wizzyrea pick out the sql for it and any associated actions that need to be done, and run them independently
15:33 wizzyrea and see what if any errors pop out
15:34 amso joined #koha
15:34 amso i have problem with koha18.05 item check in
15:35 deb-CSPL joined #koha
15:35 Scott-CSPL joined #koha
15:35 wizzyrea what kind of a problem asmo
15:36 amso The item has not been checked in due to a configuration issue in your system. You must ask an administrator to take a look at the about page and search for the "data problems" section
15:36 mifantrax thank you for the suggestion i will look into that
15:36 wizzyrea https://wiki.koha-community.or[…]uto_increment_fix you need this
15:36 wizzyrea asmo
15:36 amso Problems found Checkouts  The following ids exist in both tables issues and old_issues:  1  XML configuration file Warning You are missing the <tmp_path> entry in your koha-conf.xml file. Please add it, pointing to the configured temporary directory for your Koha instance. The effective temporary directory is '/tmp'.
15:37 wizzyrea the thing about /tmp isn't related to your checkin problem
15:37 wizzyrea so you'll want to fix it but you don't need to to fix your checkin problem
15:37 amso but how it happen
15:37 wizzyrea when mysql restarts, it resets the counters on tables
15:38 eythian my god that bug is horrific
15:38 wizzyrea yes it's not a good one
15:38 amso how to reset mysql
15:38 wizzyrea no
15:38 wizzyrea click that link
15:38 wizzyrea it tells you how to fix it
15:38 wizzyrea then upgrade to a version that doesn't have the bug
15:38 wizzyrea or probably you have done that, and now it's telling you there's a problem
15:38 amso yes im wairting
15:39 amso which link sir
15:40 wizzyrea https://wiki.koha-community.or[…]uto_increment_fix
15:40 wizzyrea ^ this one
15:40 amso ok
15:41 alex_a_ joined #koha
15:42 cait how many records is marcedit good for? asking for a friend...
15:43 cait ok, asking for me and it looks like this file might be too big
15:43 andreashm cait: haha
15:43 Scott-CSPL joined #koha
15:44 deb-CSPL joined #koha
15:44 wizzyrea well I had trouble with files of over 40k records
15:45 wizzyrea it would just, not to be rude, it pooped itself
15:46 * eythian always preferred scripts. More reproducable.
15:46 cait hm look slike it might be the case
15:46 cait i was hoping to use some of the marcedit checks on an export file
15:46 cait probably have to cut it down then, thx!
15:48 * oleonard hears wizzyrea and tsks dramatically
15:51 wizzyrea eythian, I completely feel that, also scripts work well with enormous files
15:52 wizzyrea there were a few times where I just wanted to look at a thing and marcedit is pretty convenient for that
15:56 cait I also agree, I waslooking for something quick and dirty
15:57 * oleonard hears cait and tsks dramatically
16:13 tuxayo https://en.wiktionary.org/wiki/tsk
16:13 tuxayo «An exclamation of disapproval, disappointment or discontent.»
16:13 cait oleonard: new community role.... looking out for good manners and language? :)
16:14 * tuxayo laughs and is amazed by the fact that it's in Wiktionary
16:14 cait oleonard: did you see the bug about rcvd I cc'd you on? I think that would make a great 51st branch :)
16:14 eythian In Danish, however, tsk: 1. Alternative form of tsk.
16:14 eythian what are those Danes doing to their language.
16:14 eythian hi magnuse
16:14 oleonard cait: I commented above... In fact two of those 50 branches were versions of that
16:14 eythian oh wahanui doesn't know that one any more :(
16:15 oleonard "cait: I probably asked this before: Would it make sense to have "received" in its own column?"
16:15 oleonard https://screenshots.firefox.co[…]f.mylocalkoha.org
16:15 cait oleonard: I think a number doesn't make sense
16:16 cait if it is partial, there is a second line
16:16 tuxayo eythian: « tsk: 1. Alternative form of tsk.» hum, indeed I don't get it
16:16 cait so it's basically a yes or no thing
16:16 cait I think having it at the beginning of the line makes sense to me, i'd move the column maybe - we could maybe get away using an icon?
16:16 cait also with records now not necessarily having items it gets quite difficult with numbers :)
16:17 cait maybe received yes/now
16:17 cait no
16:17 cait or the date receives
16:17 oleonard Okay cool. I depend on actual acquisitions users for these things!
16:17 cait date received (sorry, I really can't type today)
16:17 cait a column would make it nicely sortable... i like that
16:18 cait to easily find out what was not received yet of a basket
16:18 cait wizzyrea: what do you think?
16:22 fridolin1 left #koha
16:24 wizzyrea cait I'll need to have a look :)
16:25 wizzyrea my computer is being very extremely cranky and I'm trying to find out why
16:27 alex_a joined #koha
16:38 lukeG1 joined #koha
16:46 AndrewIsh oleonard:  Re: Bug 7088 - the date picker should be hidden initially, you need to rebuild your CSS
16:46 huginn` Bug http://bugs.koha-community.org[…]w_bug.cgi?id=7088 enhancement, P5 - low, ---, andrew.isherwood, Failed QA , Cannot renew items on hold even with override
16:46 AndrewIsh oleonard:  Thanks for the feedback btw :)
16:46 oleonard Oh of course, sorry for the noice AndrewIsh
16:47 AndrewIsh No problemo - I've been caught by that too many times to mention
16:57 laurence left #koha
17:06 wizzyrea oleonard, yes that label would be better I reckon
17:12 wizzyrea oleonard, on 21943 with a little alert such as "pick up branch is different to users home branch" the phone size doesn't seem to go properly
17:12 wizzyrea bug 21943
17:12 huginn` Bug http://bugs.koha-community.org[…]_bug.cgi?id=21943 enhancement, P5 - low, ---, oleonard, Needs Signoff , Clean up holds template
17:12 wizzyrea the z indexes seem funny
17:13 wizzyrea actually, it's funny even without the message
17:14 wizzyrea no actually it's that sidebar that's gone wrong anyway it's not right sorry :(
17:15 oleonard Thanks wizzyrea I'll take another look
17:18 oleonard Haha that screenshot is definitely problematic!
17:20 wizzyrea does it do the same for you?
17:21 oleonard yes
17:21 wizzyrea maybe I didn't do something
17:21 wizzyrea oh good
17:21 wizzyrea i mean bad but good
17:21 wizzyrea alright, i'm heading away for a while
17:30 reiveune bye
17:30 reiveune left #koha
17:35 andreashm joined #koha
17:37 huginn` News from kohagit: Bug 20912: DBRev 18.12.00.021 <http://git.koha-community.org/[…]6be7db76f0e0b4171>
17:37 huginn` News from kohagit: Bug 20912: (QA follow-up) Add on_editing to $Price filter <http://git.koha-community.org/[…]28fab29b3a8540e3c>
17:37 huginn` News from kohagit: Bug 20912: (QA follow-up) Rebase error corrections <http://git.koha-community.org/[…]cb6de0bf2603ad0dd>
17:37 huginn` News from kohagit: Bug 20912: (QA follow-up) Warn patron of daily and hourly renewal fees <http://git.koha-community.org/[…]1f80bd5a21f2017a5>
17:37 huginn` News from kohagit: Bug 20912: (follow-up) Prevent double charging on renewal <http://git.koha-community.org/[…]77b1225f858b0d1c6>
17:37 huginn` News from kohagit: Bug 20912: (QA follow-up) The default rule already has renewalsallowed=0 <http://git.koha-community.org/[…]3a8249f8a75c14713>
17:37 huginn` News from kohagit: Bug 20912: (QA follow-up) POD fix <http://git.koha-community.org/[…]65e2de51239a55942>
17:37 huginn` News from kohagit: Bug 20912: (QA follow-up) Fix some test failures <http://git.koha-community.org/[…]4869c74d5aa3241c1>
17:37 huginn` News from kohagit: Bug 20912: (QA follow-up) Fix TestBuilder <http://git.koha-community.org/[…]73ca0ae68a4815308>
17:37 huginn` News from kohagit: Bug 20912: (follow-up) Add hourly support <http://git.koha-community.org/[…]278822c7667fcc4c7>
17:37 huginn` News from kohagit: Bug 20912: (follow-up) Improve test coverage <http://git.koha-community.org/[…]72f7e637fc9310fe0>
17:37 huginn` News from kohagit: Bug 20912: (QA follow-up) Make DB Update idempotent <http://git.koha-community.org/[…]f783a8b0be530e929>
17:37 huginn` News from kohagit: Bug 20912: (QA follow-up) Test for distinct accountlines <http://git.koha-community.org/[…]642c4b1c5c3b55c6a>
17:37 huginn` News from kohagit: Bug 20912: (QA follow-up) Move Fees to Charges:: <http://git.koha-community.org/[…]7d1d2991e4abbb7f9>
17:37 huginn` News from kohagit: Bug 20912: (QA follow-up): Fix up unit tests <http://git.koha-community.org/[…]a31609c75fd3e3b92>
17:37 huginn` News from kohagit: Bug 20912: (QA follow-up): Fix up Koha::Fees <http://git.koha-community.org/[…]e0fe5c3bf7c2a2d8e>
17:38 huginn` News from kohagit: Bug 20912: Move calculation to Koha::Fees <http://git.koha-community.org/[…]785a033decd7deea2>
17:38 huginn` News from kohagit: Bug 20912: (QA follow-up) Make unit tests reliable and get rid of perl warnings <http://git.koha-community.org/[…]83c3bf011ddec4835>
17:38 huginn` News from kohagit: Bug 20912: (QA follow-up) Set daily charge to 0 for item type not being used for... <http://git.koha-community.org/[…]bbfe03739c6859130>
17:38 huginn` News from kohagit: Bug 20912: (QA follow-up) Fix number of tests and correct typos <http://git.koha-community.org/[…]c0ee0945282a74669>
17:39 cait bye all bbl
18:05 koha-jenkins Project Koha_Master_D9 build #673: STILL UNSTABLE in 26 min: https://jenkins.koha-community[…]ha_Master_D9/673/
18:10 andreashm joined #koha
18:11 koha-jenkins Project Koha_Master_U18 build #164: STILL UNSTABLE in 31 min: https://jenkins.koha-community[…]a_Master_U18/164/
18:13 koha-jenkins Project Koha_Master_D8 build #181: STILL UNSTABLE in 35 min: https://jenkins.koha-community[…]ha_Master_D8/181/
18:18 huginn` News from kohagit: Bug 22466: Replace existing occurrences <http://git.koha-community.org/[…]b1436b162dd1559da>
18:18 huginn` News from kohagit: Bug 22466: Do not ask for TT methods to be filtered <http://git.koha-community.org/[…]73ca70395fdb398e1>
18:18 huginn` News from kohagit: Bug 22466: Add tests <http://git.koha-community.org/[…]15fe9d6379f6f62b2>
18:46 koha-jenkins Yippee, build fixed!
18:46 koha-jenkins Project Koha_Master_D9 build #674: FIXED in 27 min: https://jenkins.koha-community[…]ha_Master_D9/674/
18:51 koha-jenkins Project Koha_Master_U18 build #165: STILL UNSTABLE in 31 min: https://jenkins.koha-community[…]a_Master_U18/165/
18:53 koha-jenkins Project Koha_Master_D8 build #182: STILL UNSTABLE in 35 min: https://jenkins.koha-community[…]ha_Master_D8/182/
19:00 cait joined #koha
19:03 andreashm joined #koha
19:19 StomproJ joined #koha
19:31 alexbuckley joined #koha
19:48 alexbuckley joined #koha
19:59 oleonard Bye all
20:06 andreashm joined #koha
20:07 * andreashm waves
20:10 andreashm joined #koha
20:55 kathryn joined #koha
21:04 wizzyrea hi kathryn
21:05 kathryn hi hi wizzyrea :)
21:10 rangi hi wizzyrea
21:11 wizzyrea hi rangi!
21:11 wizzyrea you never come or go so I don't ever say hi lol
21:11 rangi hehe
21:11 kathryn he just is
21:11 wizzyrea and now I have to run away to fetch my sproggen from school
21:11 wizzyrea boy ain't that the truth
21:12 wizzyrea "it's rangi, he just is."
21:12 wizzyrea <3
21:12 wizzyrea bbiab
21:12 kathryn hi to soren from me :)
21:12 wizzyrea will do :D
21:20 huginn` News from kohagit: Bug 20639: DBRev 18.12.00.023 <http://git.koha-community.org/[…]81aebf91b1ed01b33>
21:20 huginn` News from kohagit: Bug 15774: DBRev 18.12.00.022 <http://git.koha-community.org/[…]3ef7278aed1733e25>
21:20 huginn` News from kohagit: Bug 16251: Fix value of material select for Rancor 008 widget <http://git.koha-community.org/[…]ec4b2dc71d864b64c>
21:20 huginn` News from kohagit: Bug 22419: Records listed twice when select/unselect all from the cart <http://git.koha-community.org/[…]b7d86f4ac2fea9e03>
21:20 huginn` News from kohagit: Bug 22416: (bug 22140 follow-up) Remove warnings in Search.t <http://git.koha-community.org/[…]cf31daeae8bc5720b>
21:20 huginn` News from kohagit: Bug 15774: (QA follow-up) Remove asset of datables.css, and corresponding plugins <http://git.koha-community.org/[…]b87cbee75cd14f166>
21:20 huginn` News from kohagit: Bug 15774: (QA follow-up) Fix use statemenets <http://git.koha-community.org/[…]ef35a7ec53a000586>
21:20 huginn` News from kohagit: Bug 15774: (follow-up) fix rebase issues <http://git.koha-community.org/[…]77dc946f0f1c21e20>
21:20 huginn` News from kohagit: Bug 22275: (bug 15836 follow-up) Fix class_sources.class_split_rule FK creation <http://git.koha-community.org/[…]dd79a5b3a64721ae6>
21:20 huginn` News from kohagit: Bug 22303: Correct bottom in virtualshelves/addbybiblionumber.tt <http://git.koha-community.org/[…]2fea12619bb851f70>
21:20 huginn` News from kohagit: Bug 20639: (QA follow-up) Rephrase system preference <http://git.koha-community.org/[…]dbbbf4ae9eee4267e>
21:20 huginn` News from kohagit: Bug 22246: Fix indexing of large fields with Elasticsearch <http://git.koha-community.org/[…]5f4aa03342809cb9f>
21:20 huginn` News from kohagit: Bug 22031: Add SQL::Abstract like syntax to haspermission <http://git.koha-community.org/[…]8254819b04a5287c3>
21:20 huginn` News from kohagit: Bug 15774: Add permission for managing additional fields <http://git.koha-community.org/[…]4ee22243aeb44848d>
21:20 huginn` News from kohagit: Bug 15774: Remove unecessary returned value for ->delete <http://git.koha-community.org/[…]b7efd75306e9a2e12>
21:20 huginn` News from kohagit: Bug 15774: Do not fetch additional fields from GetSubscription <http://git.koha-community.org/[…]4f762e3e9c95a22db>
21:20 huginn` News from kohagit: Bug 15774: Fix and unify additional_fields in C4::Serials <http://git.koha-community.org/[…]d018081ed62fbab05>
21:20 huginn` News from kohagit: Bug 20639: (follow-up) Fix population of backends <http://git.koha-community.org/[…]b6415d20929b6a66b>
21:20 huginn` News from kohagit: Bug 20639: Add ILLOpacbackends syspref <http://git.koha-community.org/[…]1e9edee3a6eb88087>
21:20 huginn` News from kohagit: Bug 20535: ModZebra called with $record with items stripped <http://git.koha-community.org/[…]df2e54ee6d1af148a>
21:21 cait kidclamp++ busy :)
21:22 kidclamp trying to keep up
21:22 kidclamp and ashimema gets bored easily
21:22 ashimema Lol
21:23 ashimema Cheeky bugger
21:23 cait true... have to keep him on his toes
21:23 cait happy about the additional fields to basket one
21:23 cait ... so... where is next for additional fields? :)
21:23 kidclamp yes, me too
21:24 kidclamp bug 11844
21:24 huginn` Bug http://bugs.koha-community.org[…]_bug.cgi?id=11844 new feature, P5 - low, ---, julian.maurice, Patch doesn't apply , Additional fields for order lines
21:24 * ashimema hopes Tomas or Cait gets a chance to QA the accountno bug.. seems Josef and I confused each other there.. would be nice to get a final stamp from a their party
21:24 cait i probably would get confused too
21:24 cait hay fever and life make me pretty tired right now
21:24 cait just glad i am not asleep already :)
21:25 ashimema Hugs for cait
21:26 kidclamp night all!
21:26 cait night kidclamp :)
21:27 koha-jenkins Yippee, build fixed!
21:27 koha-jenkins Project Koha_Master_U18 build #166: FIXED in 31 min: https://jenkins.koha-community[…]a_Master_U18/166/
21:27 cait right on time jenkins
21:28 * ashimema needs to not contact on bugs from a phone..
21:28 cait heh
21:28 ashimema I thought it was the removal on accountno bug I just commented on.. not the manual invoice one..
21:28 ashimema Hadn't realised that one was also missing a SO..
21:28 ashimema Bed time me thinks..
21:28 ashimema Will stack those tomorrow..
21:29 cait :)
21:32 koha-jenkins Yippee, build fixed!
21:32 koha-jenkins Project Koha_Master_D8 build #183: FIXED in 36 min: https://jenkins.koha-community[…]ha_Master_D8/183/
21:44 ashimema Bug 15774
21:44 huginn` Bug http://bugs.koha-community.org[…]_bug.cgi?id=15774 new feature, P5 - low, ---, nick, Pushed by Module Maintainer , Additional fields for baskets
21:44 koha-jenkins Project Koha_Master_D9 build #675: UNSTABLE in 25 min: https://jenkins.koha-community[…]ha_Master_D9/675/
21:44 ashimema Is that status right kidclamp ?
21:45 ashimema 😉
21:58 koha-jenkins Project Koha_Master_U18 build #167: UNSTABLE in 30 min: https://jenkins.koha-community[…]a_Master_U18/167/
21:59 kidclamp Oops
22:07 koha-jenkins Project Koha_Master_D8 build #184: UNSTABLE in 34 min: https://jenkins.koha-community[…]ha_Master_D8/184/
23:05 koha-jenkins Project Koha_18.05_D8 build #226: SUCCESS in 19 min: https://jenkins.koha-community[…]oha_18.05_D8/226/
23:11 koha-jenkins Yippee, build fixed!
23:11 koha-jenkins Project Koha_18.05_D9 build #223: FIXED in 26 min: https://jenkins.koha-community[…]oha_18.05_D9/223/
23:29 koha-jenkins Project Koha_18.05_U18 build #223: SUCCESS in 41 min: https://jenkins.koha-community[…]ha_18.05_U18/223/
23:45 koha-jenkins Project Koha_18.05_D8 build #227: SUCCESS in 19 min: https://jenkins.koha-community[…]oha_18.05_D8/227/
23:45 papa joined #koha
23:49 barton joined #koha
23:51 koha-jenkins Project Koha_18.05_D9 build #224: SUCCESS in 27 min: https://jenkins.koha-community[…]oha_18.05_D9/224/

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