IRC log for #koha, 2023-08-24

All times shown according to UTC.

Time S Nick Message
00:04 Kolvir joined #koha
00:05 Kolvir is there anyway to search the mailing list archives seeing as both markmail and nabble links seem down?
00:21 davidnind Kolvir: it would seem not, apart from using Google advanced search - put [search term] site:https://lists.katipo.co.nz/pipermail/koha/ in the search box
00:22 davidnind a bit of a shame that markmail isn't available any more - was generally my go to when searching the archives
00:36 Kolvir ok, ty
01:24 fridolin joined #koha
03:42 cait1 joined #koha
03:59 alohabot joined #koha
04:32 PriyanshuSoni[m] Guys, can anyone of you please help me out with carousel plugin of inLibro. Why i am not getting scrolling or carousel option while selecting books in list???
04:33 PriyanshuSoni[m] I want it to be done quickly..
06:01 thibaud_g joined #koha
06:21 magnuse \o/
07:08 dcook joined #koha
07:27 fridolin joined #koha
08:09 cait joined #koha
08:16 ashimema Morning
09:45 thibaud_g joined #koha
09:54 Zahid[m] hi, can anyone tell me to add sort1 field in search patron result page, i need this field urgent as this field contains very important data to search and display on result page, it will be very helpful
09:55 Zahid[m] i am using koha 22.11
10:05 AnkeB joined #koha
10:10 AnkeB Hi! Before I file a bug, just a quick question to people using 23.05: On 23.05.02 we see http 500 when trying to edit an existing item via the edit item button. In 22.05 and 22.11 this doesn't occur. Has anyone experienced this, too, or has an idea? Thanks!
10:12 oleonard AnkeB: Are you able to see the logs to see what the underlying error might be?
10:13 AnkeB oleonard: Would that be the Plack log?
10:14 oleonard plack-intranet-error.log maybe?
10:17 AnkeB Thanks, I'll look.
10:17 oleonard AnkeB: Does it matter which record you try to edit? Or which page you're on when you click the edit button?
10:19 oleonard I did a quick check of 23.05.02 in my test system and wasn't able to reproduce the error
10:22 AnkeB oleonard: I just tried several random items, other than the one the librarian showed me as an example, so I assume it will be the same for any item. In the plack intranet error log I see this: "[2023/08/24 12:21:17] [WARN] DBIx::Class::ResultSetColumn::new(): Attempting to retrieve non-unique column 'biblionumber' on a resultset containing one-to-many joins will return duplicate results. at /usr/share/koha/lib/Koha/Objects.pm line 421". Can that be relev
10:24 oleonard AnkeB: I suggest you look at the "About" page under the "System information" tab to see if it warns of data problems
10:26 AnkeB oleonard, There is only one entry in the system information tab concerning Authority creation - I don't think that it is relevant here.
10:28 AnkeB oleonard, what's more (worse) is that I just found out that I  can't edit & save a biblio record in Cataloging - maybe we have a larger problem here...
10:28 khall joined #koha
10:28 oleonard AnkeB: I suspect it's some kind of data problem and not a bug in Koha but I don't know how to advise you
10:29 oleonard AnkeB: The error log entry you shared is not the problem, it's just a warning. I see that in my logs too.
10:30 AnkeB Thanks anyway, oleonard - this helped already. I'll see with our MySQL experts and hope to find the error. It was important to know that this is not a general error in 23.05 but probably something on our side.
10:30 oleonard Good luck!
10:31 AnkeB Thanx :-)
10:33 Zahid[m] i am using koha 22.11 i need to add sort1 field in search patron result page, i need this field urgent as this field contains very important data to search and display on result page, it will be very helpful, any suggestion ? where can i start?
10:34 oleonard Zahid[m]: I'm not aware of a configuration option that would enable that. It sounds like it would require an enhancement to Koha.
10:39 Zahid[m] any help needed. may i have to add/change the system preference in koha? currently i am stuck and finding a way for this problem.
11:03 RudyHinojosa joined #koha
11:22 oleonard Zahid[m]: I have submitted a patch, Bug 34608
11:22 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=34608 enhancement, P5 - low, ---, oleonard, Needs Signoff , Add sort1 and sort2 to patron search results
11:22 oleonard It should apply to 22.11 as well.
11:23 oleonard lucky for you I was looking for something to do to start my day ;)
12:08 oleonard "koha-testing-docker has started up and is ready to be enjoyed!" That's a nice addition :)
12:12 RudyHinojosa Is there a link to documentation how to test that, or is this still more internal at this point?
12:18 RudyHinojosa koha/koha-dpkg
12:18 RudyHinojosa ?
12:21 khall joined #koha
12:30 dcook_ joined #koha
13:20 aw-bib[m] Hi! are there some recommendations for the hardware environment for koha? (cpus, ram, disk) I searched the wiki but was out of luck and the local it asks what they should set up for the production service.
13:21 oleonard aw-bib[m]: You might have better luck asking on the Koha mailing list. I suspect the answer will depend on number of patrons, number, of records, circulation, etc.
13:21 aw-bib[m] ok. thanks, I'll do that. :)
13:29 AnkeB joined #koha
13:32 PriyanshuSoni[m] Hey guys, i am using a carousel by in Libro (v4.1.2) in Koha 22.05.02.... (full message at <https://matrix.org/_matrix/med[…]rlpdkAIynYjhNPuaJ>)
13:51 oleonard PriyanshuSoni[m]: Have you asked on the Koha mailing list yet? There might be someone there who has used it successfully and can advise you on configuration
14:05 jalway joined #koha
14:23 cait joined #koha
14:27 matts joined #koha
14:31 h2 joined #koha
14:41 khall_ joined #koha
14:46 thibaud_g joined #koha
14:48 thibaud_glt joined #koha
14:48 thibaud_g joined #koha
15:00 bag joined #koha
15:16 thibaud_g joined #koha
15:28 KevinFurst[m] cait:  Are you online today?
15:33 cait yes
15:34 cait KevinFurst[m]:
16:07 KevinFurst[m] cait: Still plugging away at this import that keeps failing. Tried a batch of only 1000 records and it still fails. Ran that batch through another MARC validator and a few errors came up. I'm trying to figure out whether they are really errors or not. One is with field 20. It says there can't be duplicates but I don't understand since we have multiples where one 020 field is for a paperback binding and one is for library binding. So they
16:07 KevinFurst[m] seem like valid records. During import,  I am matching on the ISBN 20. Any thoughts on that?
16:07 KevinFurst[m] So they're not really a duplicate per se ,there are just multiple field 20 lines on some records.
16:49 cait hm
16:49 cait 020 is repeatable
16:49 cait do you have 20 or 020?
16:49 cait also... something to try maybe. Are you trying to import MARCXML or are you importing .mrc?
16:50 KevinFurst[m] importing .mrc
16:51 KevinFurst[m] Here's an example of an 020 record it's complaining about =LDR  01857pam a2200517 a 4500
16:51 KevinFurst[m] =008  080826t20082007nyuab\c\\\000\1\eng\d
16:51 KevinFurst[m] =020  \$a9780441016235 (pbk.)
16:51 KevinFurst[m] =020  \$a0441016235
16:51 KevinFurst[m] =040  \$aICrlF$cICrlF$dICrlF
16:59 cait hm es, that looks ok to me.... maybe only think it looks like only 1 indicator?
16:59 cait but it might be the copy and paste
17:00 cait does it import nicely if you tell it to ignore the items?
17:00 cait oooh - do you see anything in administration > background jobs about your imports?
17:00 cait maybe it's not even the file!
17:01 KevinFurst[m] Yes. Imports fine without the items
17:01 cait ah too bad... i was wondering if it only needed the background job restarted, but if that worked that should not be it
17:01 cait so i think we can probably also rule out problems iwth the bibliographic records
17:01 cait did you double check the branchcodes etc?
17:02 cait no additional spaces for example in your configuration?
17:02 cait having a look at the logs might tell you something
17:02 KevinFurst[m] When I was originally working on this last month, since I couldn't get the import to work with items, I just imported the bibliographic records. Which may not have been such a good idea  as now I'm matching on ISBN 20 for the import.
17:03 cait tail -f /var/log/koha/instancename/*.log (I think)
17:03 KevinFurst[m] I've been checking the logs but can only see them from CLI the in browser logs never show anything.
17:03 cait hm, could you remove the bibliographic records again? or do you have maybe a 001 from your previous system you oculd match on?
17:04 cait yeah, I think you wouldn'T see in the browser, only js problems htere
17:04 KevinFurst[m] Do you know which should have an error? The intranet error or the worker logs?
17:04 cait maybe the plack one actually
17:04 KevinFurst[m] ok. I'm going ssh in and check again.
17:04 cait i usually check hem all with the *.log
17:08 jalway I assume the set of records you have that you're trying to import don't have the koha bib number in them?
17:08 jalway The koha bib number would be unique and an easy match.
17:08 khall joined #koha
17:09 KevinFurst[m] In all of the logs with "error" in the name, only the worker error had any entries and it's just one line: library-koha-worker-long_tasks: client (pid 2807789) killed by signal 13, respawning   I've been in koha all morning though so whatever that was must not be critical
17:10 KevinFurst[m] Correct. they came from a different service.
17:10 cait hmmm and nothing during the import itself?
17:10 KevinFurst[m] correct.
17:10 cait if you have 001 you could try to match on those
17:10 cait hm it's really odd :(
17:10 cait the only thing I can think now is something with the branchcodes or itemtype codes
17:10 cait i know that used to silently fail if not matching
17:11 KevinFurst[m] It just find it so weird that during the staging process it lists the items as if it's no issue and then just immediately fails when I do the import batch function
17:11 KevinFurst[m] *I find it
17:11 cait you could also try to use the command line scripts for importing... in case they are more verbose
17:11 cait I agree
17:11 cait Koha should do better
17:12 cait the CLI scripts would be here: https://git.koha-community.org[…]ranch/master/misc
17:12 cait stage_file.pl
17:12 wahanui i think stage_file.pl is uploading and commit_file is importing into the catalog
17:12 cait and commit_file.pl
17:12 KevinFurst[m] School is starting next week so I'm kind of running up against a deadline so I am at the point where I'm hacking away at the mrc file in these little errors the marc editor is finding in hopes something will work  (with that said, Koha didn't seem to care about these supposed errors when importing biblio info)
17:13 cait yeah I think save the time on those
17:13 cait it's the items somehow
17:13 cait so to be sure... you stage the file and it uploads, but it won't import into the catalog?
17:13 cait or in which step exactly does it not work?
17:14 KevinFurst[m] Ok. I am going to finish these error cleanups and then will move to try the CLI scripts this afternoon. I just wish I had info somewhere abou where the issue is. Nothing in the logs and nothing on the browser job screen other than "Failed" makes it really hard to find the culprit.
17:16 KevinFurst[m] oh. and btw. Importing patrons and importing patron images was slick. No issues at all. So it can't be something hardware or code related. It has to be something with my mrc file.
17:16 jalway Would koha just choke on data in item fields that have incorrect data types? I.E. AlphaNumber where it's only looking for numeric, etc.?
17:17 cait yes I tink it would
17:17 cait but really... double check the branchcodes again etc.
17:17 cait we have had had the case where one had a space in the end
17:17 cait and that WILL definitely make it fail
17:17 cait and it's kind of hard to spot with MySQL tools
17:17 jalway KevinFurst[m] How are you with regular expressions?
17:17 KevinFurst[m] Cait identified one of those for me yesterday where I was using USD in the decimal field. I did fix that but no change
17:17 KevinFurst[m] ok checking again.
17:17 KevinFurst[m] not good
17:18 cait i tihnk the trick was counting the length or something
17:18 cait (with SQL)
17:18 cait something like compare length with and without TRIM
17:19 jalway I have a command line tool that you could use to "semi-easily" check whatever fields you're wanting to check for bad data.
17:19 jalway https://github.com/josephalway/MARCCrucible
17:19 KevinFurst[m] If this is a new instance, could I just delete the branches and readd them? I only have 2 branches. PRBE for our elementary school and PRBHS for our secondary school.
17:19 jalway Though, you can probably do it all in MARCedit.
17:19 cait if you have users already you can't
17:19 KevinFurst[m] ik
17:19 KevinFurst[m] ok
17:20 cait the problem is that SQL tends to ignore spaces, but Perl does not
17:20 cait so sometimes these errors are hard to find
17:20 cait but you could try add them again... if you don't get a duplicate error...
17:20 cait branchcode is a PK
17:20 KevinFurst[m] ok. good idea
17:21 cait I know we are grapsing for straws... but one of the straws might turn out ot be the culprit
17:22 KevinFurst[m] "An error occurred when adding this library. The branchcode might already exist."
17:22 cait that's not bad
17:22 cait what about the itemtype code?
17:22 cait and your branchcodes are all uppercase?
17:23 KevinFurst[m] This item type already exists
17:23 KevinFurst[m] Both Branch and Item codes are all upper, yes
17:23 cait how annoying
17:26 KevinFurst[m] On the "Manage staged MARC Records - Batch n" screen, I've selected matching rule of ISBN (020$a), Replace existing record with incoming record,  Action of no match = Add incoming record, Item Processing = Always add items" New record and replacement record frameworks are both set to "Default"  Anything wrong there?
17:27 cait no looks good
17:27 cait did you see my question about existing 001 fields from your old system?
17:29 KevinFurst[m] In checking now, it does appear that all or almost all have an 001 in the mrc file
17:30 cait you oculd add a matching rule for that
17:30 cait on control-number index
17:30 KevinFurst[m] I don't see that as an option, I have ISBN 20, ISSN 22 or Koha Biblio 999$c
17:31 KevinFurst[m] That's it
17:31 cait you can add your own
17:31 cait these are onyl some pre-installe ones
17:31 KevinFurst[m] ok found the setting. adding now
17:33 KevinFurst[m] hm there's fields in this that I don't know what value to input. Search index, score, offset , length, normalization rule?
17:34 cait Control-number for index
17:34 cait offset leave empty
17:34 cait normalization rule too or none
17:34 cait length can be empty too
17:35 cait like that: https://snipboard.io/lM6itO.jpg
17:37 KevinFurst[m] Got it. Trying now.
17:38 KevinFurst[m] Job ID:73Status:FailedProgress:0 / 325Type:Import MARC recordsQueued:08/24/2023 12:38 PMStarted:08/24/2023 12:38 PMEnded:08/24/2023 12:38 PM
17:39 KevinFurst[m] Same. Fails immediately. Nothing in detailed messages. Going to check logs again.
17:40 cait maybe try them with tail -f before you start the impoert
17:40 cait might be easier to see
17:40 jalway Seems like it's choking on one of the first records, then.
17:40 KevinFurst[m] ok.
17:41 KevinFurst[m] btw. I am trying these last steps with a smaller file that only has ~300 records.
17:41 cait it's a good idea
17:43 cait I'd maybe even try with a single record with one item...
17:45 KevinFurst[m] Threw in the tail cmd ... : ==> /var/log/koha/library/worker-output.log <==
17:45 KevinFurst[m] DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`items`, CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE) at /usr/share/koha/lib/Koha/Object.pm line 170
17:45 KevinFurst[m] Broken FK constraint at /usr/share/koha/lib/Koha/Backgro​undJob/MARCImportCommitBatch.pm line 91
17:46 cait ha
17:46 cait it is someting with the branchcodes
17:47 KevinFurst[m] In the file or in Koha?
17:47 cait this is definitely the source of the problem
17:47 cait they are not matching
17:47 cait can you revisit your $a and $b ?
17:47 cait in 952
17:47 KevinFurst[m] Yes. Going to look at those in MarcEDIT right now
17:48 KevinFurst[m] This is a thing where if a single record is wrong or has a space, it will fail right?
17:49 KevinFurst[m] Dumb question, but for records we no longer/don't currently have an item for, it's ok to not have a 952 record (and by extension not have an a or b subfiled), right? I have some at the beginning of the file like this which made me ask
17:50 cait no 952 shoud be no problem
17:50 cait but if you have a 952 it should be complete
17:56 cait maybe the idea to try with one record with one item to start with is not a bad one
17:58 KevinFurst[m] yep. Creating a really short mrc file now to try with that in mind. I did a few searches to see if I could find either an $a or $b that had a space before PRBE or after it and it returned no results. so trying the really short file now.
17:58 cait if we got one item in, we can get them all in :)
17:58 cait *fingres crossed*
18:00 KevinFurst[m] Job ID:77Status:FinishedProgress:6 / 6Type:Import MARC recordsQueued:08/24/2023 01:00 PMStarted:08/24/2023 01:00 PMEnded:08/24/2023 01:00 PM
18:00 cait ooh
18:00 KevinFurst[m] Matched on all 6 and imported 6 items to existing bilblio record!
18:01 cait matching on the 001 ?
18:01 KevinFurst[m] yes
18:01 cait awesome :)
18:01 KevinFurst[m] How do I find the problem though in the other records using MarcEDIT?>
18:01 cait that's a good question
18:01 KevinFurst[m] Doesn't seem to be a space issue.
18:01 cait maybe it's a missing subfield issue
18:02 cait can you count 952... 952$a and 952$b
18:02 cait seeing if there isa mismatch?
18:02 KevinFurst[m] good idea. will try
18:02 cait maybe the $b especially, because it complained about holdingbranch
18:03 cait also if you use marcedit to convert to .mrk you might use your normal text editor and regex etc. if that is helpful for you
18:03 KevinFurst[m] Field 952: 19305
18:03 KevinFurst[m] Ind1 --  : 19305
18:03 KevinFurst[m] Ind2 --  : 19305
18:03 KevinFurst[m] $a: 19305
18:03 KevinFurst[m] $g: 18932
18:03 KevinFurst[m] $b: 19305
18:03 KevinFurst[m] $y: 19305
18:03 KevinFurst[m] $o: 27203
18:03 KevinFurst[m] $p: 19305
18:04 cait hm
18:04 cait can we find if all $b contain the same value?
18:04 KevinFurst[m] That would be in one of my full length files
18:04 KevinFurst[m] ok
18:05 cait I haven't used these features in MARCEdit much... I usually go for notepad++ and regex
18:08 cait but maybe it can give you a list of values used or something?
18:08 KevinFurst[m] yes, running a report now
18:08 cait *fingers crossed*
18:08 cait brb, gotta save my laundry from the incoming thunderstorm
18:17 cait KevinFurst[m]: I hope to get a success report soon! :)
18:22 Dyrcona joined #koha
18:38 KevinFurst[m] cait:  Have a job running now. Will let you know.
18:39 cait did you find any $b issues to fix?
18:41 KevinFurst[m] I did. Apparently when it was 852 the b field was also used as a special collection indicator. I thought I had removed them all but 2 records were spelled wrong at some point so my search didn't pick them up: Hoiday Bookshelf and Holiday Book shelf weren't found by my initial replacement.
18:42 KevinFurst[m] So I'm trying the batch import again after fixing those
18:42 KevinFurst[m] Threw another error. I must have missed one.
18:45 cait but at least we got a good bit further, I hope you can locate and then it will work
19:16 jalway =952.+\$a(?!PRBE).+\$b RegEx search in MARCEdit should find most typos.
19:16 KevinFurst[m] cait: Finally. It worked. Imported 19.3k items. Yay! Thank you so much for your help!!
19:17 jalway Nice, perseverance pays off. :-)
19:21 cait KevinFurst[m]: awesome :)
19:21 cait KevinFurst++
19:22 cait jalway++
19:56 RudyHinojosa joined #koha
19:56 RudyHinojosa ERROR: Can't create '/etc/koha'
19:56 RudyHinojosa Do not have write permissions on '/etc/koha'
19:56 RudyHinojosa !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!​!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
19:56 RudyHinojosa at -e line 1.
19:56 RudyHinojosa make: *** [Makefile:11299: install_koha] Error 13
19:57 RudyHinojosa almost to the finish line.
19:57 RudyHinojosa during the make install using docker.
20:20 RudyHinojosa got it. thanks.
20:20 RudyHinojosa :)
23:13 sonOfRa joined #koha
23:13 tcohen joined #koha
23:14 magnuse joined #koha
23:14 kivilahtio joined #koha
23:14 Nemo_bis joined #koha
23:18 jajm joined #koha
23:57 edveal[m] joined #koha

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