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 :)