← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | 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 | 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 | @later tell caroline it looks like bernardo has set up the 20.11 manuals for translation now | |
| 08:15 | @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 | bug 26893 | |
| 08:15 | still no bots :( | |
| 08:16 | @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 | 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 | if they go red,, then I need to investigate more.. pretty sure they should finally be reliably green again though | |
| 08:18 | they take a while now.. the build process is slow | |
| 08:20 | 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 | auth is done with gitea | |
| 08:22 | ashimema: can you have a look at the failing test from 27680? | |
| 08:22 | (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 | 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 | 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 | i wanted to take a closer look at that one but didn't get to it yet | |
| 09:42 | i think it makes no sense to have it just at that step | |
| 09:42 | and i never wait it out | |
| 09:42 | 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 | you might still be missing the "success message" | |
| 09:56 | better to make it an event that you can control intead of a timed redirect | |
| 09:56 | 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 | grr.. I really miss huggin | |
| 10:41 | 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 | 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 | 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 | 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 | 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 | ...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 | 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 | 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 | 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 | This is a defacto browser support list for the OPAC | |
| 11:45 | ashimema | cool |
| 11:45 | 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 | 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 | sorry, switching between computers | |
| 12:10 | 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/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[…]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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | well.. again it depends on perspective really.. | |
| 12:40 | 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 | it's only a problem in the daemon case really | |
| 12:41 | there are of course other real leaks that are easy to introduce | |
| 12:41 | 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 | yup | |
| 12:42 | we certainly have leaks in Koha | |
| 12:42 | and should really be working to resolve them | |
| 12:42 | our 'kill and restart' is a terrible work around really | |
| 12:43 | 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 | rather than putting it directly in the worker | |
| 12:44 | 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 | but as I tried to implement such a fix I ended up finding myself basically writing a clone of Minion. | |
| 12:45 | 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 | it's been a while | |
| 12:49 | I can't see any mention of memory profiling | |
| 12:49 | 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 | oleonard, I'm contemplating Bug 24491 - Add filters to debit types interface | |
| 12:53 | any thoughts on how best to expose such filters? | |
| 12:54 | 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 | any tips? | |
| 12:55 | oleonard | I'm not sure what you mean by types within types |
| 12:55 | ashimema | ok.. |
| 12:55 | debit types are generic | |
| 12:55 | but they can refer to point of sale, or manual invoicing.. or just be a system type | |
| 12:56 | right now we display all but system types by default and have a button to expose the system ones too | |
| 12:56 | the request here is to be able to quickly filter down to just those that are available via 'point of sale' | |
| 12:56 | or just those available via 'manual invoice' | |
| 12:58 | 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 | 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 | I suppose this is sort of simlar | |
| 13:03 | I'll write a patch and then get your opinion on the UX :) | |
| 13:03 | might be easier | |
| 13:04 | oleonard | Anyone around who is familiar with UNIMARC? |
| 13:05 | I notice there's one instance left in the OPAC which uses the Greybox library | |
| 13:05 | [% IF IDREF and MARCAUTHOR.unimarc3 %] | |
| 13:05 | 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 | ? | |
| 13:13 | oleonard: maybe the initital test plan could help? i seem to remember to having tested it back then | |
| 13:13 | it comes with a pref that might make it easier to track | |
| 13:13 | oleonard | Good idea cait |
| 13:14 | 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 | 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 | 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 | I would do sudo koha-start-zebra library (right?) | |
| 13:44 | ashimema | how did oyu install? |
| 13:44 | using packages? | |
| 13:44 | 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 | 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 | 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 | 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 | 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 | 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 | *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 | no, default should be fine | |
| 14:02 | 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 | 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 | 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 | .error retrieving biblio 9 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 681. | |
| 14:10 | I see stuff like that when I do the zebra rebuild. | |
| 14:15 | When I do the select * from biblio I see the records. They just don't let me search for them. | |
| 14:17 | 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 | 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 | try `tail -f /var/log/koha/YOUR_SITE/*.log` | |
| 14:25 | 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 | 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 | ==> /var/log/koha/library/plack-intranet-error.log <== | |
| 14:27 | [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 | [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 | [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 | [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 | [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 | ==> /var/log/koha/library/plack.log <== | |
| 14:27 | 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 | 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.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 | ==> /var/log/koha/library/indexer-output.log <== | |
| 14:27 | 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 | 9:26:58 | |
| 14:29 | 57 | |
| 14:29 | Sophia | Yes; it's 9:29 am here currently. |
| 14:30 | 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 | 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 | 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 | 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 | and select biblionumber, biblioitemnumber from biblioitems where biblionumber=1; | |
| 14:37 | 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 | 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 | 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 | 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 | 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 | one second | |
| 14:46 | Joubu | if you don't have the marcflavour system preference you will face problems :) |
| 14:46 | 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 | 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 | 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 | koha-remove | |
| 14:49 | 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 | 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 | I'm on windows 10. Koha is debian 10 | |
| 14:52 | Joubu | Sophia: koha-remove then koha-create, then restart koha-common |
| 14:53 | https://wiki.koha-community.or[…]e_a_Koha_instance | |
| 14:53 | 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 | 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 | 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 | It happened quite quickly and so did the koha-create | |
| 15:01 | Joubu | try with something else than "library" |
| 15:01 | I am pretty sure koha-remove didn't remove everything correctly | |
| 15:01 | at least to try, then we will see later | |
| 15:01 | Sophia | okay will do |
| 15:04 | 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 | I can not access it. I get a site can't be reached now. | |
| 15:06 | oh wait! I need to set up the dns for the new domain. One second. | |
| 15:10 | 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 | 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 | 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 | 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 | 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 | 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 | ok, time to leave and make dinner - bye all! | |
| 16:42 | cait left #koha | |
| 16:42 | ashimema | have a nice evening cait |
| 16:42 | 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 | intranetstylesheet is a full replacement for the staff client's default CSS | |
| 17:43 | 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 | I will add this subtlety to the manual | |
| 17:47 | cait | caroline++ |
| 17:48 | great changes to manual lately :) | |
| 17:48 | 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 | I saw ashimema worked hard today | |
| 17:50 | And he told me bernardo added the 20.11 files to pootle | |
| 17:51 | cait | yep |
| 17:51 | 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 | 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 | but if you describe the problem someone might be able to help | |
| 22:30 | 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 | be useful in troubleshooting this. | |
| 22:32 | 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 | and are you using the in-bulit paypal feature via sysprefs or the actual newer plugin? | |
| 22:44 | 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 | tcohen would be the best one to help you i guess, but probably not around at this time | |
| 22:45 | the plugin will replace the in-built feature (which is depracated now) | |
| 22:45 | 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 | 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 | 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 | there is going a lot of work into it for the last few versions | |
| 22:49 | bywaters tutorials are usually pretty good too | |
| 22:49 | 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 | it should be more or less | |
| 22:51 | what is the error exactly and is there anything in the logs? | |
| 22:51 | ah you don't want to post that i understand | |
| 22:51 | 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 | I can post it. | |
| 22:52 | Here is what the logs show when I try to make a payment: | |
| 22:52 | 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 | 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 | And here is the error: | |
| 22:52 | Error: there was a problem processing your payment | |
| 22:52 | Unable to start your payment. | |
| 22:52 | Please try again later. | |
| 22:52 | 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 | 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 | 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 |
← Previous day | Today | Next day → | Search | Index