Time Nick Message 23:46 dcook davidnind++ 22:57 davidnind FYI - For those in the Fediverse/Mastodon, I created a channel for Koha - https://mastodon.world/@KohaILS (@KohaILS@mastodon.world) 19:05 PabloAB[m] <tcohen> "Pablo Bianchi: what is your..." <- Doesn't seem a data issue, but I would gladly run any other tests. 19:05 PabloAB[m] Doesn't seem a data issue, but I would gladly run any other tests. 19:04 * PabloAB[m] sent a sql code block: https://matrix.org/_matrix/media/v3/download/matrix.org/ovrKxBpzCODNHUTzFgtutehK 18:48 * PabloAB[m] sent a code block: https://matrix.org/_matrix/media/v3/download/matrix.org/qYSLXrUIkMGkohesizSCDmkA 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:46 lukeg oop, nvm. its back! 18:46 lukeg bugzilla down? 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:47 tcohen you should go take care of it 17:47 tcohen if you have rows on the 'issues' table, with no itemnumber or borrowernumber, then that's broken data 17:46 tcohen PabloAB[m]: what is your doubt? 16:46 reiveune bye 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.. 15:44 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32399 major, P5 - low, ---, m.de.rooy, Needs Signoff , Database update for bug 30483 is failing 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. 13:24 marcelr . 12:42 Joubu davewood: by default only current jobs are displayed. There are checboxes at the top of the table to display them all 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:20 davewood thank you! 12:20 davewood Joubu: the problem/issue we had was fixed with the upgrade. 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:13 * ashimema has been fixing bugs in koha-push this morning.. it's fun 12:13 davewood well .. they exist in the DB but dont show up in the intranet webinterface. 12:12 davewood Joubu: for the record, after the upgrade the jobs i mentioned before do not exist in the DB anymore. 12:10 davewood http://paste.scsys.co.uk/1619 doesnt look totally wrong to me :) 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:00 Joubu tcohen, marcelr: shouldn't we ask Lucas to release a new version with 32242? It missed the latest 22.05 11:59 Joubu which is in 22.05.06 11:58 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_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:58 Joubu davewood: your issue is resolved by bug 31351 11:56 davewood i read the bug description and i dont see where my issue is similiar. 11:55 davewood but is my issue because of the bug you mentioned? ot is it just an assumption? 11:52 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32242 critical, P5 - low, ---, m.de.rooy, Pushed to master , The job has not been sent to the message broker: (Wide character in syswrite ... ) 11:52 Joubu davewood: bug 32242 won't be part of .07, which may cause another problem in this area 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:40 marcelr hola tcohen 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/ViewPolicy.pm line 120. 11:40 tcohen hola #koha 11:27 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32242 major, P5 - low, ---, m.de.rooy, Pushed to master , The job has not been sent to the message broker: (Wide character in syswrite ... ) 11:27 Joubu bug 32242 11:27 Joubu davewood: Are you seeing "The job has not been sent to the message broker" in plack-intranet-error.log? 11:10 davewood thanks cait 10:58 davewood more info (logs, etc) i dont know where else i could look for debug info ... http://paste.scsys.co.uk/1617 10:55 davewood just something that I can pass mq-host/port/user/passwort/vhost too and that tells me everything looks good 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:53 cait I think we'll need one of theothers for that one, tcohen, Joubu, ashimema? 10:50 davewood koha-common/now 22.05.05-1 all [installed,upgradable to: 22.05.06-1] 10:49 cait davewood: which verion of Koha? 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 => http://paste.scsys.co.uk/1616 10:27 cait thx marcelr++ 10:27 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32399 major, P5 - low, ---, m.de.rooy, Needs Signoff , Database update for bug 30483 is failing 10:27 marcelr bug 32399 needs a signoff 09:11 marcelr hm dependabot 09:08 marcelr o/ 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 08:56 cait but nothing you could get data from Hea with 08:56 paxed sure, but when a query does dozen joins on 10 million rows, that's still slow no matter the storage 08:55 cait storage can make a huge difference 08:55 cait hm and no way to tell about hardware and modifications - both will impact performance greatly 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:54 cait and then still, what would we do with it? 08:54 cait we do some anonymization on the data, I am not sure we can combine the numbers and names 08:53 cait ? 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:51 paxed branches sounds right 08:49 cait libraries it says, so maybe branches, not sure 08:46 paxed cait: koha installations, or libraries? 08:45 cait if you update yours, please let me know so I can update the table on the website 08:45 cait Checked the demos on the website, all are online, but no 22.11 ones yet 08:43 cait 19.500 Kohas on Hea 08:01 wahanui what's up, alex_ 08:01 alex_ Bonjour 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:40 cait[m] I updated the env and killed my ktd... it's still wrong 07:40 cait[m] but I tried restarting all the things - put it in the issue 07:40 cait[m] I have to come back to this later - have to run 07:39 Joubu it worked for me 07:39 cait[m] Joubu: davidnind and I tried the quotes, they didn't help 07:06 Joubu and hi, #koha! 07:06 Joubu davidnind: that's certainly coming from https://gitlab.com/koha-community/koha-testing-docker/-/issues/316 07:02 wahanui Hi dcook are you around? 07:02 ashimema Hi dcook 07:02 ashimema Morning koha 03:20 dcook Happy Monday... 03:20 dcook I've got some headache inducing news for folk haha 03:20 dcook tcohen: Don't suppose you're still awake 03:20 dcook Oh boy 02:02 dcook Oh goody... it works on some datatables and not others.. 01:35 dcook Thanks. It's the worst. Haha. 01:32 davidnind Good luck! 01:32 dcook Hmm doesn't like Hebrew either it seems.. 01:31 dcook Trying to resolve a problem with DataTables and Arabic... not fun... 01:30 dcook Yeah I'm not sure about those biblioitems columns :/ 01:26 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32313 minor, P5 - low, ---, david, NEW , Complete database column descriptions for cataloguing module in guided reports 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:24 dcook Although being a programmer is just a state of mind :p 01:24 dcook Fair enough! 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! 00:52 davidnind Ages ago I had a go at using Selenium + Robot Framework + Screenshot library (see https://wiki.koha-community.org/wiki/Documentation_Automated_Screencapture and https://gitlab.com/davidnind/koha-automated-screenshots) 00:49 dcook I think selenium can do screenshots as well.. 00:49 dcook All good. Whatever we're using makes sense.. 00:48 davidnind I went for Cypress.io as that is what Joubu used for the electron resource module (ERM) use View 00:48 davidnind Thanks dcook for the suggestion - I'll have a look 00:43 dcook davidnind++ # Automating screenshots sounds pretty cool. I'm a fan of puppeteer/playwright for that kind of thing 00:41 huginn dcook: The operation succeeded. 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:07 davidnind sorry, wrong window 🙂 00:06 davidnind :q