Time Nick Message 04:15 mtj slef: looking at the script, i dont think so ^ 04:16 mtj Joubu: ill sort a fix for 26893 tonite 06:52 fridolin hi there 07:00 reiveune hello 07:56 alex_a Bonjour 07:56 wahanui hello, alex_a 08:12 cait1 good morning #koha 08:14 ashimema morning #koha 08:14 ashimema @later tell caroline it looks like bernardo has set up the 20.11 manuals for translation now 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:15 ashimema bug 26893 08:15 ashimema still no bots :( 08:16 ashimema @later tell gmcharlt any chance you could give the bots a poke... or teach me how to perhaps? 08:16 cait1 ashimema: do you get a note when they finish? i coudl check mine? 08:17 ashimema can you see this page cait https://gitlab.com/koha-community/koha-manual/-/pipelines 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: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 they take a while now.. the build process is slow 08:20 ashimema 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: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:21 Joubu yep 08:22 Joubu auth is done with gitea 08:22 Joubu ashimema: can you have a look at the failing test from 27680? 08:22 Joubu (see last comment) 08:23 ashimema Just doing some breakfast, then will take a look 08:47 ashimema ooh.. I wasn't even aware of that test 08:47 ashimema I was running against the equivalent in db_dependant 08:50 magnuse \o/ 08:59 nlegrand Bonjour #koha 09:15 * cait1 waves 09:37 cait1 ashimema: thx! the manual is looking good now https://koha-community.org/manual/20.05/de/html/index.html 09:37 ashimema excellent 09:37 wahanui darn tootin' it is. 09:37 ashimema humm.. 20.11 failed though.. grr 09:37 cait1 but i won't look much closer, i will only find new typos and such 09:37 ashimema wow.. it took over an hour! 09:39 tcohen morning 09:40 cait1 ... and new work arrived: https://translate.koha-community.org/de/man20.11/ 09:40 cait1 bgkriegel++ caroline_catlady++ ashimema++ 09:41 Joubu cait1: do you agree with removing the "redirect after 10 sec" behaviour at the end of the installer? (27473) 09:42 cait1 yes 09:42 cait1 i wanted to take a closer look at that one but didn't get to it yet 09:42 cait1 i think it makes no sense to have it just at that step 09:42 cait1 and i never wait it out 09:42 cait1 morning tcohen! 09:44 ashimema I do 09:55 cait1 i think usability wise... if you are using a screen reader or suh 09:55 cait1 you might still be missing the "success message" 09:56 cait1 better to make it an event that you can control intead of a timed redirect 09:56 cait1 and it's only at the last step, so people have been clicking through all the time before 10:04 tcohen hi cait1 ! 10:05 magnuse AddressFormat does not affect the format of the addresses on OPAC/cgi-bin/koha/opac-library.pl ? 10:38 Joubu fridolin: 27828 10:40 ashimema bug 27807 ready for testing 10:40 ashimema grr.. I really miss huggin 10:41 ashimema Bug 27807 - API DataTables Wrapper fails for ordered on multiple columns 10:44 fridolin Joubu: arf on master also or juste 20.11 ? 10:44 fridolin ah very simple, i signoff 10:48 Joubu 20.11 and 20.05 10:48 wahanui 40.16 10:49 magnuse lulz 10:50 fridolin Joubu: ok signed-off 10:51 fridolin it applyes on master 11:05 cait1 magnuse: i think only the ones on the patron address page so far - file a bug? :) 11:11 magnuse bug 27830 :-) 11:11 magnuse Bug 27830 - OPAC library list does not use AddressFormat https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27830 11:13 cait1 huginn! we miss yo so much 11:17 magnuse indeed! 11:17 magnuse irc regulars? 11:17 wahanui hmmm... irc regulars is https://wiki.koha-community.org/wiki/IRC_Regulars 11:18 magnuse gmcharlt_ it is 11:24 Joubu I sent him and email this morning 11:25 oleonard cait1: My calendar tells me that today is your birthday. Is this true? 11:26 ashimema ooh 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:27 ashimema morning oleonard 11:27 oleonard Hi ashimema 11:28 ashimema remind me.. where do we list our target browser support? 11:30 oleonard I don't know that we have an official list... :/ 11:30 ashimema lol 11:30 oleonard I feel like it all lives in mailing list discussions 11:31 oleonard ...but it generally revolves around IE versions rather than being comprehensive 11:31 ashimema I was trying to work it out for bug 27807 11:31 ashimema I reckon I'm safe to use 'indexOf'.. grepping the codebase it looks like we already use it allot 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 and hopefully 'filter' is ok 11:32 oleonard aindriu: You might want to investigate options for using MarcEdit to convert your data 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 ashimema what oleonard said.. I was going to suggest marcedit 11:33 aindriu ok, thanks for your help oleonard 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: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: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:45 oleonard This is a defacto browser support list for the OPAC 11:45 ashimema cool 11:45 ashimema thanks 11:45 oleonard You can see the list that this translates to by running npx browserslist '> 0.5%, last 2 versions, Firefox ESR' 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:46 oleonard Like I said, this is only a defacto support list, but caniuse tracks JS features too 11:47 oleonard https://www.caniuse.com/mdn-javascript_builtins_array_filter 11:48 koha-jenkins Yippee, build fixed! 11:48 wahanui Congratulations! 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/ 12:10 oleonard cait did you see my question earlier? 12:10 cait hm? 12:10 cait sorry, switching between computers 12:10 cait will ocme back as he other cait in a moment 12:17 cait1 back 12:17 cait oleonard: what was the question? 12:17 oleonard Whether it is indeed your birthday today? 12:17 cait it is 12:18 oleonard HAPPY BIRTHDAY \o/ 12:18 cait thank you :) and thx for remembering! 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:19 oleonard I don't remember how I learned it but I put it in my calendar :D 12:19 cait :) 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: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 cait because it's so slow... 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: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 but it is actually possible to launch multiple instances of this script with the WHERE option in touch_all_biblios.pl 12:21 kohaputti so if you have many cores you get it faster done 12:23 cait hm i'll keep that in mind! 12:24 magnuse happy birthday cait! may there be cake! 12:24 cait i just went out in my lunch break and bought me a piece :) 12:25 magnuse yay! well deserved! 12:27 ashimema perl can be a bit funky with the way it handles memory kohaputti 12:27 * ashimema digs out a link 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:29 ashimema https://stackoverflow.com/questions/9733146/tips-for-keeping-perl-memory-usage-low/9734699#9734699 12:31 oleonard Bug 27756 12:36 kohaputti the forking solution for bug 27756 doesn't sound 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 it just prevents the leak getting too big by killing and creating new process, right? 12:37 kohaputti but doesn't actually fix the leak. 12:37 ashimema you mean for the 27756 case.. or for your touch_all_bibs case? 12:38 kohaputti 27756 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 ashimema hmm.. I wouldn't say there's a leak as such in that case 12:38 ashimema yeah, exactly 12:38 kohaputti but is it really true? 12:38 ashimema one task may well take more memory than another.. that's fine 12:38 kohaputti It sounds like a bug in perl 12:39 ashimema the problem comes when you run one massive task and it eats all that memory forever 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 well.. again it depends on perspective 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:40 ashimema it's only a problem in the daemon case really 12:41 ashimema there are of course other real leaks that are easy to introduce 12:41 ashimema but yes.. this does also help with leaks when there are some 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:42 ashimema as forking will limit the leak to just that run of the task 12:42 ashimema yup 12:42 ashimema we certainly have leaks in Koha 12:42 ashimema and should really be working to resolve them 12:42 ashimema our 'kill and restart' is a terrible work around really 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:44 ashimema rather than putting it directly in the worker 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:45 ashimema but as I tried to implement such a fix I ended up finding myself basically writing a clone of Minion. 12:45 ashimema sometimes once you've seen good code, it's hard to unsee it 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:46 ashimema indeed 12:47 kohaputti so something is read to memory again and again 12:47 ashimema so there must be a leak somewhere in ModBilio or GetMarcBiblio I reckon 12:48 kohaputti I will try to find some tool to trace the leak 12:48 ashimema NYTProf is probably your friend 12:48 kohaputti it has memory too? 12:48 ashimema likely others too 12:49 ashimema hmm, maybe it doesn't actually 12:49 ashimema it's been a while 12:49 ashimema I can't see any mention of memory profiling 12:49 ashimema dang 12:49 kohaputti https://metacpan.org/pod/distribution/Devel-NYTProf/MemoryProfiling.pod 12:49 ashimema let us know how you get on.. i'd be really interested 12:49 kohaputti seems to be on idea phase 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:52 ashimema :) 12:52 oleonard Very happy to be able to help, TimothyAlexis 12:52 tcohen :-D 12:52 ashimema Pleasure TimothyAlexis :) 12:52 ashimema oleonard, I'm contemplating Bug 24491 - Add filters to debit types interface 12:53 ashimema any thoughts on how best to expose such filters? 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:54 ashimema any tips? 12:55 oleonard I'm not sure what you mean by types within types 12:55 ashimema ok.. 12:55 ashimema debit types are generic 12:55 ashimema but they can refer to point of sale, or manual invoicing.. or just be a system type 12:56 ashimema right now we display all but system types by default and have a button to expose the system ones too 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 or just those available via 'manual invoice' 12:58 ashimema I suppose they're "quick searches" in effect 12:58 oleonard So it could be a system type or not 12:58 ashimema yup 13:01 fridolin Your welcome TimothyAlexis :D 13:01 oleonard Would a series of checkboxes work? [ ] show system types [ ] show point of sale [ ] show manual invoice 13:01 ashimema I would think so 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:02 ashimema I suppose this is sort of simlar 13:03 ashimema I'll write a patch and then get your opinion on the UX :) 13:03 ashimema might be easier 13:04 oleonard Anyone around who is familiar with UNIMARC? 13:05 oleonard I notice there's one instance left in the OPAC which uses the Greybox library 13:05 oleonard [% IF IDREF and MARCAUTHOR.unimarc3 %] 13:05 oleonard I don't know what the circumstances are when it is displayed 13:12 cait TimothyAlexis: you are not trying to leave I hopeß 13:12 cait ? 13:13 cait oleonard: maybe the initital test plan could help? i seem to remember to having tested it back then 13:13 cait it comes with a pref that might make it easier to track 13:13 oleonard Good idea cait 13:14 oleonard I'm starting to wonder whether UNIMARC really exists... No one is every around to answer questions about it XD 13:40 TimothyAlexis cait: I wanted to thank you all just because I wanted to thank you. 13:41 TimothyAlexis I am working at this library with a temporary employment though. 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: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 ashimema sounds like indexing isn't running 13:43 ashimema zebra 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:44 Sophia I would do sudo koha-start-zebra library (right?) 13:44 ashimema how did oyu install? 13:44 ashimema using packages? 13:44 ashimema perfect 13:44 Sophia yep; apt-get packages. Thanks so much! I'm going to give that a shot. You're a life saver! 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:48 magnuse Sophia: try "sudo koha-indexer --status mykoha" and "sudo koha-zebra --status mykoha" 13:48 magnuse change mykoha for the name of your instance 13:48 wahanui magnuse: that doesn't look right 13:49 magnuse Sophia: in newer versions it will be "sudo koha-zebra --start library" 13:49 Sophia Thanks; both say okay running for library (that's the library name) 13:49 magnuse ok, that's good 13:50 magnuse sometimes it helps to do a full reindex: "sudo koha-rebuild-zebra -f -v library" 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:53 Sophia I did get error retreiving biblio 1 (2 etc). at /usr/share/koha/bin/migration_tools/rebuild_zebra if that helps. 13:53 Sophia But still no records in the system. 13:54 Joubu oleonard: for Idref see 6af69c264885ac7c031351d03eca1495096c8fb1 13:59 caroline_catlady wow thanks ashimema!! 13:59 magnuse Sophia: ah, sounds like the problem is in actually saving the records in the database, then 13:59 magnuse then reindexing won't help 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? 14:00 Sophia *if that is an issue 14:01 magnuse if you get the cataloguing schema/form with all the fields etc it should be ok 14:02 Sophia I've been using the default one; is there a different one I should be using? 14:02 magnuse you could check More > About Koha > System information 14:02 magnuse no, default should be fine 14:02 magnuse you could create a report like "select * from biblio" and see if that gives you anything 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: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: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:06 Sophia nothing happened. No new log entry or anything but it just says after saving "bibliographic record not found" 14:07 cait TimothyAlexis: that's good,b ut don't scare me like that! :) 14:08 cait Sorry Sophia - I can't help right now, but you have definitely come to the right place 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:10 Sophia .error retrieving biblio 9 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 681. 14:10 Sophia I see stuff like that when I do the zebra rebuild. 14:15 Sophia When I do the select * from biblio I see the records. They just don't let me search for them. 14:17 Sophia here's the image of what happened when I did that search : https://imgur.com/a/74Vo4gM 14:21 cait Sophia: wondering, are you using UNIMARC or MARC21? 14:21 cait makes a difference for indexing and frameworks 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:24 Joubu Sophia: my turn, trying again from the beginning 14:24 Sophia So thankful for all the help :) 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:25 Sophia yes; right after hitting save. 14:25 Joubu so you should have something useful in the log 14:25 Joubu try `tail -f /var/log/koha/YOUR_SITE/*.log` 14:25 Joubu then try again 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 Sophia I'll try again though. 14:26 Joubu yes, with the *.log to make sure you are watching all of them :) 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:27 Sophia ==> /var/log/koha/library/plack-intranet-error.log <== 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 [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 $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 $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 $searchid in concatenation (.) or string at /usr/share/koha/intranet/cgi-bin/cataloguing/addbiblio.pl line 870. 14:27 Sophia ==> /var/log/koha/library/plack.log <== 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 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 ==> /var/log/koha/library/indexer-output.log <== 14:27 Sophia error retrieving biblio 11 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 681. 14:28 Joubu does it match your current time? 14:29 Joubu 9:26:58 14:29 Joubu 57 14:29 Sophia Yes; it's 9:29 am here currently. 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:30 Joubu you didn't create a new bibliographic record from an empty form 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:31 Joubu try with an empty form and keep your eyes on the tail -f output when you save 14:31 Joubu paste the output there http://paste.koha-community.org/ 14:31 Sophia okay; going to do that now. 14:32 pastebot "Sophia" at 127.0.0.1 pasted "Log from Koha" (12 lines) at http://paste.koha-community.org/27953 14:32 Sophia I received the same issue of not being able to find the record. 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:34 Joubu no 14:34 Joubu there is something going on here 14:35 Sophia that's a mild relief then. 14:35 Joubu do you have access to the MySQL/MariaDB CLI? 14:35 Sophia Yep. 14:37 Joubu select count(*) from biblio where biblionumber=1; 14:37 Joubu and select biblionumber, biblioitemnumber from biblioitems where biblionumber=1; 14:37 Joubu select value from systempreferences where variable="marcflavour"; 14:38 Sophia okay. I'll paste that here to the same site as before. 14:38 Joubu I am expecting: 1, 1:1, 'MARC21' 14:41 pastebot "Sophia" at 127.0.0.1 pasted "Database selects" (20 lines) at http://paste.koha-community.org/27954 14:42 Sophia I don't think we got the expected results. 14:44 cait was it flavor? 14:44 cait maybe 14:44 caroline_catlady I was checking that too 14:44 Sophia let me try it with that spelling. 14:44 caroline_catlady flavour seems wrong 14:44 caroline_catlady no, it's really marcflavour 14:45 cait ah ok 14:45 caroline_catlady with the ou 14:45 Sophia also empty set. 14:45 cait then something is really wrong 14:45 cait sorry Joubu, plz continue 14:45 magnuse Joubu++ 14:45 * magnuse gotta run 14:45 Joubu https://imgur.com/a/74Vo4gM on this screenshot you have biblionumber=1 14:46 Joubu Sophia: ^ 14:46 Sophia Thank you for your help @magnuse. 14:46 Joubu Did you remove them? 14:46 Sophia let me try and see if it's still there then? 14:46 Sophia one second 14:46 Joubu if you don't have the marcflavour system preference you will face problems :) 14:46 Joubu how did you install? 14:46 Sophia I followed this: https://wiki.koha-community.org/wiki/Koha_on_Debian 14:47 Joubu is it a fresh install? 14:47 Joubu if so, reinstall from scratch 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 I mean, drop the Koha instance and recreate it (don't reinstall the whole system!) 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 then check the log when you install 14:48 Joubu at the end of the install if: select value from systempreferences where variable="marcflavour"; 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 does not return anything then don't try anything else 14:49 Joubu koha-remove 14:49 Joubu that's the command to remove your instance 14:50 Joubu then the same koha-create command you used, from the wiki page 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 once it's done you go through the web install 14:52 Joubu Sophia: on which OS are you? 14:52 Sophia Now I get an internal server error when I try to access the intra 14:52 Sophia I'm on windows 10. Koha is debian 10 14:52 Joubu Sophia: koha-remove then koha-create, then restart koha-common 14:53 Joubu https://wiki.koha-community.org/wiki/Koha_on_Debian#Create_a_Koha_instance 14:53 Joubu restart from there, the koha-plack commands, etc. 14:53 Sophia I did; but I'll give it a go again. 14:55 Joubu if you have a 500 (internal server error), then there is something in the logs 14:55 Sophia I'm still getting an internal server error and nothing else :\ maybe I should start from scratch? 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:57 Sophia that's all I'm getting. I'm so confused :\ 14:58 Joubu Sophia: did you get an error on koha-remove? 14:58 Sophia no error on remove. 14:58 Sophia It happened quite quickly and so did the koha-create 15:01 Joubu try with something else than "library" 15:01 Joubu I am pretty sure koha-remove didn't remove everything correctly 15:01 Joubu at least to try, then we will see later 15:01 Sophia okay will do 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:05 Sophia I can not access it. I get a site can't be reached now. 15:06 Sophia oh wait! I need to set up the dns for the new domain. One second. 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: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:12 Joubu :) 15:12 Sophia I'm going to leave everything as default marc21 setup. I'm not going to click on anything etc. 15:18 Sophia Marc21 is now the database flaour! 15:19 pastebot "Sophia" at 127.0.0.1 pasted "flavour success!" (6 lines) at http://paste.koha-community.org/27957 15:20 Sophia Great success! 15:20 Sophia Thank you so friggen much I wish I could buy you all lunch or something <3 15:21 Joubu try to catalogue a new record! :) 15:21 Sophia I just did! :) it worked perfectly! 15:21 caroline_catlady Sophia++ Joubu++ 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: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:24 Joubu only the commands we give you here :) 15:24 Sophia Indeed. 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:31 cait Joubu++ great work 15:36 cait Sophia++ too 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? 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 16:40 cait caroline: i think so - but i think all lowercase or so? 16:41 cait ok, time to leave and make dinner - bye all! 16:42 ashimema have a nice evening cait 16:42 ashimema enjoy your birthday 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? 17:42 oleonard The color part is not accurate 17:42 oleonard intranetstylesheet is a full replacement for the staff client's default CSS 17:43 oleonard intranetcolorstylesheet is an addition to the default 17:43 caroline kind of like IntranerUserCSS but a file instead of CSS code? 17:43 oleonard Yes 17:43 caroline ok thanks! 17:44 caroline I will add this subtlety to the manual 17:47 cait caroline++ 17:48 cait great changes to manual lately :) 17:48 cait and did you see my comments about the german manual earlier? worked all like a charm now :) 17:49 caroline no I didn't see. Good to know! 17:49 caroline I saw ashimema worked hard today 17:50 caroline And he told me bernardo added the 20.11 files to pootle 17:51 cait yep 17:51 cait lots of new work waiting... 18:04 reiveune bye 18:35 magnuse caroline++ cait++ ashimema++ bernardo++ 19:07 davidnind cait: Happy birthday! 🎉 🎂🎈 19:16 cait thx :) 19:26 oleonard davidnind++ 19:55 kathryn kia ora koutou, sorry to leave it so long between visits! 19:55 caroline hello kathryn! 19:56 kathryn hi caroline, how are you? 19:56 caroline pretty good, and you? 19:57 kathryn yup, takes a while to settle back from summer hols, but am WELL into it now 19:57 kathryn it's been a super busy start to the year, in a good way 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. 22:30 cait at this our there is a little less people around 22:30 cait but if you describe the problem someone might be able to help 22:30 cait what are the errors you seeß 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:31 Sophia be useful in troubleshooting this. 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:43 cait where did you enter the credentials? 22:44 cait and are you using the in-bulit paypal feature via sysprefs or the actual newer plugin? 22:44 cait i believe the plugin has its own configuration page 22:44 Sophia It was in the plugin configuration. I'm using the newer plugin. 22:44 cait hm ok 22:44 cait tcohen would be the best one to help you i guess, but probably not around at this time 22:45 cait the plugin will replace the in-built feature (which is depracated now) 22:45 cait so i think it's supposed to work 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 maybe silly, but have you checked for addiitonal spaces and such in the configuration? 22:45 Sophia I've checked, but it can't hurt to check again. 22:46 cait maybe this would be helpful: https://bywatersolutions.com/education/paypal-is-now-a-plugin 22:46 Sophia That's the one I followed to set this up :\ but my credentials don't look anything like theirs. 22:47 cait :( 22:47 cait we don't use payment services yet here... so haven't played with this feature myself 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 Sophia Documentation for anything is so hard to find after 2017. 22:48 cait why after 2017? 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:49 cait it's hard to keep up with koha, but the first thing i'd always check is the manual 22:49 cait there is going a lot of work into it for the last few versions 22:49 cait bywaters tutorials are usually pretty good too 22:49 cait often older docs will work 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:50 cait the payplal one is 20.05, which is not that old yet - it should apply fine 22:50 cait it should be more or less 22:51 cait what is the error exactly and is there anything in the logs? 22:51 cait ah you don't want to post that i understand 22:51 cait but maybe double check the output, it might have the useful bit you need 22:51 Sophia Oh no I just didn't want to flood you guys :) 22:51 Sophia I can post it. 22:52 Sophia Here is what the logs show when I try to make a payment: 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 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 And here is the error: 22:52 Sophia Error: there was a problem processing your payment 22:52 Sophia Unable to start your payment. 22:52 Sophia Please try again later. 22:52 Sophia I really appreciate you even thinking about this; honestly, I really do :) 22:52 cait hm the above is the apache logs - that doesn't look like a paroblem 22:53 cait well or ont the error 22:53 Sophia to get the log I used the tail -f /var/log/koha/library/*.log 22:54 cait sorry, i will have to pass 22:54 cait i think let it rest for today - get back to it tomorrow with fresh eyes 22:55 Sophia No worries at all. Thanks though :)