Time Nick Message
01:49 yetyunglungTimothy[m] <Joubu> "you need to run the script in..." <- Hi Joubu, Thanks for your reply.
01:49 yetyunglungTimothy[m] I'm getting the error while running under koha-shell
01:49 yetyunglungTimothy[m] Invalid 'to' parameter: wxid_gaeoqxvn01an22mbts-koha@exabytes-91983485:/usr/share/koha/bin/cronjobs$
05:30 Joubu yetyunglungTimothy[m]: the error is self-explanatory, the "to" parameter you are passing to the script is not correct. What are you trying to acchieve?
06:04 Joubu @later tell oleonard Could you have a look at 32303? I have no idea what's going on!
06:04 huginn` Joubu: The operation succeeded.
06:47 paxed why oh why does intranet detail display "Itemtype:" come via detail.tt, but all the other informatin via XSLT?
06:55 yetyunglungTimothy[m] <Joubu> "yet yung lung Timothy: the error..." <- I'm trying to run the process_message_queue.pl
06:55 yetyunglungTimothy[m] because I can use postfix to send email but not at my Koha system.. The email status keep showing pending
06:56 Joubu remove the "to" parameter
06:58 yetyunglungTimothy[m] Joubu: let me try to find where is the "TO"
07:00 yetyunglungTimothy[m] yetyunglungTimothy[m]: I don't see the "to" parameter in the process_message_queue.pl file...
07:05 Joubu how do you run the script?
07:05 yetyunglungTimothy[m] server terminal
07:13 Joubu then?
07:18 * yetyunglungTimothy[m] uploaded an image: (11KiB) < https://matrix.org/_matrix/media/r0/download/matrix.org/ZwgZXDQKmLQqDiFGtayvFlYn/image.png >
07:18 yetyunglungTimothy[m] showing this error
07:20 Joubu The error is not meaningful, but I guess it means that the email cannot be sent because because the "to" value is not correct
07:21 Joubu which version of Koha are you using?
07:21 yetyunglungTimothy[m] 20.11.08.000
07:22 yetyunglungTimothy[m] I'm not sure whether is something related to this "bug"
07:22 yetyunglungTimothy[m] https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=102079&action=edit
07:24 Joubu latest 20.11 version is 20.11.19
07:24 Joubu you should upgrade to this version, first
07:29 yetyunglungTimothy[m] will it affect anything if my data ?
07:29 reiveune hello
07:31 Joubu yetyunglungTimothy[m]: It will modify the DB, not negatively. You should upgrade on a test system first.
07:36 yetyunglungTimothy[m] Joubu: ic.. ok.. Thanks for your help :)
07:37 cait1 good morning #koha
07:51 alex_ Bonjour
08:29 davewood cait1: yeah, I try to touch as little ass possible. currently im facing an issue where adding a new book doesnt trigger reindexing of the ES index. I have to run `koha-elasticsearch --rebuild <instancename>` to find the record.
08:29 davewood hmm ... that extra s was unfortunate and a typo. :)
08:32 Joubu davewood: which version of Koha are you using?
08:33 Joubu if recent, have a look at the background jobs, are you aware of them?
08:33 davewood koha-common/now 22.05.05-1 all [installed,upgradable to: 22.05.06-1]
08:37 Joubu davewood: have a look at admin/background-jobs.pl and make sure the index jobs have been run succcessfully
08:42 davewood Joubu: my rabbitmq logs shows a new connection from the koha instance right after adding a new book.
08:42 Joubu what's the status of the job?
08:45 davewood oh, thats a handy overview ... i see an entry "Update Elasticsearch index" progress 0/1
08:45 davewood records have successfully been reindexed. Some errors occurred.
08:45 davewood '/ records have successfully been reindexed. Some errors occurred.'
08:45 Joubu something wrong there ;)
08:46 Joubu if it isn't on the UI, have a look at the DB directly
08:46 Joubu select data from background_jobs where id=XX;
08:46 Joubu you should see the error there
08:52 davewood http://paste.scsys.co.uk/1000
08:53 Joubu hum no error there
08:53 davewood I dont see an error
08:53 davewood for the record, koha runs in a lxc container, and rabbitmq runs in a separate lxc container.
08:53 Joubu maybe in the log of the worker
08:54 Joubu /var/log/koha/$INSTANCE/worker-*
08:54 yetyunglungTimothy[m] Hi, can anyone help me with this, why I getting this error - "Unknown column 'b.marcxml' in 'field list'"... (full message at <https://matrix.org/_matrix/media/r0/download/matrix.org/suxkWDQKhvEeXJqkfsXYkqPc>)
08:57 Joubu marcxml as been moved to biblio_metadata.metadata
08:57 Joubu https://wiki.koha-community.org/wiki/SQL_Reports_Library - search for biblio_metadata there
08:59 yetyunglungTimothy[m] ic.. so I just changed the b.marcxml to metadata will do, right ?
09:00 davewood Joubu: I triggered a new background job while watching ` tail -f /var/log/koha/geosearch/worker-*log` ... worker-output.log and worker-error.log stay empty ... the background_jobs DB table entry looks the same as before.
09:18 cait1 yetyunglungTimothy[m]: not quite
09:18 cait1 yetyunglungTimothy[m]: you also need to link a different table
09:18 yetyunglungTimothy[m] 🥲
09:18 cait1 last line
09:18 cait1 new last line:
09:19 cait1 LEFT JOIN biblio_metadatabM ON (items.biblionumber = bm.biblionumber)
09:19 cait1 and then you change b.marcxml to bm.metadata
09:20 yetyunglungTimothy[m] OK. Let me try
09:20 cait1 new = just add the line. at the and.. not sure that was clear
09:20 cait1 you are still getting b.totalissues from biblioitems, so we need to keep that as well
09:22 yetyunglungTimothy[m] It said -> Table 'koha_mbts.biblio_metadatabm' doesn't exist
09:23 yetyunglungTimothy[m] SELECT old_issues.*, borrowers.cardnumber, borrowers.surname,... (full message at <https://matrix.org/_matrix/media/r0/download/matrix.org/bcBNECwMXvFIUpGnoxjsXXqN>)
09:23 Joubu davewood: is the worker running?
09:25 cait1 iblio_metadatabm missng a space here: iblio_metadata bm
09:26 cait1 biblio_metadata is the table, but we name it bm so we can refer to the column within it with bm.metadata
09:26 yetyunglungTimothy[m] cait1: OK. I try again
09:29 ndapanda hey there
09:29 yetyunglungTimothy[m] yetyunglungTimothy[m]: wow... it success... Thanks
09:30 ndapanda i just wanted to know if KOHA is a free library software.. does that mean the training will be free?
09:32 yetyunglungTimothy[m] is it possible to trace the process_message_queue.pl whether it is running?
09:32 yetyunglungTimothy[m] The email I sent from KOHA still showing "PENDING", but I send mail at server terminal using "echo" command but it sent immediately..
09:32 yetyunglungTimothy[m] What is the possible root caused for this issue ya?
09:32 yetyunglungTimothy[m] Sorry for my broken English...
09:33 davewood Joubu: worker wasnt running.
09:33 davewood root@koha-geosearch:~# koha-worker --start geosearch
09:33 davewood job status -> Finished
09:34 davewood thank you for your help, we will puth the worker status in our monitoring
09:34 davewood Joubu++
09:38 Joubu davewood: I think you need to specify a queue name
09:38 Joubu bug 27783, that is in 22.05
09:38 huginn` 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27783 enhancement, P5 - low, ---, martin.renvoize, RESOLVED FIXED, Introduce background job queues
09:39 Joubu there are 2 queues, default and long_tasks
09:39 Joubu without parameter I think it will only deal with 'default'
09:40 Joubu so either you start another worker (recommended) or you need to start it and pass the 2 queue parameters
09:40 Joubu or you just restart koha-common, that should deal with that properly
09:41 davewood etc/init.d/koha-common restart ... this should do the right thing I hope
09:42 Joubu yup, ps ax to make sure you have the 2 koha-worker processes ;)
09:43 davewood --queue long_tasks && --queue default are present
09:43 Joubu all good :)
10:00 cait1 yetyunglungTimothy[m]: the message_queue is processed every 15 minutes
10:01 cait1 so it's normal you don't see the email immediately
10:34 cait1 t
10:34 cait1 it looks like all the matrix users have been dropped
10:34 cait1 did we do something to cause this? When I message ashimema I see:
10:34 cait1 716: is in +g mode (server side ignore)
10:34 cait1 717: has been informed that you messaged or invited them.
10:34 ashimema huh
10:35 ashimema I PM'd you a few seconds ago..
10:35 ashimema it it replying to me that's got you that message?
11:03 cait1 hm don't see it
11:03 cait1 last is a lol :)
11:03 cait1 but it looks like the error is gone now
11:03 cait1 bbl!
11:35 oleonard o/
11:39 tcohen hola #koha
11:42 tcohen @later tell AndrewFH you don't have the SYNC_REPO env variable set
11:42 huginn` tcohen: The operation succeeded.
11:55 oleonard Welcome back [m] crew :D
12:00 cait1 shows how many have switched now :)
12:01 oleonard a lot of lurkers!
12:33 domm[m] Hey, slightly weird question: If a librarian accepts an acquisition and turns it into an order, the biblio should stay invisible in OPAC. This seems to have worked, but now it does not (and the librarians say they didn't change anything). Does anybody know where I could start digging to figure out why a biblio (which has an item, but the item has no signature) is suddenly visible in OPAC? Or where / how to turn that off?
12:34 cait1 it's probably to do with the changed behavior of default values maybe?
12:34 cait1 did you update since it worked or did it 'just' stop working?
12:35 cait1 you either hid them using OpacSuppression (using 942$n) or you hid them using item values (not for loan -1 or so) in OpacHiddenItems
12:40 oleonard Joubu: Maybe you know the answer to Bug 32291? I notice you've touched related code
12:40 huginn` 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32291 minor, P5 - low, ---, koha-bugs, NEW , What is a library category?
12:44 cait1 domm[m]: ^
12:46 Joubu oleonard: nothing, that's wrong code
12:47 Joubu oleonard: I bet it's bad copy/paste code from the admin/categories template
12:47 cait1 and I transalted it all! ;)
13:06 magnuse do entries in zebraqueue get indexed by elastic if SearchEngine = Elasticsearch? or only by zebra? is there another way to tell elastic to index something?
13:08 domm[m] cait1: I'll check 942$n etc, and there was no update to Koha
13:15 cait1 domm[m]: ok, so probably not a changed behaviour then :)
13:15 cait1 magnuse: I think both get indexed with searchengine = elastic, but that might be outdated information
13:16 cait1 i think if you have = zebra, elastic doesn't get updated
13:18 magnuse cait1: i have SearchEngine = Elasticsearch. i put som biblionumbers in zebraqueue and they got marked as done = 1, but the changes in the records (added items) do not show in search results
13:24 cait1 elastic doesn't use the zebraqueue
13:24 cait1 if you manually added that won't work
13:25 cait1 (using SQL)
13:26 magnuse cait1: ok!
13:26 * magnuse wonders what elastic does use...
13:26 cait1 I think it triggers background jobs from the code directly
13:27 cait1 but others might be able to explain that better
13:27 Joubu zebraqueue is for zebra, ES indexes "on the fly"
13:27 magnuse i found /usr/share/koha/bin/search_tools/rebuild_elasticsearch.pl which i think i can use
13:28 Joubu in most recent versions using a background job
13:28 cait1 yes, that script works - i have used that to do full reindex
13:30 magnuse cait++ Joubu++
13:33 matts Hi ! What version of docker should I be running for KTD ? I'm currently on the Ubuntu jammy version (Docker version 20.10.12) and 'ktd up' complains as follows :
13:33 matts unknown shorthand flag: 'f' in -f
13:33 matts See 'docker --help'
13:34 matts Version 20.10.17 is available in snap. Would that do the trick ?
13:40 matts Ok, I found the answer. If someone needs it: 'docker compose' is not a command on my system. docker-compose, on the other hand, is.
13:41 matts diff --git a/bin/ktd b/bin/ktd
13:41 matts - docker compose ${COMPOSE_OPTIONS} $@
13:41 matts + docker-compose ${COMPOSE_OPTIONS} $@
13:41 matts does the trick
13:42 * cait1 waves at matts
13:42 matts hi cait1 :)
13:42 cait1 vor docker compose you need v2
13:42 cait1 mine was too low when I installed the ubuntu one I think (jammy and kinetic)
13:42 cait1 but don't know about docker itself, I've used the instructions for installing from their repo now
13:43 cait1 linked from ktd README
13:43 matts Oh, ok, thanks cait1
13:52 Joubu matts: if you read the readme you will avoid the second most common problems :D
13:52 Joubu (search for "max_map_count")
13:53 matts Thanks Joubu, but the next problem I have is not this one, it's another :) (AH00526: Syntax error on line 18 of /etc/apache2/ports.conf: Cannot define multiple Listeners on the same IP:port)
13:55 Joubu shutdown the container
13:55 Joubu before up
13:55 Joubu that's the third most common problem :D
13:55 matts lol
13:55 matts That did the trick, thanks :)
13:56 matts Is there a fourth most common problem that I should know about ? :)
13:56 Joubu KOHA_SYNC not defined
13:56 Joubu or wrong
13:56 Joubu SYNC_REPO I mean
13:57 matts Ok, I somehow avoided this one :)
13:58 Joubu the apache prolem should have been fixed actually - https://gitlab.com/koha-community/koha-testing-docker/-/issues/282
13:58 Joubu tcohen: ^^
13:58 Joubu just noting, it's the second time in a couple of days
14:02 Joubu Unless matts forgot to pull new ktd containers
14:02 Joubu images*
14:03 matts Hmm, I did a fresh install this morning. They should be up to date, then, right ?
15:18 tcohen @seen marcelr
15:18 huginn` tcohen: marcelr was last seen in #koha 4 days, 6 hours, 55 minutes, and 44 seconds ago: <marcelr> ok
15:27 tcohen @later tell marcelr can you please take care of the t/db_dependent/Koha/Item/Template.t failure?
15:27 huginn` tcohen: The operation succeeded.
16:03 reiveune bye
16:18 ashimema magic cait
16:19 ashimema is there a way to search bugzilla for anything a particular user has touched in any way (from their login email)
16:19 cait1 probably
16:19 cait1 touched as?
16:19 cait1 commented?
16:19 ashimema commented, signed off
16:19 ashimema etc
16:20 cait1 advanced search - search by people
16:20 cait1 check all the checkboxes, enter name or email maybe
16:20 ashimema hmm
16:20 ashimema perhaps this person has never touched anything
16:20 ashimema as those searches come up empty
16:20 cait1 you might also want to extend the status
16:21 * ashimema is trying to track down users who haven't filled in their real names
16:21 ashimema so the dashboard looks a little cleaner
16:21 cait1 sometimes people use a different description/mail for bugzilla
16:21 cait1 what data do you have?
16:21 cait1 make sure you also extend status
16:21 cait1 to all status
16:39 tcohen Joubu: how do I reproduce the apache/ports problem?
16:42 tcohen Joubu: doesn't the problem with permissions come from misc4dev calling yarn as root or smth?
16:50 Joubu tcohen: I think it happens when you up ktd without down before
16:51 Joubu permissions? Which ones? I let my note somewhere, IIRC it does not work when prove it run using the -c param of koha-shell
16:51 Joubu but it works if you enter into a koha-shell, then run prove
16:52 tcohen I tried something
16:52 tcohen waiting for the images to build
19:22 tcohen mtj: are we ready with packaging/dependencies for the release?
19:46 huberto Now that tables are all (mostly?) loaded dynamically and use DataTables, has there been any discussion regarding the use of the "responsive" DataTables extension?
19:51 tcohen huberto: that's a great idea
19:51 tcohen file a bug for that?
19:59 huberto Sure. I will first work out the required steps then open a bug about it. Thanks!
23:10 cait[m] @later tell davidnind I finally updated the wiki for LTS: https://wiki.koha-community.org/wiki/Koha_Versioning
23:10 huginn` cait[m]: The operation succeeded.
23:11 cait[m] @later tell tuxayo I finally updated the wiki for LTS: https://wiki.koha-community.org/wiki/Koha_Versioning
23:11 huginn` cait[m]: The operation succeeded.
23:38 tuxayo cait++ thanks :D will read later
23:38 cait[m] yes please - hope i got it all right
23:39 tuxayo @davidnind , was a meeting scheduled for oceania-americas slot? It seems not http://irc.koha-community.org/search.pl?channel=koha&nick=&q=endmeeting
23:39 huginn` tuxayo: I'll give you the answer just as soon as RDA is ready
23:39 cait[m] i used the same time again for next dev sorry for that - i think the script hasn't been run yet