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