IRC log for #koha, 2021-03-02

All times shown according to UTC.

Time S Nick Message
00:00 cait joined #koha
00:22 inlibro joined #koha
01:22 inlibro joined #koha
02:22 inlibro joined #koha
03:23 inlibro joined #koha
04:15 mtj slef: looking at the script, i dont think so ^
04:16 mtj Joubu: ill sort a fix for 26893 tonite
04:23 inlibro joined #koha
05:23 inlibro joined #koha
06:23 inlibro joined #koha
06:50 paul_p joined #koha
06:52 fridolin joined #koha
06:52 fridolin hi there
07:00 reiveune joined #koha
07:00 reiveune hello
07:24 inlibro joined #koha
07:42 lds joined #koha
07:43 did joined #koha
07:43 paul_p joined #koha
07:49 cait joined #koha
07:50 cait1 joined #koha
07:56 alex_a joined #koha
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-commun[…]anual/-/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:24 inlibro joined #koha
08:31 TimothyAlexis joined #koha
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:58 nlegrand joined #koha
08:59 nlegrand Bonjour #koha
09:15 * cait1 waves
09:24 inlibro joined #koha
09:35 alex_a_ joined #koha
09:37 cait1 ashimema: thx! the manual is looking good now https://koha-community.org/man[…]e/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:51 alex_a joined #koha
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:24 inlibro joined #koha
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.or[…]_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:24 inlibro joined #koha
11:25 aindriu joined #koha
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[…]oha_20.11_U18/46/
11:41 koha-jenkins Project Koha_20.11_U2010 build #47: SUCCESS in 53 min: https://jenkins.koha-community[…]a_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[…]oha_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-ja[…]tins_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[…]oha_20.11_U16/51/
12:04 cait joined #koha
12:05 aindriu joined #koha
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 Dyrcona joined #koha
12:17 cait it is
12:18 oleonard HAPPY BIRTHDAY \o/
12:18 kohaputti joined #koha
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/mainte​nance/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[…]oha_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 AndrewFH joined #koha
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:24 inlibro joined #koha
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/ques[…]w/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[…]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:48 TimothyAlexis joined #koha
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/distr[…]moryProfiling.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 Dyrcona joined #koha
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:24 AndrewFH joined #koha
13:25 inlibro joined #koha
13:30 AndrewFH joined #koha
13:40 TimothyAlexis cait: I wanted to thank you all just because I wanted to thank you.
13:40 Sophia joined #koha
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:48 wahanui joined #koha
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:52 marie-luce joined #koha
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/migrat​ion_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 inlibro joined #koha
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.valleyofw[…]ult&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?bibl​ionumber=11&frameworkcode=&searchid= HTTP/1.1" 200 29131 "http://library-intra.valleyofw[…]ult&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/migrat​ion_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:42 TGoat joined #koha
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.or[…]ki/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:49 AndrewFH joined #koha
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.or[…]e_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=lo​calhost;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:25 inlibro joined #koha
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:29 Sophia left #koha
15:31 cait Joubu++ great work
15:36 cait Sophia++ too
15:39 fridolin left #koha
15:49 did joined #koha
15:50 slef Is there a more current guide than https://wiki.koha-community.or[…]eth_Configuration or shall I try to update that to match current code?
16:06 jzairo joined #koha
16:22 caroline_catlady Are index names the same in ES and Zebra? https://koha-community.org/man[…]ha-search-indexes
16:25 inlibro joined #koha
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 cait left #koha
16:42 ashimema have a nice evening cait
16:42 ashimema enjoy your birthday
16:46 AndrewFH joined #koha
16:49 cait joined #koha
16:56 paul_p joined #koha
17:25 inlibro joined #koha
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...
17:57 marie-luce joined #koha
18:02 davidnind joined #koha
18:04 reiveune bye
18:04 reiveune left #koha
18:26 inlibro joined #koha
18:35 magnuse caroline++ cait++ ashimema++ bernardo++
18:51 AndrewFH joined #koha
19:07 davidnind cait: Happy birthday!  ðŸŽ‰ 🎂🎈
19:16 cait thx :)
19:26 inlibro joined #koha
19:26 oleonard davidnind++
19:54 kathryn joined #koha
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
19:59 davidnind left #koha
20:21 Oak joined #koha
20:26 inlibro joined #koha
20:26 khall_ joined #koha
21:26 inlibro joined #koha
21:58 inlibro joined #koha
21:58 oleonard joined #koha
21:59 gmcharlt joined #koha
22:19 AndrewFH joined #koha
22:26 jzairo left #koha
22:26 inlibro joined #koha
22:27 Sophia joined #koha
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/e[…]l-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.or[…]a/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 :)
23:10 Sophia left #koha
23:13 oleonard_ joined #koha
23:26 inlibro joined #koha

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary