Time Nick Message 20:20 RudyHinojosa :) 20:20 RudyHinojosa got it. thanks. 19:57 RudyHinojosa during the make install using docker. 19:57 RudyHinojosa almost to the finish line. 19:56 RudyHinojosa make: *** [Makefile:11299: install_koha] Error 13 19:56 RudyHinojosa at -e line 1. 19:56 RudyHinojosa !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! 19:56 RudyHinojosa Do not have write permissions on '/etc/koha' 19:56 RudyHinojosa ERROR: Can't create '/etc/koha' 19:22 cait jalway++ 19:21 cait KevinFurst++ 19:21 cait KevinFurst[m]: awesome :) 19:17 jalway Nice, perseverance pays off. :-) 19:16 KevinFurst[m] cait: Finally. It worked. Imported 19.3k items. Yay! Thank you so much for your help!! 19:16 jalway =952.+\$a(?!PRBE).+\$b RegEx search in MARCEdit should find most typos. 18:45 cait but at least we got a good bit further, I hope you can locate and then it will work 18:42 KevinFurst[m] Threw another error. I must have missed one. 18:42 KevinFurst[m] So I'm trying the batch import again after fixing those 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:39 cait did you find any $b issues to fix? 18:38 KevinFurst[m] cait: Have a job running now. Will let you know. 18:17 cait KevinFurst[m]: I hope to get a success report soon! :) 18:08 cait brb, gotta save my laundry from the incoming thunderstorm 18:08 cait *fingers crossed* 18:08 KevinFurst[m] yes, running a report now 18:08 cait but maybe it can give you a list of values used or something? 18:05 cait I haven't used these features in MARCEdit much... I usually go for notepad++ and regex 18:04 KevinFurst[m] ok 18:04 KevinFurst[m] That would be in one of my full length files 18:04 cait can we find if all $b contain the same value? 18:04 cait hm 18:03 KevinFurst[m] $p: 19305 18:03 KevinFurst[m] $o: 27203 18:03 KevinFurst[m] $y: 19305 18:03 KevinFurst[m] $b: 19305 18:03 KevinFurst[m] $g: 18932 18:03 KevinFurst[m] $a: 19305 18:03 KevinFurst[m] Ind2 -- : 19305 18:03 KevinFurst[m] Ind1 -- : 19305 18:03 KevinFurst[m] Field 952: 19305 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:02 cait maybe the $b especially, because it complained about holdingbranch 18:02 KevinFurst[m] good idea. will try 18:02 cait seeing if there isa mismatch? 18:02 cait can you count 952... 952$a and 952$b 18:01 cait maybe it's a missing subfield issue 18:01 KevinFurst[m] Doesn't seem to be a space issue. 18:01 cait that's a good question 18:01 KevinFurst[m] How do I find the problem though in the other records using MarcEDIT?> 18:01 cait awesome :) 18:01 KevinFurst[m] yes 18:01 cait matching on the 001 ? 18:00 KevinFurst[m] Matched on all 6 and imported 6 items to existing bilblio record! 18:00 cait ooh 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 17:58 cait *fingres crossed* 17:58 cait if we got one item in, we can get them all in :) 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:56 cait maybe the idea to try with one record with one item to start with is not a bad one 17:50 cait but if you have a 952 it should be complete 17:50 cait no 952 shoud be no problem 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:48 KevinFurst[m] This is a thing where if a single record is wrong or has a space, it will fail right? 17:47 KevinFurst[m] Yes. Going to look at those in MarcEDIT right now 17:47 cait in 952 17:47 cait can you revisit your $a and $b ? 17:47 cait they are not matching 17:47 cait this is definitely the source of the problem 17:47 KevinFurst[m] In the file or in Koha? 17:46 cait it is someting with the branchcodes 17:46 cait ha 17:45 KevinFurst[m] Broken FK constraint at /usr/share/koha/lib/Koha/BackgroundJob/MARCImportCommitBatch.pm line 91 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] Threw in the tail cmd ... : ==> /var/log/koha/library/worker-output.log <== 17:43 cait I'd maybe even try with a single record with one item... 17:41 cait it's a good idea 17:41 KevinFurst[m] btw. I am trying these last steps with a smaller file that only has ~300 records. 17:40 KevinFurst[m] ok. 17:40 jalway Seems like it's choking on one of the first records, then. 17:40 cait might be easier to see 17:40 cait maybe try them with tail -f before you start the impoert 17:39 KevinFurst[m] Same. Fails immediately. Nothing in detailed messages. Going to check logs again. 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:37 KevinFurst[m] Got it. Trying now. 17:35 cait like that: https://snipboard.io/lM6itO.jpg 17:34 cait length can be empty too 17:34 cait normalization rule too or none 17:34 cait offset leave empty 17:34 cait Control-number for index 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:31 KevinFurst[m] ok found the setting. adding now 17:31 cait these are onyl some pre-installe ones 17:31 cait you can add your own 17:31 KevinFurst[m] That's it 17:30 KevinFurst[m] I don't see that as an option, I have ISBN 20, ISSN 22 or Koha Biblio 999$c 17:30 cait on control-number index 17:30 cait you oculd add a matching rule for that 17:29 KevinFurst[m] In checking now, it does appear that all or almost all have an 001 in the mrc file 17:27 cait did you see my question about existing 001 fields from your old system? 17:27 cait no looks good 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:23 cait how annoying 17:23 KevinFurst[m] Both Branch and Item codes are all upper, yes 17:23 KevinFurst[m] This item type already exists 17:22 cait and your branchcodes are all uppercase? 17:22 cait what about the itemtype code? 17:22 cait that's not bad 17:22 KevinFurst[m] "An error occurred when adding this library. The branchcode might already exist." 17:21 cait I know we are grapsing for straws... but one of the straws might turn out ot be the culprit 17:20 KevinFurst[m] ok. good idea 17:20 cait branchcode is a PK 17:20 cait but you could try add them again... if you don't get a duplicate error... 17:20 cait so sometimes these errors are hard to find 17:20 cait the problem is that SQL tends to ignore spaces, but Perl does not 17:19 KevinFurst[m] ok 17:19 KevinFurst[m] ik 17:19 cait if you have users already you can't 17:19 jalway Though, you can probably do it all in MARCedit. 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 https://github.com/josephalway/MARCCrucible 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:18 cait something like compare length with and without TRIM 17:18 cait (with SQL) 17:18 cait i tihnk the trick was counting the length or something 17:17 KevinFurst[m] not good 17:17 KevinFurst[m] ok checking again. 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 jalway KevinFurst[m] How are you with regular expressions? 17:17 cait and it's kind of hard to spot with MySQL tools 17:17 cait and that WILL definitely make it fail 17:17 cait we have had had the case where one had a space in the end 17:17 cait but really... double check the branchcodes again etc. 17:17 cait yes I tink it would 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: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: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:13 cait or in which step exactly does it not work? 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 it's the items somehow 17:13 cait yeah I think save the time on those 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:12 cait and commit_file.pl 17:12 wahanui i think stage_file.pl is uploading and commit_file is importing into the catalog 17:12 cait stage_file.pl 17:12 cait the CLI scripts would be here: https://git.koha-community.org/Koha-community/Koha/src/branch/master/misc 17:11 cait Koha should do better 17:11 cait I agree 17:11 cait you could also try to use the command line scripts for importing... in case they are more verbose 17:11 KevinFurst[m] *I find it 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:10 cait i know that used to silently fail if not matching 17:10 cait the only thing I can think now is something with the branchcodes or itemtype codes 17:10 cait hm it's really odd :( 17:10 cait if you have 001 you could try to match on those 17:10 KevinFurst[m] correct. 17:10 cait hmmm and nothing during the import itself? 17:10 KevinFurst[m] Correct. they came from a different service. 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:08 jalway The koha bib number would be unique and an easy match. 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:04 cait i usually check hem all with the *.log 17:04 KevinFurst[m] ok. I'm going ssh in and check again. 17:04 cait maybe the plack one actually 17:04 KevinFurst[m] Do you know which should have an error? The intranet error or the worker logs? 17:04 cait yeah, I think you wouldn'T see in the browser, only js problems htere 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: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 tail -f /var/log/koha/instancename/*.log (I think) 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:02 cait having a look at the logs might tell you something 17:02 cait no additional spaces for example in your configuration? 17:01 cait did you double check the branchcodes etc? 17:01 cait so i think we can probably also rule out problems iwth the bibliographic records 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 KevinFurst[m] Yes. Imports fine without the items 17:00 cait maybe it's not even the file! 17:00 cait oooh - do you see anything in administration > background jobs about your imports? 17:00 cait does it import nicely if you tell it to ignore the items? 16:59 cait but it might be the copy and paste 16:59 cait hm es, that looks ok to me.... maybe only think it looks like only 1 indicator? 16:51 KevinFurst[m] =040 \$aICrlF$cICrlF$dICrlF 16:51 KevinFurst[m] =020 \$a0441016235 16:51 KevinFurst[m] =020 \$a9780441016235 (pbk.) 16:51 KevinFurst[m] =008 080826t20082007nyuab\c\\\000\1\eng\d 16:51 KevinFurst[m] Here's an example of an 020 record it's complaining about =LDR 01857pam a2200517 a 4500 16:50 KevinFurst[m] importing .mrc 16:49 cait also... something to try maybe. Are you trying to import MARCXML or are you importing .mrc? 16:49 cait do you have 20 or 020? 16:49 cait 020 is repeatable 16:49 cait hm 16:07 KevinFurst[m] So they're not really a duplicate per se ,there are just multiple field 20 lines on some records. 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] 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 15:34 cait KevinFurst[m]: 15:33 cait yes 15:28 KevinFurst[m] cait: Are you online today? 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 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/media/v3/download/matrix.org/gOuPOnirlpdkAIynYjhNPuaJ>) 13:21 aw-bib[m] ok. thanks, I'll do that. :) 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: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. 12:18 RudyHinojosa ? 12:18 RudyHinojosa koha/koha-dpkg 12:12 RudyHinojosa Is there a link to documentation how to test that, or is this still more internal at this point? 12:08 oleonard "koha-testing-docker has started up and is ready to be enjoyed!" That's a nice addition :) 11:23 oleonard lucky for you I was looking for something to do to start my day ;) 11:22 oleonard It should apply to 22.11 as well. 11:22 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34608 enhancement, P5 - low, ---, oleonard, Needs Signoff , Add sort1 and sort2 to patron search results 11:22 oleonard Zahid[m]: I have submitted a patch, Bug 34608 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. 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: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:31 AnkeB Thanx :-) 10:30 oleonard Good luck! 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: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: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: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: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: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: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:19 oleonard I did a quick check of 23.05.02 in my test system and wasn't able to reproduce the error 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:17 AnkeB Thanks, I'll look. 10:14 oleonard plack-intranet-error.log maybe? 10:13 AnkeB oleonard: Would that be the Plack log? 10:12 oleonard AnkeB: Are you able to see the logs to see what the underlying error might be? 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! 09:55 Zahid[m] i am using koha 22.11 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 08:16 ashimema Morning 06:21 magnuse \o/ 04:33 PriyanshuSoni[m] I want it to be done quickly.. 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??? 00:36 Kolvir ok, ty 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: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:05 Kolvir is there anyway to search the mailing list archives seeing as both markmail and nabble links seem down?