IRC log for #koha, 2022-12-05

All times shown according to UTC.

Time S Nick Message
00:06 davidnind :q
00:07 davidnind sorry, wrong window 🙂
00:41 dcook @later tell ashimema Let me know if you have any Keycloak questions! git worktrees seems like the kind of thing that would be useful for me. I still use vim as well, although I've used VSCode for a few things. I work all over the place, so vim is just the easiest to use...
00:41 huginn dcook: The operation succeeded.
00:43 dcook davidnind++ # Automating screenshots sounds pretty cool. I'm a fan of puppeteer/playwright for that kind of thing
00:48 davidnind Thanks dcook for the suggestion - I'll have a look
00:48 davidnind I went for as that is what Joubu used for the electron resource module (ERM) use View
00:49 dcook All good. Whatever we're using makes sense..
00:49 dcook I think selenium can do screenshots as well..
00:52 davidnind Ages ago I had a go at using Selenium + Robot Framework + Screenshot library (see https://wiki.koha-community.or[…]ted_Screencapture and[…]ated-screenshots)
00:53 davidnind From memory, it was a bit easier - but as I'm not a programmer they all have a bit of a learning curve!
01:24 dcook Fair enough!
01:24 dcook Although being a programmer is just a state of mind :p
01:26 davidnind Anyone more familiar with reporting, the biblioitems table, and cataloguing? I'm trying to add column descriptions for guided reports and I can't work out what a couple of columns should be... bug 32313
01:26 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=32313 minor, P5 - low, ---, david, NEW , Complete database column descriptions for cataloguing module in guided reports
01:30 dcook Yeah I'm not sure about those biblioitems columns :/
01:31 dcook Trying to resolve a problem with DataTables and Arabic... not fun...
01:32 dcook Hmm doesn't like Hebrew either it seems..
01:32 drbone joined #koha
01:32 davidnind Good luck!
01:35 dcook Thanks. It's the worst. Haha.
02:02 dcook Oh goody... it works on some datatables and not others..
02:36 Joubu_ joined #koha
02:38 tcohen joined #koha
03:20 dcook Oh boy
03:20 dcook tcohen: Don't suppose you're still awake
03:20 dcook I've got some headache inducing news for folk haha
03:20 dcook Happy Monday...
03:48 Oak joined #koha
06:14 thibaud_g joined #koha
06:28 reiveune joined #koha
07:02 ashimema Morning koha
07:02 ashimema Hi dcook
07:02 wahanui Hi dcook are you around?
07:06 Joubu davidnind: that's certainly coming from[…]cker/-/issues/316
07:06 Joubu and hi, #koha!
07:39 cait[m] Joubu: davidnind and I tried the quotes, they didn't help
07:39 Joubu it worked for me
07:40 cait[m] I have to come back to this later - have to run
07:40 cait[m] but I tried restarting all the things - put it in the issue
07:40 cait[m] I updated the env and killed my ktd... it's still wrong
07:48 paxed it feels really strange to me that the letters processing first handles <<>> and then TT, making stuff like [% IF <<borrowers.categorycode>> == blahblah %] valid.
07:58 lds joined #koha
08:01 alex_ joined #koha
08:01 alex_ Bonjour
08:01 wahanui what's up, alex_
08:12 cait joined #koha
08:43 cait 19.500 Kohas on Hea
08:45 thibaud_g joined #koha
08:45 cait Checked the demos on the website, all are online, but no 22.11 ones yet
08:45 cait if you update yours, please let me know so I can update the table on the website
08:46 paxed cait: koha installations, or libraries?
08:49 cait libraries it says, so maybe branches, not sure
08:51 paxed branches sounds right
08:53 paxed hea knows the largest instances. there really should be a test to see if unmodified koha lags in some areas when there's that much data
08:53 cait ?
08:54 cait we do some anonymization on the data, I am not sure we can combine the numbers and names
08:54 cait and then still, what would we do with it?
08:55 paxed i know we had to do some local changes couple years back, because acq was really slow on our system, due to massive amounts of data
08:55 cait hm and no way to tell about hardware and modifications - both will impact performance greatly
08:55 cait storage can make a huge difference
08:56 paxed sure, but when a query does dozen joins on 10 million rows, that's still slow no matter the storage
08:56 cait but nothing you could get data from Hea with
08:58 paxed but hea gets number of holds/subscriptions/checkouts/acq etc. create a dummy db with that many rows in the db, check how much koha slows down in some areas
09:08 marcelr joined #koha
09:08 marcelr o/
09:11 marcelr hm dependabot
09:16 zb joined #koha
10:26 marcelr joined #koha
10:27 marcelr bug 32399 needs a signoff
10:27 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=32399 major, P5 - low, ---,, Needs Signoff , Database update for bug 30483 is failing
10:27 cait thx marcelr++
10:48 davewood rabbitmq jobs not working ... both queues are running (default/long_long_tasks) i can see the jobs in the intranet website ... status = new "elasticsearch index aktualisieren" ... progress 0/1 ... i see the connection =>
10:49 cait davewood: which verion of Koha?
10:50 davewood koha-common/now 22.05.05-1 all [installed,upgradable to: 22.05.06-1]
10:53 cait I think we'll need one of theothers for that one, tcohen, Joubu, ashimema?
10:54 davewood is there no mq client installed by default that I can use to check the connection params. rabbitmqadmin, rabbitmq-diagnostics ... I dont get either of them to work
10:55 davewood just something that I can pass mq-host/port/user/passwort/vhost too and that tells me everything looks good
10:58 davewood more info (logs, etc) i dont know where else i could look for debug info ...
11:10 davewood thanks cait
11:11 kidclamp joined #koha
11:27 Joubu davewood: Are you seeing "The job has not been sent to the message broker" in plack-intranet-error.log?
11:27 Joubu bug 32242
11:27 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=32242 major, P5 - low, ---,, Pushed to master , The job has not been sent to the message broker: (Wide character in syswrite ... )
11:40 tcohen hola #koha
11:40 davewood Joubu: no, but lots of these -> [2022/12/05 10:57:12] [WARN] Argument "LOK" isn't numeric in numeric ge (>=) at /usr/share/koha/lib/Koha/Filter/MARC/ line 120.
11:40 marcelr hola tcohen
11:52 Joubu davewood: I misread your version, you have .05, latest is .06, package for .07 will be available soon (if not there yet)
11:52 Joubu davewood: bug 32242 won't be part of .07, which may cause another problem in this area
11:52 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=32242 critical, P5 - low, ---,, Pushed to master , The job has not been sent to the message broker: (Wide character in syswrite ... )
11:55 davewood but is my issue because of the bug you mentioned? ot is it just an assumption?
11:56 davewood i read the bug description and i dont see where my issue is similiar.
11:58 Joubu davewood: your issue is resolved by bug 31351
11:58 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=31351 major, P5 - low, ---, stalkernoid, Pushed to stable , Worker dies on reindex job when operator last name/first name/branch name contains non-ASCII chars
11:59 Joubu which is in 22.05.06
12:00 Joubu tcohen, marcelr: shouldn't we ask Lucas to release a new version with 32242? It missed the latest 22.05
12:08 davewood Joubu: i upgradec to Koha 22.11.00 and see some info regarding rabbitmq_stomp ... we are running an external rabbitmq server, I hope that works.
12:10 davewood doesnt look totally wrong to me :)
12:12 davewood Joubu: for the record, after the upgrade the jobs i mentioned before do not exist in the DB anymore.
12:13 davewood well .. they exist in the DB but dont show up in the intranet webinterface.
12:13 * ashimema has been fixing bugs in koha-push this morning.. it's fun
12:14 davewood the jobs dont show up in the list, if i click a different job and change the jobid i can still see them.
12:20 davewood Joubu: the problem/issue we had was fixed with the upgrade.
12:20 davewood thank you!
12:26 cait davewood: for your LOK ones... possibly that these are fields you got into Koha via Z39.50? some pica based targets have LOK for holding information
12:29 alex_ joined #koha
12:42 Joubu davewood: by default only current jobs are displayed. There are checboxes at the top of the table to display them all
13:06 JBoyer_ joined #koha
13:12 caroline joined #koha
13:18 marcelr joined #koha
13:24 marcelr .
13:45 Dyrcona joined #koha
14:54 JBoyer joined #koha
15:00 lukeg joined #koha
15:23 domm[m] joined #koha
15:23 educkett[m] joined #koha
15:23 JacobOMara[m] joined #koha
15:24 PedroAmorim[m] joined #koha
15:37 PabloBianchi[m] joined #koha
15:42 cait left #koha
15:44 PabloBianchi[m] Hi! I'm one of those having the issue related to bug 32399. I would be glad to give any further info.
15:44 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=32399 major, P5 - low, ---,, Needs Signoff , Database update for bug 30483 is failing
15:45 PabloBianchi[m] I had also hesitated to turn FOREIGN_KEY_CHECKS off, that's why I wrote to the list in the first place..
16:06 JBoyer_ joined #koha
16:46 reiveune bye
16:47 reiveune left #koha
17:44 caroline joined #koha
17:46 tcohen PabloAB[m]: what is your doubt?
17:47 tcohen if you have rows on the 'issues' table, with no itemnumber or borrowernumber, then that's broken data
17:47 tcohen you should go take care of it
17:48 tcohen i.e. if you open a patron circ page, and try to list the checkouts, the page will be broken-ish because it cannot load the checkouts table
17:53 lukeg joined #koha
18:02 rangi[m] joined #koha
18:46 lukeg bugzilla down?
18:46 lukeg oop, nvm. its back!
18:48 PabloAB[m] My doubt is if I have to turn FOREIGN_KEY_CHECKS off. As mention on the list, my issues table have only one row where itemnumber and borrowernumber have not null values
18:48 * PabloAB[m] sent a code block:[…]IkMGkohesizSCDmkA
19:04 * PabloAB[m] sent a sql code block:[…]zCODNHUTzFgtutehK
19:05 PabloAB[m] Doesn't seem a data issue, but I would gladly run any other tests.
19:05 PabloAB[m] <tcohen> "Pablo Bianchi: what is your..." <- Doesn't seem a data issue, but I would gladly run any other tests.
20:17 lukeg joined #koha
22:39 uhusiano[m] joined #koha
22:44 JBoyer joined #koha
22:57 davidnind FYI - For those in the Fediverse/Mastodon, I created a channel for Koha - (
23:40 Oak joined #koha
23:46 dcook davidnind++

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