Time Nick Message
00:34 dcook Now to figure out why KohaTable and DataTable are giving me a result with different methods..
00:34 dcook Or rather.. different attributes I guess. Oh.. I wonder..
00:35 dcook Ahh I see
00:35 * dcook curses profusely
00:38 * Francesca is curious
00:38 dcook Meee too heh
00:38 dcook Me being out of touch I'm sure
00:39 wizzyrea is this the thing that makes it so you can have configurable table columns?
00:39 dcook That was yesterday heh
00:39 dcook That drove me a bit nuts
00:39 dcook Today it's ajax with KohaTable
00:39 dcook it worked fine with DataTable
00:40 dcook But with KohaTable... I think maybe it uses a different version of datatables
00:40 dcook Which is fair enough but just unexpected
00:41 dcook Can't find any ajax examples with KohaTable...
00:42 dcook checkouts.js here we go..
00:43 dcook Oh or maybe KohaTable is older
00:43 dcook Here's what I was using: https://datatables.net/reference/api/ajax.reload()
00:47 dcook Should be on DataTables 1.10.10...
00:52 dcook oh Yes DataTable and KohaTable return very very different results...
00:52 * dcook sighs
00:55 dcook I think KohaTable uses the legacy API..
01:03 dcook Think I may have figured it out...
01:03 dcook Hurray!
01:05 wizzyrea yay!
01:05 dcook Basically yeah... diferent return values
01:05 dcook But if you just tack on a .dataTable().api() to the end of the KohaTable return value, then you're all right
01:05 dcook Obviously :p
01:06 * dcook doesn't want to count the number of minutes just wasted...
01:06 dcook 32 minutes O_O
01:06 dcook Well I'm not getting that part of my life back
02:04 dcook Now onto encoding issues which are much more time consuming >_<
02:22 lavamind # koha-list | wc -l
02:22 lavamind 119
02:23 lavamind ^ and that is how you teach an ILS to students :D
02:23 lavamind this is on a VM with 4 GB of RAM
02:24 lavamind thanks to mojolicious
02:24 lavamind (and you all of course heh)
02:24 dcook O_o
02:25 dcook Tell me more heh
02:25 lavamind where to start lol
02:25 dcook What's the bug number again?
02:26 lavamind 20582 and 20630
02:26 wahanui 41212
02:31 dcook Cooool
02:32 lavamind I wrote an small script to manage the indexing
02:32 lavamind by using file-based sessions I can check for active web sessions before hitting the database to look for pending records
02:32 dcook A few months ago I wrote a small script to manage indexing too heh
02:32 dcook Iiinteresting
02:33 dcook I do a count query for each database's zebra queue
02:33 dcook It goes pretty fast but still not as many as 119 databases..
02:33 dcook Then I fork off an indexing process per instance
02:33 lavamind dcook: right, you want to avoid having to run 119 queries every minute
02:33 dcook And use file locking to make sure I don't retry to index the same index too often
02:33 dcook I'm probably doing about 70 every minute and don't notice a thing
02:34 dcook Or maybe it's every 5 minutes
02:34 * dcook checks
02:34 dcook But my servers are also waaaaay more powerful
02:34 dcook Oh my bad
02:34 lavamind dcook: http://paste.debian.net/1050058/
02:34 dcook Every 5 seconds
02:35 lavamind I have it at 2 minutes right now
02:35 lavamind I want to see how it goes with 40 students hitting it all at once :P
02:36 lavamind you can see I put the sessions files in /run so it's all in memory
02:38 dcook I might be missing something but why don't you have koha-rebuild-zebra in your loop?
02:38 * dcook reads more
02:40 dcook Oh I see what mine does. Mine doens't run every 5 seconds. Rather, it checks the counts for all instances, and forks off an indexer for anything that needs indexing done, and then waits 5 seconds before it starts all over..
02:40 * dcook is not a big fan of polling
02:41 dcook Of course, if we had a message queue...
02:41 dcook Now back to my actual problem heh
02:41 lavamind dcook: I run one /usr/sbin/koha-rebuild-zebra command for all the instances that need indexing
02:41 dcook Ahhh
02:41 lavamind it does the iterations itself
02:41 dcook I don't use the debian packages so I'm not super familiar with the debian commands
02:42 dcook That's cool
02:42 dcook And good on you for using the Mojolicious patches
02:42 lavamind dcook: sorry to bother you :P
02:42 dcook Nah, I find it super interesting
02:42 dcook I'd love to use the Mojolicious patches but... time and risk :/
02:42 dcook So please post about your experiences on Bugzilla. I'd love to hear how you go.
02:42 dcook I'm sure many of us would
02:42 lavamind right right... doesn't make much sense for traditional deployments to be sure
02:43 dcook How do you mean?
02:43 * dcook is wondering what on earth is double-encoding his strings..
02:43 lavamind deploying one instance per site
02:43 dcook Traditional outside of Koha maybe
02:43 lavamind one big fat instance
02:43 dcook Mm
02:44 dcook Even with the packages, I guess it was never really multitenant
02:44 dcook Just lots of little instances
02:44 dcook Pseudo-multitenant
02:44 lavamind it got us far enough, until we had to move away from 3.08 heheh
02:44 lavamind but this, it's another game, it's so much faster
02:44 dcook PV = 0xa6029c0 "Knihovna \303\232st\303\255"\0 [UTF8 "Knihovna \x{da}st\x{ed}"]
02:45 dcook I know "Knihovna \x{da}st\x{ed}" is right. Curious what "Knihovna \303\232st\303\255" means though..
02:45 dcook lavamind: Yeah I think to really support multiple instances it's the way to go
02:46 dcook Although rewriting Koha to be more MVC would be great
02:46 dcook Actually, I was thinking how the Mojolicious patches could help ease into that
02:46 dcook Slowly start replacing CGI scripts with routes in Mojolicious...
02:47 lavamind multitenancy is great for a) enabling SaaS deployments and b) education
02:47 * dcook doesn't love being wedded to a particular framework... but controllers should be thin anyway...
02:47 dcook lavamind: Both big use cases for Koha heh
02:48 lavamind well there you go
02:49 dcook So I'm getting valid UTF-8 from my client... but then my server is screwing it up..
02:49 dcook Even though the log makes it look like it's valid..
02:50 dcook Or maybe it's the socket connection on the client end too..
02:56 dcook Hmm valid UTF-8 on the server...
02:56 wizzyrea is your database in the utf-8 character set?
02:57 dcook Definitely
02:57 dcook This is an issue of Koha sending data over a UNIX socket and then getting the same data back... but it being double encoded
02:57 wizzyrea ah
02:58 dcook I think I'm narrowing it down..
03:00 dcook Hmm today is Friday... this is a suitable Friday problem
03:00 dcook wizzyrea: It's my own code which makes this worse... heh
03:02 dcook Leaves the client OK, arrives at the server OK, leaves the server OK... arrives at the client BAD
03:03 dcook Must be something we're doing for utf8 handling elsewhere in Koha I reckon..
03:04 dcook Or the output on my server..
03:05 dcook Hrm
03:05 dcook One direction is good and one direction is bad..
03:05 dcook Hmm I should be able to use netcat as a client..
03:06 lavamind one direction is both good and bad?
03:06 dcook Or that
03:07 lavamind I wouldn't know, never listen to them
03:07 dcook I should know soon enough I think
03:08 dcook netcat-openbsd++
03:12 dcook Oh jeez I'm so confused but it looks like the server
03:12 dcook As netcat looks like it's getting the same badness
03:13 dcook Except not... so confused
03:24 dcook I thought I had my head around encodings...
03:24 dcook Oh wait I'm using a different terminal..
03:36 dcook Thought I fixed it and made it much worse >_<
03:47 dcook The only valid UTF-8 strings are those that Perl isn't marking internally
03:47 dcook Ok then..
04:00 dcook Yep looks like something on the Koha end...
04:00 dcook Or on the output of the server.. gahh
04:01 dcook But have to decode it on the client side..
04:05 dcook So the valid UTF8 bytes show wrong on Koha
04:05 dcook But the invalid UTF8 bytes show right on Koha...
04:06 dcook Wtf..
04:17 dcook It worked because it's encoded as Latin-1 and I'm guessing Chrome is showing everything as Latin-1...
04:18 dcook Oh yeah. I try to send Chinese and it's batshit again
05:05 dcook Ohhh yeah I think I've nearly got it
05:05 dcook Silly me
05:05 dcook So obvious in the end...
05:06 dcook Ahhh not quite
05:18 dcook Woohoo. Solved it.
05:18 dcook I was reversing the Encode functions >_<
05:18 dcook decode = octets -> characters, encode = characters -> octets
05:19 dcook I think about it as encoding octets to get characters...
05:19 dcook And decoding characters to get octets..
06:04 dcook Hmm
06:04 dcook ERROR 1071 (42000) at line 4325: Specified key was too long; max key length is 767 bytes
06:05 dcook Didn't have a problem loading this schema in yesterday...
06:05 dcook Ah but I changed it..
06:10 dcook Ahh I see
06:10 dcook heya josef_moravec
06:10 wahanui josef_moravec is using this "manual" when building packages: https://wiki.koha-community.org/wiki/Building_Debian_Packages_-_The_Easy_Way
06:10 dcook Almost resolved most things :p
06:10 josef_moravec 下åˆå¥½ dcook
06:10 josef_moravec ;)
06:11 dcook 早上好 ;)
06:11 josef_moravec dcook: one more comment come to my mind: you do not need to use ->new before ->find and ->search
06:11 dcook Running into an unrelated/related problem
06:11 dcook Hmm I think I tried without it and it didn't work?
06:12 dcook That's why I added it :S
06:12 dcook Actually I shouldn't be on IRC>.
06:12 josef_moravec when you have Koha::Objects based class, it should not be needed
06:12 dcook I've been all day in an office without air conditioning
06:12 dcook @wunder syd
06:12 huginn dcook: Sydney, Australia :: Partly Cloudy :: 100F/38C | Friday: Showers and thunderstorms early. Lows overnight in the mid 70s. Friday Night: Scattered thunderstorms during the evening. Partly cloudy skies after midnight. Low 76F. Winds NW at 15 to 25 mph. Chance of rain 40%. Winds could occasionally gust over 40 mph.
06:12 km Hi
06:12 * dcook is grumpy and not in a good mood for talking to humans heh
06:12 josef_moravec @wunder Prague
06:12 huginn josef_moravec: Prague, Czech Republic :: Clear :: 39F/4C | Wind Chill: 35F/2C | Friday: Partly cloudy this morning. Increasing clouds with periods of showers this afternoon. High 56F. Winds light and variable. Chance of rain 50%. Friday Night: Showers early, then cloudy overnight. Low 46F. Winds NNW at 5 to 10 mph. Chance of rain 60%.
06:12 dcook hi km
06:13 dcook josef_moravec: any ideas about "ERROR 1071 (42000) at line 4326: Specified key was too long; max key length is 767 bytes"?
06:13 dcook I think it's because of the 4 byte utf8 collation..
06:13 josef_moravec urf8mb4 related
06:13 km Can we export catalogue details in to Excel from KOHA with cover page images of books?
06:13 dcook josef_moravec: Are there any tips on avoiding the error?
06:13 dcook km: I am afraid I don't understand the question
06:14 dcook You mean URLs to cover images?
06:14 dcook Or actually inserting images into a spreadsheet?
06:15 josef_moravec dcook: is this error on varchar(255) type of column? Then change it to VARCHAR(191)
06:15 km okay. I wanted to export Bibliographic details from KOHA in to Excel file.Can get the cover page images of each book in the exported Excel file?
06:15 dcook josef_moravec: It doesn't say but yeah I think that's the issue
06:15 dcook km: I'm afraid I still don't understand what you're trying to ask. Maybe someone else will understand better.
06:15 josef_moravec if you look to kohastructure.sql you will see many varchar(191) columns
06:15 dcook heh I was trying to find those as examples
06:16 dcook I must not be looking far enough
06:16 dcook hopefully varchar(191) will be enough
06:16 km Hi dcook
06:16 dcook I guess we'll see
06:17 josef_moravec dcook: or you can just make the key of length 191
06:17 km It is actually inserting images into a spreadsheet
06:17 josef_moravec see authorised_values table definition
06:17 dcook josef_moravec: The error doesn't really tell me anything other than the table is the problem
06:17 josef_moravec dcook: unfortunately :(
06:18 dcook Ah but since it's a key..
06:18 km hi dcook
06:18 dcook It must mean the unique key I'm making
06:18 josef_moravec yes, when it is not key, it is not problem
06:18 dcook km: I'm going to say no
06:19 dcook The key is a compound key of two varchar(255) fields :'(
06:19 km please answer
06:19 dcook km: I have
06:20 * dcook ponders
06:20 josef_moravec dcook: do you mean oai_record key in oai_harvester_biblios
06:20 josef_moravec ?
06:20 dcook josef_moravec: yeah that's the one I'm looking at
06:23 josef_moravec so then maybe have table oai_harvester_repositories and oai_harvester_biblios.oai_repository foreign key to it?
06:24 josef_moravec but it is relatively big change :(
06:24 dcook yeah I was just thinking that :/
06:24 * dcook sighs
06:24 dcook I've already spent all day working on this when I probably should've spent 0 hours on it :(
06:25 dcook And now it's irreparably broken for now :/
06:25 dcook Well not irreparably per se..
06:26 * dcook checks the thermostat. Apparently it's only 28C indoors ;)
06:28 kohaputti Hi, coding help needed! https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19893#c197 is it good idea to put a syspref that store search index status, e.g. INDEX_STATUS_OK, INDEX_STATUS_REINDEX_REQUIRED, INDEX_STATUS_RECREATE_REQUIRED?
06:28 huginn Bug 19893: enhancement, P1 - high, ---, glasklas, Needs Signoff , Alternative optimized indexing for Elasticsearch
06:28 dcook josef_moravec: probably would've been a worthwhile change anyway
06:28 kohaputti like can sysprefs be used other than user customizable things or should in this case new table be created / something else?
06:30 dcook I wonder if I even need that unique key..
06:34 kohaputti dcook, hi!
06:38 * dcook waves
06:38 dcook Actually 191 is pretty long...
06:38 dcook It is unlikely that I'll hit that limit
06:39 josef_moravec dcook: the identifier is the first? isn't it? Then it could be OK...
06:39 dcook Yeah the identifier is first, so even if it did get truncated it would still be ok
06:40 dcook I only include both because technically you could have duplicate identifiers across different repositories...
06:40 dcook But in practice I don't think that would actually happen
06:40 dcook I mean technically I think a url could be like 2083 characters
06:40 dcook So I'm already restricting it by saying 255..
06:40 josef_moravec but usually the idntifier is prefixed and sometimes the prefix could be really long, lik oai:some-very-old-url.com:systemprefix-systemid
06:41 dcook Hmm
06:41 dcook By that token, I should have separate tables for both identifiers and repositories :/
06:41 dcook Or remove the constraint and handle it a different way
06:41 josef_moravec for now, i am for constrain it, as i most cases it would be ok
06:42 josef_moravec we could enhance it on another report in the future
06:42 dcook I think the same
06:42 dcook There may be other hurdles along the way that are more important
06:42 josef_moravec exactly
06:42 dcook Can't believe it took me so long to work out the encoding bug today.. heh
06:43 josef_moravec it is sometimes tricky
06:44 josef_moravec and error messages from mysql are usually horrible
06:44 josef_moravec I always have to google it to understand what thay mean
06:44 dcook In this case... actually I don't know what the encoding issue was
06:44 dcook The data in mysql was ok
06:45 dcook I think Perl was getting confused on one end of the socket between the harvester and the web ui
06:45 dcook So I added some explicit encoding functions so that it knew when things were bytes vs characters and that did the trick
06:45 josef_moravec dcook: by the way, what about tests?
06:45 dcook >_>
06:45 dcook <_<
06:46 dcook In all honesty, I was waiting to write those, because I had a feeling that things were going to change
06:46 dcook And didn't want to have to rewrite all the tests hah
06:46 josef_moravec dcook: absolutely understand ;)
06:46 dcook At Kohacon, fridolin actually raised some good points, which makes me think my entire design is no good anyway
06:48 dcook I'm thinking this one might actually be better rewritten as a plugin
06:49 josef_moravec dcook: whole harvester?
06:49 dcook Yeah
06:50 dcook For web users, I think it would look all right as a plugin
06:50 dcook The tricky part would be the database...
06:50 dcook Although I hear that plugins these days update the schema too
06:50 dcook The reliance on third-party dependencies makes it not great as a plugin though..
06:51 dcook I've been thinking of keeping a separate database
06:51 josef_moravec I like plugins, and probably it will be the way in the future that many things will be as plugin, but i think the plugin system would need many improvements to make such a think possible
06:51 dcook So that the only parts of Koha I need are a web UI (easy with a plugin in theory) and a record importer
06:51 ashimema Mornin' #koha
06:51 dcook allo ashimema
06:51 josef_moravec like dependencies as you say, and better hooks handling
06:51 josef_moravec Hi ashimema
06:52 dcook With the harvester, it wouldn't need any hooks really
06:52 dcook The web ui would communicate with the daemon
06:52 dcook And then the daemon could do everything on its own
06:52 dcook Once upon a time, I had an iteration that was totally separate to Koha
06:52 dcook Other than the UI for comms
06:53 dcook But the web services for importing into Koha are suuuper slow
06:53 dcook Or used to be
06:53 dcook The only way to get half-decent performance was to closely couple with Koha :/
06:54 dcook Sometimes I think OAI-PMH harvesting is better implemented instance by instance...
06:54 dcook That a catch-all won't work
06:54 dcook I've been working on this for like 5.5 years at this point :/
06:54 dcook I'd given up before andreashm contacted me
06:55 dcook And now I don't want to give up, but...
06:55 dcook I don't know that it really has a chance of getting in, so I think it may have to just be a plugin
06:56 dcook But on that note, I almost have my commits ready ;)
06:57 dcook josef_moravec: I really do appreciate all the work that you're putting into this too :)
07:01 * dcook apologizes for the heat-induced rant :p
07:04 dcook One last QA test tool run then I'll upload..
07:04 josef_moravec dcook: great!
07:05 dcook I think I've fixed most things. I think there are 3 outstanding things: the SQL statement, the datatable styling, and the foreign key. I think I might be wrong in my response about the foreign key though...
07:05 dcook But I'm out of time O_O
07:05 dcook Once these patches go up, I am going to get cold beers
07:05 dcook heh
07:05 josef_moravec dcook: enjoy ;)
07:06 josef_moravec no problem, submit what you have, I'll try to catch oleonard and we could probably do something with datatable styling...
07:06 dcook Hopefully it's just a case of needing to add a CSS class or something
07:07 dcook I probably won't get a chance to follow up for a little while anyway
07:08 dcook Some pressing non-Koha stuff early next week
07:12 magnuse \o/
07:12 dcook yo magnuse
07:12 magnuse yo yo yo dcook
07:24 ashimema OAI fun aye dcook
07:24 ashimema Lots of reading back
07:35 reiveune hello
07:36 * ashimema first challenge of the days.. fix a 10 year old FIXME
07:36 ashimema that's gotta be a bit of a record
07:59 alexbuckley hi all
08:06 Archie^ hey remind me what table patron records are stored in?
08:08 alexbuckley hey archie they are in the borrowers table
08:09 matts hi
08:09 wahanui hola, matts
08:10 alexbuckley Hey ashimema did you see I wrote a patch (bug 21754) as an alternative to 21732 as it automatically cancels outstanding holds on lost items
08:10 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21754 enhancement, P5 - low, ---, alexbuckley, Needs Signoff , If an item is marked as lost, any outstanding transfers upon it should be automatically cancelled
08:14 fridolin hi there
08:16 Archie^ right, thank you
08:27 marcelr hi #koha
08:39 ashimema thanks alexbuckley (IRC)
08:39 ashimema now we're just left to see if we get any replies to me queries on the mailing lists
08:39 alexbuckley yeah
08:40 ashimema nothings ever easy is it ;)
08:41 ashimema that's the problem with Koha now.. it's got so much history and so much code pre-existing that when you try to do even the simplest looking things you end up finding it touches way more than you originally thought
08:41 ashimema thanks for all the perserverance though :)
08:42 alexbuckley no worries, super keen to try to get that in as it seems pretty important that when item marked as lost things like transfers are dealt with
08:47 marcelr ashimema: why am i seeing so much ill patches ?
08:47 ashimema huh
08:48 marcelr was ill a bit sick?
08:48 ashimema lol
08:48 ashimema nah.. we always had a phase 2 and phase 3 planned
08:48 ashimema this is only around 2/3rds of pahse 2
08:48 marcelr oops and critical stock rotation stuff..
08:48 ashimema mm.. the stock rotation stuff is annoying..
08:49 ashimema it's basically rebase pain
08:49 marcelr i will pick the other one now
08:49 ashimema it got rebased for like 5 years and unfortunately not everything was caught at the last qa before push..
08:49 ashimema especially as immediately after push the sql strict stufff was push which also broke it and added to the fix patches
08:50 marcelr 5 years aarg
08:50 ashimema we have more plans for ILL.. lots more polishing to do there to make it more refined. Bywater are jumping on board too to help us convert backends to plugins
08:51 ashimema yeah.. it's hard to keep something up to date for that long :(
08:51 ashimema invariably feature creep and bugs creep in
08:51 ashimema ILL in it's original form in Koha core has the same sort of issue really.. the original stuff that got in worked.. but was not at all polished because it ended up so parred down
08:51 ashimema it's getting better now though
08:52 marcelr hard to break such stuff in handleable pieces
08:52 ashimema more people getting involved.. I think it's slowly becomeing a much more polished and usable feature
08:52 ashimema indeed
08:52 marcelr same for recalls now
08:52 marcelr just too large to get in without bugs
08:52 ashimema I don't blame anyone.. I'm having a right nightmare with some big feature QA's lately (from the qaing side not the submitting side)
08:52 ashimema it's teaching me allot about how to submit stuff cleaner
08:53 marcelr yeah but qa is not only for teaching you :)
08:53 marcelr even more about teaching submitters..
08:53 ashimema yeah.. I'm working through recalls still.. my aim is now to work hard with alexbuckley beggning of next cycle to get it in early in a cycle rather than let it slip in this cycle
08:53 ashimema oh definitely
08:53 marcelr yeah we should push it early for 19.05
08:53 ashimema definitely
08:55 ashimema ooh, your looking at bug 15529 too.
08:55 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15529 normal, P5 - low, ---, alexbuckley, Failed QA , Process Message Queue may send duplicate emails if process is launched twice
08:55 ashimema cool.. I got stuck there
08:58 ashimema Jonathans comment threw me.. I hadn't even considered locking at the db level as an alternative
08:58 marcelr ashimema: we had some struggles about database locking too already
08:59 ashimema yeah.. exactly
08:59 marcelr it is not trivial too
08:59 ashimema locks can cause a massive performance issue sometimes too
08:59 marcelr i would not object to using exactly the same locking as in rebuild_zebra but not duplicate it
08:59 ashimema yeah.. baby steps ;)
09:00 ashimema you suggested what I was going to suggest next
09:00 marcelr nice sprintf bug btw
09:00 ashimema even as a secondary bug perhaps if we're keen on getting it through
09:00 marcelr you once leave the parentheses and there you go
09:00 marcelr perlcritic is your friend ;)
09:01 ashimema ack yeah.. can't believe I missed the sprintf horrors when rebasing.. alex sassmanshausen wrote those in the first place.. really surprises me now I look back
09:01 ashimema oops
09:01 ashimema perlcritic missed it here.. perhaps I just missed pushing a followup up
09:01 ashimema grr
09:16 * cait waves
09:26 ashimema anyone know what misc/crontjobs/staticfines.pl is for?
09:26 ashimema I've always used /fines.pl
09:26 cait it's a special kind of fine calculation
09:26 cait sadly not very well documented, let me find the bug
09:27 cait bug 6858
09:27 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6858 normal, P5 - low, ---, matthias.meusburger, CLOSED FIXED, Adds staticfines.pl for static fines processing
09:27 cait This patch allows to apply only one fine for a given borrower, no matter how many items are late, based on a given delay, which applies to the most late item.
09:28 ashimema erm
09:28 ashimema ok
09:28 ashimema no idea what that means
09:30 ashimema I wonder if anyone actually uses it.
09:31 cait matts might know :)
09:32 matts I don't know if anyone still uses it
09:33 ashimema one to put to the mailing list then nuke from high orbit I reckon ;)
09:33 ashimema sure it was usefull once upon a time
09:33 matts a loooong time ago :)
09:34 ashimema hehe
10:27 marcelr @later tell kidclamp bug 14385 ?
10:27 huginn marcelr: The operation succeeded.
10:42 huginn News from kohagit: Bug 20968: (RM follow-up) Add missing filter <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=1a0172a253e5432e5eef862768aaacb3463501f2>
10:42 huginn News from kohagit: Bug 14385: DBRev 18.06.00.050 <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=7a1641cd41bf51a992cb07dff58d320c49f15b68>
10:42 huginn News from kohagit: Bug 20996: (QA follow-up) Fix pod <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=ce6a27b0d287f14eb0d515db6b2a5e1f5d278381>
10:42 huginn News from kohagit: Bug 20996: (follow-up) Fix merge problems <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=f947655862abc813df685d51edbfbe7b34027178>
10:42 huginn News from kohagit: Bug 21640: Enable output to STDOUT for Itiva outbound script <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=12ed04eabb32cb957acd9f88d94ccada0ac09d07>
10:42 huginn News from kohagit: Bug 21606: [sql_modes] Fix matching rules insert <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=32c4dbfd6814f01ae2b430e88f13b89bd374f34f>
10:42 huginn News from kohagit: Bug 14385: (QA follow-up) Additional changes and fixes <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=70651422a7517338a68e22321d9918757746ef33>
10:42 huginn News from kohagit: Bug 21501: Remove dead code from course reserves module <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=84857caaef467b7c3dfa82404143de8dc41fc858>
10:42 huginn News from kohagit: Bug 20996: (follow-up) Fix column name expectation <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=4ffd2d3b347072f6422adb98608859264ba269d6>
10:42 huginn News from kohagit: Bug 20996: (follow-up) Add <branch> to conf tpl <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=8e8f26f2cb2195f1e07136898320875dc055aad4>
10:42 huginn News from kohagit: Bug 20996: Further enhance performance <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=3fb44a8bd63663fb7c4d93e85c30d58d9b2ce08f>
10:42 huginn News from kohagit: Bug 20968: (follow-up) Replace tabs with spaces <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=9783773ada4dec115342a4f8f16b29eb5b98cc2f>
10:42 huginn News from kohagit: Bug 20968: Rename method get_intranet_catalog_toolbar_button to intranet_catalog_bibl... <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=e87fa069dc3d10284a2bd31b7c7913132fed5d06>
10:42 huginn News from kohagit: Bug 20968: Add unit tests <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=60ca17c616e6026fbd271fb3f99473f3ef7edf00>
10:42 huginn News from kohagit: Bug 20968: (follow-up) Respond to feedback <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=7910a530b85b6ee42307d41cba57b95ced2aca27>
10:42 huginn News from kohagit: Bug 20968: Add hooks into cat-toolbar.inc to display buttons <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=741f17e916a3f64d71b55fd87065136307e3bae7>
10:42 huginn News from kohagit: Bug 14385: Squash of a lot of patches rebased <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=e1b5fa657de843a177fb4bf57947a1376152d021>
10:42 huginn News from kohagit: Bug 14385: (follow-up) Changes to sysprefs.sql and atomicupdate <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=e31e0e5daa764892dfb7878696cb1159d27c3a1c>
10:42 huginn News from kohagit: Bug 14385: (follow-up) C4::Borrowers not found <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=8b7a7a2bb34609c402117933625e06e1b8e2cd69>
10:42 huginn News from kohagit: Bug 14385: Extend OpacHiddenItems to allow specifying exempt borrower categories <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=5e4e10c4ca558180137bf5a4ff5a68495efa0ec7>
10:43 josef_moravec kidclamp++
10:45 marcelr hey kidclamp woke up
10:46 kidclamp Out most of today, so wanted to keep the queue from getting too big :-)
10:55 ashimema any chance you could add 19066 to the pushed pile pretty please.. I'd like to start rebasing some bits I'm working on atop it.
10:55 ashimema ;)
10:55 ashimema hows things otherwise?
10:59 kidclamp Things are good, heading to do a training today so can look at that but when back
10:59 ashimema have fun
11:13 Guest1933 Project Koha_Master_D9 build #594: UNSTABLE in 29 min: https://jenkins.koha-community.org/job/Koha_Master_D9/594/
11:14 Guest1933 Project Koha_Master_U18 build #83: UNSTABLE in 29 min: https://jenkins.koha-community.org/job/Koha_Master_U18/83/
11:17 oleonard Hi #koha
11:18 marcelr hi oleonard
11:18 wahanui hi oleopard
11:20 Guest1933 Project Koha_Master_D8 build #89: UNSTABLE in 37 min: https://jenkins.koha-community.org/job/Koha_Master_D8/89/
11:23 marcelr ashimema: ill request tests are sick ;_
11:23 ashimema :9
11:23 ashimema I shall go take a look
11:23 ashimema ta
11:25 marcelr htg bye #koha
11:58 josef_moravec hi oleonard
11:58 wahanui hi oleopard
11:59 josef_moravec oleonard: could I ask you to have a look at bug 10662? There are some datatable styling issues
11:59 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10662 new feature, P3, ---, dcook, Signed Off , Build OAI-PMH Harvesting Client
11:59 oleonard Sure
11:59 * oleonard was just trying to wrap his head around whether we need both Select2 and jquery.multiple.select.js
12:03 Joubu hi #koha
12:03 Joubu How is going the feature slush?
12:04 oleonard josef_moravec: I get an error when I try to run the database update. "Specified key was too long; max key length is 767 bytes"
12:05 oleonard josef_moravec: Did you encounter that too?
12:06 Joubu haaa!
12:07 Joubu what are you doing?
12:07 oleonard Joubu: Trying to test Bug 10662
12:07 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10662 new feature, P3, ---, dcook, Signed Off , Build OAI-PMH Harvesting Client
12:07 josef_moravec ah, looks like dcook does not submit tha patch for this yet
12:08 Joubu ok it's not the exact same error as bug 21273
12:08 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21273 major, P5 - low, ---, koha-bugs, NEW , After upgrade from 17.11.08 to 18.05.02 intra not working, Software error: Template process failed
12:08 josef_moravec oleonard: for workaround you could edit /installer/data/mysql/atomicupdate/bug_10662.sql
12:09 josef_moravec and remove line 11 - unique key
12:10 oleonard Thanks josef_moravec
12:33 oleonard josef_moravec: Do you know if metadataPrefix is always required?
12:34 oleonard The error messages implies that it is, "[metadataPrefix is a required field for an OAI-PMH request.]"
12:34 josef_moravec it is required by OAI-PMH standard
12:34 oleonard Okay, so making it a required field makes sense
12:34 oleonard (client-side)
12:42 ere apart from when using a resumptionToken
12:43 Joubu Who's fixing Jenkings? ashimema, kidclamp?
12:43 ashimema kidclamp is at training
12:43 ashimema I was about to take a look.. seems like it's ILL :(
12:44 ashimema which as much as I should be.. I'm no expert in at the moment
12:44 ashimema and AndrewIsh is on leave today
12:44 ere oleonard: with resumptionToken you must not send metadataPrefix (nor with verb=Identify etc.). so it's not always mandatory
12:44 Joubu ashimema: I bet it is caused by bug 20996
12:44 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20996 normal, P5 - low, ---, andrew.isherwood, Pushed to Master , Fix API response time on ILL request endpoint
12:45 ashimema mm
12:45 ashimema me too
12:46 oleonard ere: Have you looked at Bug 10662? I don't see an input for resumptionToken in the "new request" form so I wonder if that case needs to be considered.
12:46 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10662 new feature, P3, ---, dcook, Signed Off , Build OAI-PMH Harvesting Client
12:48 oleonard I would like to put as much client-side validation into that form as we can, but I'm not familiar with the requirements
12:55 ere oleonard: I haven't really, so this is simply theoretical about the protocol. But usually metadataPrefix is part of harvesting source configuration and resumptionToken is only used internally by the harvester. However, the harsh reality is that sometimes you need to restart harveting from a given resumptionToken to avoid reharvesting everything you already got before something glitched.
12:55 oleonard Thanks ere. I'll leave it for now and bring it up with dcook
12:56 * oleonard is disappointed that fixFloat is so fragile
12:57 ere oleonard: In practice you typically need two config options for the format: the format you request using the metadataPrefix, and the actual format the provider returns. Some servers don't follow the guidelines, and there are no standard prefixes for all formats, so what you call it and they call it may not match..
12:57 oleonard Sounds typical for library data exchange...
12:57 Joubu oleonard: I think the last changes were quite good :) The problem is that browsers do not interpret/implement the specs identically...
12:58 oleonard Joubu: I guess we should consider ourselves lucky that this kind of issue happens so infrequently
12:59 ere oleonard: If you happen to need anything for reference, there's always RecordManager that I've written. Wrong programming language, though, but e.g. the configuration might be of use: https://github.com/NatLibFi/RecordManager/wiki/Data-Source-Configuration#oai-pmh-harvesting-specific-settings
13:00 ere (also the common settings affect harvesting)
13:04 Joubu #koha - I know I asked it a dozen of times already but as today it's ft slush I must ask again. I really believe that bug 19185 must be part of 18.11. We need more tests!
13:04 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19185 enhancement, P5 - low, ---, jonathan.druart, Needs Signoff , Web installer and onboarding tool selenium test
13:06 ashimema I thought it was pretty much blocked by bug 19821 Joubu
13:06 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19821 enhancement, P5 - low, ---, julian.maurice, Needs Signoff , Run tests on a separate database
13:06 ashimema I can sign it off.. as I've already tested it..
13:07 ashimema in fact.. I thought I had signed it off
13:07 Joubu 19185 is waiting for a SO as well
13:10 caroline hi #koha!
13:20 oleonard Hi caroline
13:27 Joubu Anybody around is connected with an IPv6 address?
13:28 tcohen morning
13:52 fridolin k
14:14 mtompset Greetings, #koha ashimema Joubu caroline oleonard tcohen
14:14 mtompset Nope... not with IPv6 here.
14:14 mtompset Greetings, fridolin
14:15 tcohen hi
14:15 fridolin hi
14:15 wahanui que tal, fridolin
14:15 fridolin va bene
14:15 fridolin ve bene wahanui
14:15 fridolin wahanui ba bene
14:15 wahanui fridolin: what?
14:15 fridolin wahanui: watts
14:15 wahanui fridolin: huh?
14:16 fridolin wahanui: Obi-Wan Kenobi
14:16 wahanui fridolin: huh?
14:26 oleonard wahanui: Bro do you even nerd?
14:26 wahanui wish i knew, oleonard
14:41 Archie^ Hey guys, so im having an issue with migrating to Koha. does anyone have a couple of minutes?
14:42 oleonard Ask away Archie^, and if someone can they'll answer
14:44 Archie^ Right so basically we just got access to database of another library. The plan is to create Master Koha with a bunch of different libraries being able to connet to it.So i have access to DB and they have all the books they store in access as MARC21XML. So we are in a stage that we want to migrate all data to koha as a proof of concept that koha is better solution etc
14:44 Archie^ what i dont understand is, if i upload these books into koha via marc21xml upload then there is no option to link these books that they are available in this certain library
14:46 oleonard Archie^: To show that a book is available at a particular library you must add an item record specific to that library. Multiple item records can be added to a single bibliographic record.
14:47 Archie^ so that's not something that should be added in MARC21 file? i mean ... does that mean i have to take different approach into migrating the data rathen then marc21xml upload that already exists in KOHA
14:48 oleonard I don't know what kind of record you're getting out of the old system, but ideally it would already contain item information
14:48 caroline Archie^: items in Koha are in fields 952. Make sure your records have that information
14:49 caroline For homelibrary, it's 952$a
14:50 caroline What system are you migrating from?
14:52 Archie^ it's an old legacy system created specifically for my country called Alis
14:55 eythian it's very likely you'll have to do something to convert the item records you have to the form that koha expects - every system does that bit differently.
14:59 tuxayo mtompset (IRC) around for a chat?
15:00 caroline Archie^: the official MARC field for items is 852, but it varies from system to system http://www.loc.gov/marc/bibliographic/bd852.html
15:01 caroline You'll have to check the records for item information and map them to Koha's item fields https://wiki.koha-community.org/wiki/Holdings_data_fields_(9xx)
15:02 caroline if you need help with the mapping, I can help you, that's pretty much what I do all day these days :)
15:03 Archie^ ok then i have another issue :D
15:05 Archie^ so ok we have to systems here, one is Aleph and one is Alis, the aleph one is master system that pretty much holds all catalogue of books in country and alis is little libraries etc. so if i get full dump of alpeh into koha (onlythe books, nothing else interests me from aleph) and i want to add books into from alis libraries it will just find it as a duplicate and dismiss?
15:06 Archie^ i had in my mind something like.. im adding books from alis and koha checks for duplicates, sees that it is already in Koha but adds some sort of .. + 1 that it is available in this new library
15:06 Archie^ i'm fairly comfused myself :S
15:07 oleonard Archie^: The import process can check for duplicates based on a unique field of your choice
15:07 caroline or multiple fields
15:08 caroline in Administration > Record matching rules https://koha-community.org/manual/18.11/en/html/administration.html#record-matching-rules
15:08 caroline Then you can tell it to import only the items from the records that are duplicates
15:09 Archie^ im not sure what items is in this context
15:09 Archie^ sorry for all the confusion, still fairly new to Library game ;D
15:10 oleonard An item is the part of the record which identifies the physical instance of that record
15:10 oleonard The item has an identifier like a barcode, and it is associated with a particular library
15:19 Archie^ so basically if a person checks out a book, then this record of checking the book out is considered an item?
15:19 caroline the book itself is th item
15:20 Archie^ ahh i think i got it
15:20 oleonard Archie^: Look at the MARC view of this book in our catalog: https://search.myacpl.org/cgi-bin/koha/opac-MARCdetail.pl?biblionumber=543826
15:20 oleonard The table at the bottom lists the items
15:21 oleonard All this data is in the MARC record, but the item information is separated in this display
15:22 caroline it's like if you have a record of Harry potter and the philosopher's stone, but you have 5 copies of that book. You will have one record describing the title, author, publisher, etc. and 5 items with each their barcode, their status, etc.
15:23 caroline Your MARC record will have 5 x 852 (or 952) fields
15:28 oleonard See y'all later
15:56 josef_moravec oleonard++
16:04 reiveune bye
17:56 mtompset Oops...
17:56 mtompset @seen tuxayo
17:56 huginn mtompset: tuxayo was last seen in #koha 2 hours, 56 minutes, and 25 seconds ago: <tuxayo> mtompset (IRC) around for a chat?
17:58 lukeG Has anyone expereinced problems with audio-alerts not sounding/playing in 18.05.05?
18:26 caroline Could someone check bug 21758 and tell me if it's just my system that's broken?
18:26 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21758 enhancement, P5 - low, ---, koha-bugs, NEW , Navigation in Z39.50 result pages not working in Acquisitions
18:43 ashimema Slushy slush slush
18:44 * ashimema is tired and take a well earned weekend
18:44 ashimema Have a good one #koha
18:47 CrispyBran Anyone know what makes an item consigned?
18:53 ashimema caroline++
18:53 caroline :D
18:53 ashimema Now I just need to find a QA in the remaining hours
18:54 caroline Did we talk about the decimal dot multiplying the actual cost upon receiving?
18:54 caroline I think so... That needs to be fixed before the release
18:56 caroline yes there it is bug 18723
18:56 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18723 critical, P5 - low, ---, josef.moravec, Failed QA , Dot not recognized as decimal separator on receive
20:25 tuxayo caroline (IRC): bug 21507
20:25 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21507 major, P5 - low, ---, koha-bugs, NEW , Decimal separators issues in patrons payments/fines, simplified
20:26 tuxayo I coundln't find time until the last few days for this :(
20:26 tuxayo My plan after bug 21507 is to do the same for 18723
20:26 caroline won't 21507 fix 18723?
20:28 tuxayo caroline (IRC): QA feedback on bug 12310 (it's predecessor) made me scope it only on fines. So I prefer to keep that.
20:29 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12310 major, P5 - low, ---, victor.grousset, BLOCKED , Decimal separators issues in patrons payments/fines
20:29 caroline ok
20:30 tuxayo I thinks that a good idea because we might have to do at once many decimal fields in acquisitions and it's difficult to test. So wanting to fix acquisitions at the same time might cause payement/fines fix to take longer to be merged
20:30 tuxayo Also the test plan will be less scary :)
20:31 caroline very important point!
20:31 caroline friendly test plans get tested :)
20:36 tuxayo ^_^
20:36 tuxayo caroline (IRC) Do you know areas in Koha where decimal numbers can be written with both «.» or «,» ? (or maybe follow the CurrencyFormat syspref) Because i'm sure I have found such a thing.
20:36 tuxayo This is to mutualize the server side code handling this. Because that's what I need for bug 21507
20:36 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21507 major, P5 - low, ---, koha-bugs, NEW , Decimal separators issues in patrons payments/fines, simplified
20:37 caroline you mean other than fines and acquisitions?
20:53 tuxayo caroline (IRC): Maybe in aquision actually, I don't know it enough
20:54 tuxayo caroline (IRC): In fines, some of field work with both but It's JavaScript that replaces commas with dots
20:54 tuxayo we can see that on unfocus.
20:56 caroline I never paid attention to be honest, other than when it broke everything and suddenly my order was 3999$ instead of 39.99$
22:45 caroline have a good weekend all!
23:04 * CrispyBran waves goodbye