Time Nick Message 22:55 Sophia No worries at all. Thanks though :) 22:54 cait i think let it rest for today - get back to it tomorrow with fresh eyes 22:54 cait sorry, i will have to pass 22:53 Sophia to get the log I used the tail -f /var/log/koha/library/*.log 22:53 cait well or ont the error 22:52 cait hm the above is the apache logs - that doesn't look like a paroblem 22:52 Sophia I really appreciate you even thinking about this; honestly, I really do :) 22:52 Sophia Please try again later. 22:52 Sophia Unable to start your payment. 22:52 Sophia Error: there was a problem processing your payment 22:52 Sophia And here is the error: 22:52 Sophia 192.168.1.1 - - [02/Mar/2021:17:52:06 -0500] "GET /opac/errors/404.pl HTTP/1.1" 404 25931 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.190 Safari/537.36" 22:52 Sophia 192.168.1.1 - - [02/Mar/2021:17:52:05 -0500] "POST /opac/opac-account-pay.pl HTTP/1.1" 200 25454 "http://library.valleyofwada.org/cgi-bin/koha/opac-account.pl" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.190 Safari/537.36" 22:52 Sophia Here is what the logs show when I try to make a payment: 22:51 Sophia I can post it. 22:51 Sophia Oh no I just didn't want to flood you guys :) 22:51 cait but maybe double check the output, it might have the useful bit you need 22:51 cait ah you don't want to post that i understand 22:51 cait what is the error exactly and is there anything in the logs? 22:50 cait it should be more or less 22:50 cait the payplal one is 20.05, which is not that old yet - it should apply fine 22:50 Sophia For sure; I've used them for a lot already :) I just can't figure out this last piece of the puzzle. I was really hoping the plugin would be a plug 'n play sorta deal. 22:49 cait often older docs will work 22:49 cait bywaters tutorials are usually pretty good too 22:49 cait there is going a lot of work into it for the last few versions 22:49 cait it's hard to keep up with koha, but the first thing i'd always check is the manual 22:48 Sophia Oh, I mean anything recent. Everything I"m finding is for older versions of Koha. I can't find hardly anything for the current version :\ especially for payments etc. At least, nothing that makes any sense to me...probably to more technical people though they are helpful :) 22:48 cait why after 2017? 22:47 Sophia Documentation for anything is so hard to find after 2017. 22:47 Sophia Yeah for real. I'm so frustrated by this entire process. I really hope I never have to do this again LOL. 22:47 cait we don't use payment services yet here... so haven't played with this feature myself 22:47 cait :( 22:46 Sophia That's the one I followed to set this up :\ but my credentials don't look anything like theirs. 22:46 cait maybe this would be helpful: https://bywatersolutions.com/education/paypal-is-now-a-plugin 22:45 Sophia I've checked, but it can't hurt to check again. 22:45 cait maybe silly, but have you checked for addiitonal spaces and such in the configuration? 22:45 Sophia No worries at all; hopefully they see it eventually. I'm using the NVP/SOAP API integration (Classic) credentials. I've tried the built-in and the plugin and have had no luck with either. 22:45 cait so i think it's supposed to work 22:45 cait the plugin will replace the in-built feature (which is depracated now) 22:44 cait tcohen would be the best one to help you i guess, but probably not around at this time 22:44 cait hm ok 22:44 Sophia It was in the plugin configuration. I'm using the newer plugin. 22:44 cait i believe the plugin has its own configuration page 22:44 cait and are you using the in-bulit paypal feature via sysprefs or the actual newer plugin? 22:43 cait where did you enter the credentials? 22:32 Sophia It never even presents the user with a paypal login or anything; it just says there was an error. I tried to watch the logs as recommended earlier but nothing was showing up to give me a hint. 22:31 Sophia be useful in troubleshooting this. 22:31 Sophia No worries :) Whenever we try to process a payment via paypal we get the notice that there was an error processing our payment. I believe we have the right api credentials (we used the legacy ones from paypal for our business account) and we just can't seem to get it to process a payment. I'm trying to avoid sending you all a wall of text honestly because I'm not even sure what information would 22:30 cait what are the errors you seeß 22:30 cait but if you describe the problem someone might be able to help 22:30 cait at this our there is a little less people around 22:28 Sophia Hello again. I was able to get some amazing help this morning, and I am wondering if I can pick your brains for the last bit we need to get this library set up. We've downloaded the paypal plugin recommended from the koha plugins wiki, and we're running into some trouble. Would anyone be willing to help with this? Sorry to bug you all again. 19:57 kathryn it's been a super busy start to the year, in a good way 19:57 kathryn yup, takes a while to settle back from summer hols, but am WELL into it now 19:56 caroline pretty good, and you? 19:56 kathryn hi caroline, how are you? 19:55 caroline hello kathryn! 19:55 kathryn kia ora koutou, sorry to leave it so long between visits! 19:26 oleonard davidnind++ 19:16 cait thx :) 19:07 davidnind cait: Happy birthday! 🎉 🎂🎈 18:35 magnuse caroline++ cait++ ashimema++ bernardo++ 18:04 reiveune bye 17:51 cait lots of new work waiting... 17:51 cait yep 17:50 caroline And he told me bernardo added the 20.11 files to pootle 17:49 caroline I saw ashimema worked hard today 17:49 caroline no I didn't see. Good to know! 17:48 cait and did you see my comments about the german manual earlier? worked all like a charm now :) 17:48 cait great changes to manual lately :) 17:47 cait caroline++ 17:44 caroline I will add this subtlety to the manual 17:43 caroline ok thanks! 17:43 oleonard Yes 17:43 caroline kind of like IntranerUserCSS but a file instead of CSS code? 17:43 oleonard intranetcolorstylesheet is an addition to the default 17:42 oleonard intranetstylesheet is a full replacement for the staff client's default CSS 17:42 oleonard The color part is not accurate 17:42 caroline what is the difference between intranetcolorstylesheet and intranetstylesheet? If there are other things besides color changes in intranetcolorstylesheet, will they be ignored? 16:42 ashimema enjoy your birthday 16:42 ashimema have a nice evening cait 16:41 cait ok, time to leave and make dinner - bye all! 16:40 cait caroline: i think so - but i think all lowercase or so? 16:22 caroline_catlady Are index names the same in ES and Zebra? https://koha-community.org/manual/20.11/en/html/searching.html#koha-search-indexes 15:50 slef Is there a more current guide than https://wiki.koha-community.org/wiki/Shibboleth_Configuration or shall I try to update that to match current code? 15:36 cait Sophia++ too 15:31 cait Joubu++ great work 15:28 Sophia Alright; I'm going to head out now. Thanks again. Now it's time to take a crash course in library science LOL. Take care everyone :) 15:24 Sophia Indeed. 15:24 Joubu only the commands we give you here :) 15:23 Sophia You are incredible. Thank you so much. Seriously. You made my day. If you're in the states and would like a write off letter for helping me just let me know as we're a 501c3. I'll gladly send you one. 15:22 Sophia So I assume now the task is to delete these two databases, set it up again with the 'library' name that the club wanted, and never...ever...issue another koha command (internet Gods willing). 15:21 caroline_catlady Sophia++ Joubu++ 15:21 Sophia I just did! :) it worked perfectly! 15:21 Joubu try to catalogue a new record! :) 15:20 Sophia Thank you so friggen much I wish I could buy you all lunch or something <3 15:20 Sophia Great success! 15:19 pastebot "Sophia" at 127.0.0.1 pasted "flavour success!" (6 lines) at http://paste.koha-community.org/27957 15:18 Sophia Marc21 is now the database flaour! 15:12 Sophia I'm going to leave everything as default marc21 setup. I'm not going to click on anything etc. 15:12 Joubu :) 15:11 Sophia Okay...never mind. Now it works (I'm flailing over here LOL). Going through the setup in the browser. I'll post the flavor when done. 15:10 Sophia still can't access it now :\ man I think I need to just start from even a reinstall of debian I feel so lost :\ 15:06 Sophia oh wait! I need to set up the dns for the new domain. One second. 15:05 Sophia I can not access it. I get a site can't be reached now. 15:04 Sophia okay. let me see I called it vowlibrary so I should be able to reach it at vowlibrary-intra let me see if that works. 15:01 Sophia okay will do 15:01 Joubu at least to try, then we will see later 15:01 Joubu I am pretty sure koha-remove didn't remove everything correctly 15:01 Joubu try with something else than "library" 14:58 Sophia It happened quite quickly and so did the koha-create 14:58 Sophia no error on remove. 14:58 Joubu Sophia: did you get an error on koha-remove? 14:57 Sophia that's all I'm getting. I'm so confused :\ 14:57 Sophia DBI connect('database=koha_library;host=localhost;port=3306','koha_library',...) failed: Access denied for user 'koha_library'@'localhost' (using password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517. 14:55 Sophia I'm still getting an internal server error and nothing else :\ maybe I should start from scratch? 14:55 Joubu if you have a 500 (internal server error), then there is something in the logs 14:53 Sophia I did; but I'll give it a go again. 14:53 Joubu restart from there, the koha-plack commands, etc. 14:53 Joubu https://wiki.koha-community.org/wiki/Koha_on_Debian#Create_a_Koha_instance 14:52 Joubu Sophia: koha-remove then koha-create, then restart koha-common 14:52 Sophia I'm on windows 10. Koha is debian 10 14:52 Sophia Now I get an internal server error when I try to access the intra 14:52 Joubu Sophia: on which OS are you? 14:50 Joubu once it's done you go through the web install 14:50 Sophia Thanks! And then I just follow the tutorial as the wiki until I get to where I am now, right? Okay. I'll do that and run the flavour command afterwards before trying to add records etc and post the results. 14:50 Joubu then the same koha-create command you used, from the wiki page 14:49 Joubu that's the command to remove your instance 14:49 Joubu koha-remove 14:48 Joubu does not return anything then don't try anything else 14:48 Sophia Alright; is there a tutorial on how to drop and reinstall a library instance? I have no idea how to do that. 14:48 Joubu at the end of the install if: select value from systempreferences where variable="marcflavour"; 14:47 Joubu then check the log when you install 14:47 Sophia Yes; fresh install. I had this issue on the last fresh install I did though so it's probably something I'm doing. This is go number two LOL. 14:47 Joubu I mean, drop the Koha instance and recreate it (don't reinstall the whole system!) 14:47 Sophia I don't have that record now...maybe when I rebuilt the zebra index or something it caused issues? 14:47 Joubu if so, reinstall from scratch 14:47 Joubu is it a fresh install? 14:46 Sophia I followed this: https://wiki.koha-community.org/wiki/Koha_on_Debian 14:46 Joubu how did you install? 14:46 Joubu if you don't have the marcflavour system preference you will face problems :) 14:46 Sophia one second 14:46 Sophia let me try and see if it's still there then? 14:46 Joubu Did you remove them? 14:46 Sophia Thank you for your help @magnuse. 14:46 Joubu Sophia: ^ 14:45 Joubu https://imgur.com/a/74Vo4gM on this screenshot you have biblionumber=1 14:45 * magnuse gotta run 14:45 magnuse Joubu++ 14:45 cait sorry Joubu, plz continue 14:45 cait then something is really wrong 14:45 Sophia also empty set. 14:45 caroline_catlady with the ou 14:45 cait ah ok 14:44 caroline_catlady no, it's really marcflavour 14:44 caroline_catlady flavour seems wrong 14:44 Sophia let me try it with that spelling. 14:44 caroline_catlady I was checking that too 14:44 cait maybe 14:44 cait was it flavor? 14:42 Sophia I don't think we got the expected results. 14:41 pastebot "Sophia" at 127.0.0.1 pasted "Database selects" (20 lines) at http://paste.koha-community.org/27954 14:38 Joubu I am expecting: 1, 1:1, 'MARC21' 14:38 Sophia okay. I'll paste that here to the same site as before. 14:37 Joubu select value from systempreferences where variable="marcflavour"; 14:37 Joubu and select biblionumber, biblioitemnumber from biblioitems where biblionumber=1; 14:37 Joubu select count(*) from biblio where biblionumber=1; 14:35 Sophia Yep. 14:35 Joubu do you have access to the MySQL/MariaDB CLI? 14:35 Sophia that's a mild relief then. 14:34 Joubu there is something going on here 14:34 Joubu no 14:34 Sophia I'm sure it's me doing something dumb..but I have no idea what that dumb thing could be honestly. 14:32 Sophia I received the same issue of not being able to find the record. 14:32 pastebot "Sophia" at 127.0.0.1 pasted "Log from Koha" (12 lines) at http://paste.koha-community.org/27953 14:31 Sophia okay; going to do that now. 14:31 Joubu paste the output there http://paste.koha-community.org/ 14:31 Joubu try with an empty form and keep your eyes on the tail -f output when you save 14:30 Sophia No; I've tried that so many times and get the same issue that I"m trying to use the autofill feature now. Should I not use that? 14:30 Joubu you didn't create a new bibliographic record from an empty form 14:30 Sophia so only off by a few min. Would that create an issue? I'm accessing it via my acutal computer. This is on a small computer being used as a server that I have ssh into etc. 14:29 Sophia Yes; it's 9:29 am here currently. 14:29 Joubu 57 14:29 Joubu 9:26:58 14:28 Joubu does it match your current time? 14:27 Sophia error retrieving biblio 11 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 681. 14:27 Sophia ==> /var/log/koha/library/indexer-output.log <== 14:27 Sophia 192.168.1.1 - - [02/Mar/2021:09:26:57 -0500] "GET /intranet/cataloguing/additem.pl?biblionumber=11&frameworkcode=&searchid= HTTP/1.1" 200 29131 "http://library-intra.valleyofwada.org/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=0&z3950=1&frameworkcode=Default&breedingid=20" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.190 Safari/537.36" 14:27 Sophia 192.168.1.1 - - [02/Mar/2021:09:26:57 -0500] "POST /intranet/cataloguing/addbiblio.pl HTTP/1.1" 302 0 "http://library-intra.valleyofwada.org/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=0&z3950=1&frameworkcode=Default&breedingid=20" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.190 Safari/537.36" 14:27 Sophia ==> /var/log/koha/library/plack.log <== 14:27 Sophia [2021/03/02 09:26:57] [WARN] Use of uninitialized value $searchid in concatenation (.) or string at /usr/share/koha/intranet/cgi-bin/cataloguing/addbiblio.pl line 870. 14:27 Sophia [2021/03/02 09:26:57] [WARN] Use of uninitialized value $encoding in pattern match (m//) at /usr/share/koha/lib/C4/Biblio.pm line 3035. 14:27 Sophia [2021/03/02 09:26:57] [WARN] Use of uninitialized value $encoding in string eq at /usr/share/koha/lib/C4/Biblio.pm line 3015. 14:27 Sophia [2021/03/02 09:26:57] [WARN] Use of uninitialized value in string eq at /usr/share/koha/intranet/cgi-bin/cataloguing/addbiblio.pl line 86. 14:27 Sophia [2021/03/02 09:26:57] [WARN] Use of uninitialized value in string eq at /usr/share/koha/intranet/cgi-bin/cataloguing/addbiblio.pl line 50. 14:27 Sophia ==> /var/log/koha/library/plack-intranet-error.log <== 14:27 Sophia Okay here is what I get (I'm going to try and decrypt it but sharing in case you actually know what any of this means): 14:26 Joubu yes, with the *.log to make sure you are watching all of them :) 14:25 Sophia I'll try again though. 14:25 Sophia when I do the tail -f nothing shows up. When I check the log I get what looks like it entered the book. 14:25 Joubu then try again 14:25 Joubu try `tail -f /var/log/koha/YOUR_SITE/*.log` 14:25 Joubu so you should have something useful in the log 14:25 Sophia yes; right after hitting save. 14:25 Joubu you said you get "bibliographic record not found". Do you get it when you hit the save button after you tried to create a new bibliographic record? 14:24 Sophia So thankful for all the help :) 14:24 Joubu Sophia: my turn, trying again from the beginning 14:22 Sophia whatever the default is. I am not a libarian sadly...just the idiot who knows how to 'basically' set up servers for our club haha. My time at university was wasted studying philosophy not useful things like library management (which I sorely regret this last week!). 14:21 cait makes a difference for indexing and frameworks 14:21 cait Sophia: wondering, are you using UNIMARC or MARC21? 14:17 Sophia here's the image of what happened when I did that search : https://imgur.com/a/74Vo4gM 14:15 Sophia When I do the select * from biblio I see the records. They just don't let me search for them. 14:10 Sophia I see stuff like that when I do the zebra rebuild. 14:10 Sophia .error retrieving biblio 9 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 681. 14:09 Sophia No worries cait. I totally understand folks are doing this out of the kindness of their hearts. I am so lost with this...I just don't understand even where to start trying to figure out why this isn't saving. Each time I do the zebra rebuild I do see it referencing the new books I added...but they never show up in the actual catalogue :\ 14:08 cait Sorry Sophia - I can't help right now, but you have definitely come to the right place 14:07 cait TimothyAlexis: that's good,b ut don't scare me like that! :) 14:06 Sophia nothing happened. No new log entry or anything but it just says after saving "bibliographic record not found" 14:04 Sophia ah okay! I'll try that now and see if that can give me some direction. Seriously. Thank you. If I'm still lost I may have to bug you again LOL. 14:04 magnuse but the best will probably be to watch the plack error log while you try to add a record. if you have access to the server do "sudo tail -f /var/log/koha/library/plack-error-log" while you try to add a record 14:03 Sophia let me try and see if that brings anything up. I've been trying to use the auto fill (the new from z39 button) and making sure required fields were filled in and still nothing is saving :\ 14:02 magnuse you could create a report like "select * from biblio" and see if that gives you anything 14:02 magnuse no, default should be fine 14:02 magnuse you could check More > About Koha > System information 14:02 Sophia I've been using the default one; is there a different one I should be using? 14:01 magnuse if you get the cataloguing schema/form with all the fields etc it should be ok 14:00 Sophia *if that is an issue 14:00 Sophia I am using mariadb is that is an issue? I checked the database itself and it seems Koha did create a database etc. Is there somewhere I can look to make sure it's configured properly etc? 13:59 magnuse then reindexing won't help 13:59 magnuse Sophia: ah, sounds like the problem is in actually saving the records in the database, then 13:59 caroline_catlady wow thanks ashimema!! 13:54 Joubu oleonard: for Idref see 6af69c264885ac7c031351d03eca1495096c8fb1 13:53 Sophia But still no records in the system. 13:53 Sophia I did get error retreiving biblio 1 (2 etc). at /usr/share/koha/bin/migration_tools/rebuild_zebra if that helps. 13:51 Sophia When I check the logs it shows it's trying to upload/save them but when I click on the link to view the record it says 'not found'. I'll give the rebuid command a try. I really appreciate your help on this. I've been knocking my head against the wall on this thing for a few days now and figured it was time to reach out. 13:50 magnuse sometimes it helps to do a full reindex: "sudo koha-rebuild-zebra -f -v library" 13:49 magnuse ok, that's good 13:49 Sophia Thanks; both say okay running for library (that's the library name) 13:49 magnuse Sophia: in newer versions it will be "sudo koha-zebra --start library" 13:48 wahanui magnuse: that doesn't look right 13:48 magnuse change mykoha for the name of your instance 13:48 magnuse Sophia: try "sudo koha-indexer --status mykoha" and "sudo koha-zebra --status mykoha" 13:47 Sophia I'm still having the same issue. It says the record is not found. Do I need to configure zebra? I also had a notice that it was a depreceated script. Maybe that is an issue? 13:44 Sophia yep; apt-get packages. Thanks so much! I'm going to give that a shot. You're a life saver! 13:44 ashimema perfect 13:44 ashimema using packages? 13:44 ashimema how did oyu install? 13:44 Sophia I would do sudo koha-start-zebra library (right?) 13:43 Sophia oh! okay; is that easy to find in the documentation how to get set up? Thanks so much by the way. I am super lost with all this. 13:43 ashimema zebra 13:42 ashimema sounds like indexing isn't running 13:42 Sophia I'm not a professional or anything; I'm setting this up for a group I am a member of who would like to share books etc. 13:42 Sophia Hello. Would anyone mind helping me with an issue I am having with my Koha installation? I have it up and running but it will not save new books. After I save them they never show up. I even waited overnight to see if it was just taking time to populate etc. 13:41 TimothyAlexis I am working at this library with a temporary employment though. 13:40 TimothyAlexis cait: I wanted to thank you all just because I wanted to thank you. 13:14 oleonard I'm starting to wonder whether UNIMARC really exists... No one is every around to answer questions about it XD 13:13 oleonard Good idea cait 13:13 cait it comes with a pref that might make it easier to track 13:13 cait oleonard: maybe the initital test plan could help? i seem to remember to having tested it back then 13:12 cait ? 13:12 cait TimothyAlexis: you are not trying to leave I hopeß 13:05 oleonard I don't know what the circumstances are when it is displayed 13:05 oleonard [% IF IDREF and MARCAUTHOR.unimarc3 %] 13:05 oleonard I notice there's one instance left in the OPAC which uses the Greybox library 13:04 oleonard Anyone around who is familiar with UNIMARC? 13:03 ashimema might be easier 13:03 ashimema I'll write a patch and then get your opinion on the UX :) 13:02 ashimema I suppose this is sort of simlar 13:02 ashimema we have the filter box on the left on some pages.. the one we removed when we updated acquisitions orders to an ajax datatable 13:01 ashimema I would think so 13:01 oleonard Would a series of checkboxes work? [ ] show system types [ ] show point of sale [ ] show manual invoice 13:01 fridolin Your welcome TimothyAlexis :D 12:58 ashimema yup 12:58 oleonard So it could be a system type or not 12:58 ashimema I suppose they're "quick searches" in effect 12:56 ashimema or just those available via 'manual invoice' 12:56 ashimema the request here is to be able to quickly filter down to just those that are available via 'point of sale' 12:56 ashimema right now we display all but system types by default and have a button to expose the system ones too 12:55 ashimema but they can refer to point of sale, or manual invoicing.. or just be a system type 12:55 ashimema debit types are generic 12:55 ashimema ok.. 12:55 oleonard I'm not sure what you mean by types within types 12:54 ashimema any tips? 12:54 ashimema we have a reasonably nice 'show/hide system types' option as it stands.. but it would be nice to have a couple of single click filter options to filter down to the different types within types (point of sale, manual invoice).. I'm just not sure where to place any UX elements 12:53 ashimema any thoughts on how best to expose such filters? 12:52 ashimema oleonard, I'm contemplating Bug 24491 - Add filters to debit types interface 12:52 ashimema Pleasure TimothyAlexis :) 12:52 tcohen :-D 12:52 oleonard Very happy to be able to help, TimothyAlexis 12:52 ashimema :) 12:51 TimothyAlexis I want to thank you who have always been responsive and helpful here, at all times, even when I could have been more agreeable and respectful in asking. Thank you ashimema, cait, fridolin, Joubu, kohaputti, magnuse, oleonard, tcohen and tuxayo. 12:49 kohaputti seems to be on idea phase 12:49 ashimema let us know how you get on.. i'd be really interested 12:49 kohaputti https://metacpan.org/pod/distribution/Devel-NYTProf/MemoryProfiling.pod 12:49 ashimema dang 12:49 ashimema I can't see any mention of memory profiling 12:49 ashimema it's been a while 12:49 ashimema hmm, maybe it doesn't actually 12:48 ashimema likely others too 12:48 kohaputti it has memory too? 12:48 ashimema NYTProf is probably your friend 12:48 kohaputti I will try to find some tool to trace the leak 12:47 ashimema so there must be a leak somewhere in ModBilio or GetMarcBiblio I reckon 12:47 kohaputti so something is read to memory again and again 12:46 ashimema indeed 12:46 kohaputti anyway... In the touch_all_biblios.pl case the perl code should not grow in memory usage because perl should re-use the allocated memory not used by the program 12:45 ashimema sometimes once you've seen good code, it's hard to unsee it 12:45 ashimema but as I tried to implement such a fix I ended up finding myself basically writing a clone of Minion. 12:44 ashimema that way forking becomes part of the tasks themselves so people implementing alternate workers don't get caught out by this same issue 12:44 ashimema rather than putting it directly in the worker 12:43 ashimema as for bug 27756 itself... I was looking at it from a rather different direction to Joubu's fix.. I was thinking of putting the fork inside Koha::BackgroundJob as a wrapper around process.. 12:42 ashimema our 'kill and restart' is a terrible work around really 12:42 ashimema and should really be working to resolve them 12:42 ashimema we certainly have leaks in Koha 12:42 ashimema yup 12:42 ashimema as forking will limit the leak to just that run of the task 12:42 kohaputti yeah, with plack for example it is also a problem, because we have it setup every 5000 requests to restart the process and that causes that time for Koha to load like 5 seconds I think 12:41 ashimema but yes.. this does also help with leaks when there are some 12:41 ashimema there are of course other real leaks that are easy to introduce 12:40 ashimema it's only a problem in the daemon case really 12:40 ashimema perl grabs memory it needs as it needs it.. then re-uses it whenever possible.. by doing that it can quickly access memory a second time.. 12:39 ashimema well.. again it depends on perspective really.. 12:39 ashimema because this is a daemon sitting around.. it's good practice to fork so you reclaim the memory as soon as the task is completed 12:39 ashimema the problem comes when you run one massive task and it eats all that memory forever 12:38 kohaputti It sounds like a bug in perl 12:38 ashimema one task may well take more memory than another.. that's fine 12:38 kohaputti but is it really true? 12:38 ashimema yeah, exactly 12:38 ashimema hmm.. I wouldn't say there's a leak as such in that case 12:38 kohaputti but if what David says "Once Perl allocates memory, it doesn't return that memory to the Operating System for the life of that Perl process" is true then O.o maybe that might be necessary 12:38 kohaputti 27756 12:37 ashimema you mean for the 27756 case.. or for your touch_all_bibs case? 12:37 kohaputti but doesn't actually fix the leak. 12:36 kohaputti it just prevents the leak getting too big by killing and creating new process, right? 12:36 koha-jenkins Project Koha_20.11_D9 build #68: SUCCESS in 55 min: https://jenkins.koha-community.org/job/Koha_20.11_D9/68/ 12:36 kohaputti the forking solution for bug 27756 doesn't sound right 12:31 oleonard Bug 27756 12:29 ashimema https://stackoverflow.com/questions/9733146/tips-for-keeping-perl-memory-usage-low/9734699#9734699 12:29 ashimema bug 277756.. dcook links to stackoverflow that gives just about the best answer i've seen regarding how perl can gobble up memory 12:27 * ashimema digs out a link 12:27 ashimema perl can be a bit funky with the way it handles memory kohaputti 12:25 magnuse yay! well deserved! 12:24 cait i just went out in my lunch break and bought me a piece :) 12:24 magnuse happy birthday cait! may there be cake! 12:23 cait hm i'll keep that in mind! 12:21 kohaputti so if you have many cores you get it faster done 12:21 kohaputti but it is actually possible to launch multiple instances of this script with the WHERE option in touch_all_biblios.pl 12:21 cait I seem to remember Ere working on some performance improvements for it when he did the subtitle and other fields, but not sure 12:21 kohaputti yeah, some perf optimization would be also nice but I'm now worried about running out-of-mem on prod :D 12:20 cait because it's so slow... 12:20 cait kohaputti: that's really long, but you got a big collection. I think we never ran it actually, we always worked around it somehow doing the migration manually 12:20 koha-jenkins Project Koha_20.11_U20 build #50: SUCCESS in 44 min: https://jenkins.koha-community.org/job/Koha_20.11_U20/50/ 12:19 cait :) 12:19 oleonard I don't remember how I learned it but I put it in my calendar :D 12:19 kohaputti heyy, has any of you tracked down memleaks in Koha before? The script /usr/share/koha/bin/maintenance/touch_all_biblios.pl started at around 200MB of Mem usage and now after around a week of it running it is at 1.7GB. 12:18 cait thank you :) and thx for remembering! 12:18 oleonard HAPPY BIRTHDAY \o/ 12:17 cait it is 12:17 oleonard Whether it is indeed your birthday today? 12:17 cait oleonard: what was the question? 12:17 cait1 back 12:10 cait will ocme back as he other cait in a moment 12:10 cait sorry, switching between computers 12:10 cait hm? 12:10 oleonard cait did you see my question earlier? 11:48 koha-jenkins Project Koha_20.11_U16 build #51: FIXED in 1 hr 1 min: https://jenkins.koha-community.org/job/Koha_20.11_U16/51/ 11:48 wahanui Congratulations! 11:48 koha-jenkins Yippee, build fixed! 11:47 oleonard https://www.caniuse.com/mdn-javascript_builtins_array_filter 11:46 oleonard Like I said, this is only a defacto support list, but caniuse tracks JS features too 11:46 koha-jenkins Project Koha_20.11_D10 build #67: SUCCESS in 58 min: https://jenkins.koha-community.org/job/Koha_20.11_D10/67/ 11:45 oleonard You can see the list that this translates to by running npx browserslist '> 0.5%, last 2 versions, Firefox ESR' 11:45 ashimema thanks 11:45 ashimema cool 11:45 oleonard This is a defacto browser support list for the OPAC 11:45 oleonard ashimema: When we build CSS for the OPAC we use a plugin called "autoprefixer" which connects to CanIUse.com to determine what current support is for various features. We don't pass any additional config, so it uses the default, which is "> 0.5%, last 2 versions, Firefox ESR" 11:41 koha-jenkins Project Koha_20.11_U2010 build #47: SUCCESS in 53 min: https://jenkins.koha-community.org/job/Koha_20.11_U2010/47/ 11:35 koha-jenkins Project Koha_20.11_U18 build #46: SUCCESS in 47 min: https://jenkins.koha-community.org/job/Koha_20.11_U18/46/ 11:33 aindriu ok, thanks for your help oleonard 11:32 ashimema what oleonard said.. I was going to suggest marcedit 11:32 ashimema I'm not sure I'm afraid aindriu.. I've scripted things before like that but it's been a number of years 11:32 oleonard aindriu: You might want to investigate options for using MarcEdit to convert your data 11:31 ashimema and hopefully 'filter' is ok 11:31 aindriu Can someone help me, I want to bring all the books in our Access database to Koha, do you know how to do this? 11:31 ashimema I reckon I'm safe to use 'indexOf'.. grepping the codebase it looks like we already use it allot 11:31 ashimema I was trying to work it out for bug 27807 11:31 oleonard ...but it generally revolves around IE versions rather than being comprehensive 11:30 oleonard I feel like it all lives in mailing list discussions 11:30 ashimema lol 11:30 oleonard I don't know that we have an official list... :/ 11:28 ashimema remind me.. where do we list our target browser support? 11:27 oleonard Hi ashimema 11:27 ashimema morning oleonard 11:26 aindriu hi, we have an Microsoft Access database of a lot of books, we recently got Koha up and running on another machine, is it possible to import the Microsoft Access Database? 11:26 ashimema ooh 11:25 oleonard cait1: My calendar tells me that today is your birthday. Is this true? 11:24 Joubu I sent him and email this morning 11:18 magnuse gmcharlt_ it is 11:17 wahanui hmmm... irc regulars is https://wiki.koha-community.org/wiki/IRC_Regulars 11:17 magnuse irc regulars? 11:17 magnuse indeed! 11:13 cait1 huginn! we miss yo so much 11:11 magnuse Bug 27830 - OPAC library list does not use AddressFormat https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27830 11:11 magnuse bug 27830 :-) 11:05 cait1 magnuse: i think only the ones on the patron address page so far - file a bug? :) 10:51 fridolin it applyes on master 10:50 fridolin Joubu: ok signed-off 10:49 magnuse lulz 10:48 wahanui 40.16 10:48 Joubu 20.11 and 20.05 10:44 fridolin ah very simple, i signoff 10:44 fridolin Joubu: arf on master also or juste 20.11 ? 10:41 ashimema Bug 27807 - API DataTables Wrapper fails for ordered on multiple columns 10:40 ashimema grr.. I really miss huggin 10:40 ashimema bug 27807 ready for testing 10:38 Joubu fridolin: 27828 10:05 magnuse AddressFormat does not affect the format of the addresses on OPAC/cgi-bin/koha/opac-library.pl ? 10:04 tcohen hi cait1 ! 09:56 cait1 and it's only at the last step, so people have been clicking through all the time before 09:56 cait1 better to make it an event that you can control intead of a timed redirect 09:55 cait1 you might still be missing the "success message" 09:55 cait1 i think usability wise... if you are using a screen reader or suh 09:44 ashimema I do 09:42 cait1 morning tcohen! 09:42 cait1 and i never wait it out 09:42 cait1 i think it makes no sense to have it just at that step 09:42 cait1 i wanted to take a closer look at that one but didn't get to it yet 09:42 cait1 yes 09:41 Joubu cait1: do you agree with removing the "redirect after 10 sec" behaviour at the end of the installer? (27473) 09:40 cait1 bgkriegel++ caroline_catlady++ ashimema++ 09:40 cait1 ... and new work arrived: https://translate.koha-community.org/de/man20.11/ 09:39 tcohen morning 09:37 ashimema wow.. it took over an hour! 09:37 cait1 but i won't look much closer, i will only find new typos and such 09:37 ashimema humm.. 20.11 failed though.. grr 09:37 wahanui darn tootin' it is. 09:37 ashimema excellent 09:37 cait1 ashimema: thx! the manual is looking good now https://koha-community.org/manual/20.05/de/html/index.html 09:15 * cait1 waves 08:59 nlegrand Bonjour #koha 08:50 magnuse \o/ 08:47 ashimema I was running against the equivalent in db_dependant 08:47 ashimema ooh.. I wasn't even aware of that test 08:23 ashimema Just doing some breakfast, then will take a look 08:22 Joubu (see last comment) 08:22 Joubu ashimema: can you have a look at the failing test from 27680? 08:22 Joubu auth is done with gitea 08:21 Joubu yep 08:21 ashimema also.. we need to update the wiki.. gitolite is no longer a thing now we've moved the git server.. right Joubu? 08:20 * ashimema tihnks it's time to ask for the keys to that server as well.. it's one of the few I'm missing 08:20 ashimema Joubu++ 08:18 ashimema they take a while now.. the build process is slow 08:18 ashimema if they go red,, then I need to investigate more.. pretty sure they should finally be reliably green again though 08:18 ashimema if you can, there's three blue ones.. 'Running'.. when they turn green 'Passed' then it means they've run to completion and the manuals should be there 08:17 ashimema can you see this page cait https://gitlab.com/koha-community/koha-manual/-/pipelines 08:16 cait1 ashimema: do you get a note when they finish? i coudl check mine? 08:16 ashimema @later tell gmcharlt any chance you could give the bots a poke... or teach me how to perhaps? 08:15 ashimema still no bots :( 08:15 ashimema bug 26893 08:15 ashimema @later tell Caroline I triggered the merge requests for 19.11, 20.05 and 20.11 translations and have merged them all for you.. so those branches at least should all have the very latest translated copies of the manual on koha-community.org shortly. (once the builds have finished) 08:14 ashimema @later tell caroline it looks like bernardo has set up the 20.11 manuals for translation now 08:14 ashimema morning #koha 08:12 cait1 good morning #koha 07:56 wahanui hello, alex_a 07:56 alex_a Bonjour 07:00 reiveune hello 06:52 fridolin hi there 04:16 mtj Joubu: ill sort a fix for 26893 tonite 04:15 mtj slef: looking at the script, i dont think so ^